Tech-Angels

MySQL : How to optimize all databases in command line

Really simple :

sudo mysqlcheck -1 -A —optimize

-A : “Check all the databases. This will be same as
—databases with all databases selected.”

-1 : “Instead of issuing one query for each table, use one
query per database, naming all tables in the database in
a comma-separated list.”


blog comments powered by Disqus
To Tumblr, Love Metalab