cmshn
By:
cmshn

Where can i log MySql errors?

April 21, 2014 10.5k views
My server keeps crashing Mysql. I have 1 Gig RAM and 1 Gig swap, on Ubuntu 12.04. Just using for wordpress. How can i solve crashing problem? How can i check errors?
2 Answers
MySQL's error log file is /var/log/mysql.err. Check the last few lines, what does it say?
tail -30 /var/log/mysql.err 
I installed default my.cnf. I found logs. My problem is same with these :(

https://www.digitalocean.com/community/questions/mysql-server-keeps-stopping-unexpectedly

https://www.digitalocean.com/community/questions/mysql-crashes-but-apache-continues
Have another answer? Share your knowledge.