I made the modifications on the auto_rescheduling_window and it looks like that did it!!!!!!!
Here is a look at top:
Code: Select all
top - 16:21:12 up 14 days, 4:20, 1 user, load average: 0.64, 0.47, 0.40
Tasks: 237 total, 1 running, 236 sleeping, 0 stopped, 0 zombie
Cpu(s): 8.1%us, 1.6%sy, 0.0%ni, 90.2%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 16325748k total, 14014816k used, 2310932k free, 208848k buffers
Swap: 4194296k total, 0k used, 4194296k free, 12739392k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17498 apache 20 0 339m 22m 3748 S 8.3 0.1 0:00.25 httpd
15360 apache 20 0 437m 26m 4348 S 6.0 0.2 0:01.44 httpd
15033 root 20 0 139m 46m 3084 S 1.7 0.3 0:06.06 mrtg
15366 root 20 0 15164 1348 944 R 0.7 0.0 0:00.12 top
Thanks for sticking with the problem...I will watch for several days and report back as others may want to see the results.
Here are the table stats:
Code: Select all
ls -lahs /var/lib/mysql/nagios | head -15
total 1.1G
12K drwx------ 2 mysql mysql 12K Sep 17 15:15 .
4.0K drwxr-xr-x 6 mysql mysql 4.0K Sep 3 12:01 ..
4.0K -rw-rw---- 1 mysql mysql 61 Jul 17 18:01 db.opt
12K -rw-rw---- 1 mysql mysql 8.9K Jul 17 18:01 nagios_acknowledgements.frm
4.0K -rw-rw---- 1 mysql mysql 212 Sep 12 14:29 nagios_acknowledgements.MYD
4.0K -rw-rw---- 1 mysql mysql 3.0K Sep 17 15:15 nagios_acknowledgements.MYI
12K -rw-rw---- 1 mysql mysql 8.6K Jul 17 18:01 nagios_commands.frm
12K -rw-rw---- 1 mysql mysql 12K Sep 17 08:50 nagios_commands.MYD
8.0K -rw-rw---- 1 mysql mysql 7.0K Sep 17 15:15 nagios_commands.MYI
12K -rw-rw---- 1 mysql mysql 9.2K Jul 17 18:01 nagios_commenthistory.frm
176K -rw-rw---- 1 mysql mysql 173K Sep 17 08:50 nagios_commenthistory.MYD
20K -rw-rw---- 1 mysql mysql 20K Sep 17 15:15 nagios_commenthistory.MYI
12K -rw-rw---- 1 mysql mysql 9.1K Jul 17 18:01 nagios_comments.frm
4.0K -rw-rw---- 1 mysql mysql 516 Sep 17 08:50 nagios_comments.MYD
tail -100 /var/log/mysqld.log |grep crashed
You have new mail in /var/spool/mail/root