Nura111
asked on
does an optimize database will have an empty slow log files?
does an optimize database will have an empty slow log files?
Not necessarily. It depends on the time defined for long_query_time. If you set it too high like 1000 then probably you won't see any query in the log.
ASKER
ok but I meant if I set it to an optimize time that is a second is in real life there is actually an empty one?
because im new to db and trying to optimize my database but its seem i keep having queries in the slow log file that are really short and simple
such as SELECT and no INNER JOIN and so on
(they are also examining really short rows)
so i don't think there is a way to optimize them.
and im not really sure i understand how cone they are there if only dealing with one row
because im new to db and trying to optimize my database but its seem i keep having queries in the slow log file that are really short and simple
such as SELECT and no INNER JOIN and so on
(they are also examining really short rows)
so i don't think there is a way to optimize them.
and im not really sure i understand how cone they are there if only dealing with one row
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I need to ask the question again but it helped me to think of diffrent soulution