[icinga-users] icinga{,web}2: Slow queries after update

Klaus Muth muth at hagos.de
Wed Nov 18 08:44:50 CET 2015


Hi!
I've got some Problems after updating to icinga2 2.4.0 + icingaweb2 2.1.0
with my mysql Database - especially Report/Alert Summary and
History/Notifications gives me slow queries like hell:

# Query_time: 254.459070  Lock_time: 0.000332 Rows_sent: 1  Rows_examined: 0
# Query_time: 5.766696  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 5.373292  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 5.640845  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 5.762252  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 7.297739  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 8.253388  Lock_time: 0.000088 Rows_sent: 0  Rows_examined: 1
# Query_time: 5.648985  Lock_time: 0.000288 Rows_sent: 2  Rows_examined: 4730
# Query_time: 5.655411  Lock_time: 0.000213 Rows_sent: 10  Rows_examined: 8253
# Query_time: 7.112222  Lock_time: 0.000345 Rows_sent: 1  Rows_examined: 10900
# Query_time: 5.914227  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
# Query_time: 284.937383  Lock_time: 0.000322 Rows_sent: 25  Rows_examined:
129094089

This was just for the History/Notifications. The icinga server load went up
to 8 while the queries were running.

Missing indices? Some other problem?
-- 
Klaus Muth
Hagos eG                   EDV                    Tel: 0711/78805-7085
Zentrale Stuttgart         Industriestr. 62       Fax: 0711/78805-7035
http://www.hagos.de        70565 Stuttgart               muth at hagos.de

Hagos eG
Sitz:                      Stuttgart
Rechtsform:                Genossenschaft
Registergericht:           Stuttgart GnR 77
Vorstände:                 Guido Eichel, Ralf Tigges
Aufsichtsratsvorsitzender: Thomas Müller
USt.-ID-Nr.:               DE 147799748


More information about the icinga-users mailing list