How to install and run MySQL Tuner

MySQL Tuner is a tool which allows you to optimize your MySQL server behavior by changing a few values within your mysql configuration files. 
It can increase your loading time by reducing the time to process your MySQL queries and it could also reduce your ressources usage. 

It is a must have when you are running a linux VPS or a dedicated server in order to host a few websites. 


Throughout, this tutorial we will see how to install and run MySQL tuner.

*** Disclaimer *** MySQL requires a 24 hours history after its install in order to provide accurate guidances ***

1) We are going to download MySQL tuner to your VPS. In order to do so you would need to connect to your VPS in SSH, you can find how below : 

http://www.host-stage.net/client-area/knowledgebase/20/How-To-connect-to-your-server-or-Web-Hosting-account-in-Secured-Shell.html

Then, you would need to download mysql tuner with the following SSH command :

wget http://www.host-stage.net/client-area/dl.php?type=d&id=22

2) We are going to give the right to your script to be executed on your server with the following SSH command : 

chmod 755 mysqltuner.pl


3) In order to launch the script and see its output, you would need to type the following command : 

./mysqltuner.pl

You would be able to see all the tweaks you can do on your MySQL server. Most of them takes place in the following files : /etc/my.cnf

That's it! You have now installed and run MySQL tuner. You can find more information on their official website : 

http://mysqltuner.com


You can also open a support ticket requesting more details on the optimization you can perform on your server. 




  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

How to Refresh your cPanel License

If you have purchased your linux VPS along with a cPanel license. Your license won't be active...

How To Clean your cPanel Logs Files in One Go

This tutorial is meant to provide a shortcut to clean your log files in a cPanel Dedicated Server...

How To Update cPanel From SSH or GUI

In order to update the cPanel software on a Linux VPS, there is 2 ways to do it. Upgrading the...

How To Backup / Restore / Export your CSF Firewall Configuration

Whenever you want to deploy a new Linux VPS / Dedicated server, you generally have to set and...

How to Install the CSF / LFD Firewall on your VPS / Dedicated Server

Throughout this guide, you'll learn how to install your own Firewall on your linux VPS /...