Page 1 of 1
nagios_logentries table growing very quick
Posted: Fri May 29, 2020 6:13 pm
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?
Re: nagios_logentries table growing very quick
Posted: Mon Jun 01, 2020 8:33 am
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!