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 the DELETE statement and then fail to give me everything else or only give me the other statements without the DELETE statement.
Here is the DELETE statement from the slow query log file:
User@Host: abc[abc] @ [##.#.#.#]
Query_time: 0.013774 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 16094
use my_db;
SET timestamp=1420780225;
DELETE FROM sessions WHERE date_modified < ‘2015-01-07 22:10:25’;
When I execute pt-query-digest I do it like this: /opt/percona-toolkit-2.2.12/bin/pt-query-digest /opt/slow_query.log > /opt/slow_query_report.txt
Anyone know why the tool is failing to put the DELETE statements into the report?