Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-26781

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

XMLWordPrintable

    • 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.

            zabbix.dev Zabbix Development Team
            ifedotjevs Ilja Fedotjevs
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: