slowql icon indicating copy to clipboard operation
slowql copied to clipboard

Does not work with MySQL 5.6 slow log

Open kvokka opened this issue 1 year ago • 2 comments

Using this command for slowql-replayer

./replayer_linux_amd64 -db rp2 -f /mnt/disks/data/mysql-slow.log -h 10.240.0.39 -u user -password PASS -k mysql

/mnt/disks/data/mysql-slow.log:

Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.6.35-80.0-log (Percona Server (GPL), Release 80.0, Revision f113994f31). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 170213 16:00:33
# User@Host: replaypoker[replaypoker] @  [10.240.0.7]  Id:  2459
# Schema: rp2  Last_errno: 0  Killed: 0
# Query_time: 26.717140  Lock_time: 0.000178  Rows_sent: 0  Rows_examined: 989715  Rows_affected: 989715
# Bytes_sent: 58
use rp2;
SET timestamp=1487001633;
replace into user_ranks(user_id, rank) select u.id as pId, @pRank := @pRank + 1 as curr_rank from users as u join (select @prank:=0) r where u.state='active' order by playfunds desc;

Get in the return with such output (multiple times):

ERRO[0000] time: error converting 170213 to time: parsing time "170213" as "2006-01-02T15:04:05Z07:00": cannot parse "13" as "-"

kvokka avatar Jan 22 '23 11:01 kvokka