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

Details

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

    Description

      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

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: