zabbxi db is increasting 1GB every two days.

[Balaraju]

Hi team,

I am using the zabbix2.4 in centos. My db is increasing 1GB every two days. I have enabled the housekeeping as every 31 days. Can any body tell the what might be problem.

[batchenr]

Hi team,

I am using the zabbix2.4 in centos. My db is increasing 1GB every two days. I have enabled the housekeeping as every 31 days. Can any body tell the what might be problem.

see ref for this issue :

https://www.zabbix.com/forum/showthread.php?t=9925

i have used this too:
http://dba.stackexchange.com/questio...bdata-in-mysql

let us know if all went ok
be sure to backup mysql first! and even snapshot the server!

[Pada]

For how long have your setup been running and what is your typical amount of days that you keep the item history and item trends for?

Like we're not using the "innodb_file_per_table" and our Zabbix database isn't increasing in size that much and we're doing almost 1000 nvps (new values/s).
The deletions that the housekeeper makes does not free up visible disk space, but it allows for new data to be inserted into the place where records was deleted previously - or at least that is what I understand from it.

So if you're keeping history for 90 days (which is the default on the stock Zabbix templates), and you've only been running your Zabbix system for less than 90 days, then Zabbix will consume a lot of disk space, no matter what you do (except for changing the amount of history to keep for the items).