nagios_logentries table growing very quick

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

nagios_logentries table growing very quick

Post by BanditBBS »

Code: Select all

-rw-rw----. 1 mysql mysql 8.8K Mar 15  2019 /var/lib/mysql/nagios/nagios_logentries.frm
-rw-rw----  1 mysql mysql  13M May 29 20:08 /var/lib/mysql/nagios/nagios_logentries.MYI
-rw-rw----  1 mysql mysql  14M May 29 20:08 /var/lib/mysql/nagios/nagios_logentries.MYD
That is after 45 minutes after I truncated the table. The table was many GB large. I changed the setting to only keep 7 days worth of logs but I'd like to keep more. On my other similarly sized server I have it set to 60 days and it is only

Code: Select all

-rw-rw---- 1 mysql mysql 8.8K Feb 13  2017 /var/lib/mysql/nagios/nagios_logentries.frm
-rw-rw---- 1 mysql mysql 411M May 29 18:12 /var/lib/mysql/nagios/nagios_logentries.MYI
-rw-rw---- 1 mysql mysql 647M May 29 18:12 /var/lib/mysql/nagios/nagios_logentries.MYD
Any hints at what I could look at that can be making my grow so quick?
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: nagios_logentries table growing very quick

Post by BanditBBS »

I figured out the issue. I recently set a lower max concurrent checks and its hitting that often and having to push the checks. Each time that happens it is writing that to the log and causing great growth. So never mind about looking into this, this one is all on me and I know what I need to do!
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Locked