LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 04-23-2011, 12:25 PM   #1
a4kata
Member
 
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, 12:48 PM   #2
cmnorton
Member
 
Registered: Feb 2005
Distribution: Ubuntu, CentOS
Posts: 585

Rep: Reputation: 35
You need some logging

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.
 
Old 04-23-2011, 08:20 PM   #3
gugabaga
Member
 
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
 
  


Reply


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 10:08 AM
Turn off logs knobby67 Debian 1 10-06-2009 08:41 AM
Now Its MySQLs Turn! rn5a Linux - Newbie 15 09-10-2007 10:35 AM
Help with MySQL logs icarusfall Linux - Software 0 11-14-2005 06:24 PM
How do i turn php and mysql on? jp2 Linux - Newbie 2 09-14-2004 06:42 PM


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

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