check_mysql question

Nagios Nagios Plugins support
1

I recently had a problem with a mysql table that first had the error

/usr/sbin/mysqld: Incorrect key file for table ‘./apa/sessions.MYI’; try to repair it

then later the same table is got this error in the log file
’./apa/sessions’ is marked as crashed and should be repaired

Can the check_mysql provide check for stuff like this?

2

Check_mysql doesn’t have the ability to check tables. There may be something already created or you could write a simple script to query a table for something you know is going to be there. Than confirm the result.