Progressive increase in zabbix server disk usage

[jornell]

Hello,

Two weeks ago I made some changes from the frontend of the zabbix server, basically I modified some housekeeping, reducing the time interval in which it saves the history, since then the space usage has been increasing due to the database that zabbix uses in my case MariaDB.

S.O: Ubuntu 20
Zabbix Server: 6.0.18
Database: MariaDB
Host: 500 aprox






- Table Sizes 30/05



- Table sizes 29/05

Tables | Size in MB |
+----------------------------+------------+
| history_uint | 79671.08 |
| history | 30550.05 |
| history_text | 23962.31 |
| trends_uint | 14961.23 |
| trends | 5642.38 |
| auditlog | 459.05 |
| events | 258.48 |


As a temporary measure I had to delete some files that I had on the server, that is why there are considerable drops in the graph, however the progressive increase continues and in a few more days the server is full, since it is increasing 8GB per day


if anyone can help me i would be very grateful.

[cyber]

You don't have "override" in history and trends, so basically, whatever is set in item config, that stays. This really does not remove things based on time but based on when they really expire.
By setting overrides you can be sure, that you have X days of history and Y days of trends... This way, if you have an environment that does not grow rapidly, your DB should stay in pretty stable size.

[jornell]

Hello,

at the beginning it was without "Override", I modified it by placing dates up to 180 and then the progressive increase began, I'm not sure if it was because of that but because of the dates it fits with time, so to test I put it as it was to see if it would stop this progressive increase in space, yesterday I again placed dates even lower than 90 days but the increase continues today.

[cyber]

I think it will not delete everything at once. Housekeeper has its limits...