Is there a program I can interpret a MySQL Slow Query Log with?

Hi, As above.

Is there a program available to read a MySQL Slow Query Log?

I know our site was slow last night but I want to see if this log tells me something...more connections than usual etc. etc.
chriscounter07Asked:
Who is Participating?
 
gplanaCommented:
Sorry if I haven't understood at first.

I know there is a tool: http://www.webyog.com/en/comparing_mysql_monitors.php

It's not free, but its cost is reasonable.

Hope it helps.
0
 
gplanaCommented:
0
 
chriscounter07Author Commented:
Ideal.

I have actually read the query file enough now to understand exactly what the issues are.

Any other comments on this for an actual program to help rather than 'just better coding'?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
gplanaCommented:
Well, you can also do some performance test at the operating system layer, but this is operating system specific.
0
 
chriscounter07Author Commented:
gplana,

hi, my question is asking for a program to interpret and analyse a MySQL Slow Query log, not  to make the SQL server better.  I know what I need to do, I just want to be able to read the log faster and a program would do that for me.

:)
0
 
chriscounter07Author Commented:
are there any more answers to give.  Thanks for your message gplana, I was hoping for something open source really but your post definitely gets a mention :)
0
 
chriscounter07Author Commented:
Not quite what I was after but is a *very* nice tool for displaying performance of SQL.
It's strange that with all my searching I was never able to find a standalone program to analyze a slow query log and tell me which queries need looking at.
0
 
chriscounter07Author Commented:
+ my apologies to admin staff person angelIII for my delay.  I always try to look into all possibilities with all my questions so that future readers can have the best possible advice from IT pros.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.