How To Install mysqltuner on Kali Linux

In this tutorial we learn how to install mysqltuner on Kali Linux. mysqltuner is high-performance MySQL tuning script

Introduction

In this tutorial we learn how to install mysqltuner on Kali Linux.

What is mysqltuner

mysqltuner is:

High-performance MySQL tuning script written in perl that will provide you with a snapshot of a MySQL server?s health. Based on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The script gives you automated MySQL tuning that is on the level of what you would receive from a MySQL DBA.

Features:

* Memory Usage: Calculates MySQL memory usage at max load and makes
  recommendations for increasing or decreasing the MySQL memory
  footprint. Per-thread and server-wide buffer data is calculated
  separately for an accurate snapshot of the server?s configuration.
* Slow Queries: Reviews the amount of slow queries relative to the
  total queries. Slow query time limits are also analyzed and
  recommendations are made.
* Connections: Current and historical connection counts are
  reviewed.
* Key Buffer: Takes configuration data and compares it to the actual
  indexes found in MyISAM tables. Key cache hit rates are calculated
  and variable adjustments are suggested.
* Query Cache: Query cache hit rates and usage percentages are used
  to make recommendations for the query cache configuration
  variables.
* Sorting & Joins: Per-thread buffers that affect sorts and joins
  are reviewed along with the statistics from the queries run
  against the server.
* Temporary Tables: Variable recommendations are made to reduce
  temporary tables that are written to the disk.
* Table Cache: Compares total tables opened to the currently open
  tables. Calculates the table cache hit rate in order to make
  suggestions.
* Open Files: Determines if the server will approach or run into the
  open file limit set by the operating system or the MySQL server
  itself.
* Table Locks: Finds table locking that forces queries to wait and
  makes suggestions for reducing locks that require a wait.
* Thread Cache: Calculates how many times MySQL must create a new
  thread to respond to a query.
* Aborted Connections: Finds applications that are not closing
  connections to MySQL properly.
* Read/Write Ratios: Calculates the percentage of read and write
  operations on your MySQL installation.

There are three methods to install mysqltuner on Kali Linux. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install mysqltuner Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install mysqltuner using apt-get by running the following command:

sudo apt-get -y install mysqltuner

Install mysqltuner Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install mysqltuner using apt by running the following command:

sudo apt -y install mysqltuner

Install mysqltuner Using aptitude

If you want to follow this method, you might need to install aptitude on Kali Linux first since aptitude is usually not installed by default on Kali Linux. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install mysqltuner using aptitude by running the following command:

sudo aptitude -y install mysqltuner

How To Uninstall mysqltuner on Kali Linux

To uninstall only the mysqltuner package we can use the following command:

sudo apt-get remove mysqltuner

Uninstall mysqltuner And Its Dependencies

To uninstall mysqltuner and its dependencies that are no longer needed by Kali Linux, we can use the command below:

sudo apt-get -y autoremove mysqltuner

Remove mysqltuner Configurations and Data

To remove mysqltuner configuration and data from Kali Linux we can use the following command:

sudo apt-get -y purge mysqltuner

Remove mysqltuner configuration, data, and all of its dependencies

We can use the following command to remove mysqltuner configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge mysqltuner

Dependencies

mysqltuner have the following dependencies:

References

Summary

In this tutorial we learn how to install mysqltuner package on Kali Linux using different package management tools: apt, apt-get and aptitude.