Page 2 of 3
Re: Scheduling very unstable - Part 2
Posted: Mon Jul 30, 2018 7:45 am
by scottwilkerson
You are getting queue send errors although you have increased this already you may need to go higher that your current values
https://support.nagios.com/kb/article.php?id=139
Also, it may be a good time to think about offloading the database to another server, which can shift the strain on this server
https://assets.nagios.com/downloads/nag ... Server.pdf
Re: Scheduling very unstable - Part 2
Posted: Tue Jul 31, 2018 3:09 am
by rajasegar
Offloaded but same old problem. There is no queue messages but the scheduling is totally blank.
Hope you guys can fix this problem.
How can it be a performance problem when it is ok for ages then acts up for weeks then ok again?
Capture4.JPG
profile (1).zip
Re: Scheduling very unstable - Part 2
Posted: Tue Jul 31, 2018 11:32 am
by scottwilkerson
PM sent
Re: Scheduling very unstable - Part 2
Posted: Tue Jul 31, 2018 7:00 pm
by rajasegar
scottwilkerson wrote:PM sent
Since we work 12 hours apart, there seems to be a scheduling problem.
We work at GMT+8 hours. 2pm CDT is 3am our time and nobody will be in office.
Previously Troy used to do WebEx with us as he works in Australian time.
Hope we can arrange something similar.
Re: Scheduling very unstable - Part 2
Posted: Wed Aug 01, 2018 8:43 am
by scottwilkerson
I will reach out to Troy to see if he would be available
Re: Scheduling very unstable - Part 2
Posted: Wed Aug 01, 2018 4:36 pm
by scottwilkerson
I do not have anyone available in your timezone, so we either have to continue through the thread or schedule something that can be accomplished between 9-5 CDT
Earlier you mentioned
rajasegar wrote:
Looks like a normal shutdown as we included mysqld service shutdown in the script.
what script is this? We do not have anything included in Nagios XI that does this.
Re: Scheduling very unstable - Part 2
Posted: Wed Aug 01, 2018 9:01 pm
by rajasegar
scottwilkerson wrote:I do not have anyone available in your timezone, so we either have to continue through the thread or schedule something that can be accomplished between 9-5 CDT
Earlier you mentioned
rajasegar wrote:
Looks like a normal shutdown as we included mysqld service shutdown in the script.
what script is this? We do not have anything included in Nagios XI that does this.
Can we schedule WebEx at 9am CDT which is Thursday 02-Aug 10pm my time today?
I will send you my WhatsApp number via PM.
It is just our own script we use to shutdown Nagios and restart its associated services before any activities in the server.
Re: Scheduling very unstable - Part 2
Posted: Thu Aug 02, 2018 7:38 am
by scottwilkerson
PM Sent
Re: Scheduling very unstable - Part 2
Posted: Thu Aug 09, 2018 1:16 am
by rajasegar
Reverted back from offloaded DB.
It seems slow but way better now. I hour plus and it still around the 100 mark
Capture.JPG
Here is the profile now
profile (2).zip
Code: Select all
[nagios@nagiosprodxi3 debug]$ ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
0x99000002 19333120 nagios 600 188128256 183719
You have mail in /var/spool/mail/nagios
Code: Select all
[nagios@nagiosprodxi3 debug]$ cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_buffer_pool_size = 10G
max_connections=500
# Added by NAgios Tech 6/8/2018
max_allowed_packet = 32M
innodb_file_per_table = 1
query_cache_size=16M
query_cache_limit=4M
tmp_table_size=64M
max_heap_table_size=64M
table_open_cache=32
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[nagios@nagiosprodxi3 debug]$
Re: Scheduling very unstable - Part 2
Posted: Thu Aug 09, 2018 7:27 am
by scottwilkerson
your ndo2db.cfg still has this meaning it is offloaded
that should be changed to
and then restart ndo2db