How to Install and Uninstall mysqltuner Package on Ubuntu 16.04 LTS (Xenial Xerus)

Last updated: May 14,2024

1. Install "mysqltuner" package

Please follow the steps below to install mysqltuner on Ubuntu 16.04 LTS (Xenial Xerus)


    
        
            $
        

        
            
                sudo apt update
            
                    
    
    Copied


    
        
            $
        

        
            
                sudo apt install
            
                        
                mysqltuner
            
                    
    
    Copied

2. Uninstall "mysqltuner" package

Please follow the instructions below to uninstall mysqltuner on Ubuntu 16.04 LTS (Xenial Xerus):


    
        
            $
        

        
            
                sudo apt remove
            
                        
                mysqltuner
            
                    
    
    Copied


    
        
            $
        

        
            
                sudo apt autoclean && sudo apt autoremove
            
                    
    
    Copied

3. Information about the mysqltuner package on Ubuntu 16.04 LTS (Xenial Xerus)

Package: mysqltuner
Priority: extra
Section: universe/admin
Installed-Size: 156
Maintainer: Ubuntu Developers
Original-Maintainer: KURASHIKI Satoru
Architecture: all
Version: 1.6.0-1
Depends: perl
Recommends: mysql-server | virtual-mysql-server, libtext-template-perl
Filename: pool/universe/m/mysqltuner/mysqltuner_1.6.0-1_all.deb
Size: 45048
MD5sum: 7e836f2d56f398ef5ec5ae900032be5a
SHA1: a2e7741d723aedb0f982d5806a8a776b83528852
SHA256: 570293e82c1e0d03ee8b58e56c126852cdb442537f83ca2220ed5daffe2375d3
Description-en: high-performance MySQL tuning script
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.
Description-md5: d079bed656ffe89a06c680dc18513f56
Homepage: http://mysqltuner.com
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Origin: Ubuntu