Manage logs on MY SQL server

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jatindeepsharma
Posts: 70
Joined: Wed Apr 04, 2018 10:52 am

Manage logs on MY SQL server

Post by jatindeepsharma »

Hello Team,
nagios_logentries table on my SQL server is getting increased day by day, how can i manage this table? size of this table is going upto 42GB which slow down front end of NAGIOS.please suggest.

Path of nagios logs.
/home/mysql/mysql/nagios
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Manage logs on MY SQL server

Post by mcapra »

Here's the official documentation for optimizing/tuning the MySQL database for Nagios XI:
https://assets.nagios.com/downloads/nag ... zation.pdf

My memory may be failing me, but I think you want to tune the "Max Log Entries Age" of the NDOUtils database settings.

I'd also check to make sure the database maintenance tasks are running, as these are responsible for cleaning-up the nagios_logentries table among others. Admin->System Status:
https://support.nagios.com/kb/article.php?id=70

If you have many checks in an unhealthy state, this table's size can increase quite rapidly as all of the checks are hitting their retry interval (60 seconds by default for most checks) rather than their usual check interval (300 seconds by default for most checks).

I'd suggest preparing a system profile should one of the techs ask for it:
https://assets.nagios.com/downloads/nag ... zation.pdf
Former Nagios employee
https://www.mcapra.com/
User avatar
mbellerue
Posts: 1403
Joined: Fri Jul 12, 2019 11:10 am

Re: Manage logs on MY SQL server

Post by mbellerue »

Thanks for jumping in Matt!

jatindeepsharma, did Matt's answer provide you with the information needed to resolve your issue?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked