MYSQLTUNER(1) User Contributed Perl Documentation MYSQLTUNER(1) 

 MySQLTuner 2.5.2 - 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)
 --protocol tcp              Force TCP connection instead of socket
 --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
 --defaults-extra-file <path>      Path to an extra custom config file
 --server-log <path>         Path to explicit log file (error_log)


 --skipsize                  Don't enumerate tables and their types/sizes (default: on)
                             (Recommended for servers with many tables)
 --json                      Print result as JSON string
 --prettyjson                Print result as JSON formatted string
 --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)
 --cvefile <path>            CVE File for vulnerability checks
 --outputfile <path>         Path to a output txt file
 --reportfile <path>         Path to a report txt file
 --template   <path>         Path to a template file
 --dumpdir <path>            Path to a directory where to dump information files
 --feature <feature>         Run a specific feature (see FEATURES section)
=head1 OUTPUT OPTIONS
 --silent                    Don't output anything on screen
 --verbose                   Print out all options (default: no verbose, dbstat, idxstat, sysstat, tbstat, pfstat)
 --color                     Print output in color
 --nocolor                   Don't print output in color
 --nogood                    Remove OK responses
 --nobad                     Remove negative/suggestion responses
 --noinfo                    Remove informational responses
 --debug                     Print debug information
 --noprocess                 Consider no other process is running
 --dbstat                    Print database information
 --nodbstat                  Don't print database information
 --tbstat                    Print table information
 --notbstat                  Don't print table information
 --colstat                   Print column information
 --nocolstat                 Don't print column information
 --idxstat                   Print index information
 --noidxstat                 Don't print index information
 --nomyisamstat              Don't print MyIsam information
 --sysstat                   Print system information
 --nosysstat                 Don't print system information
 --nostructstat              Don't print table structures information
 --pfstat                    Print Performance schema
 --nopfstat                  Don't print Performance schema
 --bannedports               Ports banned separated by comma (,)
 --server-log                Define specific error_log to analyze
 --maxportallowed            Number of open ports allowable on this host
 --buffers                   Print global and per-thread buffer values

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

  perldoc mysqltuner

<https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md>

 Internal documentation

Major Hayden - major@mhtx.net Jean-Marie Renouard - jmrenouard@gmail.com

Bug reports, feature requests, and downloads at http://mysqltuner.pl/

Bug tracker can be found at https://github.com/major/MySQLTuner-perl/issues

Maintained by Jean-Marie Renouard (jmrenouard\@gmail.com) - Licensed under GPL

<https://github.com/major/MySQLTuner-perl>

 git clone https://github.com/major/MySQLTuner-perl.git

Copyright (C) 2006-2023 Major Hayden - major@mhtx.net # Copyright (C) 2015-2023 Jean-Marie Renouard - jmrenouard@gmail.com

For the latest updates, please visit http://mysqltuner.pl/

Git repository available at https://github.com/major/MySQLTuner-perl

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 <https://www.gnu.org/licenses/>.

2024-02-24 perl v5.38.2