I'm facing the exact same problem.
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 :
ptqd 11-21.slow.log --output slowlog --no-report --filter '($event->{timestamp} > 1483957800) && ($event->{timestamp} < 1483959600)' > 11-21.halfhour.log
The major point for me is the loss of the query cache hit info.
Original log:
# Time: 170109 12:08:43 # User@Host: pidf_user[pidf_user] @ [10.226.13.132] # Thread_id: 32829731 Schema: webmbpidf QC_hit: No # Query_time: 0.015387 Lock_time: 0.000038 Rows_sent: 0 Rows_examined: 0
Filtered log
# Time: 170109 11:59:59 # User@Host: pest_user[pest_user] @ 10.226.13.13 [] # Thread_id: 32805954 # Query_time: 0.000221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
I'm facing the exact same problem.
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 :
ptqd 11-21.slow.log --output slowlog --no-report --filter '($event- >{timestamp} > 1483957800) && ($event- >{timestamp} < 1483959600)' > 11-21.halfhour.log
The major point for me is the loss of the query cache hit info.
Original log:
# Time: 170109 12:08:43 pidf_user] @ [10.226.13.132]
# User@Host: pidf_user[
# Thread_id: 32829731 Schema: webmbpidf QC_hit: No
# Query_time: 0.015387 Lock_time: 0.000038 Rows_sent: 0 Rows_examined: 0
Filtered log
# Time: 170109 11:59:59 pest_user] @ 10.226.13.13 []
# User@Host: pest_user[
# Thread_id: 32805954
# Query_time: 0.000221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0