Zabbix database maintenance advice

[jhdore]

Hi all,

I've had Zabbix running for a couple of years, and the database is about 23GB in size (based on observations of the mysqldump file). It takes a while to back up when I'm doing upgrades - are there any features I can use to shrink the size of the database, such as throwing data older than x years, or whatnot? I can't find any docs that might indicate how to do database maintenance on the zabbix server itself.

Is 23GB of data in the db a problem?

We're using MariaDB (MySQL) as the db, on Ubuntu 18.04 LTS, and currently at Zabbix version 5.0.21 installed from the repositories.

Cheers,
James

[cyber]

23G... tiny one.. I have ~1T..:P

But to reduce... how long you keep your data? You can try to reduce history storage times. Set shorter period in housekeeper (also "Override item history period") and let it do the job...

[cyber]

23G... tiny one.. I have ~1T..:P

But to reduce... how long you keep your data? You can try to reduce history storage times. Set shorter period in housekeeper (also "Override item history period") and let it do the job...

[jhdore]

Ah, that guided me to the correct area in the platform, and I found the data retention settings, thanks! Good to know I have a small one too