Re-occurring crash of the DB

[laverdiereg]

Please let me know your findings

[tgriep]

Open a root shell in the Nagios server and run the following commands. Get the /tmp/info.txt file and upload it to the forum post.

Code: Select all

mysql -u root -pnagiosxi -e "show global status like '%used_connections%'; show variables like 'max_connections';" >/tmp/info.txt
echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -pnagiosxi >>/tmp/info.txt

[laverdiereg]

Web front end is crashed again this morning

Attaching requested file

[tgriep]

Thanks for the file. Everything looks good in it.

Your server only has 2 Gig of memory assigned to it and if it gets full, the Linux Kernel will stop the processes that take the most memory and that is usually the MYSQL database. When that happens, it would cause corruption and you would see the issue you are having.

I suggest doubling the amount of Memory and CPU's assigned to the server and then repair the database.
Wait and see if the issues is resolved.

[laverdiereg]

Done... stay tuned. Thanks for your help

[tgriep]

Your welcome, hopefully this is it.