On Wednesday 29 June 2016 at 15:52:54, Diana Scannicchio wrote:
> We tried few months ago to upgrade to v2.4.1, unfortunately the restart of
> the icinga2 service was hanging forever apparently due to some bad
> interaction with mysql. Once we disabled ido-mysql, it started. We setup
> a test server, identical to the production one with the exception of the
> HA, to be able to play and we observed the same behaviour.
> [2016-06-01 16:19:03 +0200] information/IdoMysqlConnection: Query queue
> items: 987844, query rate: 0.7/s (42/min 46/5min 2251/15min); empty in
> infinite time, your database isn't able to keep up
Are you doing any MySQL logging (for example, slow queries) to see what it
thinks is going on?
If not, what do you get by connecting to MySQL as a privileged user and asking
it to "show processlist"?
Also, what do you see in 'top' for CPU and memory usage for MySQL?
Antony.
--
The Magic Words are Squeamish Ossifrage.
Please reply to the list;
please *don't* CC me.
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
