Mysql log queries FreeBSD

If you want to activate logging of mysql queries, add in your my.cnf (by default it is /var/db/mysql/my.cnf)
in [mysqld] section:

log=/var/log/mysql.log

create log file:

#touch /var/log/mysql.log
#chmod 666 /var/log/mysql.log

and restart mysql-server:

#/usr/local/etc/rc.d/mysql-server restart (it can be different on you server)

That is all.

PS: I don’t recommend you use it on hight loaded servers permanently. Use it only for debugging.

Posted on March 10th, 2011 by admin
Filed under: Tips