How to turn off all mysql logs

a4kata · 04-23-2011, 11:25 AM

Hello, I would like to ask how to turn off all mysql logs because mysql is using too many resources. I turned slow queries log and there is no slow queries here is what I want to turn off the logs maybe this is causing mysql to high load ?

cmnorton · 04-23-2011, 11:48 AM

I found these:

http://www.qc4blog.com/?p=882
and
http://mysql.com

but this sounds like you have a much bigger issue, too small a disk. You can install and use log rotate playing with the parameters so you keep a smaller log file and fewer of them. You'd archive the logs off. However, most mysql log level-related posts I read want to increase not decrease logging.

Good luck.

gugabaga · 04-23-2011, 07:20 PM

First check if it is really mysql that is slowing ur system down.

If u still want to turn log off edit /etc/my.cnf

You can find a list of my.cnf options by executing 'mysqladmin variables' in a terminal.

Hope this helps