--- name: "mysqltuner" section: "1" platform: "linux" package: "mysqltuner" version: "2.6.0-1" release: "Debian 13 (Trixie)" platforms: ["linux"] url: "https://new.carta.tech/mysqltuner" --- # mysqltuner(1) ## NAME ``` MySQLTuner 2.6.0 - MySQL High Performance Tuning Script ``` ## IMPORTANT USAGE GUIDELINES 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 ## CONNECTION AND AUTHENTICATION ``` --host Connect to a remote host to perform tests (default: localhost) --socket Use a different socket for a local connection --port Port to use for connection (default: 3306) --protocol tcp Force TCP connection instead of socket --user Username to use for authentication --userenv Name of env variable which contains username to use for authentication --pass Password to use for authentication --passenv Name of env variable which contains password to use for authentication --ssl-ca Path to public key --mysqladmin Path to a custom mysqladmin executable --mysqlcmd Path to a custom mysql executable --defaults-file Path to a custom .my.cnf --defaults-extra-file Path to an extra custom config file --server-log Path to explicit log file (error_log) ``` ## PERFORMANCE AND REPORTING OPTIONS ``` --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 Amount of RAM installed in megabytes --forceswap Amount of swap memory configured in megabytes --passwordfile Path to a password file list (one password by line) --cvefile CVE File for vulnerability checks --outputfile Path to a output txt file --reportfile Path to a report txt file --template Path to a template file --dumpdir Path to a directory where to dump information files --feature Run a specific feature (see FEATURES section) --dumpdir information_schema tables and sys views are dumped in CSV in this path ``` ## 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 --experimental Print experimental analysis (may fail) --nondedicated Consider server is not dedicated to Db server usage only --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 ``` ## PERLDOC You can find documentation for this module with the perldoc command. ``` perldoc mysqltuner ``` ### INTERNALS \ ``` Internal documentation ``` ## AUTHORS Major Hayden - major@mhtx.net Jean-Marie Renouard - jmrenouard@gmail.com ## CONTRIBUTORS - • 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 - • Long Radix ## SUPPORT 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 ## SOURCE CODE \ ``` git clone https://github.com/major/MySQLTuner-perl.git ``` ## COPYRIGHT AND LICENSE 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 \.