Quote Originally Posted by pi0tr3k View Post


I'm worried about OPTIMIZE TABLE query, as I'm sure my mysql server will die.
I have tables with 4MILL records, ~12GB ..

How can I optimize such a big table, without any problems.?
Run it with the nice command.
Whoo Reviewed by Whoo 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