Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I turned on slow query logging in my Amazon RDS instance (via the method here), and now I'm wondering how to parse the data collected in the slow queries table (mysql.slow_log). Can I use the mysqlslowdump command?

If not, are there ways of exporting the table to the slow log file format that mysqlslowdump creates?

What, if any, other parsers can I use to parse the data in the slow queries table?

EDIT: Found a python script that dumps the slow_log table to a format readable by mysqldumpslow command (thanks memonic). I modified it, which you can see here:

share|improve this question

I've tested Percona's tools and they are great

this one pt-query-advisor Analyze queries and advise on possible problems, and this one pt-query-digest converts slow log into more readable format. :)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.