Page 1 of 1

mysql is getting crashed often

Posted: Thu Mar 09, 2017 9:14 am
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

Re: mysql is getting crashed often

Posted: Thu Mar 09, 2017 11:17 am
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.

Re: mysql is getting crashed often

Posted: Fri Mar 10, 2017 12:05 am
by Deepa
yes its because of low disk space and resolved now.thank you

Re: mysql is getting crashed often

Posted: Fri Mar 10, 2017 9:52 am
by cdienger
Thanks for the update. Thread will be closed now.