[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

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.
0
chriscounter07
Asked:
chriscounter07
  • 5
  • 3
1 Solution
 
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
 
gplanaCommented:
Well, you can also do some performance test at the operating system layer, but this is operating system specific.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now