Abnormal database grow with housekeeper enabled

[DukeNukem3D]

Hi all!

I have zabbix 2.2.7 installation with PostgreSQL 9.3 as a database. I had always disabled housekeeper and now noticed that database is too large (300GB) and decided to enable it, maybe for a while. Disk I/O raised much and it did not surprise me, but what I saw then - actually disk usage is growing approximately 1G/minute. When I disable houseekeping, there is no such behavior. Well now I have 400GB disk usage.
What am I missing?

[kloczek]

Hi all!

I have zabbix 2.2.7 installation with PostgreSQL 9.3 as a database. I had always disabled housekeeper and now noticed that database is too large (300GB) and decided to enable it, maybe for a while. Disk I/O raised much and it did not surprise me, but what I saw then - actually disk usage is growing approximately 1G/minute. When I disable houseekeping, there is no such behavior. Well now I have 400GB disk usage.
What am I missing?

That this is not an zabbix issue but normal mysql behavior when you are constantly deleting and inserting records.
Solution is stop using zabbix HK and start using partitioned history* and trends* tables.
Partitioning still is not supported by zabbix OOTB so you must do this by yourself.
Try to google for "zabbix partitioning".

[DukeNukem3D]

Thanks, but I have not MySQL, but PostgreSQL. Ok will google, it seems same things apply too.

[kloczek]

Thanks, but I have not MySQL, but PostgreSQL. Ok will google, it seems same things apply too.

The same is on PostgreSQL. I didn't know what database backend you are using and this is why I've advised you to search using google