Link to home
Create AccountLog in
Avatar of Nura111
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?
Avatar of Muhammad Wasif
Muhammad Wasif
Flag of Pakistan image

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.
Avatar of Nura111
Nura111

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

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Nura111

ASKER

I need to ask the question again but it helped me to think of diffrent soulution