Removing Data older than 6 months from today..

[tryllz]

Hi,

I have been going through articles on this and have no found any clean way with this.

Our Zabbix DB (MySQL) is growing, and I have already set it not to retain data older than 180 days in Housekeeping. I have also configured /etc/zabbix/zabbix_server.conf with Housekeeping information as below.

HousekeepingFrequency=1
MaxHousekeeperDelete=900000

But the record deletion has been too slow, as a result data has grown more than it has been deleted in a week.

Can I know of a clean way to get rid existing data older than 6 months, this will need to be done in the DB as I understood.

[PavelZ]

You need to do partitioning.

Here is one of the famous guides https://blog.zabbix.com/partitioning...cedures/13531/