MySQL OPTIMIZE & Repair all tables in one go

mysqlcheck -o --all-databases -u root -p

mysqlcheck -o <db_name> -u root -p

=================================================

mysqlcheck --auto-repair --check --all-databases -u root -p 

mysqlcheck --auto-repair --databases <db_name> -u root -p

References:

https://dev.mysql.com/doc/refman/5.6/en/mysqlcheck.html

https://stackoverflow.com/questions/4582832/repair-all-tables-in-one-go

https://stackoverflow.com/questions/5474662/mysql-optimize-all-tables