[ZBXNEXT-7048] Convert "config" table to key-value format Created: 2021 Nov 12  Updated: 2025 Mar 03  Resolved: 2025 Mar 03

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F), Server (S)
Affects Version/s: None
Fix Version/s: 7.4.0beta1 (master)

Type: Change Request Priority: Minor
Reporter: Jurijs Klopovskis Assignee: Armands Arseniuss Skolmeisters
Resolution: Fixed Votes: 1
Labels: Zabbix7.4
Remaining Estimate: Not Specified
Time Spent: 413h 40m
Original Estimate: Not Specified

Attachments: File MANY_TEMPLATES-1.yaml     File MANY_TEMPLATES.yaml     PNG File screenshot-1.png     Text File zabbix_proxy.log    
Issue Links:
Causes
caused by ZBXNEXT-3706 mysql utf8 vs utf8mb4 Closed
Duplicate
is duplicated by ZBXNEXT-9054 Convert config table to key-value format Closed
Related
related to ZBX-25707 Not possible to separate audit record... READY TO DEVELOP
Sub-task
Team: Team C
Target end:
Sprint: S24-W42/43, S24-W44/45, S24-W46/47, S24-W48/49, S24-W50/51/52/1, S25-W2/3, S25-W4/5, S25-W6/7, S25-W8/9
Story Points: 14

 Description   

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.



 Comments   
Comment by Alex Kalimulin [ 2024 Oct 16 ]

Also, as stated in ZBXNEXT-9054, it is difficult to work with because every new parameter requires DB schema change. We should convert config table to key-value format.

This should be done for all databases, the title corrected.

Comment by Armands Arseniuss Skolmeisters [ 2025 Feb 21 ]

Available in versions:

Comment by Arturs Dancis [ 2025 Feb 27 ]

Documentation (7.4) updated:

Generated at Tue Apr 01 19:12:28 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.