??? Housekeeper ??? [Archive]

krusty

14-12-2005, 16:23

Hi all,

i want to know how the housekeeper works? Can somebody told me about this? Specially how i can configure this.
Because i create a new table to zabbix database and i want to delete all entry which older than the housekeeper is set.

Thanks

krusty

15-12-2005, 08:33

Hi, i have another question about values in zabbix database. How long stored the values for e.g. trends or history in zabbix database?

I ask, because i put the value of houskeeper to 30 days. I have installed zabbix in october 2005 but all entries are still in zabbix database. I thought that the housekeeper delete entries are older than 30 days but nothing was done. Is this right?

krusty

21-12-2005, 10:44

Hi, i have another question to housekeeper. Can somebody told me in which intervalls the housekeeper works?

krusty

16-01-2006, 14:52

I really do not understand what the housekeeper for. I set the interval to 90 days for both housekeepers, but when i check the values in the database there are entries which are older than 90 days. Should i set another value? Can somebody help me.

Nate Bell

16-01-2006, 15:49

I'm seeing the same behavior from the housekeeper, so I suspect it does not work. In fact, if you browse the TODO list in the Zabbix CVS, you can find this line:
- improve housekeeper. check if it works correctly.
If hard disk space is becoming an issue, there is likely a SQL command you can use to drop entries from your history that are older than 90 days. I don't have such a command for you, I just have a large enough hard drive. :)

Nate

krusty

17-01-2006, 08:40

How can i check the housekeeper. I see that the entries older then 90 days if i look into the database. So i think the housekeeper dosen´t work really. My hard drive is big enough, but i want that the houskeeper is running right.

bibi23

27-07-2006, 15:04

Hi,

I install zabbix 1.1.1 and i think housekeeper does not work properly.
I create only 4 items (every 5s, 10s 20s and 30s) and set keep 1 day history .
So, database should contains only 33120 history rows.
But there is 105795 rows.

I have the same problem with zabbix 1.0. My databse is around 50 GB :-)

Are you planed to fix this bug in the next release ?

Thanks

Alexei

27-07-2006, 18:49

This is something unbelievable! Indeed, for some unknown reason, piece of code responsible for removal of historical data has been commented out in 1.1 and 1.1.1. I just re-tested all this and discovered that ZABBIX removes nothing from history and trends.

Sorry for this! The problem is fixed and the fix will be available in 1.1.2.

vrtareg

28-07-2006, 07:41

Hi

Is there some schedule for the 1.1.2 release?
I use 1.1.1 and my database is growing and growing :)

Thanks
Areg

Alexei

28-07-2006, 07:59

Here is the patch. Overwrite exiting src/zabbix_server/housekeeper/housekeeper.c with attached file and recompile the server.

In server log file you'll find information about number of deleted records from history and trends.

vrtareg

28-07-2006, 08:05