does an optimize database will have an empty slow log files?

Nura111
Nura111 used Ask the Experts™
on
does an optimize database will have an empty slow log files?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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
You should also consider using to wordpress cache plugins/techniques to reduce SELECT load on the server. This will help UPDATE queries to perform better.

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial