Sometimes, you may need to repair/optimize MySQL Database to enhance performance.

Followings are the command I use for repairing database:

mysqlcheck --auto-repair -u<user_id> -p<user_password> --all-databases