Page 1 of 1
Myisam table crash plugin
Posted: Fri Mar 29, 2019 8:08 am
by sandeep027
HI Team,
Is there any mysql plugin to monitor myisam crashed tables in Nagios XI ? IF yes can you please let us know how to use that one.
Re: Myisam table crash plugin
Posted: Fri Mar 29, 2019 12:34 pm
by npolovenko
@sandeep027, Crashed tables can be tricky to identify. You can try using the following plugin I found:
https://gist.github.com/RPDiep/c71187ba6d8df24fc366
**I applied a couple of fixes to the plugin output to get it to work with XI and attached the modified script to this post. Please use it instead.
Place the plugin in the /usr/local/nagios/libexec/ folder and create a new command in XI:
$USER1$/dbcheck.py
Also, you need to install the following python module to get it to work:
pip install mysql-python
Re: Myisam table crash plugin
Posted: Sun Mar 31, 2019 10:55 pm
by sandeep027
Thanks much bro.. i will check the script in my server and will let you know incase of any issues.
is Everytime we want to run this script to know corrupted tables ? i mean everytime we need to check output file for crashed tables ? or we will get any emails ?
Re: Myisam table crash plugin
Posted: Mon Apr 01, 2019 10:24 am
by npolovenko
@sandeep027, I modified the script to not use the output file. You can use this tutorial to upload the plugin to XI and set it up as a regular service check.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Then you can set up email notification for the service check.
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Unless you want to use it on a remote MYSQL server?