MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Tom Blumer Date:May 16 2002 1:30am
Subject:how to turn off query logging for mysql on redhat linux
View as plain text  
Hello
I am trying to turn off the query log in mysql on redhat linux. It generates 
huge log files
(in /var/lib/mysql/hostname.log) that I dont need, and impacts performance.

safe_mysqld was run with --log, and it seems like I want to turn that off 
but I cant find
any script or config file where the --log was specified, perhaps it was 
compiled in?
I only have a binary distribution of mysql. Is there some way to override 
the --log?

I have looked at section 4.9 of the mysql doc, and
/etc/my.cnf (see below) and these scripts
/etc/rc.d/rc[0-6].d/K12mysqld
/etc/rc.d/init.d/mysqld
/usr/share/mysql/mysql.server

Does anyone know which of these scripts is really the one that starts 
safe_mysql?
(note that the err-log setting in my.cnf refers to an error log (empty on my 
machine) not
the query log that I am trying to get rid of.

Please reply directly and to the list
-thanks Tom


$ ps -ax |grep mysql
6010 ?        S      0:00 /bin/sh /usr/bin/safe_mysqld --log
6036 ?        S      0:45 /usr/libexec/mysqld --basedir=/usr 
--datadir=/var/lib

# uname -a
Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown

# mysqladmin --version
mysqladmin  Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386

# cat my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

Thread
how to turn off query logging for mysql on redhat linuxTom Blumer16 May
  • Re: how to turn off query logging for mysql on redhat linuxVictoria Reznichenko16 May