• 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?
1 Solution
Michael WorshamInfrastructure / Solutions ArchitectCommented:
Have you tried running the "mysqldumpslow" command?


There is also a Ruby-based script to help put the log into a more 'readable' format:
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
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