uint.ibd growing more than expected

[zabbixuser1]

Hello,

My zabbix server disk space started increasing recently. It was fine few months ago. i can see that history_uint.ibd table is using 300G appx disk space. Any idea why this table started consuming such huge amount recently? Any setting in zabbix needs to ab tweaked?

[kloczek]

Yes, you are collecting more data now or more frequently or not removing oldest data.
How much db grow in those few months?

[zabbixuser1]

you are collecting more data now or more frequently or not removing oldest data. >> We have not made any changes at all. This started suddenly.

How much db grow in those few months? >> appx. 200G

[Atsushi]

You are posting even the issue of housekeeper.

https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/706-housekeeping-stopped-working

The deletion processing of old data may not catch up, possibly the size of the database is increasing.
Please improve database processing performance or consider using database partitioning as vso mentioned.

[kloczek]

How much db grow in those few months? >> appx. 200G

So it may means that:
- if you don't have history* tables partitioned on some items you have very long History storage period
- if you are using partitioned history* tables you are not deleting oldest partitions