-
Incident report
-
Resolution: Unresolved
-
Trivial
-
None
-
2.4.2, 2.4.3, 2.4.4
-
DB soft: 10.0.15-MariaDB-wsrep-log for Linux on x86_64
DB hard: Intel Xeon E5-2650 x2 / RAM 64Gb / LSI MR9271-8i, Cache 1Gb, RAID-10 / HDD SAS 600Gb x4
PHP: PHP 5.4.5
HTTPD: Apache/2.2.22
Low performance in WEB-interface: "Monitoring" -> "Triggers" with high number active triggers. Refresh time for interface in 1-2min.
Total Host in configuration: 4340
Total Item: 859481
Total Trigger: 406991
Active triggers for different Hostgroup:
>40 - refresh time 20sec
>90 - refresh time 30sec
>700 - refresh time 1:30min
>900 - refresh time 1:40min
Partitioning on DB is active. Active history for 1 month.
Long query after SQL builder (API):
Start: 2015-02-24 12:17:12
SELECT t.triggerid,t.lastchange FROM triggers t 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 IN ('121','125','126','128','129') 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 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 EXISTS (SELECT NULL FROM events e WHERE t.triggerid=e.objectid AND e.source=0 AND e.object=0 AND e.value=1 AND e.acknowledged=0) AND t.flags IN ('0','4') AND ((t.value=1) OR ((t.value=0) AND (t.lastchange>1424772852))) ORDER BY t.lastchange DESC
End : 2015-02-24 12:18:51
For additional info please see file in attach (explain and profile file make in different time).
