High CPU load on optimization of NDOUTILS Db

[toper]

Hi,

Lots of errors in messages after repair

Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:56 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'

/Peter

[toper]

Hi,

After repair i got a lot of faults in /var/log/messages

Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Aug 5 21:15:55 khk26dsg5 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair

So i did
service nagios stop
echo 'TRUNCATE TABLE nagios_logentries;' |mysql -t -u root -pnagiosxi nagios
service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
Now Repair was OK
service nagios start

/Peter

[tgriep]

I guess the truncate took a while and the database was still receiving new data.
Let us know if this works for you.

[toper]

Hi,

No problem since 2200 yesterday.

How do we avoid this problem coming up again ?
Are there some autocleanup running ?

Already a lot of new entries.
[root@khk26dsg5 ~]# ls -lR /var/lib/mysql/nagios/nagios_logentries*
-rw-rw---- 1 mysql mysql 8972 May 22 2014 /var/lib/mysql/nagios/nagios_logentries.frm
-rw-rw---- 1 mysql mysql 210626696 Aug 6 18:21 /var/lib/mysql/nagios/nagios_logentries.MYD
-rw-rw---- 1 mysql mysql 233720832 Aug 6 18:21 /var/lib/mysql/nagios/nagios_logentries.MYI

thanks,
Peter Calum
TDC
Denmark

[tgriep]

There is not an automated way of to truncate the MYSQL tables, it is a manual process, so periodically you will have to truncate the tables and run the repair to shrink the tables.

[toper]

Hi,

I think it should be considered to make som automatic cleanup, like the other Database settings under 'Performance settings'

Thanks,
Peter Calum

[hsmith]

Hi,

I think it should be considered to make som automatic cleanup, like the other Database settings under 'Performance settings'

Thanks,
Peter Calum

Hi Toper,

I can put in a feature request for you. Is this topic safe to close?

[toper]

Hi,

Yes, we can close this ticket.

thanks,
Peter