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 :
Then, you would need to download mysql tuner with the following SSH command :
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 :
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 :
You can also open a support ticket requesting more details on the optimization you can perform on your server.
- 3 Users Found This Useful
If you have purchased your linux VPS along with a cPanel license. Your license won't be active...
This tutorial is meant to provide a shortcut to clean your log files in a cPanel Dedicated Server...
In order to update the cPanel software on a Linux VPS, there is 2 ways to do it. Upgrading the...
Whenever you want to deploy a new Linux VPS / Dedicated server, you generally have to set and...
Throughout this guide, you'll learn how to install your own Firewall on your linux VPS /...