Manage logs on MY SQL server

This board serves as an open discussion and support collaboration point for Nagios XI. NOTE: Nagios XI customers should use the Customer Support forum to obtain expedited support.

Manage logs on MY SQL server

Postby jatindeepsharma » Mon Jan 20, 2020 9:20 am

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
jatindeepsharma
 
Posts: 61
Joined: Wed Apr 04, 2018 10:52 am

Re: Manage logs on MY SQL server

Postby mcapra » Mon Jan 20, 2020 10:18 am

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
http://www.mcapra.com/
User avatar
mcapra
 
Posts: 3600
Joined: Thu May 05, 2016 3:54 pm

Re: Manage logs on MY SQL server

Postby mbellerue » Mon Jan 20, 2020 3:42 pm

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!
User avatar
mbellerue
 
Posts: 1274
Joined: Fri Jul 12, 2019 11:10 am


Return to Nagios XI

Who is online

Users browsing this forum: RRauscher and 44 guests