1MK-PROFILE-COMPACT(1) User Contributed Perl DocumentationMK-PROFILE-COMPACT(1)
2
6 mk-profile-compact - Compact the output from mk-query-profiler.
7
9 Usage: mk-profile-compact [OPTION...] [FILE...]
10 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 To view queries 2, 4 and 6 side by side:
15 mk-profile-compact --queries 2,4,6 profile-results.txt
17 To view summaries from two runs side by side:
19 mk-profile-compact --mode SUMMARY results-1.txt results-2.txt
21
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 mk-profile-compact is read-only and very low-risk.
29 At the time of this release, we know of no bugs that could cause
31 serious harm to users.
32 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 See also "BUGS" for more information on filing bugs and getting help.
39
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 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 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
59 This tool accepts additional command-line arguments. Refer to the
60 "SYNOPSIS" and usage information for details.
61 --config
63 type: Array
64 Read this comma-separated list of config files; if specified, this
66 must be the first option on the command line.
67 --headers
69 type: int; default: 2000
70 Reprint headers every N queries.
72 --help
74 Show help and exit.
75 --mode
77 type: string
78 What type of reports (EXTERNAL, QUERY, SUMMARY) to process.
80 --queries
82 type: hash
83 Process only this comma-separated list of queries.
85 --version
87 Show version and exit.
88
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 wget http://www.maatkit.org/get/toolname
95 or
96 wget http://www.maatkit.org/trunk/toolname
97 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
104 The environment variable "MKDEBUG" enables verbose debugging output in
105 all of the Maatkit tools:
106 MKDEBUG=1 mk-....
108
110 You need Perl and some core packages that ought to be installed in any
111 reasonably new version of Perl.
112
114 For a list of known bugs see
115 <http://www.maatkit.org/bugs/mk-profile-compact>.
116 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 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
128 This program is copyright 2007-2011 Baron Schwartz. Feedback and
129 improvements are welcome.
130 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 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 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
146 See also mk-query-profiler.
147
149 Baron Schwartz
150
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
159 This manual page documents Ver 1.1.22 Distrib 7540 $Revision: 7477 $.
160perl v5.30.1 2020-01-29 MK-PROFILE-COMPACT(1)