PT-MEXT(1)

📦
version 3.7.1_4 · 5 versions
, in arch rolling

✨ pt-mext(1) — like, the whole manual bestie 💅

Okay so real talk: pt-mext lives in the User Contributed Perl Documentation section, and it's here to look at many samples of MySQL "SHOW GLOBAL STATUS" side-by-side. That's the whole vibe. 🫶

🌸 NAME 🌸

pt-mext — Look at many samples of MySQL "SHOW GLOBAL STATUS" side-by-side. No cap, that's literally it.

🎀 SYNOPSIS 🎀

Usage: pt-mext [OPTIONS] -- COMMAND

So pt-mext columnizes repeated output from a program like mysqladmin extended. Iconic behavior honestly.

Wanna get output from mysqladmin? Bet:

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

Wanna get output from a file instead? Also slay:

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

💀 RISKS 💀

Okay bestie, listen. 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. So before you use this tool, please, for the love of everything:

  • 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
Like, actually do all four. Not me watching you skip straight to the last one. 🙈

🦋 DESCRIPTION 🦋

So here's what's happening under the hood, and it's honestly so clever. 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. Then it joins the temporary files together side-by-side and prints the result. The way that it just… does that. Obsessed. ✨

And if the --relative option is given, it first subtracts each sample from the one after it before printing results. Math queen behavior. 💅

💖 OPTIONS 💖

  • --help — Show help and exit. Short and sweet, we love a supportive flag.
  • --relative — short form: -r. Subtract each column from the previous column. It's giving delta energy.
  • --version — Show version and exit. Pop off, version info.

🌈 ENVIRONMENT 🌈

This tool does not use any environment variables. Nothing. Zero. Nada. A clean slate, a blank canvas, main character energy. 🧚

⭐ SYSTEM REQUIREMENTS ⭐

This tool requires the Bourne shell (/bin/sh) and the seq program. That's the whole guest list.

🍓 BUGS 🍓

For a list of known bugs, see <https://jira.percona.com/projects/PT/issues>. Go look, it's right there, iykyk.

Please report bugs at <https://jira.percona.com/projects/PT>. And when you do, include the following information in your bug report, because otherwise the maintainers are just gonna be like ???

  • 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". (Which, yes, is the section that says this tool does not use any environment variables. We don't make the rules, we just vibe with them. 😭)

🔥 ATTENTION 🔥

Using <PTDEBUG> might expose passwords. When debug is enabled, all command line parameters are shown in the output. So like, be careful with that one, fr fr. 💀

👑 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

Just replace TOOL with the name of any tool. Mix and match, it's your world. 🎀

🧚 AUTHORS 🧚

Baron Schwartz. The legend, the icon, the moment.

💜 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. So much free software, so little time. 🙏

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

That warranty bit is in all caps in the original for a reason, bestie — it means it, so don't come crying to anyone when it does exactly what it says.

⭐ VERSION ⭐

pt-mext 3.7.1-4

And that's the whole page! 💖 Little sign-off for the footer girlies: this one came outta perl v5.42.2, dated 2026-09-01, and it's filed under PT-MEXT(1). Take care of her, she's iconic. 🎀✨

📦 where this page comes from