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

extremly slow latest data display

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.6, 1.9.0 (alpha)
    • None
    • Frontend (F)
    • None

    Description

      monitoring -> latest data, group selected, all hosts from that group. two sql queries take very long to execute :

      Time:19.599714 LONG SQL: SELECT DISTINCT h.host,h.hostid FROM hosts h,hosts_groups hg , items i LEFT JOIN items_applications ia ON ia.itemid=i.itemid WHERE ia.itemid is NULL AND hg.hostid=h.hostid AND hg.groupid=10 AND h.hostid=i.hostid AND h.status=0 AND i.status=0 AND (h.hostid IN (0,10117,10118,10119,10120,10124,10123,10125,10331,10121,10330,10122,10126,10127,10328,10128,10129,10130,10131,10329,10332,10132,10133,10134,10135,10136,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146)) ORDER BY h.host
      Time:12.807102 LONG SQL: SELECT DISTINCT h.host,h.hostid,i.* FROM hosts h,hosts_groups hg , items i LEFT JOIN items_applications ia ON ia.itemid=i.itemid WHERE ia.itemid is NULL AND hg.hostid=h.hostid AND hg.groupid=10 AND h.hostid=i.hostid AND h.status=0 AND i.status=0 AND (h.hostid IN (10117,10118,10119,10120,10124,10123,10125,10331,10121,10330,10122,10126,10127,10328,10128,10129,10130,10131,10329,10332,10132,10133,10134,10135,10136,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146)) ORDER BY i.description,i.itemid

      Attachments

        Activity

          People

            Unassigned Unassigned
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: