6

mysql crashes every few seconds

view full story
linux-howto

http://serverfault.com – The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down: mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR: Can't connect to the server Here is the error log after the crash. I have tried running myisamchk -r -f for all databases as well as mysqlcheck -aro with no luck. I have also tried upgrading my MySQL server from 5.0 to the 5 (HowTos)