using check_mysql_health plugin

[deepakitkar]

Newbie here...

The MySQL plugin from Monitoring Wizard is missing few modes that check_mysql_health plugin. I am trying look all over the web to find a way to use specific modes from check_mysql_health and assign it to mysql servers. I am pretty new and little confused on how to do this. Should I Create a service for each mode? If I do that I will need to specify the HOST as well then it will not be used for other host, will it?

Thanks

[slansing]

Could you elaborate just a bit more on what you mean by it's modes? Are you asking about how to check for specific metrics with the plugin by adding flags and values to the command? You may want to create multiple services for this if you have multiple things you would like to check. Can you provide an example?

[deepakitkar]

I added one MySQL server to Nagios using MySQL plugin from monitoring wizard. The 6-7 parameters or should I say attributes that it displays aren't enough for me. So I wanted to include few extra parameters from this plugin "check_mysql_health" like tmp-disk-tables, sql etc. So I tried to create these services as an individual service from Core Configuration Manager but not sure how to do this. Do we need to hardcode HOST on the New Service page? How do we do it?

Thanks

[scottwilkerson]

Do we need to hardcode HOST on the New Service page? How do we do it?

In the new service you create you would select the host to apply it to using the "Manage Hosts" button on the "Common Settings" tab

[deepakitkar]

Scott - Thanks, Do we have a tutorial on setting this up, somewhere?

[abrist]

Documentation for the check_mysql_health plugin can be found at:
http://labs.consol.de/nagios/check_mysql_health/

[deepakitkar]

Thanks, this helped resolve my query.

[slansing]

Closing thread as resolved.