mysql query logging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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.

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux