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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .