Closing Mysql sessions from monitoring Nagios

[evisus]

Hi all!!. I would like to know how Nagios manages the closing of sessions to Mysql from the plugins. Our DBA calls us for many open sessions that originate from our Nagios server and that has been causing problems

Thank you

[benjaminsmith]

Hello @evisus,

You may have an issue with corrupted database tables. Log into the server as root and run the following command to check and repair the database.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

If the issue persists, please send us your system profile for us to review.

Thanks.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.

[evisus]

Hello @benjaminsmith.

I think I've explained myself wrong, I'm sorry.

Nagios is monitoring a MySQL database on a remote server. According to the DBA, nagios is leaving sessions open to MySQL and that is causing problems.

My question is whether the plugin used in the Nagios XI Wizard closes sessions to MySQL when finished running the plugins

Thank you!

[benjaminsmith]

Hi @evisus,

What do you have your check interval set at for those services?

Also, the plugin used by the wizard is check_mysql_health,. The latest version is 2.2.2, and you may want to upgrade as it's possible you maybe hitting a bug.

To check the version:

Code: Select all

cd /usr/local/nagios/libexec
./check_mysql_health -V

Upgrade instructions are found in the readme file of the plugin archive.

[evisus]

Thank you.

The interval is 5 minutes.

We are going to update the plugins.

I will be reporting results

[benjaminsmith]

We are going to update the plugins.
I will be reporting results

Sounds good. We'll wait for your reply.