Provided by: mysqltuner_1.7.13-1_all bug


        MySQLTuner 1.7.13 - MySQL High Performance Tuning Script


       To run the script with the default options, run the script without arguments Allow MySQL
       server to run for at least 24-48 hours before trusting suggestions Some routines may
       require root level privileges (script will provide warnings) You must provide the remote
       server's total memory when connecting to other servers


        --host <hostname>           Connect to a remote host to perform tests (default: localhost)
        --socket <socket>           Use a different socket for a local connection
        --port <port>               Port to use for connection (default: 3306)
        --user <username>           Username to use for authentication
        --userenv <envvar>          Name of env variable which contains username to use for authentication
        --pass <password>           Password to use for authentication
        --passenv <envvar>          Name of env variable which contains password to use for authentication
        --ssl-ca <path>             Path to public key
        --mysqladmin <path>         Path to a custom mysqladmin executable
        --mysqlcmd <path>           Path to a custom mysql executable
        --defaults-file <path>      Path to a custom .my.cnf


        --skipsize                  Don't enumerate tables and their types/sizes (default: on)
                                    (Recommended for servers with many tables)
        --skippassword              Don't perform checks on user passwords(default: off)
        --checkversion              Check for updates to MySQLTuner (default: don't check)
        --updateversion             Check for updates to MySQLTuner and update when newer version is available (default: don't check)
        --forcemem <size>           Amount of RAM installed in megabytes
        --forceswap <size>          Amount of swap memory configured in megabytes
        --passwordfile <path>       Path to a password file list(one password by line)


        --silent                    Don't output anything on screen
        --nogood                    Remove OK responses
        --nobad                     Remove negative/suggestion responses
        --noinfo                    Remove informational responses
        --debug                     Print debug information
        --dbstat                    Print database information
        --tbstat                    Print table information
        --notbstat                  Don't Print table information
        --idxstat                   Print index information
        --sysstat                   Print system information
        --pfstat                    Print Performance schema
        --bannedports               Ports banned separated by comma(,)
        --maxportallowed            Number of ports opened allowed on this hosts
        --cvefile <path>            CVE File for vulnerability checks
        --nocolor                   Don't print output in color
        --json                      Print result as JSON string
        --buffers                   Print global and per-thread buffer values
        --outputfile <path>         Path to a output txt file
        --reportfile <path>         Path to a report txt file
        --template   <path>         Path to a template file
        --verbose                   Prints out all options (default: no verbose)


       You can find documentation for this module with the perldoc command.

         perldoc mysqltuner


        Internal documentation


       Major Hayden -


       ·   Matthew Montgomery

       ·   Paul Kehrer

       ·   Dave Burgess

       ·   Jonathan Hinds

       ·   Mike Jackson

       ·   Nils Breunese

       ·   Shawn Ashlee

       ·   Luuk Vosslamber

       ·   Ville Skytta

       ·   Trent Hornibrook

       ·   Jason Gill

       ·   Mark Imbriaco

       ·   Greg Eden

       ·   Aubin Galinotti

       ·   Giovanni Bechis

       ·   Bill Bradford

       ·   Ryan Novosielski

       ·   Michael Scheidell

       ·   Blair Christensen

       ·   Hans du Plooy

       ·   Victor Trac

       ·   Everett Barnes

       ·   Tom Krouper

       ·   Gary Barrueto

       ·   Simon Greenaway

       ·   Adam Stein

       ·   Isart Montane

       ·   Baptiste M.

       ·   Cole Turner

       ·   Major Hayden

       ·   Joe Ashcraft

       ·   Jean-Marie Renouard

       ·   Stephan GroBberndt

       ·   Christian Loos


       Bug reports, feature requests, and downloads at

       Bug tracker can be found at

       Maintained by Major Hayden (major\ - Licensed under GPL



        git clone


       Copyright (C) 2006-2017 Major Hayden -

       For the latest updates, please visit

       Git repository available at

       This program is free software: you can redistribute it and/or modify it under the terms of
       the GNU General Public License as published by the Free Software Foundation, either
       version 3 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
       without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

        See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with this program.
       If not, see <>.