HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Is there any command to optimize all MySQL tables one by one automatically?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
tablesallanyautomaticallymysqloneoptimizecommandthere

Problem

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?

Solution

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.

Code Snippets

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

Context

StackExchange Database Administrators Q#64013, answer score: 18

Revisions (0)

No revisions yet.