-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
None
-
Technical backlog, S24-W36/37
Show queries take very long time on installations with very limited resources:
*************************** 1. row ***************************
query: SHOW VARIABLES LIKE ?
exec_count: 34
total_exec_time_sec: 7940.9905
avg_exec_time_sec: 233.5585
*************************** 2. row ***************************
query: SHOW TABLES LIKE ?
exec_count: 34
total_exec_time_sec: 6186.3658
avg_exec_time_sec: 181.9519
*************************** 3. row ***************************
query: SELECT `han` . `ha_nodeid` , `han` . `address` , `han` . `port` , `han` . `lastaccess` FROM `ha_node` `han` WHERE `han` . `status` = ? ORDER BY `han` . `lastaccess` DESC LIMIT ?
exec_count: 4
total_exec_time_sec: 1561.7748
avg_exec_time_sec: 390.4437
*************************** 4. row ***************************
query: SELECT `valuemapid` , `hostid` FROM `valuemap` WHERE `valuemapid` IS NULL
exec_count: 10
total_exec_time_sec: 1227.9473
avg_exec_time_sec: 122.7947
They should be avoided by using mysqli_set_charset and select null from dbversion
- part of
-
ZBX-24962 Zabbix 7.0 is using more memory
-
- Need info
-
