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-inde xes = 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.
log_slow_queries = /var/log/mysql/mysql-slow.
long_query_time = 1
log-queries-not-using-inde
(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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.