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

Zabbix Dashboard load very slow on 4.0 and 3.4

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • 4.0.1
    • None
    • API (A), Frontend (F)
    • System version: Amazon 2(CentOS 7) 4CPU 16G Memory
      PHP version: 5.6
      Nginx version: 1.10
      Zabbix version: 4.0.1
      Mysql version: 5.6 (AWS RDS)
      Database Size: 10G

    Description

      hello,

         we update zabbix 2.4 to 3.4 , In the dashboard, the problem is always displayed in the load, the loading time is 20-50s. upgrade 4.0.1 version, the problem still exists.

        Problems api: http://127.0.0.1/zabbix.php?sid=bb0de0c7433f6a4f&action=widget.problems.view

        Load size: 329k

        Load time: 20 ~ 50s

        Php slow log: 

      [16-Nov-2018 04:16:23]  [pool www] pid 21993
      
      script_filename = /usr/share/zabbix/zabbix.php
      
      [0x00007effdf2ceaf8] mysqli_query() /usr/share/zabbix/include/db.inc.php:364
      
      [0x00007effdf2cdbe8] DBselect() /usr/share/zabbix/include/classes/api/services/CEvent.php:478
      
      [0x00007effdf2c9d60] getEvents() /usr/share/zabbix/include/classes/api/services/CEvent.php:132
      
      [0x00007ffd4316c510] get() unknown:0
      
      [0x00007effdf2c8db0] call_user_func_array() /usr/share/zabbix/include/classes/api/clients/CLocalApiClient.php:123
      
      [0x00007effdf2c8390] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CFrontendApiWrapper.php:97
      
      [0x00007effdf2c8170] callClientMethod() /usr/share/zabbix/include/classes/api/wrappers/CApiWrapper.php:94
      
      [0x00007effdf2c8020] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CFrontendApiWrapper.php:63
      
      [0x00007effdf2c7be0] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CApiWrapper.php:82
      
      [0x00007ffd4316ced0] __call() unknown:0
      
      [0x00007effdf2c7840] get() /usr/share/zabbix/include/events.inc.php:479
      
      [0x00007effdf2c48d0] make_popup_eventlist() /usr/share/zabbix/app/views/monitoring.widget.problems.view.php:156
      
      [0x00007effdf2c0c58] +++ dump failed
      

      Database sql: 

      SELECT DISTINCT e.eventid,e.clock,e.ns,e.objectid,er1.r_eventid FROM events e LEFT JOIN event_recovery er1 ON er1.eventid=e.eventid WHERE e.source='0' AND e.object='0' AND e.objectid='99996' AND e.eventid<='12910327' AND e.value='1' ORDER BY e.eventid DESC LIMIT 20
      

       

      How can I solve this problem? thinks!

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              liuzhihao liuzhihao
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: