Sunday, January 30, 2011

How to log all MySQL queries

I just found this very useful tip on how to make MySQL log all queries to a text file.

Basically, you just have to add the following config to your my.cnf and restart mysqld:
log = /var/log/mysql-queries.log

Now...does anybody know how to make it only log queries made against a specific database? :o)

0 comments:

Post a Comment