How to parse mysql slow query query log into something useful?

Question

I have a long, slow query log that runs for several weeks. I would like to analyze it, which would put the highest queries at the top (with the number of executions and average execution time), and it goes from there in descending order.

What tool / command can be used for this?

Answer 1

Check out Maatkit :

mk-query-digest - parsing logs and more. Analyze, transform, filter, view and report requests.

Answer 2

script , maakit mk-query-digest:

https://github.com/LeeKemp/mysql-slow-query-log-parser/

Answer 3

, , . ... .

, , CSV. , , , .

, -, , ", " MySQLProDemon40005K +! ", .