PT-MEXT(1) User Contributed Perl Documentation PT-MEXT(1)

# [NAME](#NAME)

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

# [SYNOPSIS](#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](#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](#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](#OPTIONS)

[--help](#help)

Show help and exit.

[--relative](#relative)

short form: -r

Subtract each column from the previous column.

[--version](#version)

Show version and exit.

# [ENVIRONMENT](#ENVIRONMENT)

This tool does not use any environment variables.

# [SYSTEM REQUIREMENTS](#SYSTEM_REQUIREMENTS)

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

# [BUGS](#BUGS)

For a list of known bugs, see <https://jira.percona.com/projects/PT/issues>.

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".

# [ATTENTION](#ATTENTION)

Using <PTDEBUG> might expose passwords. When debug is enabled, all command line parameters are shown in the output.

# [DOWNLOADING](#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](#AUTHORS)

Baron Schwartz

# [ABOUT PERCONA TOOLKIT](#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](#COPYRIGHT,_LICENSE,_AND_WARRANTY)

This program is copyright 2011-2024 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](#VERSION)

pt-mext 3.7.1

2026-10-23 perl v5.44.0

---

Document: pt-mext(1p) from percona-toolkit 3.7.1-r7 (Chainguard OS)
Source: https://github.com/percona/percona-toolkit