Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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: https://gist.github.com/1484489

share|improve this question

1 Answer 1

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

 
discard

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.