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.1.56 version. My my.cnf is also attached.
I have recently had problems with the hard disk and had to run fsck with the force (-f) option to be able to start my system.
Please help me to stop the server crashing. Thank you for any help.