DragonFly On-Line Manual Pages
PT-MEXT(1) User Contributed Perl Documentation PT-MEXT(1)
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:
o Read the tool's documentation
o Review the tool's known "BUGS"
o Test the tool on a non-production server
o 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://bugs.launchpad.net/percona-toolkit>.
Include the following information in your bug report:
o Complete command-line used to run the tool
o Tool "--version"
o MySQL version of all servers involved
o Output from the tool including STDERR
o 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-2015 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 2.2.14
perl v5.20.2 2015-04-10 PT-MEXT(1)