NAME

       pt-mext - Look at many samples of MySQL "SHOW GLOBAL STATUS" side-by-side.

SYNOPSIS

       Usage: pt-mext [OPTIONS] -- COMMAND

       pt-mext columnizes repeated output from a program like mysqladmin extended.

       Get output from "mysqladmin":

          pt-mext -r -- mysqladmin ext -i10 -c3

       Get output from a file:

          pt-mext -r -- cat mysqladmin-output.txt

RISKS

       Percona Toolkit is mature, proven in the real world, and well tested, but all database tools can pose a
       risk to the system and the database server.  Before using this tool, please:

       •   Read the tool's documentation

       •   Review the tool's known "BUGS"

       •   Test the tool on a non-production server

       •   Backup your production server and verify the backups

DESCRIPTION

       pt-mext  executes  the "COMMAND" you specify, and reads through the result one line at a time.  It places
       each line into a temporary file.  When it finds a blank line, it assumes that a new sample of SHOW GLOBAL
       STATUS is starting, and it creates a new temporary file.  At the end of this process, it has a number  of
       temporary  files.   It  joins  the  temporary  files  together  side-by-side  and  prints the result.  If
       "--relative" option is given, it first subtracts each sample  from  the  one  after  it  before  printing
       results.

OPTIONS

       --help
           Show help and exit.

       --relative
           short form: -r

           Subtract each column from the previous column.

       --version
           Show version and exit.

ENVIRONMENT

       This tool does not use any environment variables.

SYSTEM REQUIREMENTS

       This tool requires the Bourne shell (/bin/sh) and the seq program.

BUGS

       For a list of known bugs, see <http://www.percona.com/bugs/pt-mext>.

       Please  report bugs at <https://jira.percona.com/projects/PT>.  Include the following information in your
       bug report:

       •   Complete command-line used to run the tool

       •   Tool "--version"

       •   MySQL version of all servers involved

       •   Output from the tool including STDERR

       •   Input files (log/dump/config files, etc.)

       If possible, include debugging output by running the tool with "PTDEBUG"; see "ENVIRONMENT".

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:

          wget percona.com/get/percona-toolkit.tar.gz

          wget percona.com/get/percona-toolkit.rpm

          wget percona.com/get/percona-toolkit.deb

       You can also get individual tools from the latest release:

          wget percona.com/get/TOOL

       Replace "TOOL" with the name of any tool.

AUTHORS

       Baron Schwartz

ABOUT PERCONA TOOLKIT

       This  tool is part of Percona Toolkit, a collection of advanced command-line tools for MySQL developed by
       Percona.  Percona Toolkit was forked from two  projects  in  June,  2011:  Maatkit  and  Aspersa.   Those
       projects  were  created  by  Baron  Schwartz  and  primarily  developed by him and Daniel Nichter.  Visit
       <http://www.percona.com/software/> to learn about other free, open-source software from Percona.

COPYRIGHT, LICENSE, AND WARRANTY

       This program is copyright 2011-2018 Percona LLC and/or its affiliates, 2010 Baron Schwartz.

       THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT  ANY  EXPRESS  OR  IMPLIED  WARRANTIES,  INCLUDING,  WITHOUT
       LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.

       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, version  2;  OR  the  Perl  Artistic
       License.   On  UNIX  and similar systems, you can issue `man perlgpl' or `man perlartistic' to read these
       licenses.

       You should have received a copy of the GNU General Public License along with this program; if not,  write
       to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA.

VERSION

       pt-mext 3.2.1

perl v5.30.3                                       2020-08-30                                        PT-MEXT(1p)