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
MySQL DBA - Tips and Techniques Magazine
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.
ReplyDelete