Sometimes database taking too much memory and such behavior of database dies or crashes the server which caused due to corrupted MySQL database. Try to do the following:
1) Kill the mysql server
Quote:
|
/etc/rc.d/init.d/mysql stop
|
2) Repair all MySQL databases:
Quote:
|
myisamchk -r /var/lib/mysql/*/*.MYI
|
or if you already new the database name which causing the problem then repair it by using following command.
Quote:
|
root@server [/var/lib/mysql]#mysqlcheck -r -o database name
|
3) Start mysql again:
Quote:
|
/etc/rc.d/init.d/mysql start
|