Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 04-23-2011, 11:25 AM   #1
Registered: Aug 2009
Posts: 30

Rep: Reputation: 0
How to turn off all mysql logs

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 ?
Old 04-23-2011, 11:48 AM   #2
Registered: Feb 2005
Distribution: Ubuntu, CentOS
Posts: 585

Rep: Reputation: 35
You need some logging

I found these:

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.
Old 04-23-2011, 07:20 PM   #3
Registered: Jan 2006
Distribution: Fedora
Posts: 61

Rep: Reputation: 15
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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to turn ON large_pages in MYSQL? Stephan_Craft Linux - Server 2 11-26-2009 09:08 AM
Turn off logs knobby67 Debian 1 10-06-2009 07:41 AM
Now Its MySQLs Turn! rn5a Linux - Newbie 15 09-10-2007 09:35 AM
Help with MySQL logs icarusfall Linux - Software 0 11-14-2005 05:24 PM
How do i turn php and mysql on? jp2 Linux - Newbie 2 09-14-2004 05:42 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:49 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration