--- name: "pt-mext" section: "1p" platform: "linux" package: "percona-toolkit" version: "3.7.1_4-1" release: "Arch Linux 2026-11-01" platforms: ["linux"] url: "https://new.carta.tech/pt-mext" --- # pt-mext(1p) Look at many samples of MySQL "SHOW GLOBAL STATUS" side-by-side. ## 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 \. Please report bugs at \. 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 Using \ might expose passwords. When debug is enabled, all command line parameters are shown in the output. ## DOWNLOADING Visit \ 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 \ 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 \. ## VERSION pt-mext 3.7.1-4