1MK-PROFILE-COMPACT(1) User Contributed Perl DocumentationMK-PROFILE-COMPACT(1)
2
3
4

NAME

6       mk-profile-compact - Compact the output from mk-query-profiler.
7

SYNOPSIS

9       Usage: mk-profile-compact [OPTION...] [FILE...]
10
11       mk-profile-compact aligns query profiler results side by side for easy
12       comparison.  With no FILE, or when FILE is -, read from standard input.
13
14       To view queries 2, 4 and 6 side by side:
15
16          mk-profile-compact --queries 2,4,6 profile-results.txt
17
18       To view summaries from two runs side by side:
19
20          mk-profile-compact --mode SUMMARY results-1.txt results-2.txt
21

RISKS

23       The following section is included to inform users about the potential
24       risks, whether known or unknown, of using this tool.  The two main
25       categories of risks are those created by the nature of the tool (e.g.
26       read-only tools vs. read-write tools) and those created by bugs.
27
28       mk-profile-compact is read-only and very low-risk.
29
30       At the time of this release, we know of no bugs that could cause
31       serious harm to users.
32
33       The authoritative source for updated information is always the online
34       issue tracking system.  Issues that affect this tool will be marked as
35       such.  You can see a list of such issues at the following URL:
36       <http://www.maatkit.org/bugs/mk-profile-compact>.
37
38       See also "BUGS" for more information on filing bugs and getting help.
39

DESCRIPTION

41       mk-profile-compact slices and aligns the output from mk-query-profiler
42       so you can compare profile results side by side easily.  It prints the
43       first profile result intact, but each subsequent result is trimmed to
44       be as narrow as possible, then aligned next to the first.
45
46       You can also use this to examine only some profile results.  For
47       example, if you have a set of queries to get a table into a known
48       state, and then a query you want to profile, you can ignore the setup
49       queries.  This is typically easy to do with a command-line option like
50       "--queries" 4,8,12,16,20 to view every 4th query.
51
52       If the first profile it sees is labeled QUERY X, it will only look at
53       QUERY profiles from then on.  The same holds for SUMMARY profiles.
54       This is because there are different numbers of lines in QUERY and
55       SUMMARY profiles.  You can specify which kind of profile result you
56       want to process.  See mk-query-profiler for the full list of types.
57

OPTIONS

59       This tool accepts additional command-line arguments.  Refer to the
60       "SYNOPSIS" and usage information for details.
61
62       --config
63           type: Array
64
65           Read this comma-separated list of config files; if specified, this
66           must be the first option on the command line.
67
68       --headers
69           type: int; default: 2000
70
71           Reprint headers every N queries.
72
73       --help
74           Show help and exit.
75
76       --mode
77           type: string
78
79           What type of reports (EXTERNAL, QUERY, SUMMARY) to process.
80
81       --queries
82           type: hash
83
84           Process only this comma-separated list of queries.
85
86       --version
87           Show version and exit.
88

DOWNLOADING

90       You can download Maatkit from Google Code at
91       <http://code.google.com/p/maatkit/>, or you can get any of the tools
92       easily with a command like the following:
93
94          wget http://www.maatkit.org/get/toolname
95          or
96          wget http://www.maatkit.org/trunk/toolname
97
98       Where "toolname" can be replaced with the name (or fragment of a name)
99       of any of the Maatkit tools.  Once downloaded, they're ready to run; no
100       installation is needed.  The first URL gets the latest released version
101       of the tool, and the second gets the latest trunk code from Subversion.
102

ENVIRONMENT

104       The environment variable "MKDEBUG" enables verbose debugging output in
105       all of the Maatkit tools:
106
107          MKDEBUG=1 mk-....
108

SYSTEM REQUIREMENTS

110       You need Perl and some core packages that ought to be installed in any
111       reasonably new version of Perl.
112

BUGS

114       For a list of known bugs see
115       <http://www.maatkit.org/bugs/mk-profile-compact>.
116
117       Please use Google Code Issues and Groups to report bugs or request
118       support: <http://code.google.com/p/maatkit/>.  You can also join
119       #maatkit on Freenode to discuss Maatkit.
120
121       Please include the complete command-line used to reproduce the problem
122       you are seeing, the version of all MySQL servers involved, the complete
123       output of the tool when run with "--version", and if possible,
124       debugging output produced by running with the "MKDEBUG=1" environment
125       variable.
126

COPYRIGHT, LICENSE AND WARRANTY

128       This program is copyright 2007-2011 Baron Schwartz.  Feedback and
129       improvements are welcome.
130
131       THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
132       WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
133       MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
134
135       This program is free software; you can redistribute it and/or modify it
136       under the terms of the GNU General Public License as published by the
137       Free Software Foundation, version 2; OR the Perl Artistic License.  On
138       UNIX and similar systems, you can issue `man perlgpl' or `man
139       perlartistic' to read these licenses.
140
141       You should have received a copy of the GNU General Public License along
142       with this program; if not, write to the Free Software Foundation, Inc.,
143       59 Temple Place, Suite 330, Boston, MA  02111-1307  USA.
144

SEE ALSO

146       See also mk-query-profiler.
147

AUTHOR

149       Baron Schwartz
150

ABOUT MAATKIT

152       This tool is part of Maatkit, a toolkit for power users of MySQL.
153       Maatkit was created by Baron Schwartz; Baron and Daniel Nichter are the
154       primary code contributors.  Both are employed by Percona.  Financial
155       support for Maatkit development is primarily provided by Percona and
156       its clients.
157

VERSION

159       This manual page documents Ver 1.1.22 Distrib 7540 $Revision: 7477 $.
160
161
162
163perl v5.30.1                      2020-01-29             MK-PROFILE-COMPACT(1)
Impressum