mysql logs on a slack

dominant · 06-19-2004, 09:52 AM

Do you know where mysql keeps its log files?

dominant · 06-20-2004, 06:31 AM

any ideas?

keefaz · 06-20-2004, 07:02 AM

By default apparently mysqld don't log in plain text files. You can add log parameters in /etc/rc.d/rc.mysqld :
change :

Code:

/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid $SKIP &

to:

Code:

/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --log=/var/lib/mysql/access_log --err-log=/var/lib/mysql/error_log $SKIP &

So you log queries & connections in /var/lib/mysql/access_log and mysqld errors in /var/lib/mysql/error_log, I find it is a good place because /var/lib/mysql should be owned by mysql

dominant · 06-20-2004, 08:43 AM

mysql is not started automatically (/etc/.rc.d)

keefaz · 06-20-2004, 09:06 AM

Quote:

mysql is not started automatically (/etc/.rc.d)

So you just have to issue this command to start mysqld whenever you want :
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --log=/var/lib/mysql/access_log --err-log=/var/lib/mysql/error_log &
Maybe do an alias for it in your ~/.bashrc like :
start_mysql="/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --log=/var/lib/mysql/access_log --err-log=/var/lib/mysql/error_log &"

datadriven · 06-20-2004, 11:34 PM

If I remember correctly there's a file called localhost.err in /var/lib/mysql

dominant · 06-21-2004, 02:02 AM

Thank you for you replies.

I fixed that by putting

log = /path/to/log/mysql.log

in my.cnf