Ad Widget

Collapse

Zabbix disable database partitioning

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mpolitaev
    Member
    • Jun 2015
    • 32
    #1

    Zabbix disable database partitioning

    Hello team!

    We have implemented a databases partitioning in our MySQL database, but is there a way to disable those changes and back to Zabbix's internal housekeeper?
    Tags: None
    • kloczek
      Senior Member
      • Jun 2006
      • 1771
      #2
      Administration -> General -> Housekeeping
      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

        • mpolitaev
          Member
          • Jun 2015
          • 32
          #3
          Originally posted by kloczek
          Administration -> General -> Housekeeping
          Are you sure? When we implement external housekeeping we made some changes with tables (https://www.zabbix.org/wiki/Docs/how...#Documentation) and now no need revert this changes? Just disable external housekeeper script and enable internal (Administration -> General -> Housekeeping)?

          What will be if we reach last partitioned tables which was created last time?

            Comment

            • mpolitaev
              Member
              • Jun 2015
              • 32
              #4
              Anyone know?

              What will be with partitioned tables, for examples with history. If i just enable internal housekeeper?

              Code:
              PARTITION p201711172300 VALUES LESS THAN (1511067600) ENGINE = InnoDB.
              It is last partition on my history table. What will be after 17 Nov 2017? As i remember, last time when it was, new values cant write to DB.

              Thank you.

                Comment

                Previous template Next
                Working...