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  
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

Does anyone know which of these scripts is really the one that starts 
(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 

# uname -a
Linux {} 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



Send and receive Hotmail on your mobile device:

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