Nagios Support Forum

Hi,

I have a fresh install of Nagios 5.8.7 that I'm finishing populating using the API and I realized that the /var/lib/mysql/binlog files in a few hours can be three or four times the size of the DDBB. Is this normal?

Now it comes by defult the entry "binlog_expire_logs_seconds=86400" on mysql-server.cnf but usually my server runs out of space before the logs are expired. I have increased the /var partition a little but I find strange the logs being so big.

It's the default change of using binlogs and this not being enough as you've found:
You can drop it down to a lower value and then restart the mysqld process to pick up those changes but I generally disable binlogs on mine following this process:

You can do this to disable and then purge:
Then do this to permanently disable:
Taken from here:

https://dba.stackexchange.com/a/226944

Thank you for your reply, I think I will just disable it as well because even if now I have enough space, if the database grows in the future I might again run out of space.

No problem, glad to help! Let us know when we're okay to lock this up and mark it as resolved.

Hi,

Yes, mark it as resolved and locked thanks.