.\" Automatically generated by Pod::Man 2.25 (Pod::Simple 3.16) .\" .\" 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" '' '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 turned on, 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. .ie \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . nr % 0 . rr F .\} .el \{\ . de IX .. .\} .\" .\" 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 "PT-UPGRADE 1p" .TH PT-UPGRADE 1p "2012-06-15" "perl v5.14.2" "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" pt\-upgrade \- Execute queries on multiple servers and check for differences. .SH "SYNOPSIS" .IX Header "SYNOPSIS" Usage: pt-upgrade [\s-1OPTION\s0...] \s-1DSN\s0 [\s-1DSN\s0...] [\s-1FILE\s0] .PP pt-upgrade compares query execution on two hosts by executing queries in the given file (or \s-1STDIN\s0 if no file given) and examining the results, errors, warnings, etc.produced on each. .PP Execute and compare all queries in slow.log on host1 to host2: .PP .Vb 1 \& pt\-upgrade slow.log h=host1 h=host2 .Ve .PP Use pt-query-digest to get, execute and compare queries from tcpdump: .PP .Vb 3 \& tcpdump \-i eth0 port 3306 \-s 65535 \-x \-n \-q \-tttt > tcpdump.txt \& pt\-query\-digest tcpdump.txt \-\-type tcpdump \-\-no\-report \-\-print > digest.txt \& pt\-upgrade digest.txt h=host1 h=host2 .Ve .PP Compare only query times on host1 to host2 and host3: .PP .Vb 1 \& pt\-upgrade slow.log h=host1 h=host2 h=host3 \-\-compare query_times .Ve .PP Compare a single query, no slowlog needed: .PP .Vb 1 \& pt\-upgrade h=host1 h=host2 \-\-query \*(AqSELECT * FROM db.tbl\*(Aq .Ve .SH "RISKS" .IX Header "RISKS" The following section is included to inform users about the potential risks, whether known or unknown, of using this tool. The two main categories of risks are those created by the nature of the tool (e.g. read-only tools vs. read-write tools) and those created by bugs. .PP pt-upgrade is a read-only tool that is meant to be used on non-production servers. It executes the \s-1SQL\s0 that you give it as input, which could cause undesired load on a production server. .PP At the time of this release, there is a bug that causes the tool to crash, and a bug that causes a deadlock. .PP The authoritative source for updated information is always the online issue tracking system. Issues that affect this tool will be marked as such. You can see a list of such issues at the following \s-1URL:\s0 http://www.percona.com/bugs/pt\-upgrade . .PP See also \*(L"\s-1BUGS\s0\*(R" for more information on filing bugs and getting help. .SH "DESCRIPTION" .IX Header "DESCRIPTION" pt-upgrade executes queries from slowlogs on one or more MySQL server to find differences in query time, warnings, results, and other aspects of the queries' execution. This helps evaluate upgrades, migrations and configuration changes. The comparisons specified by \*(L"\-\-compare\*(R" determine what differences can be found. A report is printed which outlines all the differences found; see \*(L"\s-1OUTPUT\s0\*(R" below. .PP The first \s-1DSN\s0 (host) specified on the command line is authoritative; it defines the results to which the other DSNs are compared. You can \*(L"compare\*(R" only one host, in which case there will be no differences but the output can be saved to be diffed later against the output of another single host \*(L"comparison\*(R". .PP At present, pt-upgrade only reads slowlogs. Use \f(CW\*(C`pt\-query\-digest \-\-print\*(C'\fR to transform other log formats to slowlog. .PP DSNs and slowlog files can be specified in any order. pt-upgrade will automatically determine if an argument is a \s-1DSN\s0 or a slowlog file. If no slowlog files are given and \*(L"\-\-query\*(R" is not specified then pt-upgrade will read from \f(CW\*(C`STDIN\*(C'\fR. .SH "OUTPUT" .IX Header "OUTPUT" Queries are group by fingerprints and any with differences are printed. The first part of a query report is a summary of differences. In the example below, the query returns a different number of rows (\f(CW\*(C`row counts\*(C'\fR) on each server. The second part is the side-by-side comparison of values obtained from the query on each server. Then a sample of the query is printed, preceded by its \s-1ID\s0 which can be used to locate more information in the sub-report at the end. There are sub-reports for various types of differences. .PP .Vb 10 \& # Query 1: ID 0x3C830E3839B916D7 at byte 0 _\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_\|_ \& # Found 1 differences in 1 samples: \& # column counts 0 \& # column types 0 \& # column values 0 \& # row counts 1 \& # warning counts 0 \& # warning levels 0 \& # warnings 0 \& # 127.1:12345 127.1:12348 \& # Errors 0 0 \& # Warnings 0 0 \& # Query_time \& # sum 0 0 \& # min 0 0 \& # max 0 0 \& # avg 0 0 \& # pct_95 0 0 \& # stddev 0 0 \& # median 0 0 \& # row_count \& # sum 4 3 \& # min 4 3 \& # max 4 3 \& # avg 4 3 \& # pct_95 4 3 \& # stddev 0 0 \& # median 4 3 \& use \`test\`; \& select i from t where i is not null \& \& /* 3C830E3839B916D7\-1 */ select i from t where i is not null \& \& # Row count differences \& # Query ID 127.1:12345 127.1:12348 \& # ================== =========== =========== \& # 3C830E3839B916D7\-1 4 3 .Ve .PP The output will vary slightly depending on which options are specified. .SH "OPTIONS" .IX Header "OPTIONS" This tool accepts additional command-line arguments. Refer to the \&\*(L"\s-1SYNOPSIS\s0\*(R" and usage information for details. .IP "\-\-ask\-pass" 4 .IX Item "--ask-pass" Prompt for a password when connecting to MySQL. .IP "\-\-base\-dir" 4 .IX Item "--base-dir" type: string; default: /tmp .Sp Save outfiles for the \f(CW\*(C`rows\*(C'\fR comparison method in this directory. .Sp See the \f(CW\*(C`rows\*(C'\fR \*(L"\-\-compare\-results\-method\*(R". .IP "\-\-charset" 4 .IX Item "--charset" short form: \-A; type: string .Sp Default character set. If the value is utf8, sets Perl's binmode on \&\s-1STDOUT\s0 to utf8, passes the mysql_enable_utf8 option to DBD::mysql, and runs \s-1SET\s0 \s-1NAMES\s0 \s-1UTF8\s0 after connecting to MySQL. Any other value sets binmode on \s-1STDOUT\s0 without the utf8 layer, and runs \s-1SET\s0 \s-1NAMES\s0 after connecting to MySQL. .IP "\-\-[no]clear\-warnings" 4 .IX Item "--[no]clear-warnings" default: yes .Sp Clear warnings before each warnings comparison. .Sp If comparing warnings (\*(L"\-\-compare\*(R" includes \f(CW\*(C`warnings\*(C'\fR), this option causes pt-upgrade to execute a successful \f(CW\*(C`SELECT\*(C'\fR statement which clears any warnings left over from previous queries. This requires a current database that pt-upgrade usually detects automatically, but in some cases it might be necessary to specify \*(L"\-\-temp\-database\*(R". If pt-upgrade can't auto-detect the current database, it will create a temporary table in the \&\*(L"\-\-temp\-database\*(R" called \f(CW\*(C`mk_upgrade_clear_warnings\*(C'\fR. .IP "\-\-clear\-warnings\-table" 4 .IX Item "--clear-warnings-table" type: string .Sp Execute \f(CW\*(C`SELECT * FROM ... LIMIT 1\*(C'\fR from this table to clear warnings. .IP "\-\-compare" 4 .IX Item "--compare" type: Hash; default: query_times,results,warnings .Sp What to compare for each query executed on each host. .Sp Comparisons determine differences when the queries are executed on the hosts. More comparisons enable more differences to be detected. The following comparisons are available: .RS 4 .IP "query_times" 4 .IX Item "query_times" Compare query execution times. If this comparison is disabled, the queries are still executed so that other comparisons will work, but the query time attributes are removed from the events. .IP "results" 4 .IX Item "results" Compare result sets to find differences in rows, columns, etc. .Sp What differences can be found depends on the \*(L"\-\-compare\-results\-method\*(R" used. .IP "warnings" 4 .IX Item "warnings" Compare warnings from \f(CW\*(C`SHOW WARNINGS\*(C'\fR. Requires at least MySQL 4.1. .RE .RS 4 .RE .IP "\-\-compare\-results\-method" 4 .IX Item "--compare-results-method" type: string; default: \s-1CHECKSUM\s0; group: Comparisons .Sp Method to use for \*(L"\-\-compare\*(R" \f(CW\*(C`results\*(C'\fR. This option has no effect if \f(CW\*(C`\-\-no\-compare\-results\*(C'\fR is given. .Sp Available compare methods (case-insensitive): .RS 4 .IP "\s-1CHECKSUM\s0" 4 .IX Item "CHECKSUM" Do \f(CW\*(C`CREATE TEMPORARY TABLE \`mk_upgrade\` AS query\*(C'\fR then \&\f(CW\*(C`CHECKSUM TABLE \`mk_upgrade\`\*(C'\fR. This method is fast and simple but in rare cases might it be inaccurate because the MySQL manual says: .Sp .Vb 2 \& [The] fact that two tables produce the same checksum does I mean that \& the tables are identical. .Ve .Sp Requires at least MySQL 4.1. .IP "rows" 4 .IX Item "rows" Compare rows one-by-one to find differences. This method has advantages and disadvantages. Its disadvantages are that it may be slower and it requires writing and reading outfiles from disk. Its advantages are that it is universal (works for all versions of MySQL), it doesn't alter the query in any way, and it can find column value differences. .Sp The \f(CW\*(C`rows\*(C'\fR method works as follows: .Sp .Vb 7 \& 1. Rows from each host are compared one\-by\-one. \& 2. If no differences are found, comparison stops, else... \& 3. All remain rows (after the point where they begin to differ) \& are written to outfiles. \& 4. The outfiles are loaded into temporary tables with \& C. \& 5. The temporary tables are analyzed to determine the differences. .Ve .Sp The outfiles are written to the \*(L"\-\-base\-dir\*(R". .RE .RS 4 .RE .IP "\-\-config" 4 .IX Item "--config" type: Array .Sp Read this comma-separated list of config files; if specified, this must be the first option on the command line. .IP "\-\-continue\-on\-error" 4 .IX Item "--continue-on-error" Continue working even if there is an error. .IP "\-\-convert\-to\-select" 4 .IX Item "--convert-to-select" Convert non-SELECT statements to SELECTs and compare. .Sp By default non-SELECT statements are not allowed. This option causes non-SELECT statements (like \s-1UPDATE\s0, \s-1INSERT\s0 and \s-1DELETE\s0) to be converted to \s-1SELECT\s0 statements, executed and compared. .Sp For example, \f(CW\*(C`DELETE col FROM tbl WHERE id=1\*(C'\fR is converted to \&\f(CW\*(C`SELECT col FROM tbl WHERE id=1\*(C'\fR. .IP "\-\-daemonize" 4 .IX Item "--daemonize" Fork to the background and detach from the shell. \s-1POSIX\s0 operating systems only. .IP "\-\-explain\-hosts" 4 .IX Item "--explain-hosts" Print connection information and exit. .IP "\-\-filter" 4 .IX Item "--filter" type: string .Sp Discard events for which this Perl code doesn't return true. .Sp This option is a string of Perl code or a file containing Perl code that gets compiled into a subroutine with one argument: \f(CW$event\fR. This is a hashref. If the given value is a readable file, then pt-upgrade reads the entire file and uses its contents as the code. The file should not contain a shebang (#!/usr/bin/perl) line. .Sp If the code returns true, the chain of callbacks continues; otherwise it ends. The code is the last statement in the subroutine other than \f(CW\*(C`return $event\*(C'\fR. The subroutine template is: .Sp .Vb 1 \& sub { $event = shift; filter && return $event; } .Ve .Sp Filters given on the command line are wrapped inside parentheses like like \&\f(CW\*(C`( filter )\*(C'\fR. For complex, multi-line filters, you must put the code inside a file so it will not be wrapped inside parentheses. Either way, the filter must produce syntactically valid code given the template. For example, an if-else branch given on the command line would not be valid: .Sp .Vb 1 \& \-\-filter \*(Aqif () { } else { }\*(Aq # WRONG .Ve .Sp Since it's given on the command line, the if-else branch would be wrapped inside parentheses which is not syntactically valid. So to accomplish something more complex like this would require putting the code in a file, for example filter.txt: .Sp .Vb 1 \& my $event_ok; if (...) { $event_ok=1; } else { $event_ok=0; } $event_ok .Ve .Sp Then specify \f(CW\*(C`\-\-filter filter.txt\*(C'\fR to read the code from filter.txt. .Sp If the filter code won't compile, pt-upgrade will die with an error. If the filter code does compile, an error may still occur at runtime if the code tries to do something wrong (like pattern match an undefined value). pt-upgrade does not provide any safeguards so code carefully! .Sp An example filter that discards everything but \s-1SELECT\s0 statements: .Sp .Vb 1 \& \-\-filter \*(Aq$event\->{arg} =~ m/^select/i\*(Aq .Ve .Sp This is compiled into a subroutine like the following: .Sp .Vb 1 \& sub { $event = shift; ( $event\->{arg} =~ m/^select/i ) && return $event; } .Ve .Sp It is permissible for the code to have side effects (to alter \f(CW$event\fR). .Sp You can find an explanation of the structure of \f(CW$event\fR at . .IP "\-\-fingerprints" 4 .IX Item "--fingerprints" Add query fingerprints to the standard query analysis report. This is mostly useful for debugging purposes. .IP "\-\-float\-precision" 4 .IX Item "--float-precision" type: int .Sp Round float, double and decimal values to this many places. .Sp This option helps eliminate false-positives caused by floating-point imprecision. .IP "\-\-help" 4 .IX Item "--help" Show help and exit. .IP "\-\-host" 4 .IX Item "--host" short form: \-h; type: string .Sp Connect to host. .IP "\-\-iterations" 4 .IX Item "--iterations" type: int; default: 1 .Sp How many times to iterate through the collect-and-report cycle. If 0, iterate to infinity. See also \-\-run\-time. .IP "\-\-limit" 4 .IX Item "--limit" type: string; default: 95%:20 .Sp Limit output to the given percentage or count. .Sp If the argument is an integer, report only the top N worst queries. If the argument is an integer followed by the \f(CW\*(C`%\*(C'\fR sign, report that percentage of the worst queries. If the percentage is followed by a colon and another integer, report the top percentage or the number specified by that integer, whichever comes first. .IP "\-\-log" 4 .IX Item "--log" type: string .Sp Print all output to this file when daemonized. .IP "\-\-max\-different\-rows" 4 .IX Item "--max-different-rows" type: int; default: 10 .Sp Stop comparing rows for \f(CW\*(C`\-\-compare\-results\-method rows\*(C'\fR after this many differences are found. .IP "\-\-order\-by" 4 .IX Item "--order-by" type: string; default: differences:sum .Sp Sort events by this attribute and aggregate function. .IP "\-\-password" 4 .IX Item "--password" short form: \-p; type: string .Sp Password to use when connecting. .IP "\-\-pid" 4 .IX Item "--pid" type: string .Sp Create the given \s-1PID\s0 file when daemonized. The file contains the process \&\s-1ID\s0 of the daemonized instance. The \s-1PID\s0 file is removed when the daemonized instance exits. The program checks for the existence of the \&\s-1PID\s0 file when starting; if it exists and the process with the matching \s-1PID\s0 exists, the program exits. .IP "\-\-port" 4 .IX Item "--port" short form: \-P; type: int .Sp Port number to use for connection. .IP "\-\-query" 4 .IX Item "--query" type: string .Sp Execute and compare this single query; ignores files on command line. .Sp This option allows you to supply a single query on the command line. Any slowlogs also specified on the command line are ignored. .IP "\-\-reports" 4 .IX Item "--reports" type: Hash; default: queries,differences,errors,statistics .Sp Print these reports. Valid reports are queries, differences, errors, and statistics. .Sp See \*(L"\s-1OUTPUT\s0\*(R" for more information on the various parts of the report. .IP "\-\-run\-time" 4 .IX Item "--run-time" type: time .Sp How long to run before exiting. The default is to run forever (you can interrupt with CTRL-C). .IP "\-\-set\-vars" 4 .IX Item "--set-vars" type: string; default: wait_timeout=10000,query_cache_type=0 .Sp Set these MySQL variables. Immediately after connecting to MySQL, this string will be appended to \s-1SET\s0 and executed. .IP "\-\-shorten" 4 .IX Item "--shorten" type: int; default: 1024 .Sp Shorten long statements in reports. .Sp Shortens long statements, replacing the omitted portion with a \f(CW\*(C`/*... omitted \&...*/\*(C'\fR comment. This applies only to the output in reports. It prevents a large statement from causing difficulty in a report. The argument is the preferred length of the shortened statement. Not all statements can be shortened, but very large \s-1INSERT\s0 and similar statements often can; and so can \s-1\fIIN\s0()\fR lists, although only the first such list in the statement will be shortened. .Sp If it shortens something beyond recognition, you can find the original statement in the log, at the offset shown in the report header (see \*(L"\s-1OUTPUT\s0\*(R"). .IP "\-\-socket" 4 .IX Item "--socket" short form: \-S; type: string .Sp Socket file to use for connection. .IP "\-\-temp\-database" 4 .IX Item "--temp-database" type: string .Sp Use this database for creating temporary tables. .Sp If given, this database is used for creating temporary tables for the results comparison (see \*(L"\-\-compare\*(R"). Otherwise, the current database (from the last event that specified its database) is used. .IP "\-\-temp\-table" 4 .IX Item "--temp-table" type: string; default: mk_upgrade .Sp Use this table for checksumming results. .IP "\-\-user" 4 .IX Item "--user" short form: \-u; type: string .Sp User for login if not current user. .IP "\-\-version" 4 .IX Item "--version" Show version and exit. .IP "\-\-zero\-query\-times" 4 .IX Item "--zero-query-times" Zero the query times in the report. .SH "DSN OPTIONS" .IX Header "DSN OPTIONS" These \s-1DSN\s0 options are used to create a \s-1DSN\s0. Each option is given like \&\f(CW\*(C`option=value\*(C'\fR. The options are case-sensitive, so P and p are not the same option. There cannot be whitespace before or after the \f(CW\*(C`=\*(C'\fR, and if the value contains whitespace it must be quoted. \s-1DSN\s0 options are comma-separated. See the percona-toolkit manpage for full details. .IP "\(bu" 4 A .Sp dsn: charset; copy: yes .Sp Default character set. .IP "\(bu" 4 D .Sp dsn: database; copy: yes .Sp Default database. .IP "\(bu" 4 F .Sp dsn: mysql_read_default_file; copy: yes .Sp Only read default options from the given file .IP "\(bu" 4 h .Sp dsn: host; copy: yes .Sp Connect to host. .IP "\(bu" 4 p .Sp dsn: password; copy: yes .Sp Password to use when connecting. .IP "\(bu" 4 P .Sp dsn: port; copy: yes .Sp Port number to use for connection. .IP "\(bu" 4 S .Sp dsn: mysql_socket; copy: yes .Sp Socket file to use for connection. .IP "\(bu" 4 u .Sp dsn: user; copy: yes .Sp User for login if not current user. .SH "ENVIRONMENT" .IX Header "ENVIRONMENT" The environment variable \f(CW\*(C`PTDEBUG\*(C'\fR enables verbose debugging output to \s-1STDERR\s0. To enable debugging and capture all output to a file, run the tool like: .PP .Vb 1 \& PTDEBUG=1 pt\-upgrade ... > FILE 2>&1 .Ve .PP Be careful: debugging output is voluminous and can generate several megabytes of output. .SH "SYSTEM REQUIREMENTS" .IX Header "SYSTEM REQUIREMENTS" You need Perl, \s-1DBI\s0, DBD::mysql, and some core packages that ought to be installed in any reasonably new version of Perl. .SH "BUGS" .IX Header "BUGS" For a list of known bugs, see http://www.percona.com/bugs/pt\-upgrade . .PP Please report bugs at https://bugs.launchpad.net/percona\-toolkit . Include the following information in your bug report: .IP "\(bu" 4 Complete command-line used to run the tool .IP "\(bu" 4 Tool \*(L"\-\-version\*(R" .IP "\(bu" 4 MySQL version of all servers involved .IP "\(bu" 4 Output from the tool including \s-1STDERR\s0 .IP "\(bu" 4 Input files (log/dump/config files, etc.) .PP If possible, include debugging output by running the tool with \f(CW\*(C`PTDEBUG\*(C'\fR; see \*(L"\s-1ENVIRONMENT\s0\*(R". .SH "DOWNLOADING" .IX Header "DOWNLOADING" Visit http://www.percona.com/software/percona\-toolkit/ to download the latest release of Percona Toolkit. Or, get the latest release from the command line: .PP .Vb 1 \& wget percona.com/get/percona\-toolkit.tar.gz \& \& wget percona.com/get/percona\-toolkit.rpm \& \& wget percona.com/get/percona\-toolkit.deb .Ve .PP You can also get individual tools from the latest release: .PP .Vb 1 \& wget percona.com/get/TOOL .Ve .PP Replace \f(CW\*(C`TOOL\*(C'\fR with the name of any tool. .SH "AUTHORS" .IX Header "AUTHORS" Daniel Nichter .SH "ABOUT PERCONA TOOLKIT" .IX Header "ABOUT PERCONA TOOLKIT" This tool is part of Percona Toolkit, a collection of advanced command-line tools developed by Percona for MySQL support and consulting. Percona Toolkit was forked from two projects in June, 2011: Maatkit and Aspersa. Those projects were created by Baron Schwartz and developed primarily by him and Daniel Nichter, both of whom are employed by Percona. Visit for more software developed by Percona. .SH "COPYRIGHT, LICENSE, AND WARRANTY" .IX Header "COPYRIGHT, LICENSE, AND WARRANTY" This program is copyright 2009\-2012 Percona Inc. Feedback and improvements are welcome. .PP \&\s-1THIS\s0 \s-1PROGRAM\s0 \s-1IS\s0 \s-1PROVIDED\s0 \*(L"\s-1AS\s0 \s-1IS\s0\*(R" \s-1AND\s0 \s-1WITHOUT\s0 \s-1ANY\s0 \s-1EXPRESS\s0 \s-1OR\s0 \s-1IMPLIED\s0 \&\s-1WARRANTIES\s0, \s-1INCLUDING\s0, \s-1WITHOUT\s0 \s-1LIMITATION\s0, \s-1THE\s0 \s-1IMPLIED\s0 \s-1WARRANTIES\s0 \s-1OF\s0 \&\s-1MERCHANTABILITY\s0 \s-1AND\s0 \s-1FITNESS\s0 \s-1FOR\s0 A \s-1PARTICULAR\s0 \s-1PURPOSE\s0. .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, version 2; \s-1OR\s0 the Perl Artistic License. On \s-1UNIX\s0 and similar systems, you can issue `man perlgpl' or `man perlartistic' to read these licenses. .PP You should have received a copy of the \s-1GNU\s0 General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, \s-1MA\s0 02111\-1307 \s-1USA\s0. .SH "VERSION" .IX Header "VERSION" pt-upgrade 2.1.2