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?

Improve company productivity with a Business Account.Sign Up

x
 
gplanaConnect With a Mentor Commented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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.