How to repair, analyze and optimize all database in Mysql (Linux)

Very cool command to share

Repair all database in that server

mysqlcheck --all-databases -r

Analyze all database in that server

mysqlcheck --all-databases -a

Optimize all database in that server

mysqlcheck --all-databases -o

Leave a Reply

Your email address will not be published. Required fields are marked *