Install and use MySQLTuner on Ubuntu 14.04

Leave reply

MySQLMySQLTuner is a tool written in Perl which helps you increase the performance of your MySQL database server. It is really easy to use and it is recommended to analyze your Linux VPS regularly in order to get the best performances.  In this tutorial we are going to show you how to install and use MySQLTuner on Ubuntu 14.04.

First of all, login to your server and perform a system upgrade. It may take a few minutes but it is crucial for your server’s security. Use the following command to upgrade all your system software to the latest version available:

sudo apt-get update && sudo apt-get -y upgrade

Once the upgrade is completed, you can proceed and install the MySQLTuner on your Ubuntu VPS. There are two easy ways to do that and we will cover both in this tutorial.

The first way is to use the apt package manager. It is a little easier and faster way to install MySQLTuner on your server than the other one mentioned above. Since MySQLTuner is already added to the Ubuntu repositories, you can install it using the following command:

sudo apt-get install mysqltuner

To run MySQLTuner, you can execute the command:

sudo mysqltuner

It could take a few moments before the MySQLTuner provides you with the final report.

The other way to install MySQLTuner is to download the script from Git. This is the preferable way since it allows you to use the latest version of the software.

Navigate to the /opt directory on your server and download the latest version of MySQLTuner:

cd /opt/
wget http://mysqltuner.pl/ -O mysqltuner.pl

Make the script executable by using the command:

chmod +x mysqltuner.pl

And finally, run the script using the command:

./mysqltuner.pl

Or, if you do not like to make the script executable by adding the execute bit, you can directly call Perl to start the program by using the following command:

perl mysqltuner.pl

As a result, you should get something like this:

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce or eliminate unclosed connections and network issues
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
Variables to adjust:
    query_cache_type (=1)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)

Once you get the final report and the MySQLTuner recommendations, you can make the changes to your MySQL database server settings. Of course, be careful while making the changes since you may lose some important data from your databases if something is set in a wrong way. If you are not sure about an issue, it is best to contact a MySQL expert in order to get the right answer. The best practice is to create a backup of your MySQL databases before making any changes so you can restore the databases later if something goes wrong.

Of course you don’t have to do any of this if you use one of our Linux VPS hosting services, in which case you can simply ask our expert Linux admins to install MySQLTuner for you. They are available 24×7 and will take care of your request immediately.

PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.


50% OFF Coupon

EXCLUSIVE EMAIL UPDATES AND “MEMBERS-ONLY” CONTENT


2 Responses to “Install and use MySQLTuner on Ubuntu 14.04”

  1. Install and use MySQLTuner on Ubuntu 14.04 | LUG Mureş

    […] rosehosting.com Mai multe aici […]

    Reply
  2. How to install MySQL on Ubuntu 16.04 | RoseHosting.com Linux VPS Hosting Blog

    […] One of the most important things when running MySQL on a production server is to get the most out of its performances. If you are a beginner and you do not know how to tune your MySQL server, you can start with a program called MySQLTuner. It will help you to analyze your server and to tune MySQL for better overall performances. We have written a tutorial about how to install and use MySQLTuner on Ubuntu. […]

    Reply

Leave a Reply