Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to read the slow queries log file

Posted on 2011-05-05
3
Medium Priority
?
615 Views
Last Modified: 2012-05-11
while enabling the log_queries_not_using_index and you trying to look on the results:
 technically I need to take into consideration every result in the slow log file?
#even if the user@host is the system? (and the table is 'information_schema')
#the row sent is 0?

what does the lock time mean? do I need to take it into consideration while looking at the result?
0
Comment
Question by:Nura111
2 Comments
 
LVL 29

Accepted Solution

by:
Michael Worsham earned 2000 total points
ID: 35705738
Have you tried running the "mysqldumpslow" command?

Reference:
http://dev.mysql.com/doc/refman/5.1/en/mysqldumpslow.html


There is also a Ruby-based script to help put the log into a more 'readable' format:
http://code.google.com/p/mysql-slow-query-log-parser/
0
 

Author Comment

by:Nura111
ID: 35710086
Ill defiantly try it.

I opened the slow-log-file again to look at the results
is it possible that the log file is changing in a way that he delete those queries results from the file?(the ones that the host was a the system and that the num of rows was 0)
as today they are not their anymore
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month21 days, 5 hours left to enroll

810 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