[CentOS] mysql query logging

A. Kirillov nevis2us at infoline.su
Sat Sep 12 07:45:05 UTC 2009


> # cat /etc/my.cnf
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> user=mysql
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> old_passwords=1
> max_allowed_packet=2MB
> 
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> log-query=/var/log/mysql-query.log
> 
> empty
> 
> and then I added to /etc/init.d/mysqld
> 
> get_mysql_option mysqld_safe log "/var/log/mysqld-query.log"
> querylogfile="$result"
> -and-
> start(){
>         touch "$querylogfile"
>         chown mysql:mysql "$querylogfile"
>         chmod 0640 "$querylogfile"
> 
> but nothing is logged.

Try to put
log=/var/log/mysqld.log
into [mysqld] section of my.cnf

HTH
Sasha




More information about the CentOS mailing list