-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
-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
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