2022-12-29 04:11:31 +00:00
|
|
|
# NAME
|
|
|
|
|
2024-08-06 08:43:15 +00:00
|
|
|
MySQLTuner 2.6.0 - MySQL High Performance Tuning Script
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
# 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 <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
|
2023-03-11 06:48:00 +00:00
|
|
|
--defaults-extra-file <path> Path to an extra custom config file
|
2022-12-29 04:11:31 +00:00
|
|
|
--server-log <path> 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 <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
|
2023-03-11 06:48:00 +00:00
|
|
|
--dumpdir <path> Path to a directory where to dump information files
|
2023-06-07 17:29:41 +00:00
|
|
|
--feature <feature> Run a specific feature (see FEATURES section)
|
2024-02-08 23:21:26 +00:00
|
|
|
--dumpdir <path> information_schema tables and sys views are dumped in CSV in this path
|
|
|
|
|
|
|
|
# OUTPUT OPTIONS
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
--silent Don't output anything on screen
|
|
|
|
--verbose Print out all options (default: no verbose, dbstat, idxstat, sysstat, tbstat, pfstat)
|
2024-02-08 23:21:26 +00:00
|
|
|
--color Print output in color
|
2022-12-29 04:11:31 +00:00
|
|
|
--nocolor Don't print output in color
|
|
|
|
--nogood Remove OK responses
|
|
|
|
--nobad Remove negative/suggestion responses
|
|
|
|
--noinfo Remove informational responses
|
|
|
|
--debug Print debug information
|
2024-02-12 11:25:48 +00:00
|
|
|
--experimental Print experimental analysis (may fail)
|
2024-02-08 23:21:26 +00:00
|
|
|
--nondedicated Consider server is not dedicated to Db server usage only
|
2022-12-29 04:11:31 +00:00
|
|
|
--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
|
2023-07-06 06:19:29 +00:00
|
|
|
--nomyisamstat Don't print MyIsam information
|
2022-12-29 04:11:31 +00:00
|
|
|
--sysstat Print system information
|
|
|
|
--nosysstat Don't print system information
|
2023-07-06 06:19:29 +00:00
|
|
|
--nostructstat Don't print table structures information
|
2022-12-29 04:11:31 +00:00
|
|
|
--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
|
|
|
|
|
|
|
|
[https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md](https://github.com/major/MySQLTuner-perl/blob/master/INTERNALS.md)
|
|
|
|
|
|
|
|
Internal documentation
|
|
|
|
|
|
|
|
# AUTHORS
|
|
|
|
|
|
|
|
Major Hayden - major@mhtx.net
|
2023-03-11 06:48:00 +00:00
|
|
|
Jean-Marie Renouard - jmrenouard@gmail.com
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
# 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
|
2023-03-11 06:48:00 +00:00
|
|
|
- Long Radix
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
# SUPPORT
|
|
|
|
|
|
|
|
Bug reports, feature requests, and downloads at http://mysqltuner.pl/
|
|
|
|
|
|
|
|
Bug tracker can be found at https://github.com/major/MySQLTuner-perl/issues
|
|
|
|
|
2023-03-11 06:48:00 +00:00
|
|
|
Maintained by Jean-Marie Renouard (jmrenouard\\@gmail.com) - Licensed under GPL
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
# SOURCE CODE
|
|
|
|
|
|
|
|
[https://github.com/major/MySQLTuner-perl](https://github.com/major/MySQLTuner-perl)
|
|
|
|
|
|
|
|
git clone https://github.com/major/MySQLTuner-perl.git
|
|
|
|
|
|
|
|
# COPYRIGHT AND LICENSE
|
|
|
|
|
2023-03-11 06:48:00 +00:00
|
|
|
Copyright (C) 2006-2023 Major Hayden - major@mhtx.net
|
|
|
|
\# Copyright (C) 2015-2023 Jean-Marie Renouard - jmrenouard@gmail.com
|
2022-12-29 04:11:31 +00:00
|
|
|
|
|
|
|
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/>.
|