[CentOS] mysql query logging

Craig White

craigwhite at azapple.com
Sat Sep 12 04:08:19 UTC 2009


Nothing I have done so far seems to work

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

Can someone toss me a bone here?

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the CentOS mailing list