0

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

1 Answer 1

0

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. :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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