How to read the slow queries log file

Posted on 2011-05-05
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?
Question by:Nura111
    LVL 29

    Accepted Solution

    Have you tried running the "mysqldumpslow" command?


    There is also a Ruby-based script to help put the log into a more 'readable' format:

    Author Comment

    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

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    How to increase the row limit in Jasper Server.
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now