pt-query-digest QPS, concurrency and other time-related stats don't work on Percona Server enhanced slow logs

[Jay Janssen]

This seems like a reason not to use the enhanced slow query log with pt-query-digest. The slow log I am looking at has SET timestamp= before each query. Can that be used to get timing information?

If not, can/should a datestamp be added to the enhanced stats so pt-query-digest can get all this info?

[Jay Janssen (jay-janssen)]

Examples:

# Overall: 796.65k total, 467 unique, 0 QPS, 0x concurrency ______________
# Query 1: 0 QPS, 0x concurrency, ID 0x5826F19FB94468B5 at byte 308614642

the Digest also doesn't show the time range of the queries run.

[Rolf (rolf-winmutt)]

This affects mysql community 5.5 and most likely 5.1. This is particularly problematic when trying to play back old slow logs through a review function. In my case I am trying add some enhancements to Box's Anemometer and have to rely on bin logs as the timestamps do work there.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-529