Websterz Technology Blog

Free tutorials, Tech News, Source codes, Tweaks and Tips.

Following commands are useful for mysql optimization:

  • To repair all databases:
    • $mysqlcheck –all-databases -r
  • To analyze all databases:
    • $mysqlcheck –all-databases -a
  • To optimize all databases:
    • $mysqlcheck –all-databases -o

 

That is all 🙂

Spread the love
See also  Create new SSH user on Centos

Leave a Reply

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