analyse all tables in a database

$ mysqlcheck -a mydb

optimise all tables in a database

$ mysqlcheck -o mydb

check all databases

$ mysqlcheck --all-databases

check a database

$ mysqlcheck mydb

check a table

$ mysqlcheck mydb mytable