-
Problem report
-
Resolution: Fixed
-
Major
-
6.0.0rc2
-
None
-
Team B
-
Sprint 85 (Feb 2022)
-
0.5
Following query is greatly slower after 0e36dceb985
Unknown how long but already 13 minutes and one time waited for an hour and still no success.
| 468 | zabbix | localhost:55348 | zabbix | Query | 795 | executing | select t.triggerid,t.description,t.expression,t.recovery_expression from triggers t where t.triggeri |
Tried the same on 5.0 and it was 1~ second
44630:20220207:112253.470 slow query: 1.683397 sec, "select distinct t.triggerid,t.description,t.expression,t.recovery_expression from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10084 and (t.description in
Expected:
ZBXNEXT-6196 mentions oracle so MySQL performance shouldn't have been affected
Actual:
MySQL performance have degraded greatly.
Steps:
Create empty database and try to discover lots of triggers for one discovery rule
- caused by
-
ZBXNEXT-6196 Zabbix is limited on oracle to store large templates
-
- Closed
-
- is duplicated by
-
ZBX-20582 Typo in lld_trigger.c
-
- Closed
-
