Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22365

changelog table growing large very fast

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.2.7
    • None
    • None
    • Zabbix 6.2.7, Rocky EL 8.7

      For Zabbix 6.2 it looks like there is a changelog table which is believe is used for the deterministic database triggers for faster configuration syncing from ZBXNEXT-7554. It grows very huge and is about as large as my triggers and items table.  This seems bad.

      As my instance increases in size I get a slow query message for:

      {slow query: 7.595858 sec, "select changelogid,object,objectid,operation,clock from changelog"}

      If this is used for incremental configuration syncing can that query be tightened to include a range for the clock field (i.e. clock >= LAST_SYNC_TIME and clock <= now)? Also, does the housekeeper clean up records from this table? I couldn't find anything after checking through src/zabbix_server/housekeeper. The lack of cleanup seems like it could amount to a very large table and slower configuration sync.

       

            zabbix.support Zabbix Support Team
            GRyan337 Ryan Eberly
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: