Scheduling very unstable - Part 2

[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

[rajasegar]

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

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

[scottwilkerson]

PM sent

[rajasegar]

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.

[scottwilkerson]

I will reach out to Troy to see if he would be available

[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

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.

[rajasegar]

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

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.

[scottwilkerson]

PM Sent

[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]$

[scottwilkerson]

your ndo2db.cfg still has this meaning it is offloaded

Code: Select all

db_host=10.17.19.237

that should be changed to

Code: Select all

db_host=localhost

and then restart ndo2db

Code: Select all

service ndo2db restart