I’m trying to digest some slow query logs but pt-query-digest appears to stop working when it encounters a DELETE statement. The tool still takes a long time so it would appear that it is digesting the entire file but fails to report the DELETE statements in the report. It will either give me only t…

pt-query-digest stops digesting log when it encounters DELETE statement

mirfan January 15, 2015, 3:00pm 2

Can you please run pt-query-digest with PTDEBUG=1. This will generate lots of debugging output and will help to identify what causing the issue.

$ PTDEBUG=1 output.log 2>&1

Topic		Replies	Views
pt-query-digest slowlog output format looses query cache hit information. Percona Toolkit	1	586	May 20, 2017
how to get slow query logs for mysql and analyse it through pt-query-digest? Percona Toolkit	1	1152	March 31, 2017
pt-query-digest - can't get it to show query listing for general log Percona Toolkit	1	2634	August 26, 2013
pt-query-digest how to use for a specific database only to analyse slow query log Percona Toolkit	2	4396	December 5, 2012
pt-query-digest no longer has --execute option? Percona Toolkit	2	861	October 9, 2013