pt-mext1p
Look at many samples of mysql "show global status" side-by-side.
Usage
Usage: pt-mext
[OPTIONS]
--
COMMAND
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 |
Overview
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.
Attention
Using <PTDEBUG> might expose passwords. When debug is enabled, all command line parameters are shown in the output.
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.gzwget percona.com/get/percona-toolkit.rpmwget 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.
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-2026 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, version 2 along with this program; if not, see <https://www.gnu.org/licenses/>.
Version
pt-mext 3.7.1-4
Releases
8 releases since Debian 7 (Wheezy); the text changed 5 times.
--help since Debian 8 (Jessie);
--relative since Debian 8 (Jessie);
--version since Debian 8 (Jessie).
-r until Debian 7 (Wheezy).