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 [email protected] 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 _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
