MySQL instant commands – Repair, Analyze, Optimize

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 🙂

Related posts:

Cron job for backing up MYSQL database from SSH Update fails or server cannot connect to repositories How to deal with hackers for web server? Sym links solution Remove IPtables rules from rescue system