Performance of distributed setup is bad due to wrong index

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Critical
    • 1.8.1, 1.9.0 (alpha)
    • Affects Version/s: 1.8, 1.8.1, 1.8.2, 1.9.0 (alpha)
    • Component/s: None
    • None
    • Environment:
      1.8.x, trunk

      Synchronization of configuration data works highly inefficiently due to incorrect index in Zabbix database.

      Existing index

      INDEX |cksum_1 |nodeid,tablename,recordid,cksumtype

      should be replaced with

      INDEX |cksum_1 |nodeid,cksumtype,tablename,recordid

            Assignee:
            Alexander Vladishev
            Reporter:
            Alexei Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: