Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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://jira.percona.com/projects/PT>.  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-2018 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 3.2.0

perl v5.32.0			  2020-04-23			    PT-MEXT(1)

NAME | SYNOPSIS | RISKS | DESCRIPTION | OPTIONS | ENVIRONMENT | SYSTEM REQUIREMENTS | BUGS | DOWNLOADING | AUTHORS | ABOUT PERCONA TOOLKIT | COPYRIGHT, LICENSE, AND WARRANTY | VERSION

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=pt-mext&sektion=1&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help