Saturday, June 30, 2007

Turn on MySQL Log Files

- How can I determine what query it is that is causing this to happen? I have turned on the log files by adding the following line to /etc/rc.conf:mysql_args="--log=/var/log/mysql_query.log --log-error=/var/log/ mysql_error.log"

REMEMBER::

--log-error is not supported in 3.23.55 (current stable release, as of this writing). Trying to set it in /etc/my.cnf results in an error (unrecognized option).