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

XMLWordPrintable

    • Type: Change Request
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 3.4.3
    • Component/s: 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

            Assignee:
            Andris Zeila
            Reporter:
            Timofey
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: