-
Problem report
-
Resolution: Won't Do
-
Minor
-
None
-
4.0.1
-
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.7 (AWS RDS)
Hello,
we zabbix dashbaord overview page load failed, please help solution this problem.
Problem API: http://10.0.5.226/overview.php?ddreset=1
PHP Slow Log:
[30-Nov-2018 12:28:37] [pool apps] pid 18472 script_filename = /usr/share/zabbix/overview.php [0x00007f2b60fd77f8] mapMany() /usr/share/zabbix/include/classes/api/CRelationMap.php:73 [0x00007f2b60fd72f0] mapMany() /usr/share/zabbix/include/classes/api/services/CTrigger.php:1255 [0x00007f2b60fd5620] addRelatedObjects() /usr/share/zabbix/include/classes/api/services/CTrigger.php:453 [0x00007ffff5b9dce0] get() unknown:0 [0x00007f2b60fd0450] call_user_func_array() /usr/share/zabbix/include/classes/api/clients/CLocalApiClient.php:123 [0x00007f2b60fcfa30] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CFrontendApiWrapper.php:97 [0x00007f2b60fcf810] callClientMethod() /usr/share/zabbix/include/classes/api/wrappers/CApiWrapper.php:94 [0x00007f2b60fcf6c0] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CFrontendApiWrapper.php:63 [0x00007f2b60fcf280] callMethod() /usr/share/zabbix/include/classes/api/wrappers/CApiWrapper.php:82 [0x00007ffff5b9e6a0] __call() unknown:0 [0x00007f2b60fcf0c0] get() /usr/share/zabbix/include/triggers.inc.php:752 [0x00007f2b60fce6c0] getTriggersWithActualSeverity() /usr/share/zabbix/include/items.inc.php:1049 [0x00007f2b60fcc058] getItemsDataOverview() /usr/share/zabbix/include/views/monitoring.overview.items.php:115 [0x00007f2b60fca0c0] +++ dump failed
database has slow sql? and how to fix this problem?
thanks everyone~~