Tweak MySQL my.cnf using Major Hayden’s MySQL Tuner Script

Tweak MySQL my.cnf using Major Hayden’s MySQL Tuner Script. Major Hayden is Chief Security Architect and a Linux engineer at Rackspace. In the previous guide on Optimizing MySQL Database Performance, we tweaked manually and added the last chunk of text :

DO NOT try to optimize MySQL in Rackspace Deployment. They are fully optimized. There is a Perl script for MySQL Tuning, do not use it for PVHVM unless you are a database Guru.

For managed level at Rackspace, these high grade peoples are behind…To Do List For Unmanaged Rackspace Cloud Server Owners definitely works but probably if a group of such people are managing your servers, it becomes headache less matter.

 

Tweak MySQL my.cnf using MySQL Tuner Script

 

If pl is a domain name and it is Perl script, what is the problem to link raw Github to perform a domain hack :

 

 

The GitHub repository and GitHub Page respectively are here :

 

You will only run this one if you are using one server configuration or a single separate MySQL server. An example output :

Actually this a longer output, we are showing a spot with error :

That [!!] part should be fixed.

Most important is the recommendation part :

So, basically you have to follow our described method in the older guide after running this quite helpful script – Optimizing MySQL Database Performance for applying the recommended settings.