mysqlcheck

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