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

Slow query on Administration->Notifications page

XMLWordPrintable

      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';
      

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

              Created:
              Updated:
              Resolved: