Re: [icinga-users] your database isn't able to keep up

2017-02-23 Thread Michael Martinez
On Fri, Feb 17, 2017 at 1:41 PM, Tobias von der Krone wrote: >> >> What does this mean and what should I do to fix it? > > That means that your database is too slow and you're queue items will > steadily increase. Actually, 86 queries per second is really slow. What > database are you using and wh

Re: [icinga-users] your database isn't able to keep up

2017-02-18 Thread Michael Martinez
I noticed the following entry in the log: [2017-02-18 03:21:23 -0500] information/IdoMysqlConnection: Query queue items: 1199, query rate: 60.5167/s (3631/min 22126/5min 56395/15min); empty in infinite time, your database isn't able to keep up [2017-02-18 03:21:38 -0500] information/IdoMysqlConnec

Re: [icinga-users] your database isn't able to keep up

2017-02-18 Thread Michael Martinez
On Sat, Feb 18, 2017 at 6:59 AM, Joosten, Markus wrote: > On 2017-02-17 23:33, Michael Martinez wrote: > > My guess would be that the 100 IOPS are the bottleneck, which obviously is > not much when you already have 86 database queries per second. > I'd try analyzing the system performance using io

Re: [icinga-users] your database isn't able to keep up

2017-02-18 Thread Joosten, Markus
On 2017-02-17 23:33, Michael Martinez wrote: On Fri, Feb 17, 2017 at 1:41 PM, Tobias von der Krone wrote: That means that your database is too slow and you're queue items will steadily increase. Actually, 86 queries per second is really slow. What database are you using and what specs does

Re: [icinga-users] your database isn't able to keep up

2017-02-17 Thread Michael Martinez
On Fri, Feb 17, 2017 at 1:41 PM, Tobias von der Krone wrote: > > That means that your database is too slow and you're queue items will > steadily increase. Actually, 86 queries per second is really slow. What > database are you using and what specs does your database server have? > mysql-5.5, ru

Re: [icinga-users] your database isn't able to keep up

2017-02-17 Thread Tobias von der Krone
Hi. On 2017-02-17 22:07, Michael Martinez wrote: I'm seeing the following messages in my icinga2.log: [2017-02-17 16:04:39 -0500] information/IdoMysqlConnection: Query queue items: 227, query rate: 86.5/s (5190/min 18524/5min 57927/15min); empty in infinite time, your database isn't able to kee

[icinga-users] your database isn't able to keep up

2017-02-17 Thread Michael Martinez
I'm seeing the following messages in my icinga2.log: [2017-02-17 16:04:39 -0500] information/IdoMysqlConnection: Query queue items: 227, query rate: 86.5/s (5190/min 18524/5min 57927/15min); empty in infinite time, your database isn't able to keep up What does this mean and what should I do to fi