1353
# #############################################################################
1354
# pt-query-digest fails to parse Thread_id on 5.6
1355
# https://bugs.launchpad.net/percona-toolkit/+bug/1299387
1356
# #############################################################################
1358
# first test with a Percona 5.5 slow log (includes an explicit Thread_id line)
1359
# (MySQL 5.5 doesn't include thread id)
1362
file => "$sample/slow060.txt",
1365
Thread_id => '1', # here's our item
1369
Lock_time => '0.000000',
1370
Query_time => '10.000373',
1371
Rows_affected => '0',
1372
Rows_examined => '0',
1375
arg => 'select sleep(10)',
1378
host => 'localhost',
1381
timestamp => '1405358212',
1382
ts => '140714 14:16:52',
1388
# now test with a Percona 5.6 slow log. Thread_id is now on the user@host line, and is called 'Id'.
1389
# (this is in line with MySQL 5.6)
1392
file => "$sample/slow061.txt",
1395
Thread_id => 1, # here's our item
1397
Lock_time => '0.000000',
1398
Query_time => '11.013723',
1399
Rows_affected => '0',
1400
Rows_examined => '0',
1402
arg => 'select sleep(11)',
1405
host => 'localhost',
1408
timestamp => '1405360304',
1409
ts => '140714 14:51:44',
1352
1416
# #############################################################################
1354
1418
# #############################################################################