Is there any command to optimize all MySQL tables one by one automatically? I execute below command line statement to optimize a table:
optimize table tablename;

Is there any command or statement which can optimize all the tables one by one of the selected database?
I usually use mysqlcheck with --optimize and --databases combination. mysqlcheck is a command-line interface for administrators to check, optimize and repair tables.

mysqlcheck -uroot -p --optimize --databases myDatabase


Here is the MySQL doc : http://dev.mysql.com/doc/refman/5.5/en/mysqlcheck.html

Max.