To optimize every table in all databases on the server, just run this command:
mysqlcheck -o --all-databases -u root -p
In case you want to optimize tables for a single database:
mysqlcheck -o <db_name> -u root -pReviews, tutorials, lists of online tools and services
To optimize every table in all databases on the server, just run this command:
mysqlcheck -o --all-databases -u root -p
In case you want to optimize tables for a single database:
mysqlcheck -o <db_name> -u root -p