Monitor MySQL servers for crashed tables?
 

Is there something to monitor for crashed tables? I just found out one of my sites had a table crashed and had to be repaired. It was like this for about 3 days. :1orglaugh Never happened before. How do I get notified about tables "marked as crashed", so I can repair them? Any ideas of a script to repair the crashed table on detection? :helpme

EDIT: It was INNODB table but it has never happened on InnoDB tables on the same server.

A couple of years ago I was having an issue with crashed tables. It took about 6 months for the host to find the issue (hardware issue of some sort).

I wrote myself a little monitor script that would go out periodically and do a check on each table and then if it was crashed it would do a repair of the table,

It wasn't real hard to put together.

I am not sure if I still have the code around or not right now.

.

Not sure if you have access to the MySQL log but if so, just create a script and run it via cron to parse the log for crashed tables.

Yea, I have access to everything. It is cisco cloud, quite good. Some server failed last week and had to be moved to other blades. Maybe it is then it happened and I never saw it.

and then to notify and repair :thumbsup:thumbsup

What exactly happens to a table that has crashed?

DATE TIME [ERROR] /path/to/mysqld: Table './data_base/tablename' is marked as crashed and should be repaired

If you want a custom solution coded, icq: 33375924 or email me at woj#a#t#wojfun#.#c#om to discuss details