Not sure if it should be posted here
Used to have about 5400 NVPS. My Database size got really big (about 940 GBs) -> Decided to lower some data collection frequency for some groups. After adjustments my NVPS became about 2800 NVPS.
Data for adjusted groups is stored for 14 days. So, as I undestand, after that time housekeeper should have cleaned data, collected when I used to have 5400 NVPS and database size should have decreased. But this didn't happen.
Currently the biggest table is history_uint (about 3.3 billion rows) and it didn't noticeably reduce after changes, even though I collect twice as less data of this type after my adjustments.
Any ideas what could have I done wrong?
Installation: AlmaLinux 8.7 + MariaDB 10.3.25 + Zabbix Server 5.0.31.
Used to have about 5400 NVPS. My Database size got really big (about 940 GBs) -> Decided to lower some data collection frequency for some groups. After adjustments my NVPS became about 2800 NVPS.
Data for adjusted groups is stored for 14 days. So, as I undestand, after that time housekeeper should have cleaned data, collected when I used to have 5400 NVPS and database size should have decreased. But this didn't happen.
Currently the biggest table is history_uint (about 3.3 billion rows) and it didn't noticeably reduce after changes, even though I collect twice as less data of this type after my adjustments.
Any ideas what could have I done wrong?
Installation: AlmaLinux 8.7 + MariaDB 10.3.25 + Zabbix Server 5.0.31.
Move air to a little balloon to get rid of extra material and nice trim shape of the balloon ..
Comment