The path is:
[root@XXXXXXXXXX ~]# tail /etc/my.cnf
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
and the output is:
tail /var/log/mariadb/mariadb.log -n 100 > /tmp/mariadb_log.txt
150605 18:04:46 InnoDB: highest supported file format is Barracuda.
150605 18:04:47 InnoDB: Waiting for the background threads to start
150605 18:04:48 Percona XtraDB (
http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150605 18:04:48 [Note] Plugin 'FEEDBACK' is disabled.
150605 18:04:48 [Note] Server socket created on IP: '0.0.0.0'.
150605 18:04:48 [Note] Event Scheduler: Loaded 0 events
150605 18:04:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
150610 9:21:49 [Note] /usr/libexec/mysqld: Normal shutdown
150610 9:21:49 [Note] Event Scheduler: Purging the queue. 0 events
150610 9:21:50 InnoDB: Starting shutdown...
150610 9:21:50 InnoDB: Shutdown completed; log sequence number 1597945
150610 9:21:50 [Note] /usr/libexec/mysqld: Shutdown complete
150610 09:21:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150610 09:22:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150610 9:22:56 InnoDB: The InnoDB memory heap is disabled
150610 9:22:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150610 9:22:56 InnoDB: Compressed tables use zlib 1.2.7
150610 9:22:56 InnoDB: Using Linux native AIO
150610 9:22:56 InnoDB: Initializing buffer pool, size = 128.0M
150610 9:22:56 InnoDB: Completed initialization of buffer pool
150610 9:22:56 InnoDB: highest supported file format is Barracuda.
150610 9:22:56 InnoDB: Waiting for the background threads to start
150610 9:22:57 Percona XtraDB (
http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150610 9:22:57 [Note] Plugin 'FEEDBACK' is disabled.
150610 9:22:57 [Note] Server socket created on IP: '0.0.0.0'.
150610 9:22:58 [Note] Event Scheduler: Loaded 0 events
150610 9:22:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
150610 22:17:28 [Note] /usr/libexec/mysqld: Normal shutdown
150610 22:17:28 [Note] Event Scheduler: Purging the queue. 0 events
150610 22:17:28 InnoDB: Starting shutdown...
150610 22:17:29 InnoDB: Shutdown completed; log sequence number 1597945
150610 22:17:29 [Note] /usr/libexec/mysqld: Shutdown complete
150610 22:17:29 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150610 22:23:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150610 22:23:32 InnoDB: The InnoDB memory heap is disabled
150610 22:23:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150610 22:23:32 InnoDB: Compressed tables use zlib 1.2.7
150610 22:23:32 InnoDB: Using Linux native AIO
150610 22:23:32 InnoDB: Initializing buffer pool, size = 128.0M
150610 22:23:32 InnoDB: Completed initialization of buffer pool
150610 22:23:32 InnoDB: highest supported file format is Barracuda.
150610 22:23:32 InnoDB: Waiting for the background threads to start
150610 22:23:33 Percona XtraDB (
http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150610 22:23:33 [Note] Plugin 'FEEDBACK' is disabled.
150610 22:23:33 [Note] Server socket created on IP: '0.0.0.0'.
150610 22:23:33 [Note] Event Scheduler: Loaded 0 events
150610 22:23:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
150611 18:36:47 [Note] /usr/libexec/mysqld: Normal shutdown
150611 18:36:47 [Note] Event Scheduler: Purging the queue. 0 events
150611 18:36:47 InnoDB: Starting shutdown...
150611 18:36:48 InnoDB: Shutdown completed; log sequence number 1597945
150611 18:36:48 [Note] /usr/libexec/mysqld: Shutdown complete
150611 18:36:48 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150611 18:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150611 18:46:30 InnoDB: The InnoDB memory heap is disabled
150611 18:46:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150611 18:46:30 InnoDB: Compressed tables use zlib 1.2.7
150611 18:46:30 InnoDB: Using Linux native AIO
150611 18:46:30 InnoDB: Initializing buffer pool, size = 128.0M
150611 18:46:30 InnoDB: Completed initialization of buffer pool
150611 18:46:30 InnoDB: highest supported file format is Barracuda.
150611 18:46:30 InnoDB: Waiting for the background threads to start
150611 18:46:31 Percona XtraDB (
http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150611 18:46:31 [Note] Plugin 'FEEDBACK' is disabled.
150611 18:46:31 [Note] Server socket created on IP: '0.0.0.0'.
150611 18:46:31 [Note] Event Scheduler: Loaded 0 events
150611 18:46:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
150611 18:47:30 [Note] /usr/libexec/mysqld: Normal shutdown
150611 18:47:30 [Note] Event Scheduler: Purging the queue. 0 events
150611 18:47:30 InnoDB: Starting shutdown...
150611 18:47:31 InnoDB: Shutdown completed; log sequence number 1597945
150611 18:47:31 [Note] /usr/libexec/mysqld: Shutdown complete
150611 18:47:31 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
150611 18:49:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150611 18:49:56 InnoDB: The InnoDB memory heap is disabled
150611 18:49:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150611 18:49:56 InnoDB: Compressed tables use zlib 1.2.7
150611 18:49:56 InnoDB: Using Linux native AIO
150611 18:49:56 InnoDB: Initializing buffer pool, size = 128.0M
150611 18:49:56 InnoDB: Completed initialization of buffer pool
150611 18:49:56 InnoDB: highest supported file format is Barracuda.
150611 18:49:56 InnoDB: Waiting for the background threads to start
150611 18:49:57 Percona XtraDB (
http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150611 18:49:57 [Note] Plugin 'FEEDBACK' is disabled.
150611 18:49:57 [Note] Server socket created on IP: '0.0.0.0'.
150611 18:49:57 [Note] Event Scheduler: Loaded 0 events
150611 18:49:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Today we dont have the first error reported: "Jun 11 15:25:36 XXXXXXXXXX ndo2db: Error: queue recv error."
We applied two action on the server:
a) Increase the cpu and the memory:
Tasks: 440 total, 11 running, 429 sleeping, 0 stopped, 0 zombie
%Cpu0 : 37.6 us, 4.3 sy, 0.0 ni, 57.4 id, 0.0 wa, 0.0 hi, 0.7 si, 0.0 st
%Cpu1 : 36.0 us, 8.9 sy, 0.0 ni, 54.5 id, 0.3 wa, 0.0 hi, 0.3 si, 0.0 st
%Cpu2 : 39.4 us, 4.3 sy, 0.0 ni, 56.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
%Cpu3 : 35.2 us, 6.0 sy, 0.0 ni, 58.8 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
%Cpu4 : 32.3 us, 4.3 sy, 0.0 ni, 63.4 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
%Cpu5 : 26.0 us, 4.0 sy, 0.0 ni, 69.7 id, 0.0 wa, 0.0 hi, 0.3 si, 0.0 st
KiB Mem: 12134164 total, 3975760 used, 8158404 free, 1328 buffers
KiB Swap: 4095996 total, 0 used, 4095996 free. 2371420 cached Mem
b) We applied the db processes: "VACUUM; VACUUM ANALYZE; VACUUM FULL;"
But today , in a intermitent way:
a) When we are configurating or editing services or hosts, does not take the changes.
b) Also some services in the minemap view, change their color in a intermitent way.
Do you know how resolve this?
Do you know if exist a document that help me to understand what databases use my Nagios installation, and where are the logs that we have to see for prevent incidents ?
Thanks again.