Page 1 of 1
Re-occurring crash of the DB
Posted: Mon Mar 02, 2020 3:11 pm
by laverdiereg
Please let me know your findings
Re: Re-occurring crash of the DB
Posted: Mon Mar 02, 2020 4:26 pm
by 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
Re: Re-occurring crash of the DB
Posted: Tue Mar 03, 2020 9:22 am
by laverdiereg
Web front end is crashed again this morning
Attaching requested file
Re: Re-occurring crash of the DB
Posted: Tue Mar 03, 2020 10:05 am
by 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.
Re: Re-occurring crash of the DB
Posted: Tue Mar 03, 2020 11:44 am
by laverdiereg
Done... stay tuned. Thanks for your help
Re: Re-occurring crash of the DB
Posted: Tue Mar 03, 2020 4:17 pm
by tgriep
Your welcome, hopefully this is it.