Check corrupt mysql Database table

Question

I am trying to check for corrupt tables in mysql database while it is running. This check will be done in a service which will run continues. I was looking at mysqlcheck, but the documentations says that it locks and unlocks a table. Is mysqlcheck time efficient to use in a service, and if not what is a better approach/

Answer 1

I won't answer the question you asked; instead I will try to dissuade you from thinking you need to ask that question.

Do not use MyISAM; it can become corrupt sometimes, (rarely).

Do use InnoDB; it essentially never becomes corrupt, even across nasty crashes.

Do not expect any disk crash to be repairable. Use other techniques to recover from such.

Bottom line: mysqlcheck is often needed for MyISAM after a power failure. However, mysqlcheck is both useless and unneeded for InnoDB.