connection loss of Nagios XI with mysql

[ednaldojta]

contents of /var/log/mysqld.log directory
160303 15:02:03 [Note] Event Scheduler: Purging the queue. 0 events
160303 15:02:03 InnoDB: Starting shutdown...
160303 15:02:08 InnoDB: Shutdown completed; log sequence number 0 44233
160303 15:02:08 [Note] /usr/libexec/mysqld: Shutdown complete

160303 15:02:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160303 15:02:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160303 15:02:08 InnoDB: Initializing buffer pool, size = 8.0M
160303 15:02:08 InnoDB: Completed initialization of buffer pool
160303 15:02:08 InnoDB: Started; log sequence number 0 44233
160303 15:02:08 [Note] Event Scheduler: Loaded 0 events
160303 15:02:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160303 15:20:49 [Note] /usr/libexec/mysqld: Normal shutdown

160303 15:20:49 [Note] Event Scheduler: Purging the queue. 0 events
160303 15:20:51 InnoDB: Starting shutdown...
160303 15:20:55 InnoDB: Shutdown completed; log sequence number 0 44233
160303 15:20:55 [Note] /usr/libexec/mysqld: Shutdown complete

160303 15:20:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160303 15:20:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160303 15:20:56 InnoDB: Initializing buffer pool, size = 8.0M
160303 15:20:56 InnoDB: Completed initialization of buffer pool
160303 15:20:56 InnoDB: Started; log sequence number 0 44233
160303 15:20:56 [Note] Event Scheduler: Loaded 0 events
160303 15:20:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160303 16:12:04 [Note] /usr/libexec/mysqld: Normal shutdown

160303 16:12:04 [Note] Event Scheduler: Purging the queue. 0 events
160303 16:12:06 InnoDB: Starting shutdown...
160303 16:12:09 InnoDB: Shutdown completed; log sequence number 0 44233
160303 16:12:09 [Note] /usr/libexec/mysqld: Shutdown complete

160303 16:12:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160303 16:12:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160303 16:12:10 InnoDB: Initializing buffer pool, size = 8.0M
160303 16:12:10 InnoDB: Completed initialization of buffer pool
160303 16:12:10 InnoDB: Started; log sequence number 0 44233
160303 16:12:10 [Note] Event Scheduler: Loaded 0 events
160303 16:12:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160303 16:38:41 mysqld_safe A mysqld process already exists
160304 08:31:19 mysqld_safe Number of processes running now: 0
160304 08:31:19 mysqld_safe mysqld restarted
160304 8:31:19 InnoDB: Initializing buffer pool, size = 8.0M
160304 8:31:19 InnoDB: Completed initialization of buffer pool
160304 8:31:19 InnoDB: Started; log sequence number 0 44233
160304 8:31:19 [Note] Event Scheduler: Loaded 0 events
160304 8:31:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160304 9:11:52 [Note] /usr/libexec/mysqld: Normal shutdown

160304 9:11:52 [Note] Event Scheduler: Purging the queue. 0 events
160304 9:11:54 InnoDB: Starting shutdown...
160304 9:11:57 InnoDB: Shutdown completed; log sequence number 0 44233
160304 9:11:57 [Note] /usr/libexec/mysqld: Shutdown complete

160304 09:11:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160304 09:13:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160304 9:13:04 InnoDB: Initializing buffer pool, size = 8.0M
160304 9:13:04 InnoDB: Completed initialization of buffer pool
160304 9:13:04 InnoDB: Started; log sequence number 0 44233
160304 9:13:04 [Note] Event Scheduler: Loaded 0 events
160304 9:13:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160304 9:13:05 [Note] /usr/libexec/mysqld: Normal shutdown

160304 9:13:05 [Note] Event Scheduler: Purging the queue. 0 events
160304 9:13:07 InnoDB: Starting shutdown...
160304 9:13:09 InnoDB: Shutdown completed; log sequence number 0 44233
160304 9:13:09 [Note] /usr/libexec/mysqld: Shutdown complete

160304 09:13:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160304 09:13:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160304 9:13:10 InnoDB: Initializing buffer pool, size = 8.0M
160304 9:13:10 InnoDB: Completed initialization of buffer pool
160304 9:13:10 InnoDB: Started; log sequence number 0 44233
160304 9:13:10 [Note] Event Scheduler: Loaded 0 events
160304 9:13:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution
160304 9:17:49 [Note] /usr/libexec/mysqld: Normal shutdown

160304 9:17:49 [Note] Event Scheduler: Purging the queue. 0 events
160304 9:17:49 InnoDB: Starting shutdown...
160304 9:17:50 InnoDB: Shutdown completed; log sequence number 0 44233
160304 9:17:50 [Note] /usr/libexec/mysqld: Shutdown complete

160304 09:17:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
160304 09:17:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
160304 9:17:51 InnoDB: Initializing buffer pool, size = 8.0M
160304 9:17:51 InnoDB: Completed initialization of buffer pool
160304 9:17:51 InnoDB: Started; log sequence number 0 44233
160304 9:17:51 [Note] Event Scheduler: Loaded 0 events
160304 9:17:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr

[rkennedy]

By the way, I also have an enterprise license, how do you have access to Customer Support?

Email [email protected].

If you're a customer, could I ask that you send a ticket in to [email protected]? It may be easier to troubleshoot this issue if we can get a profile from you, and possibly do a remote.

They are correct, I thought you were asking for permission to the Customer Forums (which sales would grant the access for). If you'd like to open a ticket for this, feel free to email [email protected]

To be honest though, I don't see any issue with your log file. Can you please point out the part that indicates an error?

[ednaldojta]

You saw this schedule
"160303 15:20:49 [Note] Event Scheduler: Purging the queue 0 events.".

When this event occurs, I can not see the Nagios information. The bank loses connection, this agedamento is the cause?

[hsmith]

How many hosts/services are you monitoring?

[ednaldojta]

39 hosts and 599 services.

[rkennedy]

Perhaps the XI machine doesn't have enough resources. How many CPU cores do you have allocated to it?

Also - what is the output of top|head -19?

[ednaldojta]

Below are the my server information.

[hsmith]

Resources look fine, what's the output of this command?

Code: Select all

mysql -V

[ednaldojta]

Here the output of mysql -V command attached.

[tgriep]

Can you run the following commands on the Nagios server and post the output?

Code: Select all

ipcs
ps -ef

Can you post the following file from the server so we can review it?

Code: Select all

/etc/sysctl.conf