Type: Incident report
Affects Version/s: 2.4.2, 2.4.3, 2.4.4
Fix Version/s: None
Environment: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
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
End : 2015-02-24 12:18:51
For additional info please see file in attach (explain and profile file make in different time).