• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

How to read the slow queries log file

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
Nura111
Asked:
Nura111
1 Solution
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
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
 
Nura111Author Commented:
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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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