mysql is getting crashed often

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Deepa
Posts: 10
Joined: Wed Apr 27, 2016 2:07 am

mysql is getting crashed often

Post by Deepa »

Hi
I am integrating ndo2db with nagios where mysql table is frequently getting crashed.I am not able to recognise the issue.Every time I do repair.what might be the reason?

Tables Crashed:
nagios_servicestatus
nagios_hoststatus

Now a new table is added in the list which is nagios_customvariablestatus and am unable to repair.It gets hung on that table.please help me with this

Thanks
Deepa
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: mysql is getting crashed often

Post by dwhitfield »

Please post the outputs of df -i and df -h on the server where mysql resides.

Also, please post the output of tail -100 /var/log/mysqld.log in a code block.
Deepa
Posts: 10
Joined: Wed Apr 27, 2016 2:07 am

Re: mysql is getting crashed often

Post by Deepa »

yes its because of low disk space and resolved now.thank you
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: mysql is getting crashed often

Post by cdienger »

Thanks for the update. Thread will be closed now.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked