Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4212

Change zabbix history add DUPLICATE KEY UPDATE clause to db history insertion

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 3.4.3
    • Server (S)
    • None

      Hi, zabbix some time duplicate values in history table (I use mariadb)
      That not critical, but useless

      Why i think that make a sense:
      1. It's a nonsense when DB have same or different values for that unique itemid+clock+ns
      2. That allow make itemid+clock+ns as primary key on history tables
      3. That reduce size index and db
      4. That will not break anything

      For me that also have a sense, because i can change TokuDB scheme for history tables, set primary keys and drop secondary indexes

      Thanks

            wiper Andris Zeila
            nefelim4ag Timofey
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: