WarezTeacher.com

Most webmasters can have the problem that some tables aren’t optimized or have overhead. This will cauze your server/VPS to work slower than usual since it can’t use all it’s resources. If you do this command once a week then you should be fine and your databases would stay optimized all the time. Follow the steps below:

1*Login into shell via SSH
2*Do this command (you can change the username if it isn’t ‘root’):

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

3*Enter the password
4*Sit back and enjoy with getting your databases fixed with a single command =)

• Interesting read? Pls Vote!
  
  • Subscribe
  • Digg
  • del.icio.us
  • Furl
  • StumbleUpon