-
Problem report
-
Resolution: Unresolved
-
Trivial
-
7.2.10
-
None
-
S25-W34/35
SELECT triggers queries are the cause for much blocking and wait time, in some cases for several hours.
Looking for ways to refactor the query to Zabbix Frontend
SELECT d.triggerid_down,d.triggerid_up,t.value FROM trigger_depends d,triggers t WHERE d.triggerid_up=t.triggerid AND (d.triggerid_down IN (2917379,2917380,2917381,2917382,2917383,2917384,2917771,2917772,2917773,2917774,2917775,2917776,2917782,2917783,2917784,2917785,2917786,2917787,2917793,2917794,2917795,2917796,2917797,2917798,2917804,2917805,2917806,2917807,2917808,2917809,2917815,2917816,2917817,2917818,2917819,2917820,2917826,2917827,2917828,2917829,2917830,2917831,2917837,2917838,2917839,2917840,2917841,2917842,2917848,2917849,2917850,2917851,2917852,2917853,2917859,2917860,2917861,2917862,2917863,2917864,2917870,2917871,2917872,2917873,2917874,2917875,2917881,2917882,2917883,2917884,2917885,2917886,2917892,2917893,2917894,2917895,2917896,2917897,2917903,2917904,2917905,2917906,2917907,2917908,2917914,2917915,2917916,2917917,2917918,2917919,2917925,2917926,2917927,2917928,2917929,2917930,2917936,2917937,2917938,2917939,2917940,2917941,2917947,2917948,2917949,2917950,2917951,2917952,2917958,2917959, …
Please find more details attached.