slow log issues-

Posted on 2011-04-29
Last Modified: 2013-12-06
Im trying to to find  slow queries /etc/mysql/my.cnf the configuration- i

log_slow_queries                = /var/log/mysql/mysql-slow.log
long_query_time                 = 1
log-queries-not-using-indexes   = 1
(Im pretty new to DBA) from my understanding after readin about the 1 stands for second and from some reason the results in mysql-slow.log file have query time=0.0008 which for my understanding not suppose to be there.
from my understanding in the slow log file suppse to be queries the the query time that is more than 1 second.
Question by:Nura111
    1 Comment
    LVL 20

    Accepted Solution

    If you only need those queries which are taking 1 or more seconds then disable log-queries-not-using-indexes option. When you have log-queries-not-using-indexes =1, your log will also contains those queries who are not using indexes regardless of seconds mentioned for long_query_time. Comment log-queries-not-using-indexes and restart MySQL.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    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