Myisam table crash plugin

[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.

[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

[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 ?

[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?