.\" Automatically generated by Pod::Man 4.14 (Pod::Simple 3.40) .\" .\" Standard preamble: .\" ======================================================================== .de Sp \" Vertical space (when we can't use .PP) .if t .sp .5v .if n .sp .. .de Vb \" Begin verbatim text .ft CW .nf .ne \\$1 .. .de Ve \" End verbatim text .ft R .fi .. .\" Set up some character translations and predefined strings. \*(-- will .\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left .\" double quote, and \*(R" will give a right double quote. \*(C+ will .\" give a nicer C++. Capital omega is used to do unbreakable dashes and .\" therefore won't be available. \*(C` and \*(C' expand to `' in nroff, .\" nothing in troff, for use with C<>. .tr \(*W- .ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p' .ie n \{\ . ds -- \(*W- . ds PI pi . if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch . if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch . ds L" "" . ds R" "" . ds C` "" . ds C' "" 'br\} .el\{\ . ds -- \|\(em\| . ds PI \(*p . ds L" `` . ds R" '' . ds C` . ds C' 'br\} .\" .\" Escape single quotes in literal strings from groff's Unicode transform. .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" .\" If the F register is >0, we'll generate index entries on stderr for .\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index .\" entries marked with X<> in POD. Of course, you'll have to process the .\" output yourself in some meaningful fashion. .\" .\" Avoid warning from groff about undefined register 'F'. .de IX .. .nr rF 0 .if \n(.g .if rF .nr rF 1 .if (\n(rF:(\n(.g==0)) \{\ . if \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . if !\nF==2 \{\ . nr % 0 . nr F 2 . \} . \} .\} .rr rF .\" .\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2). .\" Fear. Run. Save yourself. No user-serviceable parts. . \" fudge factors for nroff and troff .if n \{\ . ds #H 0 . ds #V .8m . ds #F .3m . ds #[ \f1 . ds #] \fP .\} .if t \{\ . ds #H ((1u-(\\\\n(.fu%2u))*.13m) . ds #V .6m . ds #F 0 . ds #[ \& . ds #] \& .\} . \" simple accents for nroff and troff .if n \{\ . ds ' \& . ds ` \& . ds ^ \& . ds , \& . ds ~ ~ . ds / .\} .if t \{\ . ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u" . ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u' . ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u' . ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u' . ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u' . ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u' .\} . \" troff and (daisy-wheel) nroff accents .ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V' .ds 8 \h'\*(#H'\(*b\h'-\*(#H' .ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#] .ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H' .ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u' .ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#] .ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#] .ds ae a\h'-(\w'a'u*4/10)'e .ds Ae A\h'-(\w'A'u*4/10)'E . \" corrections for vroff .if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u' .if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u' . \" for low resolution devices (crt and lpr) .if \n(.H>23 .if \n(.V>19 \ \{\ . ds : e . ds 8 ss . ds o a . ds d- d\h'-1'\(ga . ds D- D\h'-1'\(hy . ds th \o'bp' . ds Th \o'LP' . ds ae ae . ds Ae AE .\} .rm #[ #] #H #V #F C .\" ======================================================================== .\" .IX Title "MYSQLTUNER 1" .TH MYSQLTUNER 1 "2021-01-03" "perl v5.32.0" "User Contributed Perl Documentation" .\" For nroff, turn off justification. Always turn off hyphenation; it makes .\" way too many mistakes in technical documents. .if n .ad l .nh .SH "NAME" .Vb 1 \& MySQLTuner 1.7.17 \- MySQL High Performance Tuning Script .Ve .SH "IMPORTANT USAGE GUIDELINES" .IX Header "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 .SH "CONNECTION AND AUTHENTICATION" .IX Header "CONNECTION AND AUTHENTICATION" .Vb 11 \& \-\-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) \& \-\-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 .Ve .SH "PERFORMANCE AND REPORTING OPTIONS" .IX Header "PERFORMANCE AND REPORTING OPTIONS" .Vb 8 \& \-\-skipsize Don\*(Aqt enumerate tables and their types/sizes (default: on) \& (Recommended for servers with many tables) \& \-\-skippassword Don\*(Aqt perform checks on user passwords(default: off) \& \-\-checkversion Check for updates to MySQLTuner (default: don\*(Aqt check) \& \-\-updateversion Check for updates to MySQLTuner and update when newer version is available (default: don\*(Aqt 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) .Ve .SH "OUTPUT OPTIONS" .IX Header "OUTPUT OPTIONS" .Vb 10 \& \-\-silent Don\*(Aqt output anything on screen \& \-\-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\*(Aqt Print database information \& \-\-tbstat Print table information \& \-\-notbstat Don\*(Aqt Print table information \& \-\-idxstat Print index information \& \-\-noidxstat Don\*(Aqt Print index information \& \-\-sysstat Print system information \& \-\-nosysstat Don\*(Aqt Print system information \& \-\-pfstat Print Performance schema \& \-\-nopfstat Don\*(Aqt Print Performance schema \& \-\-verbose Prints out all options (default: no verbose, dbstat, idxstat, sysstat, tbstat, pfstat) \& \-\-bannedports Ports banned separated by comma(,) \& \-\-maxportallowed Number of ports opened allowed on this hosts \& \-\-cvefile CVE File for vulnerability checks \& \-\-nocolor Don\*(Aqt print output in color \& \-\-json Print result as JSON string \& \-\-buffers Print global and per\-thread buffer values \& \-\-outputfile Path to a output txt file \& \-\-reportfile Path to a report txt file \& \-\-template Path to a template file .Ve .SH "PERLDOC" .IX Header "PERLDOC" You can find documentation for this module with the perldoc command. .PP .Vb 1 \& perldoc mysqltuner .Ve .SS "\s-1INTERNALS\s0" .IX Subsection "INTERNALS" .PP .Vb 1 \& Internal documentation .Ve .SH "AUTHORS" .IX Header "AUTHORS" Major Hayden \- major@mhtx.net .SH "CONTRIBUTORS" .IX Header "CONTRIBUTORS" .IP "\(bu" 4 Matthew Montgomery .IP "\(bu" 4 Paul Kehrer .IP "\(bu" 4 Dave Burgess .IP "\(bu" 4 Jonathan Hinds .IP "\(bu" 4 Mike Jackson .IP "\(bu" 4 Nils Breunese .IP "\(bu" 4 Shawn Ashlee .IP "\(bu" 4 Luuk Vosslamber .IP "\(bu" 4 Ville Skytta .IP "\(bu" 4 Trent Hornibrook .IP "\(bu" 4 Jason Gill .IP "\(bu" 4 Mark Imbriaco .IP "\(bu" 4 Greg Eden .IP "\(bu" 4 Aubin Galinotti .IP "\(bu" 4 Giovanni Bechis .IP "\(bu" 4 Bill Bradford .IP "\(bu" 4 Ryan Novosielski .IP "\(bu" 4 Michael Scheidell .IP "\(bu" 4 Blair Christensen .IP "\(bu" 4 Hans du Plooy .IP "\(bu" 4 Victor Trac .IP "\(bu" 4 Everett Barnes .IP "\(bu" 4 Tom Krouper .IP "\(bu" 4 Gary Barrueto .IP "\(bu" 4 Simon Greenaway .IP "\(bu" 4 Adam Stein .IP "\(bu" 4 Isart Montane .IP "\(bu" 4 Baptiste M. .IP "\(bu" 4 Cole Turner .IP "\(bu" 4 Major Hayden .IP "\(bu" 4 Joe Ashcraft .IP "\(bu" 4 Jean-Marie Renouard .IP "\(bu" 4 Stephan GroBberndt .IP "\(bu" 4 Christian Loos .SH "SUPPORT" .IX Header "SUPPORT" Bug reports, feature requests, and downloads at http://mysqltuner.com/ .PP Bug tracker can be found at https://github.com/major/MySQLTuner\-perl/issues .PP Maintained by Major Hayden (major\e@mhtx.net) \- Licensed under \s-1GPL\s0 .SH "SOURCE CODE" .IX Header "SOURCE CODE" .PP .Vb 1 \& git clone https://github.com/major/MySQLTuner\-perl.git .Ve .SH "COPYRIGHT AND LICENSE" .IX Header "COPYRIGHT AND LICENSE" Copyright (C) 2006\-2018 Major Hayden \- major@mhtx.net .PP For the latest updates, please visit http://mysqltuner.com/ .PP Git repository available at https://github.com/major/MySQLTuner\-perl .PP This program is free software: you can redistribute it and/or modify it under the terms of the \s-1GNU\s0 General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. .PP This program is distributed in the hope that it will be useful, but \s-1WITHOUT ANY WARRANTY\s0; without even the implied warranty of \&\s-1MERCHANTABILITY\s0 or \s-1FITNESS FOR A PARTICULAR PURPOSE.\s0 .PP .Vb 1 \& See the GNU General Public License for more details. .Ve .PP You should have received a copy of the \s-1GNU\s0 General Public License along with this program. If not, see .