Link to home
Start Free TrialLog in
Avatar of Nura111
Nura111

asked on

slow log issues-

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.
ASKER CERTIFIED SOLUTION
Avatar of Muhammad Wasif
Muhammad Wasif
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial