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

Slow query on Administration->Notifications page

    Details

      Description

      It happens since Zabbix 2.2.

      Zabbix 2.0
      ******************** Script profiler ********************
      Total time: 2.325396
      Total SQL time: 0.221551
      SQL count: 227 (selects: 55 | executes: 172)
      Peak memory usage: 186.75M
      Memory limit: 2048M
      
      Zabbix 2.2
      ******************** Script profiler ********************
      Total time: 27.945257
      Total SQL time: 26.143435
      SQL count: 53 (selects: 21 | executes: 32)
      Peak memory usage: 77M
      Memory limit: 2048M
      

      The page uses API query which performs the next query:

      SELECT a.alertid,a.mediatypeid,a.userid,a.clock FROM alerts a WHERE EXISTS (SELECT NULL FROM events e WHERE a.eventid=e.eventid AND e.source='0' AND e.object='0') AND a.clock>'1388340000' AND a.clock<'1413675166';
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                dotneft Alexey Pustovalov
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: