Zabbix 4.4.5 Why is the database size not decreasing?

Question

MySQL

History cleaning is configured, Items also do not store history for more than 90 days, but the database is growing. Already once I encountered that there was not enough disk space (I had to expand the virtual machine).

Need advice on where to look and what to do. Judging by the schedule, there is some kind of cleaning, but it is clearly not enough.

Here is a larger view for two days

The database is running on MariaDB
Zabbix version 4.4.5
If you need any other data, ask in the comments. Thank you.

Answer 1

It is not enough just to set the values ​​in the web interface, you need to uncomment the lines in the zabix config /etc/zabbix/zabbix_server.conf
HouseKeeperFrequency=X - where X is the frequency of cleaning the database, I have 1 - it means it cleans every hour, look at your database, it is possible if the load is high you can put 8 (every 8 hours)
and the 2nd line below you need to uncomment it
MaxHouseKeeperDelete=x - de X the number of elements that the system deletes in 1 cycle of cleaning the database, I have 20000 (that is, my system deletes 20000 elements every hour) you write a base per hour, for example, 55000. But here, too, you need to be careful that when cleaning a large number of resource elements, the HDD is enough to write to the database

Answer 2

Try to do so.
https://bestmonitoringtools.com/zabbix-partitionin...