Where to find mySQL logs?

[max2000]

Hi

Do you know where are located mySQL logs on Unix servers?

Thank you

 

[nobaloney]

Do you mean /var/log/myslqd.log?

Or something else?

Jeff

 

[max2000]

Thank you Jeff,

But this files doens't exist on my servers.


server:/# ls /var/log/myslqd.log
ls: /var/log/myslqd.log: No such file or directory


Any other idea?

 

[jmstacey]

/home/mysql is another possibility.

 

[Chrysalis]

touch /var/log/mysqld.log
chown mysql /var/log/mysqld/log
then restart mysqld

if the file doesnt exist mysql wont create it for you.

 

[duncan]

To pull up this old thread....

MySQL crashed on my box today. I went looking for the error logs, but I can't seem to find any.

Using the advice above, I should create a log then? Sounds strange to me....

Any thoughts?

 

[Chrysalis]

yes I think mysql doesnt always create a new log file.

 

[anas_xrt]

I have refer this -- https://mariadb.com/kb/en/error-log/ for MariaDB

So, since I want my log to be in /var/log/mysqld.log (also this would be good for mysqltuner script as well)
I create as following

touch /var/log/mysqld.log
chown mysql /var/log/mysqld/log

and then I edit /etc/my.cnf add the code below

[mariadb]
log_error=/var/log/mysqld.log

then restart mariadb, now the log is generated. However to rotate the log, I have to create another rotate rule.

tee /etc/logrotate.d/mysql-error <<'EOF'
/var/log/mysqld.log {
    weekly
    missingok
    rotate 8
    compress
    delaycompress
    notifempty
    sharedscripts
    endscript
}
EOF

 

[Richard G]

Please check posting dates and do not necropost with updates. It's 15 years old.
Thank you.