Quote Originally Posted by Lifetalk View Post
Tables that have a lot of 'SELECT' queries being run on them will often end up being fragmented.
Hmmm... why does this happens? I mean the 'fragmented' part.

(Great thread, btw! Cheers)
Solutho Reviewed by Solutho on . Optimize MySQL - MySQLTuner Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours + CentOS: Download MySQLTuner: wget http://mysqltuner.com/mysqltuner.plMake executable: chmod 755 mysqltuner.plRun MySQLTuner: Rating: 5