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

System Status widget is slow on a big installation.

    Details

      Description

      This debug for a user with access to 3 hosts.

      SQL (10.818281): SELECT DISTINCT t.triggerid,t.priority,t.state,t.description,t.error,t.value,t.lastchange,t.expression FROM triggers t,functions f,items i,hosts_groups hg WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid='62' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid='167' 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.value='1' AND t.flags IN ('0','4') ORDER BY t.lastchange DESC
      dashboard.php:142 ? make_system_status() ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() in /zabbix/include/classes/api/CZBXAPI.php:1016
      ******************** Script profiler ********************
      Total time: 13.208669
      Total SQL time: 11.940816
      SQL count: 513 (selects: 498 | executes: 15)
      Peak memory usage: 32M
      Memory limit: 756M

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              oleg.ivanivskyi Oleg Ivanivskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: