MySQL Optimization cPanel

The best way to get optimization recommendations for your specific hardware resources and database queries on this server is to run the mysqltuner script. It can be ran by issuing the following command as root in a shell:

/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl


It will analyst MySQL, its databases, queries and available resources and will make recommendations on configuration changes. To give accurate recommendations, MySQL will need to be up and running for at least 24 hours before running the mysqltuner script. Once the changes it recommends is implemented, it is usually a good idea to allow another 24 hours of MySQL being online and re-running it. 

You may need to perform several iterations of this to get the best optimization for the service. 

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Run OPTIMIZE TABLE to defragment tables for better performance

For this suggestion:Run OPTIMIZE TABLE to defragment tables for better performanceRun this...

How to clear Error Log of a cPanel Account.

User the below code to clear Error Log:Replace User with Username:Code:for i in `find...

What is php.ini ?

The php.ini file and changing PHP Settings The php.ini file is a special file for PHP and...

How to fix ini_set() has been disabled for security reasons

1. Create php.ini file inside your public_html folder, OR the folder in which you have...

How to fix Fatal error: Uncaught exception 'Exception' with message 'DateTimeZone:

1: Create .htaccess file inside your public_html folder, OR the folder in which you have...