Zabbix / usage 96%

[Kcoolz]

Hi,

Was hoping someone might be able to help me out or guide me in the right direction. I am running Zabbix 6.0.5 on Ubuntu Server 18.04

My usage is currently this: https://i.imgur.com/LinMwEl.png

My housekeeper is set to only keep 7d worth of data: https://i.imgur.com/5Znf4iQ.png

I thought the SQL database might just be at a current size and has not resized, is it possible to see if i can reclaim some of the space?

SQL screenshot of usage: https://i.imgur.com/QgOCMDW.png

File structure: https://i.imgur.com/Rx35ZCF.png

https://i.imgur.com/fXikldL.png

https://i.imgur.com/nVZyrYI.png

Any help would be appreciated.

[vladimir_lv]

Auditlog started to grow because the audit log n Zabbix 6 now contains records about all configuration changes for all Zabbix objects, including changes that occurred as a result of executing an LLD rule, a network discovery action, an autoregistration action, or a script execution. Previously, configuration changes initiated from the Zabbix server, for example, as a result of executing a discovery rule, were not recorded. Now such object modifications will be stored as audit records attributed to the user System.
Please check What's new in Zabbix 6.0.0 https://www.zabbix.com/documentation...on/whatsnew600
Run housekeeper manually:

zabbix_server -R housekeeper_execute

then check the Zabbix server log and check if the DB size was changed.

[Markku]

Auditlog started to grow because the audit log n Zabbix 6 now contains records about all configuration changes for all Zabbix objects, including changes that occurred as a result of executing an LLD rule, a network discovery action, an autoregistration action, or a script execution. Previously, configuration changes initiated from the Zabbix server, for example, as a result of executing a discovery rule, were not recorded. Now such object modifications will be stored as audit records attributed to the user System.

Fortunately that was fixed in 6.0.6 so that's a "must do" update for 6.0 users.

Markku

[vladimir_lv]

Yes, you are true.

[Kcoolz]

Auditlog started to grow because the audit log n Zabbix 6 now contains records about all configuration changes for all Zabbix objects, including changes that occurred as a result of executing an LLD rule, a network discovery action, an autoregistration action, or a script execution. Previously, configuration changes initiated from the Zabbix server, for example, as a result of executing a discovery rule, were not recorded. Now such object modifications will be stored as audit records attributed to the user System.
Please check What's new in Zabbix 6.0.0 https://www.zabbix.com/documentation...on/whatsnew600
Run housekeeper manually:

zabbix_server -R housekeeper_execute

then check the Zabbix server log and check if the DB size was changed.

I have ran this manually. I will update to 6.06 and try again.

[Kcoolz]

After updating to 6.06 and running housekeeper manually the issue is still happening.

[Markku]

In this thread: https://www.zabbix.com/forum/zabbix-...p-auditlog-ibd there are some hints how to reclaim the empty space from the database.

How many hosts, items and NVPS (new values per second) does your Zabbix dashboard show? I mean, you said 7 days of history but it doesn't mean anything (as data size) unless you have some idea how much data you are accumulating in those 7 days.

Also, in Zabbix blog there is a post about database partitioning: https://blog.zabbix.com/partitioning...cedures/13531/ It helps removing the old data from the database but requires some amount of expertise to implement and keep running.

Markku

[Kcoolz]

I've cleared the binlogs from MYSQL as that seemed to have been taking a lot of the space. I will monitor the Zabbix database to see if it grows with the new housekeeper settings I've set. Thanks for the help!