it was started when machine was started
check /etc/rc.d
and in mysql manual 2.1.1
if u don't need it now, just stop the server
and start it like "./bin/safe_mysqld &"
but u have to modify rc.d anyway for next time your server start
dont log anymore.
Borus
----- Original Message -----
寄件者: "Tom Blumer" <[EMAIL PROTECTED]>
收件者: <[EMAIL PROTECTED]>
傳送日期: 2002年5月16日 AM 11:02
主旨: how to turn off query logging in mysql, redhat linux
>
> 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 manual 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.
>
> -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
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.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
---------------------------------------------------------------------
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
