Code: Select all
mysql -uroot -pnagiosxi -e 'show full processlist'Slow Nagios server
Re: Slow Nagios server
What does the following command produce?
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Slow Nagios server
File is sent in PM
wkr, Humphrey
wkr, Humphrey
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Slow Nagios server
Hi @centricrm,
Apologies for the inconvenience, can you PM me a copy of the profile? Dan is out of the office today.
Thanks!, Benjamin
Apologies for the inconvenience, can you PM me a copy of the profile? Dan is out of the office today.
Thanks!, Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Slow Nagios server
profile is sent in PM.
wkr, Humphrey
wkr, Humphrey
Re: Slow Nagios server
One thing that causes slowness is if there is a bunch of users sitting on the service status pages in a bunch of tabs showing 1000 or all services, the auto-refresh keeps occurring and some of those queries are not setup to be as efficient as they could be on large systems like yours. Outstanding queries cause MySQL CPU usage to rise, which causes more important queries to wait, and become backlogged.
Try adjusting Admin > Performance Settings > Dashlets and change the Dashlet Refresh Multiplier from 1000 (the default) to like 5000 or 10000 to see if that helps.
Try adjusting Admin > Performance Settings > Dashlets and change the Dashlet Refresh Multiplier from 1000 (the default) to like 5000 or 10000 to see if that helps.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Slow Nagios server
If that doesn't work, you could PM the Admin > System Profile > View System Info to me, or you could check on this yourself:
If you have the old active_directory/ldap_auth components, having those on XI 5+ can conflict and cause slowness with the new one (ldap_ad_integration)
If you have the old active_directory/ldap_auth components, having those on XI 5+ can conflict and cause slowness with the new one (ldap_ad_integration)
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Slow Nagios server
I am evaluating the last change (Dashlet Refresh Multiplier changed from 1000 to 5000).
The profile is sent in a PM.
wkr Humphrey
The profile is sent in a PM.
wkr Humphrey
Re: Slow Nagios server
Just checking in. Did increasing the Dashlet Refresh Multiplier value have any effect so far?
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: Slow Nagios server
The response of the server varies from good to very bad.
I'm not sure if the Dashlet Refresh Multiplier change improved the performance.
At this very moment I see a lot of processes using 100% and one 181% CPU which makes the Host Status screen slow to appear.
See output of top below.
top - 18:44:19 up 14 days, 19:25, 2 users, load average: 5.64, 6.05, 5.90
Tasks: 383 total, 6 running, 285 sleeping, 0 stopped, 92 zombie
%Cpu(s): 39.9 us, 35.5 sy, 0.0 ni, 24.6 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 16265904 total, 2671364 free, 3709132 used, 9885408 buff/cache
KiB Swap: 8380412 total, 8364796 free, 15616 used. 11304444 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
32711 mysql 20 0 4903800 1.2g 9804 S 183.1 7.6 1800:25 mysqld
683 nagios 20 0 1135416 124400 3712 R 99.7 0.8 763:36.27 nagios
690 nagios 20 0 11116 1428 760 R 99.7 0.0 811:03.19 nagios
692 nagios 20 0 11244 1432 760 R 99.7 0.0 811:17.46 nagios
703 nagios 20 0 11244 1440 760 R 99.7 0.0 810:57.56 nagios
1245 apache 20 0 704756 127388 6716 S 7.0 0.8 4:55.29 httpd
1244 apache 20 0 721140 144036 6784 S 6.0 0.9 4:49.75 httpd
There are also some zombie processes.
I'm not sure if the Dashlet Refresh Multiplier change improved the performance.
At this very moment I see a lot of processes using 100% and one 181% CPU which makes the Host Status screen slow to appear.
See output of top below.
top - 18:44:19 up 14 days, 19:25, 2 users, load average: 5.64, 6.05, 5.90
Tasks: 383 total, 6 running, 285 sleeping, 0 stopped, 92 zombie
%Cpu(s): 39.9 us, 35.5 sy, 0.0 ni, 24.6 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 16265904 total, 2671364 free, 3709132 used, 9885408 buff/cache
KiB Swap: 8380412 total, 8364796 free, 15616 used. 11304444 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
32711 mysql 20 0 4903800 1.2g 9804 S 183.1 7.6 1800:25 mysqld
683 nagios 20 0 1135416 124400 3712 R 99.7 0.8 763:36.27 nagios
690 nagios 20 0 11116 1428 760 R 99.7 0.0 811:03.19 nagios
692 nagios 20 0 11244 1432 760 R 99.7 0.0 811:17.46 nagios
703 nagios 20 0 11244 1440 760 R 99.7 0.0 810:57.56 nagios
1245 apache 20 0 704756 127388 6716 S 7.0 0.8 4:55.29 httpd
1244 apache 20 0 721140 144036 6784 S 6.0 0.9 4:49.75 httpd
There are also some zombie processes.
Re: Slow Nagios server
Now what does the following command produce?
Code: Select all
mysql -uroot -pnagiosxi -e 'show full processlist'If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.