Additions:
==analyse all tables in a database==
$ mysqlcheck -a mydb
==optimise all tables in a database==
$ mysqlcheck -o mydb
$ mysqlcheck -a mydb
==optimise all tables in a database==
$ mysqlcheck -o mydb
Additions:
==check all databases==
$ mysqlcheck --all-databases
==check a database==
$ mysqlcheck mydb
==check a table==
$ mysqlcheck mydb mytable
$ mysqlcheck --all-databases
==check a database==
$ mysqlcheck mydb
==check a table==
$ mysqlcheck mydb mytable