XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 5.2.3
    • Server (S)
    • None

      Steps to reproduce:

      1. Create 10 hosts with 400 triggers.
      2. Navigate to Monitoring -> Hosts
      3. Web page load slowly . (More than 10 seconds)

      Result:

       

      Time by script profiler debug:

      
      ******************** Script profiler ********************
      Total time: 8.946059
      Total SQL time: 8.506547
      SQL count: 327 (selects: 222 | executes: 116)
      Peak memory usage: 28M
      Memory limit: 256M 
      Query slow:
      
      SQL (8.121343): SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid IN (10788,10789,10790,10833,10834,10835,10836,10837,10838,10839,10840,10841,10842,10843,10844,10845,10846,10947,10948,10967,10970,10971,10972,10973,10974,10981,10982,10983,10984,11069,11070,11071,11072,11073,11074,11075,11076,11086,11087,11088,11089,11184,11185,11189,11190,11191,11213,11215,11216,11315) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN (0,4)
      

      Expected:
      Query optimized.

            zabbix.dev Zabbix Development Team
            dpinol Dani Pinol
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: