How to Install and Uninstall mysqltuner Package on Ubuntu 21.10 (Impish Indri)

Last updated: July 08,2024

1. Install "mysqltuner" package

This guide let you learn how to install mysqltuner on Ubuntu 21.10 (Impish Indri)


    
        
            $
        

        
            
                sudo apt update
            
                    
    
    Copied


    
        
            $
        

        
            
                sudo apt install
            
                        
                mysqltuner
            
                    
    
    Copied

2. Uninstall "mysqltuner" package

This tutorial shows how to uninstall mysqltuner on Ubuntu 21.10 (Impish Indri):


    
        
            $
        

        
            
                sudo apt remove
            
                        
                mysqltuner
            
                    
    
    Copied


    
        
            $
        

        
            
                sudo apt autoclean && sudo apt autoremove
            
                    
    
    Copied

3. Information about the mysqltuner package on Ubuntu 21.10 (Impish Indri)

Package: mysqltuner
Architecture: all
Version: 1.7.17-1
Priority: extra
Section: universe/admin
Origin: Ubuntu
Maintainer: Ubuntu Developers
Original-Maintainer: KURASHIKI Satoru
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 1442
Depends: perl:any
Recommends: default-mysql-server | virtual-mysql-server, libtext-template-perl, procps
Filename: pool/universe/m/mysqltuner/mysqltuner_1.7.17-1_all.deb
Size: 111208
MD5sum: ebe05352c78dd6adbf7861545a809840
SHA1: 58b2d3807aea71e86749fc56859be33c72159389
SHA256: 7289051ad96b071c1396721a7df2f32c63c991624141267d714d5d09efebb160
SHA512: 9c980b8fb1cecfccd408c750e301796def31530b2a2c1c55e1ac35fe6a3d2f3df597ab46908ec3fa1290bf80eb139e8dd295987457c922cb756a409a812e2199
Homepage: https://github.com/major/MySQLTuner-perl
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