Re: [icinga-users] Slow query on Icinga2

2015-09-07 Thread Romaneev Vasily
Michael, thank you the link, it's funny, but last time i did not find "New Issue" button. Thank you for the help! Hi, Thomas, i'd checked for concurent mysql statements. This request was only one. In iotop mysql use whole disk write IO. So i have big load average on my VPS. After create this in

Re: [icinga-users] Slow query on Icinga2

2015-09-03 Thread Thomas Gelf
Hi Romaneev, it would be great if you could report this on dev.icinga.org, we are currently trying to improve IDO indices. I was missing one detail in your mail, how long did the query take with the new index? Could you show a processlist output where such a query is hanging around? Is it waiting

Re: [icinga-users] Slow query on Icinga2

2015-09-03 Thread Michael Friedrich
Am 25.08.2015 um 23:49 schrieb Romaneev Vasily: I have huge table icinga_downtimehistory. About 100k records. And sometime mysql locks up to 15s on update the table. I've found, that there's missing index, so please add this to a next release of icinga2, thank you! P.S> Will be appreciated if