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

Convert "config" table to key-value format

XMLWordPrintable

    • S24-W42/43, S24-W44/45, S24-W46/47, S24-W48/49, S24-W50/51/52/1, S25-W2/3, S25-W4/5
    • 14

      DB table `config` stores everything in a single row. This poses an issue with mysql limitations on maximum row size. https://dev.mysql.com/doc/mysql-reslimits-excerpt/8.0/en/column-count-limit.html#row-size-limits

      In particular:

      The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, even if the storage engine is capable of supporting larger rows. BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row. 

      We are reaching this limit with `config` table.

      Propose to redesign the way we store data, that currently resides in `config` table, to eliminate this issue altogether.

        1. MANY_TEMPLATES.yaml
          4 kB
        2. MANY_TEMPLATES-1.yaml
          4 kB
        3. screenshot-1.png
          screenshot-1.png
          46 kB
        4. zabbix_proxy.log
          3.12 MB

            askolmeisters Armands Arseniuss Skolmeisters
            yurii Jurijs Klopovskis
            Team C
            Votes:
            1 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 311h 50m
                311h 50m