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.