My way to optimize MySQL in cPanel VPS

When set to default cPanel VPS , you need to step through the installation , configuration profiles . However, if your website hits are much larger or website , you need to prepare all steps connected via file / etc / my.cnf of MySQL .

The mission of the file / etc / my.cnf that helps you optimize the visitor to connect to the MySQL database VPS . Optimization will include visits to the higher speed , cache more data would help reduce the number of duplicate connections . Also, at some point , set consistent MySQL will help you make the most of the VPS RAM instead of increasing high cpu load when the rush hits on .

To edit the file / etc / my.cnf , you need to access using Putty software and connect to the VPS via SSH . After logging in as root , you can type the following command to access and edit the file / etc / my.cnf

vi / etc / my.cnf

The default contents of this file is not much . We can refer to the following parameters for the initial setup :

You try to optimize some parameters through which they made ​​it anyway . Do not forget to combine mysqltuner.pl use more light, will give much better results there .
Thanks all reading!Hope additional complete if it's failure? : P