Not the answer you need?
Register and ask your own question!

pt-query-digest slowlog output format looses query cache hit information.

tomdesptomdesp EntrantCurrent User Role Beginner
Hi everyone,

I'm using pt-query-digest (v2.2.20) slowlog output format to filter out queries based on their timestamp, to run further digests on the filtered slowlog :

The point is my source log 11-21.slow.log has query cache hit info, for instance :

# Time: 170109 12:08:43
# [email protected]: pidf_user[pidf_user] @ []
# Thread_id: 32829731 Schema: webmbpidf QC_hit: No
# Query_time: 0.015387 Lock_time: 0.000038 Rows_sent: 0 Rows_examined: 0

Whereas the filtered output doesn't :

# Time: 170109 11:59:59
# [email protected]: pest_user[pest_user] @ []
# Thread_id: 32805954
# Query_time: 0.000221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0

l lose schema information as well but it's less a problem in my situation.

Is there a way to keep the query cache info in the slowlog output ?

Any help would me much appreciated.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.