MySQL DBA - Tips and Techniques Magazine

13 Nov 2014


Useful utility to check, repair, analyze and optimize mysql tables.  Just be aware that it locks the table, so don't run on busy production tables if they are clustered as probe may time out.


mysqlcheck --auto-repair --all-databases –uroot

1 comment:

  1. The mysqlcheck utility is useful for MyISAM but much less so for InnoDB, NDB or TokuDB. For InnoDB there is innochecksum (greatly improved in 5.7) but there is still no need to run it periodically as done with mysqlcheck and MyISAM.