my database of zabbix is growing too large, I noticed that my VM is taking more and more place in DB, how do you trade on it, can we think to patch the @mrmarkuz to fix this ?
Removing old history data would be a way:
It’s an old issue, here are some good advices:
Maybe we can also optimize the housekeeping settings?
I try the housekeeping set to 90days, not easy to find, quite hidden menu
[root@zabbix ~]# zabbix_server -c /etc/zabbix/zabbix_server.conf -R housekeeper_execute
The Link you provided is 10 years old, the Version of Zabbix is 2.x, and the used Database at the time seems to be “Hudge-DB”…
Today, MySQL or PostgreSQL are being used!
I do have a more or less working script for this, though!
I can provide the code and reasoning behind it, if you want.
And also good to know:
My 2 cents
yes please we could add it to the wiki or think to add them inside the rpm
the sql script you gave is a screenshot and I am too lazzy to rewrite them
I’ll provide you the link to the files on my Nextcloud as a PM within the next hour - I need to check if the “master” copy was moved to my newer Macbook…
But I still have it on some storage - and in the root folder of my NethServer.
I’d be glad if you, as a achieved and respected coder, could into look into the (commented!) code and provide feedback / improvement.
My 2 cents