Ad Widget

Collapse

??? Housekeeper ???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • krusty
    Senior Member
    • Oct 2005
    • 222

    #1

    ??? Housekeeper ???

    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
    Senior Member
    • Oct 2005
    • 222

    #2
    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?
    Last edited by krusty; 15-12-2005, 09:38.

    Comment

    • krusty
      Senior Member
      • Oct 2005
      • 222

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

      Comment

      • krusty
        Senior Member
        • Oct 2005
        • 222

        #4
        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.

        Comment

        • Nate Bell
          Senior Member
          • Feb 2005
          • 141

          #5
          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

          Comment

          • krusty
            Senior Member
            • Oct 2005
            • 222

            #6
            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.

            Comment

            • bibi23
              Member
              • Oct 2005
              • 64

              #7
              housekeeper seems to not work (Zabbix 1.1.1)

              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

              Comment

              • Alexei
                Founder, CEO
                Zabbix Certified Trainer
                Zabbix Certified SpecialistZabbix Certified Professional
                • Sep 2004
                • 5654

                #8
                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.
                Alexei Vladishev
                Creator of Zabbix, Product manager
                New York | Tokyo | Riga
                My Twitter

                Comment

                • vrtareg
                  Senior Member
                  • May 2006
                  • 293

                  #9
                  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

                  Comment

                  • Alexei
                    Founder, CEO
                    Zabbix Certified Trainer
                    Zabbix Certified SpecialistZabbix Certified Professional
                    • Sep 2004
                    • 5654

                    #10
                    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.
                    Attached Files
                    Alexei Vladishev
                    Creator of Zabbix, Product manager
                    New York | Tokyo | Riga
                    My Twitter

                    Comment

                    • vrtareg
                      Senior Member
                      • May 2006
                      • 293

                      #11
                      Originally posted by Alexei
                      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.
                      Thanks !!!!
                      Areg

                      Comment

                      Working...