abrist wrote:What version of XI are you running?
Are any of your db tables crashed?How big are your tables?Code: Select all
grep crashed /var/log/mysqld.logCode: Select all
ls -lahS /var/lib/mysql/nagios | head -10
Version:
Note that this system was built from a VM template directly from Nagios ~1 month ago.
Code: Select all
Nagios XI Version : 2014R1.4
nwd2ng01 2.6.32-358.2.1.el6.x86_64 x86_64
CentOS release 6.5 (Final)
Gnome is not installedTables are small (less than 60 hosts with about 10 checks each but configured as host group checks).
Code: Select all
total 36M
-rw-rw---- 1 mysql mysql 11M Sep 25 18:23 nagios_logentries.MYD
-rw-rw---- 1 mysql mysql 6.5M Sep 25 18:23 nagios_notifications.MYD
-rw-rw---- 1 mysql mysql 6.3M Sep 25 18:23 nagios_logentries.MYI
-rw-rw---- 1 mysql mysql 2.5M Sep 25 18:23 nagios_notifications.MYI
-rw-rw---- 1 mysql mysql 2.1M Sep 25 18:23 nagios_contactnotifications.MYI
-rw-rw---- 1 mysql mysql 1.6M Sep 25 18:23 nagios_statehistory.MYD
-rw-rw---- 1 mysql mysql 1.4M Sep 25 18:23 nagios_contactnotificationmethods.MYI
-rw-rw---- 1 mysql mysql 1.3M Sep 25 18:23 nagios_contactnotificationmethods.MYD
-rw-rw---- 1 mysql mysql 1.2M Sep 25 18:23 nagios_contactnotifications.MYDlatest /var/log/messages shows this:
Code: Select all
Sep 25 18:31:52 nwd2ng01 ndo2db: Message sent to queue.
Sep 25 18:31:52 nwd2ng01 ndo2db: Warning: queue send error, retrying...
Sep 25 18:32:10 nwd2ng01 ndo2db: Message sent to queue.
Sep 25 18:32:10 nwd2ng01 ndo2db: Warning: queue send error, retrying...
Sep 25 18:32:28 nwd2ng01 ndo2db: Message sent to queue.
Sep 25 18:32:28 nwd2ng01 ndo2db: Warning: queue send error, retrying...
Sep 25 18:32:46 nwd2ng01 ndo2db: Message sent to queue.
Sep 25 18:32:46 nwd2ng01 ndo2db: Warning: queue send error, retrying...
Sep 25 18:33:04 nwd2ng01 ndo2db: Message sent to queue.
Sep 25 18:33:04 nwd2ng01 ndo2db: Warning: Retrying message send. This can occur because you have too few messages allowed or too few total bytes allowed in message queues. You are currently using 128000 of 15736 messages and 131072000 of 131072000 bytes in the queue. See README for kernel tuning options.