Verified with PS 5.6.22. Need to decide, is it okay with space or there should be _ .
root@desktop:/var/lib/mysql# cat desktop-slow-log.000013 /usr/sbin/mysqld, Version: 5.6.22-71.0-log (Percona Server (GPL), Release 71.0, Revision 726). started with: Tcp port: 0 Unix socket: (null) Time Id Command Argument # Time: 150209 12:51:52 # User@Host: root[root] @ localhost [] Id: 37 # Schema: nil Last_errno: 0 Killed: 0 # Query_time: 13.517232 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 8388608 Rows_affected: 4194304 # Bytes_sent: 0 # Stored routine: nil.nil_test use nil; SET timestamp=1423466512; INSERT INTo test SELECT * from test; root@desktop:/var/lib/mysql#
Verified with PS 5.6.22. Need to decide, is it okay with space or there should be _ .
root@desktop: /var/lib/ mysql# cat desktop- slow-log. 000013 1423466512; /var/lib/ mysql#
/usr/sbin/mysqld, Version: 5.6.22-71.0-log (Percona Server (GPL), Release 71.0, Revision 726). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
# Time: 150209 12:51:52
# User@Host: root[root] @ localhost [] Id: 37
# Schema: nil Last_errno: 0 Killed: 0
# Query_time: 13.517232 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 8388608 Rows_affected: 4194304
# Bytes_sent: 0
# Stored routine: nil.nil_test
use nil;
SET timestamp=
INSERT INTo test SELECT * from test;
root@desktop: