Ad Widget

Collapse

housekeeper table in zabbix db

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FrankieWildie
    Junior Member
    • Feb 2019
    • 3

    #1

    housekeeper table in zabbix db

    Hello.
    There is a table housekeeper.ibd inside zabbix mysql database

    Code:
    mysql> describe housekeeper;
    +---------------+---------------------+------+-----+---------+-------+
    | Field         | Type                | Null | Key | Default | Extra |
    +---------------+---------------------+------+-----+---------+-------+
    | housekeeperid | bigint(20) unsigned | NO   | PRI | NULL    |       |
    | tablename     | varchar(64)         | NO   |     |         |       |
    | field         | varchar(64)         | NO   |     |         |       |
    | value         | bigint(20) unsigned | NO   |     | NULL    |       |
    +---------------+---------------------+------+-----+---------+-------+
    4 rows in set (0.07 sec)
    I need to clean up it may be wipe at all. Is it safe to delete data here?
  • FrankieWildie
    Junior Member
    • Feb 2019
    • 3

    #2
    There is some information in the article https://zabbix.org/wiki/Docs/howto/mysql_partitioning

    1. Even with the housekeeping for items disabled, Zabbix server and web interface will keep writing housekeeping information for future use into the housekeeper table. To avoid this, you can set ENGINE = Blackhole for this table:
    Some thoughts:

    1. What is future use from housekeeper table?
    2. If houskeeper is disabled and ENGINE is set to Blackhole, is it safe to delete data?

    Comment

    • kloczek
      Senior Member
      • Jun 2006
      • 1771

      #3
      Originally posted by FrankieWildie
      I need to clean up it may be wipe at all. Is it safe to delete data here?
      Why you need to do this?

      http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
      https://kloczek.wordpress.com/
      zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
      My zabbix templates https://github.com/kloczek/zabbix-templates

      Comment

      • FrankieWildie
        Junior Member
        • Feb 2019
        • 3

        #4
        Originally posted by kloczek
        Why you need to do this?
        It's too big - 32Gb

        Comment

        Working...