Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-04-03
9
Medium Priority
?
447 Views
Last Modified: 2013-11-13
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
Comment
Question by:chriscounter07
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 15

Expert Comment

by:gplana
ID: 24058506
0
 

Author Comment

by:chriscounter07
ID: 24066974
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
 
LVL 15

Expert Comment

by:gplana
ID: 24067102
Well, you can also do some performance test at the operating system layer, but this is operating system specific.
0
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 

Author Comment

by:chriscounter07
ID: 24067219
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
 
LVL 15

Accepted Solution

by:
gplana earned 500 total points
ID: 24067291
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
 

Author Comment

by:chriscounter07
ID: 24136673
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
 

Author Closing Comment

by:chriscounter07
ID: 31566175
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
 

Author Comment

by:chriscounter07
ID: 24324891
+ 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 top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Six Sigma Control Plans

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question