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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
