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 To view queries 2, 4 and 6 side by side:
10 mk-profile-compact --queries 2,4,6 profile-results.txt
12 To view summaries from two runs side by side:
14 mk-profile-compact --mode SUMMARY results-1.txt results-2.txt
16
18 The following section is included to inform users about the potential
19 risks, whether known or unknown, of using this tool. The two main
20 categories of risks are those created by the nature of the tool (e.g.
21 read-only tools vs. read-write tools) and those created by bugs.
22 mk-profile-compact is read-only and very low-risk.
24 At the time of this release, we know of no bugs that could cause
26 serious harm to users.
27 The authoritative source for updated information is always the online
29 issue tracking system. Issues that affect this tool will be marked as
30 such. You can see a list of such issues at the following URL:
31 http://www.maatkit.org/bugs/mk-profile-compact
32 <http://www.maatkit.org/bugs/mk-profile-compact>.
33 See also "BUGS" for more information on filing bugs and getting help.
35
37 mk-profile-compact slices and aligns the output from mk-query-profiler
38 so you can compare profile results side by side easily. It prints the
39 first profile result intact, but each subsequent result is trimmed to
40 be as narrow as possible, then aligned next to the first.
41 You can also use this to examine only some profile results. For
43 example, if you have a set of queries to get a table into a known
44 state, and then a query you want to profile, you can ignore the setup
45 queries. This is typically easy to do with a command-line option like
46 "--queries" 4,8,12,16,20 to view every 4th query.
47 If the first profile it sees is labeled QUERY X, it will only look at
49 QUERY profiles from then on. The same holds for SUMMARY profiles.
50 This is because there are different numbers of lines in QUERY and
51 SUMMARY profiles. You can specify which kind of profile result you
52 want to process. See mk-query-profiler for the full list of types.
53
55 --config
56 type: Array
57 Read this comma-separated list of config files; if specified, this
59 must be the first option on the command line.
60 --headers
62 type: int; default: 2000
63 Reprint headers every N queries.
65 --help
67 Show help and exit.
68 --mode
70 type: string
71 What type of reports (EXTERNAL, QUERY, SUMMARY) to process.
73 --queries
75 type: hash
76 Process only this comma-separated list of queries.
78 --version
80 Show version and exit.
81
83 You can download Maatkit from Google Code at
84 <http://code.google.com/p/maatkit/>, or you can get any of the tools
85 easily with a command like the following:
86 wget http://www.maatkit.org/get/toolname
88 or
89 wget http://www.maatkit.org/trunk/toolname
90 Where "toolname" can be replaced with the name (or fragment of a name)
92 of any of the Maatkit tools. Once downloaded, they're ready to run; no
93 installation is needed. The first URL gets the latest released version
94 of the tool, and the second gets the latest trunk code from Subversion.
95
97 The environment variable "MKDEBUG" enables verbose debugging output in
98 all of the Maatkit tools:
99 MKDEBUG=1 mk-....
101
103 You need Perl and some core packages that ought to be installed in any
104 reasonably new version of Perl.
105
107 For list of known bugs see
108 http://www.maatkit.org/bugs/mk-profile-compact
109 <http://www.maatkit.org/bugs/mk-profile-compact>.
110 Please use Google Code Issues and Groups to report bugs or request
112 support: <http://code.google.com/p/maatkit/>. You can also join
113 #maatkit on Freenode to discuss Maatkit.
114 Please include the complete command-line used to reproduce the problem
116 you are seeing, the version of all MySQL servers involved, the complete
117 output of the tool when run with "--version", and if possible,
118 debugging output produced by running with the "MKDEBUG=1" environment
119 variable.
120
122 This program is copyright 2007-2010 Baron Schwartz. Feedback and
123 improvements are welcome.
124 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
126 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
127 MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
128 This program is free software; you can redistribute it and/or modify it
130 under the terms of the GNU General Public License as published by the
131 Free Software Foundation, version 2; OR the Perl Artistic License. On
132 UNIX and similar systems, you can issue `man perlgpl' or `man
133 perlartistic' to read these licenses.
134 You should have received a copy of the GNU General Public License along
136 with this program; if not, write to the Free Software Foundation, Inc.,
137 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
138
140 See also mk-query-profiler.
141
143 Baron Schwartz
144
146 This tool is part of Maatkit, a toolkit for power users of MySQL.
147 Maatkit was created by Baron Schwartz; Baron and Daniel Nichter are the
148 primary code contributors. Both are employed by Percona. Financial
149 support for Maatkit development is primarily provided by Percona and
150 its clients.
151
153 This manual page documents Ver 1.1.22 Distrib 6839 $Revision: 6831 $.
154perl v5.12.1 2010-08-01 MK-PROFILE-COMPACT(1)