Analyze Slow Query log

There is a nice tool like Percona’s ‘pt-query-digest’ tool at, which will automatically parse the slow_query_log and analyze it for the slowest queries.

you run the command

pt-query-digest slowquerylog.txt

Wich should output a summary and a list of the longest-to-execute queries.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.