Nagios Support Forum

I watched Nagios over the weekend and saw no issues. it's back to working normally. You can close this issue.

Thanks for all the help!

Mark

I applied option 0 and it seems to be working. The mysql process load is minimal and I've not seen any instances where the updates stop. I'll keep an eye on it over the weekend and give an update Monday morning.

Thanks!

Mark

Here's the output:

[root@mvsc1lx0128 ~]# mysql -undoutils -pn@gweb nagios <<< 'select count(*) from nagios_commenthistory union all select count(*) from nagios_commenthistory where deletion_time > from_unixtime(0);'
count(*)
2440506
2432656
[root@mvsc1lx0128 ~]#

Thanks,

Mark

After watching for a while, it looks like when this process showed up:

3701 ndoutils localhost nagios 1 Execut INSERT INTO nagios_commenthistory (instance_id, comment_type, entry_

Nagios stopped updating service checks.

Thanks,

Mark

Another screenshot from a few minutes later: Queries: 1.3M qps: 225 Slow: 575.0 Se/In/Up/De(%): 134/15/03/09 qps now: 9 Slow qps: 0.2 Threads: 52 ( 3/ 0) 77/23/17/02 Cache Hits: 848.3k Hits/s: 145.5 Hits now: 2.2 Ratio: 48.2% Ratio now: 30.6% Key Efficiency: 91.4% Bps in/out: 24.0k/44.8k Now in/out:...

MySQL on localhost (5.5.60-MariaDB) up 0+01:27:03 [14:50:49] Queries: 963.0k qps: 189 Slow: 503.0 Se/In/Up/De(%): 124/18/04/10 qps now: 167 Slow qps: 0.2 Threads: 52 ( 2/ 0) 106/22/01/22 Cache Hits: 565.8k Hits/s: 110.9 Hits now: 86.9 Ratio: 47.5% Ratio now: 49.1% Key Efficiency: 94.6% Bps in/out: 2...

Output from this command: mysql -unagiosql -pn@gweb <<< 'show full processlist\G' is in the attached file "out2.txt" There was no output from this command: mysql -unagiosql -pn@gweb <<< 'show warnings' [root@mvsc1lx0128 ~]# mysql -unagiosql -pn@gweb <<< 'show warnings' [root@mvsc1lx0128 ~]...

I've attached a file with the output from the first command. The other two commands had an account error: [root@mvsc1lx0128 ~]# mysql -unagiosql nagiosql <<< "SHOW WARNINGS" ERROR 1045 (28000): Access denied for user 'nagiosql'@'localhost' (using password: NO) [root@mvsc1lx0128 ~]# mysql -...

Hello, We upgraded from Nagios 5.6.14 to 5.8.1 about a week ago. Since then I've seen a few problems that I've not been able to correct. Since the upgrade, I've seen really high mariadb activity and at times, service checks do not update. Most of the time, mariadb is using 100-200% cpu (as reported ...