-
Problem report
-
Resolution: Won't fix
-
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.