Check corrupt mysql Database table



  • 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/



  • 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.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2