Percona Toolkit moved to https://jira.percona.com/projects/PT

Merge lp:~percona-toolkit-dev/percona-toolkit/pxc-pt-mysql-summary into lp:percona-toolkit/2.1

  1. pxc-pt-mysql-summary
  2. Merge into 2.1
Proposed by Daniel Nichter
Status: Merged
Approved by: Daniel Nichter
Approved revision: 475
Merged at revision: 479
Proposed branch: lp:~percona-toolkit-dev/percona-toolkit/pxc-pt-mysql-summary
Merge into: lp:percona-toolkit/2.1
Diff against target: 6394 lines (+5974/-24)
39 files modified
bin/pt-mysql-summary (+76/-10)
lib/bash/collect_mysql_info.sh (+1/-1)
lib/bash/parse_options.sh (+1/-1)
lib/bash/report_mysql_info.sh (+83/-8)
t/lib/bash/report_mysql_info.sh (+54/-1)
t/pt-mysql-summary/pt-mysql-summary.t (+16/-3)
t/pt-mysql-summary/samples/expected_output_temp002.txt (+1/-0)
t/pt-mysql-summary/samples/expected_output_temp003.txt (+1/-0)
t/pt-mysql-summary/samples/expected_output_temp004.txt (+1/-0)
t/pt-mysql-summary/samples/expected_output_temp005.txt (+1/-0)
t/pt-mysql-summary/samples/expected_output_temp006.txt (+341/-0)
t/pt-mysql-summary/samples/expected_output_temp007.txt (+295/-0)
t/pt-mysql-summary/samples/expected_result_report_summary.txt (+1/-0)
t/pt-mysql-summary/samples/ps-mysqld-006.txt (+4/-0)
t/pt-mysql-summary/samples/temp006/innodb-status (+119/-0)
t/pt-mysql-summary/samples/temp006/mysql-databases (+5/-0)
t/pt-mysql-summary/samples/temp006/mysql-master-logs (+1/-0)
t/pt-mysql-summary/samples/temp006/mysql-master-status (+1/-0)
t/pt-mysql-summary/samples/temp006/mysql-plugins (+41/-0)
t/pt-mysql-summary/samples/temp006/mysql-processlist (+48/-0)
t/pt-mysql-summary/samples/temp006/mysql-status (+410/-0)
t/pt-mysql-summary/samples/temp006/mysql-status-defer (+410/-0)
t/pt-mysql-summary/samples/temp006/mysql-users (+1/-0)
t/pt-mysql-summary/samples/temp006/mysql-variables (+422/-0)
t/pt-mysql-summary/samples/temp006/mysqld-instances (+4/-0)
t/pt-mysql-summary/samples/temp006/mysqldump (+1128/-0)
t/pt-mysql-summary/samples/temp007/innodb-status (+118/-0)
t/pt-mysql-summary/samples/temp007/mysql-databases (+5/-0)
t/pt-mysql-summary/samples/temp007/mysql-master-logs (+1/-0)
t/pt-mysql-summary/samples/temp007/mysql-master-status (+1/-0)
t/pt-mysql-summary/samples/temp007/mysql-plugins (+41/-0)
t/pt-mysql-summary/samples/temp007/mysql-processlist (+24/-0)
t/pt-mysql-summary/samples/temp007/mysql-status (+380/-0)
t/pt-mysql-summary/samples/temp007/mysql-status-defer (+380/-0)
t/pt-mysql-summary/samples/temp007/mysql-users (+1/-0)
t/pt-mysql-summary/samples/temp007/mysql-variables (+423/-0)
t/pt-mysql-summary/samples/temp007/mysqld-executables (+1/-0)
t/pt-mysql-summary/samples/temp007/mysqld-instances (+4/-0)
t/pt-mysql-summary/samples/temp007/mysqldump (+1129/-0)
To merge this branch: bzr merge lp:~percona-toolkit-dev/percona-toolkit/pxc-pt-mysql-summary
Reviewer Review Type Date Requested Status
Daniel Nichter Approve
Brian Fraser (community) Approve
Review via email: mp+136806@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

112 - for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^ .*[0-9]/{print $1}' ); do
113 + for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^.*[0-9]/{print $1}' ); do

Isn't that changing the meaning of the regex? The original was "a space plus any characters", now it's just "any characters".

not ok 9 - --read-samples works for t/pt-mysql-summary/temp007
# Failed test '--read-samples works for t/pt-mysql-summary/temp007'
# at pt-mysql-summary.t line 67.
# 51,52c51,52
# < Bytes_received 3e+09 35000 200
# < Bytes_sent 3e+09 35000 2250
# ---
# > Bytes_received 3000000000 35000 200
# > Bytes_sent 3000000000 35000 2250

Need to coerce away the e notation.

review: Needs Fixing
Revision history for this message
Brian Fraser (fraserbn) wrote :

> 112 - for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^
> .*[0-9]/{print $1}' ); do
> 113 + for pid in $( grep '/mysqld' "$mysqld_instances" | awk
> '/^.*[0-9]/{print $1}' ); do
>
> Isn't that changing the meaning of the regex? The original was "a space plus
> any characters", now it's just "any characters".
>

Yes, that's intended. The regex is just there to skip the header, but breaks on ubuntu; see t/pt-mysql-summary/samples/temp006/mysqld-instances

>
> not ok 9 - --read-samples works for t/pt-mysql-summary/temp007
> # Failed test '--read-samples works for t/pt-mysql-summary/temp007'
> # at pt-mysql-summary.t line 67.
> # 51,52c51,52
> # < Bytes_received 3e+09 35000 200
> # < Bytes_sent 3e+09 35000 2250
> # ---
> # > Bytes_received 3000000000 35000 200
> # > Bytes_sent 3000000000 35000 2250
>
> Need to coerce away the e notation.

On it.

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

Looks good so far. I propose rearranging some of the lines in the PXC section, to group related lines:

# Percona XtraDB Cluster #####################################
             Cluster Name | pt_sandbox_cluster
          Cluster Address | gcomm://
             Cluster Size | 3
            Cluster Nodes | 10.0.2.15,10.0.2.15,10.0.2.15
                Node Name | 12345
              Node Status | Primary
               SST Method | rsync
            Slave Threads | 2
       Ignore Split Brain | false
            Ignore Quorum | false
              gcache Size | 128M
         gcache Directory | /tmp/12345/data/
              gcache Name | /tmp/12345/data//galera.cache

Revision history for this message
Brian Fraser (fraserbn) wrote :

Yeah, that looks a lot better. Done, and Jay replied about leaving out wsrep_provider_version, so I think that this branch is ready for merging.

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

+ name_val "Cluster" "$(get_var "wsrep_cluster_name" "$mysql_var")"

+ name_val "Node" "$(get_var "wsrep_node_name" "$mysql_var")"

I think those should be "Cluster Name" and "Node Name" respectively, to match their variable names, and because just "Cluster" is ambiguous--cluster what? address? size? nodes? name?

Revision history for this message
Brian Fraser (fraserbn) wrote :

Whoops, I thought that I did that. Changed.

Revision history for this message
Brian Fraser (fraserbn) :
review: Approve
Revision history for this message
Daniel Nichter (daniel-nichter) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'bin/pt-mysql-summary'
2--- bin/pt-mysql-summary 2012-11-19 18:47:13 +0000
3+++ bin/pt-mysql-summary 2012-12-04 16:32:31 +0000
4@@ -71,7 +71,7 @@
5 usage() {
6 local file="$1"
7
8- local usage=$(grep '^Usage: ' "$file")
9+ local usage="$(grep '^Usage: ' "$file")"
10 echo $usage
11 echo
12 echo "For more information, 'man $TOOL' or 'perldoc $file'."
13@@ -921,7 +921,7 @@
14 collect_mysqld_executables () {
15 local mysqld_instances="$1"
16
17- for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^ .*[0-9]/{print $1}' ); do
18+ for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^.*[0-9]/{print $1}' ); do
19 ps -o cmd -p $pid | sed -e 's/^\(.*mysqld\) .*/\1/' | grep -v '^CMD$'
20 done | sort -u
21 }
22@@ -1061,9 +1061,10 @@
23 local file="$1"
24 local variables_file="$2"
25
26- local socket=${socket:-""}
27- local port=${port:-""}
28- local datadir="${datadir:-""}"
29+ local socket=""
30+ local port=""
31+ local datadir=""
32+ local defaults_file=""
33
34 [ -e "$file" ] || return
35
36@@ -1082,7 +1083,17 @@
37 if echo "${word}" | grep -- "--datadir=" > /dev/null; then
38 datadir="$(echo "${word}" | cut -d= -f2)"
39 fi
40+ if echo "${word}" | grep -- "--defaults-file=" > /dev/null; then
41+ defaults_file="$(echo "${word}" | cut -d= -f2)"
42+ fi
43 done
44+
45+ if [ -n "${defaults_file:-""}" -a -r "${defaults_file:-""}" ]; then
46+ socket="${socket:-"$(grep "^socket\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
47+ port="${port:-"$(grep "^port\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
48+ datadir="${datadir:-"$(grep "^datadir\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
49+ fi
50+
51 local nice="$(get_var "internal::nice_of_$pid" "$variables_file")"
52 local oom="$(get_var "internal::oom_of_$pid" "$variables_file")"
53 if [ -n "${_NO_FALSE_NEGATIVES}" ]; then
54@@ -1090,6 +1101,11 @@
55 oom="?"
56 fi
57 printf " %5s %-26s %-4s %-3s %s\n" "${port}" "${datadir}" "${nice:-"?"}" "${oom:-"?"}" "${socket}"
58+
59+ defaults_file=""
60+ socket=""
61+ port=""
62+ datadir=""
63 done
64 }
65
66@@ -1155,8 +1171,7 @@
67 utime2 = ${utime2};
68 udays = utime1 / 86400;
69 udiff = utime2 - utime1;
70- format=\"%-35s %11s %11s %11s\\n\";
71- printf(format, \"Variable\", \"Per day\", \"Per second\", udiff \" secs\");
72+ printf(\"%-35s %11s %11s %11s\\n\", \"Variable\", \"Per day\", \"Per second\", udiff \" secs\");
73 }
74 \$2 ~ /^[0-9]*\$/ {
75 if ( \$2 > 0 && \$2 < 18446744073709551615 ) {
76@@ -1179,9 +1194,13 @@
77 persec = int(persec);
78 nowsec = int(nowsec);
79 if ( perday + persec + nowsec > 0 ) {
80- if ( perday == 0 ) { perday = \"\"; }
81- if ( persec == 0 ) { persec = \"\"; }
82- if ( nowsec == 0 ) { nowsec = \"\"; }
83+ perday_format=\"%11.f\";
84+ persec_format=\"%11.f\";
85+ nowsec_format=\"%11.f\";
86+ if ( perday == 0 ) { perday = \"\"; perday_format=\"%11s\"; }
87+ if ( persec == 0 ) { persec = \"\"; persec_format=\"%11s\"; }
88+ if ( nowsec == 0 ) { nowsec = \"\"; nowsec_format=\"%11s\"; }
89+ format=\"%-35s \" perday_format \" \" persec_format \" \" nowsec_format \"\\n\";
90 printf(format, \$1, perday, persec, nowsec);
91 }
92 }
93@@ -1978,6 +1997,42 @@
94 done
95 }
96
97+section_percona_xtradb_cluster () {
98+ local mysql_var="$1"
99+ local mysql_status="$2"
100+
101+ name_val "Cluster Name" "$(get_var "wsrep_cluster_name" "$mysql_var")"
102+ name_val "Cluster Address" "$(get_var "wsrep_cluster_address" "$mysql_var")"
103+ name_val "Cluster Size" "$(get_var "wsrep_cluster_size" "$mysql_status")"
104+ name_val "Cluster Nodes" "$(get_var "wsrep_incoming_addresses" "$mysql_status")"
105+
106+ name_val "Node Name" "$(get_var "wsrep_node_name" "$mysql_var")"
107+ name_val "Node Status" "$(get_var "wsrep_cluster_status" "$mysql_status")"
108+
109+ name_val "SST Method" "$(get_var "wsrep_sst_method" "$mysql_var")"
110+ name_val "Slave Threads" "$(get_var "wsrep_slave_threads" "$mysql_var")"
111+
112+ name_val "Ignore Split Brain" "$( parse_wsrep_provider_options "pc.ignore_sb" "$mysql_var" )"
113+ name_val "Ignore Quorum" "$( parse_wsrep_provider_options "pc.ignore_quorum" "$mysql_var" )"
114+
115+ name_val "gcache Size" "$( parse_wsrep_provider_options "gcache.size" "$mysql_var" )"
116+ name_val "gcache Directory" "$( parse_wsrep_provider_options "gcache.dir" "$mysql_var" )"
117+ name_val "gcache Name" "$( parse_wsrep_provider_options "gcache.name" "$mysql_var" )"
118+}
119+
120+parse_wsrep_provider_options () {
121+ local looking_for="$1"
122+ local mysql_var_file="$2"
123+
124+ grep wsrep_provider_options "$mysql_var_file" \
125+ | perl -Mstrict -le '
126+ my $provider_opts = scalar(<STDIN>);
127+ my $looking_for = $ARGV[0];
128+ my %opts = $provider_opts =~ /(\S+)\s*=\s*(\S*)(?:;|$)/g;
129+ print $opts{$looking_for};
130+ ' "$looking_for"
131+}
132+
133 report_mysql_summary () {
134 local dir="$1"
135
136@@ -2044,6 +2099,17 @@
137 section "Key Percona Server features"
138 section_percona_server_features "$dir/mysql-variables"
139
140+ section "Percona XtraDB Cluster"
141+ local has_wsrep="$(get_var "wsrep_on" "$dir/mysql-variables")"
142+ if [ -n "${has_wsrep:-""}" ]; then
143+ local wsrep_on="$(feat_on "$dir/mysql-variables" "wsrep_on")"
144+ if [ "${wsrep_on:-""}" = "Enabled" ]; then
145+ section_percona_xtradb_cluster "$dir/mysql-variables" "$dir/mysql-status"
146+ else
147+ name_val "wsrep_on" "OFF"
148+ fi
149+ fi
150+
151 section "Plugins"
152 name_val "InnoDB compression" "$(get_plugin_status "$dir/mysql-plugins" "INNODB_CMP")"
153
154
155=== modified file 'lib/bash/collect_mysql_info.sh'
156--- lib/bash/collect_mysql_info.sh 2012-10-24 18:43:26 +0000
157+++ lib/bash/collect_mysql_info.sh 2012-12-04 16:32:31 +0000
158@@ -201,7 +201,7 @@
159 collect_mysqld_executables () {
160 local mysqld_instances="$1"
161
162- for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^ .*[0-9]/{print $1}' ); do
163+ for pid in $( grep '/mysqld' "$mysqld_instances" | awk '/^.*[0-9]/{print $1}' ); do
164 ps -o cmd -p $pid | sed -e 's/^\(.*mysqld\) .*/\1/' | grep -v '^CMD$'
165 done | sort -u
166 }
167
168=== modified file 'lib/bash/parse_options.sh'
169--- lib/bash/parse_options.sh 2012-08-29 01:05:33 +0000
170+++ lib/bash/parse_options.sh 2012-12-04 16:32:31 +0000
171@@ -68,7 +68,7 @@
172 usage() {
173 local file="$1"
174
175- local usage=$(grep '^Usage: ' "$file")
176+ local usage="$(grep '^Usage: ' "$file")"
177 echo $usage
178 echo
179 echo "For more information, 'man $TOOL' or 'perldoc $file'."
180
181=== modified file 'lib/bash/report_mysql_info.sh'
182--- lib/bash/report_mysql_info.sh 2012-08-24 23:18:36 +0000
183+++ lib/bash/report_mysql_info.sh 2012-12-04 16:32:31 +0000
184@@ -104,9 +104,10 @@
185 local file="$1"
186 local variables_file="$2"
187
188- local socket=${socket:-""}
189- local port=${port:-""}
190- local datadir="${datadir:-""}"
191+ local socket=""
192+ local port=""
193+ local datadir=""
194+ local defaults_file=""
195
196 [ -e "$file" ] || return
197
198@@ -127,7 +128,17 @@
199 if echo "${word}" | grep -- "--datadir=" > /dev/null; then
200 datadir="$(echo "${word}" | cut -d= -f2)"
201 fi
202+ if echo "${word}" | grep -- "--defaults-file=" > /dev/null; then
203+ defaults_file="$(echo "${word}" | cut -d= -f2)"
204+ fi
205 done
206+
207+ if [ -n "${defaults_file:-""}" -a -r "${defaults_file:-""}" ]; then
208+ socket="${socket:-"$(grep "^socket\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
209+ port="${port:-"$(grep "^port\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
210+ datadir="${datadir:-"$(grep "^datadir\>" "$defaults_file" | tail -n1 | cut -d= -f2 | sed 's/^[ \t]*//;s/[ \t]*$//')"}"
211+ fi
212+
213 local nice="$(get_var "internal::nice_of_$pid" "$variables_file")"
214 local oom="$(get_var "internal::oom_of_$pid" "$variables_file")"
215 # Only used during testing
216@@ -136,6 +147,12 @@
217 oom="?"
218 fi
219 printf " %5s %-26s %-4s %-3s %s\n" "${port}" "${datadir}" "${nice:-"?"}" "${oom:-"?"}" "${socket}"
220+
221+ # Need to unset all of them in case the next process uses --defaults-file
222+ defaults_file=""
223+ socket=""
224+ port=""
225+ datadir=""
226 done
227 }
228
229@@ -211,8 +228,7 @@
230 utime2 = ${utime2};
231 udays = utime1 / 86400;
232 udiff = utime2 - utime1;
233- format=\"%-35s %11s %11s %11s\\n\";
234- printf(format, \"Variable\", \"Per day\", \"Per second\", udiff \" secs\");
235+ printf(\"%-35s %11s %11s %11s\\n\", \"Variable\", \"Per day\", \"Per second\", udiff \" secs\");
236 }
237 \$2 ~ /^[0-9]*\$/ {
238 if ( \$2 > 0 && \$2 < 18446744073709551615 ) {
239@@ -235,9 +251,18 @@
240 persec = int(persec);
241 nowsec = int(nowsec);
242 if ( perday + persec + nowsec > 0 ) {
243- if ( perday == 0 ) { perday = \"\"; }
244- if ( persec == 0 ) { persec = \"\"; }
245- if ( nowsec == 0 ) { nowsec = \"\"; }
246+ # We do the format in this roundabout way because we want two clashing
247+ # behaviors: If something is zero, just print the space padding,
248+ # however, if it's any other number, we want that. Problem: %s alone
249+ # might use scientific notation, and we can't use %11.f for both cases
250+ # as it would turn the empty string into a zero. So use both.
251+ perday_format=\"%11.f\";
252+ persec_format=\"%11.f\";
253+ nowsec_format=\"%11.f\";
254+ if ( perday == 0 ) { perday = \"\"; perday_format=\"%11s\"; }
255+ if ( persec == 0 ) { persec = \"\"; persec_format=\"%11s\"; }
256+ if ( nowsec == 0 ) { nowsec = \"\"; nowsec_format=\"%11s\"; }
257+ format=\"%-35s \" perday_format \" \" persec_format \" \" nowsec_format \"\\n\";
258 printf(format, \$1, perday, persec, nowsec);
259 }
260 }
261@@ -1074,6 +1099,42 @@
262 done
263 }
264
265+section_percona_xtradb_cluster () {
266+ local mysql_var="$1"
267+ local mysql_status="$2"
268+
269+ name_val "Cluster Name" "$(get_var "wsrep_cluster_name" "$mysql_var")"
270+ name_val "Cluster Address" "$(get_var "wsrep_cluster_address" "$mysql_var")"
271+ name_val "Cluster Size" "$(get_var "wsrep_cluster_size" "$mysql_status")"
272+ name_val "Cluster Nodes" "$(get_var "wsrep_incoming_addresses" "$mysql_status")"
273+
274+ name_val "Node Name" "$(get_var "wsrep_node_name" "$mysql_var")"
275+ name_val "Node Status" "$(get_var "wsrep_cluster_status" "$mysql_status")"
276+
277+ name_val "SST Method" "$(get_var "wsrep_sst_method" "$mysql_var")"
278+ name_val "Slave Threads" "$(get_var "wsrep_slave_threads" "$mysql_var")"
279+
280+ name_val "Ignore Split Brain" "$( parse_wsrep_provider_options "pc.ignore_sb" "$mysql_var" )"
281+ name_val "Ignore Quorum" "$( parse_wsrep_provider_options "pc.ignore_quorum" "$mysql_var" )"
282+
283+ name_val "gcache Size" "$( parse_wsrep_provider_options "gcache.size" "$mysql_var" )"
284+ name_val "gcache Directory" "$( parse_wsrep_provider_options "gcache.dir" "$mysql_var" )"
285+ name_val "gcache Name" "$( parse_wsrep_provider_options "gcache.name" "$mysql_var" )"
286+}
287+
288+parse_wsrep_provider_options () {
289+ local looking_for="$1"
290+ local mysql_var_file="$2"
291+
292+ grep wsrep_provider_options "$mysql_var_file" \
293+ | perl -Mstrict -le '
294+ my $provider_opts = scalar(<STDIN>);
295+ my $looking_for = $ARGV[0];
296+ my %opts = $provider_opts =~ /(\S+)\s*=\s*(\S*)(?:;|$)/g;
297+ print $opts{$looking_for};
298+ ' "$looking_for"
299+}
300+
301 report_mysql_summary () {
302 local dir="$1"
303
304@@ -1164,6 +1225,20 @@
305 section_percona_server_features "$dir/mysql-variables"
306
307 # ########################################################################
308+ # Percona XtraDB Cluster data
309+ # ########################################################################
310+ section "Percona XtraDB Cluster"
311+ local has_wsrep="$(get_var "wsrep_on" "$dir/mysql-variables")"
312+ if [ -n "${has_wsrep:-""}" ]; then
313+ local wsrep_on="$(feat_on "$dir/mysql-variables" "wsrep_on")"
314+ if [ "${wsrep_on:-""}" = "Enabled" ]; then
315+ section_percona_xtradb_cluster "$dir/mysql-variables" "$dir/mysql-status"
316+ else
317+ name_val "wsrep_on" "OFF"
318+ fi
319+ fi
320+
321+ # ########################################################################
322 # Plugins
323 # ########################################################################
324 # TODO: what would be good is to show nonstandard plugins here.
325
326=== modified file 't/lib/bash/report_mysql_info.sh'
327--- t/lib/bash/report_mysql_info.sh 2012-10-24 19:36:32 +0000
328+++ t/lib/bash/report_mysql_info.sh 2012-12-04 16:32:31 +0000
329@@ -1,6 +1,6 @@
330 #!/usr/bin/env bash
331
332-plan 33
333+plan 41
334
335 . "$LIB_DIR/alt_cmds.sh"
336 . "$LIB_DIR/log_warn_die.sh"
337@@ -307,6 +307,16 @@
338 parse_mysqld_instances "$PT_TMPDIR/in" "$PT_TMPDIR/empty" > "$PT_TMPDIR/got"
339 no_diff "$PT_TMPDIR/got" "$PT_TMPDIR/expected" "parse_mysqld_instances"
340
341+cat <<EOF > "$PT_TMPDIR/expected"
342+ Port Data Directory Nice OOM Socket
343+ ===== ========================== ==== === ======
344+ 12345 /tmp/12345/data ? ? /tmp/12345/mysql_sandbox12345.sock
345+ 12346 /tmp/12346/data ? ? /tmp/12346/mysql_sandbox12346.sock
346+ 12347 /tmp/12347/data ? ? /tmp/12347/mysql_sandbox12347.sock
347+EOF
348+parse_mysqld_instances "$samples/ps-mysqld-006.txt" "$PT_TMPDIR/empty" > "$PT_TMPDIR/got"
349+no_diff "$PT_TMPDIR/got" "$PT_TMPDIR/expected" "ps-mysqld-006.txt (uses --defaults-file)"
350+
351 # ###########################################################################
352 # get_mysql_*
353 # ###########################################################################
354@@ -729,6 +739,49 @@
355 "$samples/expected_output_temp004.txt" \
356 "report_mysql_summary, dir: temp004"
357
358+report_mysql_summary "$samples/temp006" 2>/dev/null | tail -n+3 > "$PT_TMPDIR/got"
359+no_diff \
360+ "$PT_TMPDIR/got" \
361+ "$samples/expected_output_temp006.txt" \
362+ "report_mysql_summary, dir: temp006 (PXC, cluster node)"
363+
364+report_mysql_summary "$samples/temp007" 2>/dev/null | tail -n+3 > "$PT_TMPDIR/got"
365+no_diff \
366+ "$PT_TMPDIR/got" \
367+ "$samples/expected_output_temp007.txt" \
368+ "report_mysql_summary, dir: temp007 (PXC, traditional master)"
369+
370+# ###########################################################################
371+# parse_wsrep_provider_options
372+# ###########################################################################
373+
374+vars_file="$samples/temp006/mysql-variables"
375+is \
376+ "$(parse_wsrep_provider_options "base_host" "$vars_file")" \
377+ "192.168.122.1" \
378+ "parse_wsrep_provider_options works for the first option"
379+
380+is \
381+ "$(parse_wsrep_provider_options "replicator.commit_order" "$vars_file")" \
382+ "3" \
383+ "parse_wsrep_provider_options works for the last option"
384+
385+is \
386+ "$(parse_wsrep_provider_options "pc.ignore_sb" "$vars_file")" \
387+ "false" \
388+ "parse_wsrep_provider_options works for pc.ignore_sb"
389+
390+is \
391+ "$(parse_wsrep_provider_options "pc.ignore_quorum" "$vars_file")" \
392+ "false" \
393+ "parse_wsrep_provider_options works for pc.ignore_quorum"
394+
395+is \
396+ "$(parse_wsrep_provider_options "gcache.name" "$vars_file")" \
397+ "/tmp/12345/data//galera.cache" \
398+ "parse_wsrep_provider_options works for gcache.name"
399+
400+
401 # ###########################################################################
402 # Done
403 # ###########################################################################
404
405=== modified file 't/pt-mysql-summary/pt-mysql-summary.t'
406--- t/pt-mysql-summary/pt-mysql-summary.t 2012-10-24 19:03:45 +0000
407+++ t/pt-mysql-summary/pt-mysql-summary.t 2012-12-04 16:32:31 +0000
408@@ -14,7 +14,7 @@
409
410 my ($tool) = $PROGRAM_NAME =~ m/([\w-]+)\.t$/;
411
412-use Test::More tests => 7;
413+use Test::More;
414 use File::Temp qw( tempdir );
415
416 local $ENV{PTDEBUG} = "";
417@@ -56,12 +56,13 @@
418 );
419
420 # --read-samples
421-for my $i (2..5) {
422+for my $i (2..7) {
423 ok(
424 no_diff(
425 sub {
426 local $ENV{_NO_FALSE_NEGATIVES} = 1;
427- print `$trunk/bin/$tool --read-samples $trunk/t/pt-mysql-summary/samples/temp00$i -- --defaults-file=/tmp/12345/my.sandbox.cnf | tail -n+3 | perl -wlnpe 's/Skipping schema analysis.*/Skipping schema analysis/'`
428+ my $out = `$trunk/bin/$tool --read-samples $trunk/t/pt-mysql-summary/samples/temp00$i -- --defaults-file=/tmp/12345/my.sandbox.cnf | tail -n+3 | perl -wlnpe 's/Skipping schema analysis.*/Skipping schema analysis/'`;
429+ print $out;
430 },
431 "t/pt-mysql-summary/samples/expected_output_temp00$i.txt",
432 ),
433@@ -69,4 +70,16 @@
434 );
435 }
436
437+# Test that --help works under sh
438+
439+my $sh = `sh $trunk/bin/$tool --help`;
440+my $bash = `bash $trunk/bin/$tool --help`;
441+
442+is(
443+ $sh,
444+ $bash,
445+ "--help works under sh and bash"
446+);
447+
448+done_testing;
449 exit;
450
451=== modified file 't/pt-mysql-summary/samples/expected_output_temp002.txt'
452--- t/pt-mysql-summary/samples/expected_output_temp002.txt 2012-03-31 02:00:57 +0000
453+++ t/pt-mysql-summary/samples/expected_output_temp002.txt 2012-12-04 16:32:31 +0000
454@@ -123,6 +123,7 @@
455 Smooth Flushing | Not Supported
456 HandlerSocket NoSQL | Not Supported
457 Fast Hash UDFs | Unknown
458+# Percona XtraDB Cluster #####################################
459 # Plugins ####################################################
460 InnoDB compression | ACTIVE
461 # Query cache ################################################
462
463=== modified file 't/pt-mysql-summary/samples/expected_output_temp003.txt'
464--- t/pt-mysql-summary/samples/expected_output_temp003.txt 2012-03-30 21:04:25 +0000
465+++ t/pt-mysql-summary/samples/expected_output_temp003.txt 2012-12-04 16:32:31 +0000
466@@ -99,6 +99,7 @@
467 Smooth Flushing | Not Supported
468 HandlerSocket NoSQL | Not Supported
469 Fast Hash UDFs | Unknown
470+# Percona XtraDB Cluster #####################################
471 # Plugins ####################################################
472 InnoDB compression | Not found
473 # Query cache ################################################
474
475=== modified file 't/pt-mysql-summary/samples/expected_output_temp004.txt'
476--- t/pt-mysql-summary/samples/expected_output_temp004.txt 2012-03-30 21:04:25 +0000
477+++ t/pt-mysql-summary/samples/expected_output_temp004.txt 2012-12-04 16:32:31 +0000
478@@ -98,6 +98,7 @@
479 Smooth Flushing | Not Supported
480 HandlerSocket NoSQL | Not Supported
481 Fast Hash UDFs | Unknown
482+# Percona XtraDB Cluster #####################################
483 # Plugins ####################################################
484 InnoDB compression | Not found
485 # Query cache ################################################
486
487=== modified file 't/pt-mysql-summary/samples/expected_output_temp005.txt'
488--- t/pt-mysql-summary/samples/expected_output_temp005.txt 2012-03-31 02:00:57 +0000
489+++ t/pt-mysql-summary/samples/expected_output_temp005.txt 2012-12-04 16:32:31 +0000
490@@ -141,6 +141,7 @@
491 Smooth Flushing | Enabled
492 HandlerSocket NoSQL | Not Supported
493 Fast Hash UDFs | Unknown
494+# Percona XtraDB Cluster #####################################
495 # Plugins ####################################################
496 InnoDB compression | ACTIVE
497 # Query cache ################################################
498
499=== added file 't/pt-mysql-summary/samples/expected_output_temp006.txt'
500--- t/pt-mysql-summary/samples/expected_output_temp006.txt 1970-01-01 00:00:00 +0000
501+++ t/pt-mysql-summary/samples/expected_output_temp006.txt 2012-12-04 16:32:31 +0000
502@@ -0,0 +1,341 @@
503+# Instances ##################################################
504+ Port Data Directory Nice OOM Socket
505+ ===== ========================== ==== === ======
506+ 12345 /tmp/12345/data 0 0 /tmp/12345/mysql_sandbox12345.sock
507+ 12346 /tmp/12346/data 0 0 /tmp/12346/mysql_sandbox12346.sock
508+ 12347 /tmp/12347/data 0 0 /tmp/12347/mysql_sandbox12347.sock
509+# MySQL Executable ###########################################
510+# Report On Port 12345 #######################################
511+ User | msandbox@%
512+ Time | 2012-11-27 17:38:42 (ART)
513+ Hostname | hugmeir
514+ Version | 5.5.28-23.7-log Percona XtraDB Cluster (GPL) 5.5.28-23.7, Revision 373, wsrep_23.7.r3821
515+ Built On | Linux i686
516+ Started | 2012-11-27 16:56 (up 0+00:41:51)
517+ Databases | 5
518+ Datadir | /tmp/12345/data/
519+ Processes | 4 connected, 1 running
520+ Replication | Is not a slave, has 0 slaves connected
521+ Pidfile | /tmp/12345/data/mysql_sandbox12345.pid (exists)
522+# Processlist ################################################
523+
524+ Command COUNT(*) Working SUM(Time) MAX(Time)
525+ ------------------------------ -------- ------- --------- ---------
526+ Query 1 1 0 0
527+ Sleep 3 0 8000 2500
528+
529+ User COUNT(*) Working SUM(Time) MAX(Time)
530+ ------------------------------ -------- ------- --------- ---------
531+ msandbox 1 1 0 0
532+ system user 3 0 0 0
533+
534+ Host COUNT(*) Working SUM(Time) MAX(Time)
535+ ------------------------------ -------- ------- --------- ---------
536+ 3 0 0 0
537+ localhost 1 1 0 0
538+
539+ db COUNT(*) Working SUM(Time) MAX(Time)
540+ ------------------------------ -------- ------- --------- ---------
541+ NULL 4 1 0 0
542+
543+ State COUNT(*) Working SUM(Time) MAX(Time)
544+ ------------------------------ -------- ------- --------- ---------
545+ NULL 2 0 0 0
546+ sleeping 1 1 0 0
547+ wsrep aborter idle 1 0 0 0
548+
549+# Status Counters (Wait 10 Seconds) ##########################
550+Variable Per day Per second 10 secs
551+Binlog_cache_disk_use 35
552+Binlog_cache_use 150
553+Binlog_stmt_cache_use 35
554+Bytes_received 125000000 1250 225
555+Bytes_sent 25000000 300 2500
556+Com_admin_commands 35
557+Com_alter_table 70
558+Com_begin 35
559+Com_change_db 2000
560+Com_checksum 35
561+Com_commit 70
562+Com_create_db 70
563+Com_create_function 100
564+Com_create_procedure 100
565+Com_create_table 700
566+Com_create_trigger 200
567+Com_create_view 250
568+Com_drop_db 35
569+Com_drop_table 35
570+Com_flush 70
571+Com_insert 35000
572+Com_load 35
573+Com_rollback 35
574+Com_select 10000 1
575+Com_set_option 12500
576+Com_show_binlogs 400
577+Com_show_create_db 100
578+Com_show_create_func 100
579+Com_show_create_proc 100
580+Com_show_create_table 3500
581+Com_show_create_trigger 200
582+Com_show_databases 450
583+Com_show_engine_status 400
584+Com_show_fields 1750
585+Com_show_function_status 100
586+Com_show_master_status 400
587+Com_show_plugins 400
588+Com_show_procedure_status 100
589+Com_show_processlist 400
590+Com_show_slave_status 400
591+Com_show_status 600
592+Com_show_table_status 1750
593+Com_show_tables 250
594+Com_show_triggers 1750
595+Com_show_variables 400
596+Com_update 35
597+Connections 7000 1
598+Created_tmp_disk_tables 8000 1
599+Created_tmp_files 250
600+Created_tmp_tables 35000 6
601+Flush_commands 100
602+Handler_commit 8000
603+Handler_prepare 6000
604+Handler_read_first 900
605+Handler_read_key 800
606+Handler_read_next 1250
607+Handler_read_rnd_next 2250000 25 45
608+Handler_rollback 1000
609+Handler_update 200
610+Handler_write 2000000 25 45
611+Innodb_adaptive_hash_cells 5000000 60
612+Innodb_adaptive_hash_heap_buffers 200
613+Innodb_adaptive_hash_hash_searches 4500000 50
614+Innodb_adaptive_hash_non_hash_searches 1750000 20
615+Innodb_background_log_sync 1500
616+Innodb_buffer_pool_pages_flushed 30000
617+Innodb_buffer_pool_pages_old 8000
618+Innodb_buffer_pool_read_requests 15000000 175
619+Innodb_buffer_pool_write_requests 8000000 90
620+Innodb_checkpoint_max_age 250000000 3000
621+Innodb_checkpoint_target_age 250000000 3000
622+Innodb_data_fsyncs 4500
623+Innodb_data_writes 35000
624+Innodb_data_written 1250000000 15000
625+Innodb_dblwr_pages_written 25000
626+Innodb_dblwr_writes 600
627+Innodb_dict_tables 900
628+Innodb_history_list_length 35
629+Innodb_ibuf_segment_size 70
630+Innodb_ibuf_size 35
631+Innodb_log_write_requests 600000 7
632+Innodb_log_writes 2500
633+Innodb_lsn_current 300000000 3500
634+Innodb_lsn_flushed 300000000 3500
635+Innodb_lsn_last_checkpoint 300000000 3500
636+Innodb_master_thread_1_second_loops 1500
637+Innodb_master_thread_10_second_loops 150
638+Innodb_master_thread_background_loops 100
639+Innodb_master_thread_main_flush_loops 100
640+Innodb_master_thread_sleeps 1500
641+Innodb_max_trx_id 30000
642+Innodb_mem_adaptive_hash 22500000 250
643+Innodb_mem_dictionary 8000000 90
644+Innodb_mem_total 1250000000 12500
645+Innodb_mutex_os_waits 200
646+Innodb_mutex_spin_rounds 9000
647+Innodb_mutex_spin_waits 400
648+Innodb_oldest_view_low_limit_trx_id 30000
649+Innodb_os_log_fsyncs 3000
650+Innodb_os_log_written 300000000 3500
651+Innodb_pages_created 25000
652+Innodb_pages_written 30000
653+Innodb_purge_trx_id 30000
654+Innodb_rows_inserted 1750000 20
655+Innodb_rows_read 1750000 20
656+Innodb_s_lock_os_waits 800
657+Innodb_s_lock_spin_rounds 25000
658+Innodb_s_lock_spin_waits 800
659+Innodb_x_lock_os_waits 300
660+Innodb_x_lock_spin_rounds 9000
661+Key_read_requests 1500
662+Key_reads 35
663+Key_write_requests 400
664+Key_writes 400
665+Open_table_definitions 1750
666+Opened_files 45000 4
667+Opened_table_definitions 3500
668+Opened_tables 4000
669+Queries 80000 4
670+Questions 50000 4
671+Select_scan 8000
672+Sort_scan 70
673+Table_locks_immediate 7000
674+Threads_created 7000 1
675+Uptime 90000 1 1
676+binlog_commits 175
677+binlog_group_commits 175
678+wsrep_protocol_version 150
679+wsrep_last_committed 1750
680+wsrep_replicated 1750
681+wsrep_replicated_bytes 125000000 1250
682+wsrep_received 400
683+wsrep_received_bytes 22500
684+wsrep_local_commits 150
685+wsrep_local_state 150
686+wsrep_cert_index_size 2500000 30
687+wsrep_cluster_conf_id 100
688+wsrep_cluster_size 100
689+# Table cache ################################################
690+ Size | 400
691+ Usage | 10%
692+# Key Percona Server features ################################
693+ Table & Index Stats | Not Supported
694+ Multiple I/O Threads | Enabled
695+ Corruption Resilient | Not Supported
696+ Durable Replication | Not Supported
697+ Import InnoDB Tables | Not Supported
698+ Fast Server Restarts | Not Supported
699+ Enhanced Logging | Not Supported
700+ Replica Perf Logging | Disabled
701+ Response Time Hist. | Not Supported
702+ Smooth Flushing | Not Supported
703+ HandlerSocket NoSQL | Not Supported
704+ Fast Hash UDFs | Unknown
705+# Percona XtraDB Cluster #####################################
706+ Cluster Name | pt_sandbox_cluster
707+ Cluster Address | gcomm://
708+ Cluster Size | 3
709+ Cluster Nodes | 192.168.0.100,192.168.0.100,192.168.0.100
710+ Node Name | 12345
711+ Node Status | Primary
712+ SST Method | rsync
713+ Slave Threads | 2
714+ Ignore Split Brain | false
715+ Ignore Quorum | false
716+ gcache Size | 128M
717+ gcache Directory | /tmp/12345/data/
718+ gcache Name | /tmp/12345/data//galera.cache
719+# Plugins ####################################################
720+ InnoDB compression | ACTIVE
721+# Query cache ################################################
722+ query_cache_type | ON
723+ Size | 0.0
724+ Usage | 0%
725+ HitToInsertRatio | 0%
726+# Schema #####################################################
727+
728+ Database Tables Views SPs Trigs Funcs FKs Partn
729+ mysql 22
730+ percona_test 3
731+ sakila 16 7 3 6 3 22
732+
733+ Database MyISAM InnoDB
734+ mysql 22
735+ percona_test 3
736+ sakila 7 16
737+
738+ Database BTREE
739+ mysql 31
740+ percona_test 2
741+ sakila 63
742+
743+ c t s e l d i t s t b v b y d m
744+ h i e n o a n i m e i a l e e e
745+ a m t u n t t n a x g r o a c d
746+ r e m g e y l t i c b r i i
747+ s b t i l n h m u
748+ t l i n i t a a m
749+ a o m t n r l i
750+ m b e t n
751+ p t
752+ Database === === === === === === === === === === === === === === === ===
753+ mysql 61 8 6 78 5 4 19 3 3 4 8 3 4
754+ percona_test 3 2
755+ sakila 1 15 1 3 4 2 19 26 7 42 1 1 7 2
756+
757+# Noteworthy Technologies ####################################
758+ Full Text Indexing | No
759+ Geospatial Types | No
760+ Foreign Keys | Yes
761+ Partitioning | No
762+ InnoDB Compression | No
763+ SSL | No
764+ Explicit LOCK TABLES | No
765+ Delayed Insert | No
766+ XA Transactions | No
767+ NDB Cluster | No
768+ Prepared Statements | No
769+ Prepared statement count | 0
770+# InnoDB #####################################################
771+ Version | 1.1.8-rel29.1
772+ Buffer Pool Size | 32.0M
773+ Buffer Pool Fill | 35%
774+ Buffer Pool Dirty | 0%
775+ File Per Table | OFF
776+ Page Size | 16k
777+ Log File Size | 2 * 5.0M = 10.0M
778+ Log Buffer Size | 8M
779+ Flush Method |
780+ Flush Log At Commit | 1
781+ XA Support | ON
782+ Checksums | ON
783+ Doublewrite | ON
784+ R/W I/O Threads | 4 4
785+ I/O Capacity | 200
786+ Thread Concurrency | 0
787+ Concurrency Tickets | 500
788+ Commit Concurrency | 0
789+ Txn Isolation Level | REPEATABLE-READ
790+ Adaptive Flushing | ON
791+ Adaptive Checkpoint |
792+ Checkpoint Age | 0
793+ InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
794+ Oldest Transaction | 0 Seconds
795+ History List Len | 1
796+ Read Views | 1
797+ Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
798+ Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
799+ Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
800+ Pending I/O Flushes | 0 buf pool, 0 log
801+ Transaction States | 1xnot started
802+# MyISAM #####################################################
803+ Key Cache | 16.0M
804+ Pct Used | 10%
805+ Unflushed | 0%
806+# Security ###################################################
807+ Users | 2 users, 0 anon, 0 w/o pw, 0 old pw
808+ Old Passwords | OFF
809+# Binary Logging #############################################
810+ Binlogs | 1
811+ Zero-Sized | 0
812+ Total Size | 1.4M
813+ binlog_format | ROW
814+ expire_logs_days | 0
815+ sync_binlog | 0
816+ server_id | 12345
817+ binlog_do_db |
818+ binlog_ignore_db |
819+# Noteworthy Variables #######################################
820+ Auto-Inc Incr/Offset | 3/1
821+ default_storage_engine | InnoDB
822+ flush_time | 0
823+ init_connect |
824+ init_file |
825+ sql_mode |
826+ join_buffer_size | 128k
827+ sort_buffer_size | 2M
828+ read_buffer_size | 128k
829+ read_rnd_buffer_size | 256k
830+ bulk_insert_buffer | 0.00
831+ max_heap_table_size | 16M
832+ tmp_table_size | 16M
833+ max_allowed_packet | 1M
834+ thread_stack | 192k
835+ log | ON
836+ log_error | /tmp/12345/data/mysqld.log
837+ log_warnings | 1
838+ log_slow_queries | OFF
839+log_queries_not_using_indexes | OFF
840+ log_slave_updates | ON
841+# Configuration File #########################################
842+ Config File | Cannot autodetect or find, giving up
843+# The End ####################################################
844
845=== added file 't/pt-mysql-summary/samples/expected_output_temp007.txt'
846--- t/pt-mysql-summary/samples/expected_output_temp007.txt 1970-01-01 00:00:00 +0000
847+++ t/pt-mysql-summary/samples/expected_output_temp007.txt 2012-12-04 16:32:31 +0000
848@@ -0,0 +1,295 @@
849+# Instances ##################################################
850+ Port Data Directory Nice OOM Socket
851+ ===== ========================== ==== === ======
852+ 12345 /tmp/12345/data 0 0 /tmp/12345/mysql_sandbox12345.sock
853+ 12346 /tmp/12346/data 0 0 /tmp/12346/mysql_sandbox12346.sock
854+ 12347 /tmp/12347/data 0 0 /tmp/12347/mysql_sandbox12347.sock
855+# MySQL Executable ###########################################
856+ Path to executable | /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld
857+ Has symbols | Yes
858+# Report On Port 12345 #######################################
859+ User | msandbox@%
860+ Time | 2012-11-27 18:59:59 (ART)
861+ Hostname | hugmeir
862+ Version | 5.5.28-23.7-log Percona XtraDB Cluster (GPL) 5.5.28-23.7, Revision 373, wsrep_23.7.r3821
863+ Built On | Linux i686
864+ Started | 2012-11-27 18:58 (up 0+00:01:36)
865+ Databases | 5
866+ Datadir | /tmp/12345/data/
867+ Processes | 2 connected, 2 running
868+ Replication | Is not a slave, has 1 slaves connected
869+ Pidfile | /tmp/12345/data/mysql_sandbox12345.pid (exists)
870+# Processlist ################################################
871+
872+ Command COUNT(*) Working SUM(Time) MAX(Time)
873+ ------------------------------ -------- ------- --------- ---------
874+ Binlog Dump 1 1 90 90
875+ Query 1 1 0 0
876+
877+ User COUNT(*) Working SUM(Time) MAX(Time)
878+ ------------------------------ -------- ------- --------- ---------
879+ msandbox 2 2 90 90
880+
881+ Host COUNT(*) Working SUM(Time) MAX(Time)
882+ ------------------------------ -------- ------- --------- ---------
883+ localhost 2 2 90 90
884+
885+ db COUNT(*) Working SUM(Time) MAX(Time)
886+ ------------------------------ -------- ------- --------- ---------
887+ NULL 2 2 90 90
888+
889+ State COUNT(*) Working SUM(Time) MAX(Time)
890+ ------------------------------ -------- ------- --------- ---------
891+ Master has sent all binlog to 1 1 90 90
892+ NULL 1 1 0 0
893+
894+# Status Counters (Wait 10 Seconds) ##########################
895+Variable Per day Per second 11 secs
896+Binlog_cache_disk_use 900
897+Binlog_cache_use 3500
898+Binlog_stmt_cache_use 900
899+Bytes_received 3000000000 35000 200
900+Bytes_sent 3000000000 35000 2250
901+Com_admin_commands 1750
902+Com_begin 900
903+Com_change_db 1750
904+Com_checksum 900
905+Com_commit 1750
906+Com_create_db 1750
907+Com_create_function 2500
908+Com_create_procedure 2500
909+Com_create_table 17500
910+Com_create_trigger 5000
911+Com_create_view 6000
912+Com_drop_db 900
913+Com_drop_table 900
914+Com_insert 1000000 10
915+Com_load 900
916+Com_rollback 900
917+Com_select 15000 1
918+Com_set_option 10000
919+Com_show_engine_status 900
920+Com_show_status 900
921+Com_show_tables 900
922+Com_show_variables 1750
923+Com_update 900
924+Connections 12500 1
925+Created_tmp_files 6000
926+Created_tmp_tables 3500 6
927+Flush_commands 900
928+Handler_commit 125000 1
929+Handler_prepare 100000 1
930+Handler_read_first 17500
931+Handler_read_key 15000
932+Handler_read_rnd_next 45000000 500 40
933+Handler_rollback 12500
934+Handler_update 5000
935+Handler_write 45000000 500 40
936+Innodb_adaptive_hash_cells 125000000 1500
937+Innodb_adaptive_hash_heap_buffers 5000
938+Innodb_adaptive_hash_hash_searches 125000000 1250
939+Innodb_adaptive_hash_non_hash_searches 50000000 500
940+Innodb_background_log_sync 30000
941+Innodb_buffer_pool_pages_flushed 700000 8
942+Innodb_buffer_pool_pages_old 200000 2
943+Innodb_buffer_pool_read_requests 400000000 4500
944+Innodb_buffer_pool_write_requests 200000000 2500
945+Innodb_checkpoint_max_age 7000000000 80000
946+Innodb_checkpoint_target_age 7000000000 80000
947+Innodb_data_fsyncs 100000 1
948+Innodb_data_writes 900000 9
949+Innodb_data_written 30000000000 350000
950+Innodb_dblwr_pages_written 600000 6
951+Innodb_dblwr_writes 15000
952+Innodb_dict_tables 22500
953+Innodb_ibuf_segment_size 1750
954+Innodb_ibuf_size 900
955+Innodb_log_write_requests 15000000 175
956+Innodb_log_writes 60000
957+Innodb_lsn_current 8000000000 90000
958+Innodb_lsn_flushed 8000000000 90000
959+Innodb_lsn_last_checkpoint 8000000000 90000
960+Innodb_master_thread_1_second_loops 30000
961+Innodb_master_thread_10_second_loops 2500
962+Innodb_master_thread_background_loops 3500
963+Innodb_master_thread_main_flush_loops 3500
964+Innodb_master_thread_sleeps 30000
965+Innodb_max_trx_id 800000 8
966+Innodb_mem_adaptive_hash 600000000 7000
967+Innodb_mem_dictionary 200000000 2250
968+Innodb_mem_total 30000000000 350000
969+Innodb_mutex_os_waits 3500
970+Innodb_mutex_spin_rounds 200000 2
971+Innodb_mutex_spin_waits 12500
972+Innodb_oldest_view_low_limit_trx_id 700000 8
973+Innodb_os_log_fsyncs 80000
974+Innodb_os_log_written 8000000000 90000
975+Innodb_pages_created 600000 7
976+Innodb_pages_written 700000 8
977+Innodb_rows_inserted 40000000 500
978+Innodb_rows_read 40000000 500
979+Innodb_s_lock_os_waits 22500
980+Innodb_s_lock_spin_rounds 600000 7
981+Innodb_s_lock_spin_waits 22500
982+Innodb_x_lock_os_waits 7000
983+Innodb_x_lock_spin_rounds 225000 2
984+Key_read_requests 25000000 300
985+Key_reads 900
986+Key_write_requests 10000000 125
987+Key_writes 200000 2
988+Open_table_definitions 50000
989+Opened_files 200000 2 4
990+Opened_table_definitions 80000
991+Opened_tables 80000
992+Queries 1000000 10 3
993+Questions 150000 1 3
994+Select_scan 4500
995+Table_locks_immediate 175000 1
996+Threads_created 12500 1
997+Uptime 90000 1 1
998+binlog_commits 4500
999+binlog_group_commits 4500
1000+wsrep_local_index 4000000000000 45000000
1001+# Table cache ################################################
1002+ Size | 400
1003+ Usage | 15%
1004+# Key Percona Server features ################################
1005+ Table & Index Stats | Not Supported
1006+ Multiple I/O Threads | Enabled
1007+ Corruption Resilient | Not Supported
1008+ Durable Replication | Not Supported
1009+ Import InnoDB Tables | Not Supported
1010+ Fast Server Restarts | Not Supported
1011+ Enhanced Logging | Not Supported
1012+ Replica Perf Logging | Disabled
1013+ Response Time Hist. | Not Supported
1014+ Smooth Flushing | Not Supported
1015+ HandlerSocket NoSQL | Not Supported
1016+ Fast Hash UDFs | Unknown
1017+# Percona XtraDB Cluster #####################################
1018+ wsrep_on | OFF
1019+# Plugins ####################################################
1020+ InnoDB compression | ACTIVE
1021+# Query cache ################################################
1022+ query_cache_type | ON
1023+ Size | 0.0
1024+ Usage | 0%
1025+ HitToInsertRatio | 0%
1026+# Schema #####################################################
1027+
1028+ Database Tables Views SPs Trigs Funcs FKs Partn
1029+ mysql 22
1030+ percona_test 3
1031+ sakila 16 7 3 6 3 22
1032+
1033+ Database MyISAM InnoDB
1034+ mysql 22
1035+ percona_test 3
1036+ sakila 8 15
1037+
1038+ Database BTREE FULLTEXT
1039+ mysql 31
1040+ percona_test 2
1041+ sakila 63 1
1042+
1043+ c t s e l d i t s t b v b y d m
1044+ h i e n o a n i m e i a l e e e
1045+ a m t u n t t n a x g r o a c d
1046+ r e m g e y l t i c b r i i
1047+ s b t i l n h m u
1048+ t l i n i t a a m
1049+ a o m t n r l i
1050+ m b e t n
1051+ p t
1052+ Database === === === === === === === === === === === === === === === ===
1053+ mysql 61 8 6 78 5 4 19 3 3 4 8 3 4
1054+ percona_test 3 2
1055+ sakila 1 15 1 3 4 2 19 26 7 42 1 1 7 2
1056+
1057+# Noteworthy Technologies ####################################
1058+ Full Text Indexing | Yes
1059+ Geospatial Types | No
1060+ Foreign Keys | Yes
1061+ Partitioning | No
1062+ InnoDB Compression | No
1063+ SSL | No
1064+ Explicit LOCK TABLES | No
1065+ Delayed Insert | No
1066+ XA Transactions | No
1067+ NDB Cluster | No
1068+ Prepared Statements | No
1069+ Prepared statement count | 0
1070+# InnoDB #####################################################
1071+ Version | 1.1.8-rel29.1
1072+ Buffer Pool Size | 32.0M
1073+ Buffer Pool Fill | 35%
1074+ Buffer Pool Dirty | 0%
1075+ File Per Table | OFF
1076+ Page Size | 16k
1077+ Log File Size | 2 * 5.0M = 10.0M
1078+ Log Buffer Size | 8M
1079+ Flush Method |
1080+ Flush Log At Commit | 1
1081+ XA Support | ON
1082+ Checksums | ON
1083+ Doublewrite | ON
1084+ R/W I/O Threads | 4 4
1085+ I/O Capacity | 200
1086+ Thread Concurrency | 0
1087+ Concurrency Tickets | 500
1088+ Commit Concurrency | 0
1089+ Txn Isolation Level | REPEATABLE-READ
1090+ Adaptive Flushing | ON
1091+ Adaptive Checkpoint |
1092+ Checkpoint Age | 0
1093+ InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
1094+ Oldest Transaction | 0 Seconds
1095+ History List Len | 0
1096+ Read Views | 1
1097+ Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
1098+ Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
1099+ Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
1100+ Pending I/O Flushes | 0 buf pool, 0 log
1101+ Transaction States | 1xnot started
1102+# MyISAM #####################################################
1103+ Key Cache | 16.0M
1104+ Pct Used | 10%
1105+ Unflushed | 0%
1106+# Security ###################################################
1107+ Users | 2 users, 0 anon, 0 w/o pw, 0 old pw
1108+ Old Passwords | OFF
1109+# Binary Logging #############################################
1110+ Binlogs | 1
1111+ Zero-Sized | 0
1112+ Total Size | 3.1M
1113+ binlog_format | STATEMENT
1114+ expire_logs_days | 0
1115+ sync_binlog | 0
1116+ server_id | 12345
1117+ binlog_do_db |
1118+ binlog_ignore_db |
1119+# Noteworthy Variables #######################################
1120+ Auto-Inc Incr/Offset | 1/1
1121+ default_storage_engine | InnoDB
1122+ flush_time | 0
1123+ init_connect |
1124+ init_file |
1125+ sql_mode |
1126+ join_buffer_size | 128k
1127+ sort_buffer_size | 2M
1128+ read_buffer_size | 128k
1129+ read_rnd_buffer_size | 256k
1130+ bulk_insert_buffer | 0.00
1131+ max_heap_table_size | 16M
1132+ tmp_table_size | 16M
1133+ max_allowed_packet | 1M
1134+ thread_stack | 192k
1135+ log | ON
1136+ log_error | /tmp/12345/data/mysqld.log
1137+ log_warnings | 1
1138+ log_slow_queries | OFF
1139+log_queries_not_using_indexes | OFF
1140+ log_slave_updates | ON
1141+# Configuration File #########################################
1142+ Config File | Cannot autodetect or find, giving up
1143+# The End ####################################################
1144
1145=== modified file 't/pt-mysql-summary/samples/expected_result_report_summary.txt'
1146--- t/pt-mysql-summary/samples/expected_result_report_summary.txt 2012-03-31 02:00:57 +0000
1147+++ t/pt-mysql-summary/samples/expected_result_report_summary.txt 2012-12-04 16:32:31 +0000
1148@@ -107,6 +107,7 @@
1149 Smooth Flushing | Not Supported
1150 HandlerSocket NoSQL | Not Supported
1151 Fast Hash UDFs | Unknown
1152+# Percona XtraDB Cluster #####################################
1153 # Plugins ####################################################
1154 InnoDB compression | Not found
1155 # Query cache ################################################
1156
1157=== added file 't/pt-mysql-summary/samples/ps-mysqld-006.txt'
1158--- t/pt-mysql-summary/samples/ps-mysqld-006.txt 1970-01-01 00:00:00 +0000
1159+++ t/pt-mysql-summary/samples/ps-mysqld-006.txt 2012-12-04 16:32:31 +0000
1160@@ -0,0 +1,4 @@
1161+ PID TTY STAT TIME COMMAND
1162+32324 pts/6 Sl 0:25 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12345/my.sandbox.cnf
1163+32419 pts/6 Sl 0:18 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12346/my.sandbox.cnf
1164+32578 pts/6 Sl 0:18 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12347/my.sandbox.cnf
1165
1166=== added directory 't/pt-mysql-summary/samples/temp006'
1167=== added file 't/pt-mysql-summary/samples/temp006/collect.err'
1168=== added file 't/pt-mysql-summary/samples/temp006/innodb-status'
1169--- t/pt-mysql-summary/samples/temp006/innodb-status 1970-01-01 00:00:00 +0000
1170+++ t/pt-mysql-summary/samples/temp006/innodb-status 2012-12-04 16:32:31 +0000
1171@@ -0,0 +1,119 @@
1172+*************************** 1. row ***************************
1173+ Type: InnoDB
1174+ Name:
1175+Status:
1176+=====================================
1177+121127 17:38:42 INNODB MONITOR OUTPUT
1178+=====================================
1179+Per second averages calculated from the last 53 seconds
1180+-----------------
1181+BACKGROUND THREAD
1182+-----------------
1183+srv_master_thread loops: 42 1_second, 42 sleeps, 4 10_second, 3 background, 3 flush
1184+srv_master_thread log flush and writes: 45
1185+----------
1186+SEMAPHORES
1187+----------
1188+OS WAIT ARRAY INFO: reservation count 39, signal count 39
1189+Mutex spin waits 11, rounds 271, OS waits 6
1190+RW-shared spins 24, rounds 720, OS waits 24
1191+RW-excl spins 0, rounds 270, OS waits 9
1192+Spin rounds per wait: 24.64 mutex, 30.00 RW-shared, 270.00 RW-excl
1193+--------
1194+FILE I/O
1195+--------
1196+I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
1197+I/O thread 1 state: waiting for completed aio requests (log thread)
1198+I/O thread 2 state: waiting for completed aio requests (read thread)
1199+I/O thread 3 state: waiting for completed aio requests (read thread)
1200+I/O thread 4 state: waiting for completed aio requests (read thread)
1201+I/O thread 5 state: waiting for completed aio requests (read thread)
1202+I/O thread 6 state: waiting for completed aio requests (write thread)
1203+I/O thread 7 state: waiting for completed aio requests (write thread)
1204+I/O thread 8 state: waiting for completed aio requests (write thread)
1205+I/O thread 9 state: waiting for completed aio requests (write thread)
1206+Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
1207+ ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
1208+Pending flushes (fsync) log: 0; buffer pool: 0
1209+0 OS file reads, 1067 OS file writes, 131 OS fsyncs
1210+0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
1211+-------------------------------------
1212+INSERT BUFFER AND ADAPTIVE HASH INDEX
1213+-------------------------------------
1214+Ibuf: size 1, free list len 0, seg size 2, 0 merges
1215+merged operations:
1216+ insert 0, delete mark 0, delete 0
1217+discarded operations:
1218+ insert 0, delete mark 0, delete 0
1219+Hash table size 138337, node heap has 7 buffer(s)
1220+0.00 hash searches/s, 0.00 non-hash searches/s
1221+---
1222+LOG
1223+---
1224+Log sequence number 8809964
1225+Log flushed up to 8809964
1226+Last checkpoint at 8809964
1227+Max checkpoint age 7782360
1228+Checkpoint age target 7539162
1229+Modified age 0
1230+Checkpoint age 0
1231+0 pending log writes, 0 pending chkp writes
1232+93 log i/o's done, 0.00 log i/o's/second
1233+----------------------
1234+BUFFER POOL AND MEMORY
1235+----------------------
1236+Total memory allocated 34062336; in additional pool allocated 0
1237+Internal hash tables (constant factor + variable factor)
1238+ Adaptive hash index 672196 (553348 + 118848)
1239+ Page hash 17692 (buffer pool 0 only)
1240+ Dictionary cache 221035 (139064 + 81971)
1241+ File system 41792 (41336 + 456)
1242+ Lock system 42228 (41908 + 320)
1243+ Recovery system 0 (0 + 0)
1244+Dictionary memory allocated 81971
1245+Buffer pool size 2047
1246+Buffer pool size, bytes 33538048
1247+Free buffers 1332
1248+Database pages 708
1249+Old database pages 241
1250+Modified db pages 0
1251+Pending reads 0
1252+Pending writes: LRU 0, flush list 0, single page 0
1253+Pages made young 0, not young 0
1254+0.00 youngs/s, 0.00 non-youngs/s
1255+Pages read 0, created 708, written 916
1256+0.00 reads/s, 0.00 creates/s, 0.00 writes/s
1257+No buffer pool page gets since the last printout
1258+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
1259+LRU len: 708, unzip_LRU len: 0
1260+I/O sum[0]:cur[0], unzip sum[0]:cur[0]
1261+--------------
1262+ROW OPERATIONS
1263+--------------
1264+0 queries inside InnoDB, 0 queries in queue
1265+1 read views open inside InnoDB
1266+---OLDEST VIEW---
1267+Normal read view
1268+Read view low limit trx n:o 338
1269+Read view up limit trx id 337
1270+Read view low limit trx id 339
1271+Read view individually stored trx ids:
1272+Read view trx id 337
1273+-----------------
1274+Main thread process no. 32324, id 2710072128, state: waiting for server activity
1275+Number of rows inserted 47315, updated 0, deleted 0, read 47274
1276+0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
1277+------------
1278+TRANSACTIONS
1279+------------
1280+Trx id counter 34E
1281+Purge done for trx's n:o < 338 undo n:o < 0
1282+History list length 1
1283+LIST OF TRANSACTIONS FOR EACH SESSION:
1284+---TRANSACTION 0, not started
1285+MySQL thread id 205, OS thread handle 0xa0822b40, query id 2462 localhost msandbox sleeping
1286+SHOW /*!50000 ENGINE*/ INNODB STATUS
1287+----------------------------
1288+END OF INNODB MONITOR OUTPUT
1289+============================
1290+
1291
1292=== added file 't/pt-mysql-summary/samples/temp006/mysql-databases'
1293--- t/pt-mysql-summary/samples/temp006/mysql-databases 1970-01-01 00:00:00 +0000
1294+++ t/pt-mysql-summary/samples/temp006/mysql-databases 2012-12-04 16:32:31 +0000
1295@@ -0,0 +1,5 @@
1296+information_schema
1297+mysql
1298+percona_test
1299+performance_schema
1300+sakila
1301
1302=== added file 't/pt-mysql-summary/samples/temp006/mysql-master-logs'
1303--- t/pt-mysql-summary/samples/temp006/mysql-master-logs 1970-01-01 00:00:00 +0000
1304+++ t/pt-mysql-summary/samples/temp006/mysql-master-logs 2012-12-04 16:32:31 +0000
1305@@ -0,0 +1,1 @@
1306+mysql-bin.000001 1518742
1307
1308=== added file 't/pt-mysql-summary/samples/temp006/mysql-master-status'
1309--- t/pt-mysql-summary/samples/temp006/mysql-master-status 1970-01-01 00:00:00 +0000
1310+++ t/pt-mysql-summary/samples/temp006/mysql-master-status 2012-12-04 16:32:31 +0000
1311@@ -0,0 +1,1 @@
1312+mysql-bin.000001 1518742
1313
1314=== added file 't/pt-mysql-summary/samples/temp006/mysql-plugins'
1315--- t/pt-mysql-summary/samples/temp006/mysql-plugins 1970-01-01 00:00:00 +0000
1316+++ t/pt-mysql-summary/samples/temp006/mysql-plugins 2012-12-04 16:32:31 +0000
1317@@ -0,0 +1,41 @@
1318+binlog ACTIVE STORAGE ENGINE NULL GPL
1319+wsrep ACTIVE STORAGE ENGINE NULL GPL
1320+mysql_native_password ACTIVE AUTHENTICATION NULL GPL
1321+mysql_old_password ACTIVE AUTHENTICATION NULL GPL
1322+MRG_MYISAM ACTIVE STORAGE ENGINE NULL GPL
1323+MyISAM ACTIVE STORAGE ENGINE NULL GPL
1324+MEMORY ACTIVE STORAGE ENGINE NULL GPL
1325+CSV ACTIVE STORAGE ENGINE NULL GPL
1326+PERFORMANCE_SCHEMA ACTIVE STORAGE ENGINE NULL GPL
1327+InnoDB ACTIVE STORAGE ENGINE NULL GPL
1328+INNODB_RSEG ACTIVE INFORMATION SCHEMA NULL GPL
1329+INNODB_UNDO_LOGS ACTIVE INFORMATION SCHEMA NULL GPL
1330+INNODB_TRX ACTIVE INFORMATION SCHEMA NULL GPL
1331+INNODB_LOCKS ACTIVE INFORMATION SCHEMA NULL GPL
1332+INNODB_LOCK_WAITS ACTIVE INFORMATION SCHEMA NULL GPL
1333+INNODB_CMP ACTIVE INFORMATION SCHEMA NULL GPL
1334+INNODB_CMP_RESET ACTIVE INFORMATION SCHEMA NULL GPL
1335+INNODB_CMPMEM ACTIVE INFORMATION SCHEMA NULL GPL
1336+INNODB_CMPMEM_RESET ACTIVE INFORMATION SCHEMA NULL GPL
1337+INNODB_SYS_TABLES ACTIVE INFORMATION SCHEMA NULL GPL
1338+INNODB_SYS_TABLESTATS ACTIVE INFORMATION SCHEMA NULL GPL
1339+INNODB_SYS_INDEXES ACTIVE INFORMATION SCHEMA NULL GPL
1340+INNODB_SYS_COLUMNS ACTIVE INFORMATION SCHEMA NULL GPL
1341+INNODB_SYS_FIELDS ACTIVE INFORMATION SCHEMA NULL GPL
1342+INNODB_SYS_FOREIGN ACTIVE INFORMATION SCHEMA NULL GPL
1343+INNODB_SYS_FOREIGN_COLS ACTIVE INFORMATION SCHEMA NULL GPL
1344+INNODB_SYS_STATS ACTIVE INFORMATION SCHEMA NULL GPL
1345+INNODB_TABLE_STATS ACTIVE INFORMATION SCHEMA NULL GPL
1346+INNODB_INDEX_STATS ACTIVE INFORMATION SCHEMA NULL GPL
1347+INNODB_BUFFER_POOL_PAGES ACTIVE INFORMATION SCHEMA NULL GPL
1348+INNODB_BUFFER_POOL_PAGES_INDEX ACTIVE INFORMATION SCHEMA NULL GPL
1349+INNODB_BUFFER_POOL_PAGES_BLOB ACTIVE INFORMATION SCHEMA NULL GPL
1350+XTRADB_ADMIN_COMMAND ACTIVE INFORMATION SCHEMA NULL GPL
1351+INNODB_CHANGED_PAGES ACTIVE INFORMATION SCHEMA NULL GPL
1352+INNODB_BUFFER_PAGE ACTIVE INFORMATION SCHEMA NULL GPL
1353+INNODB_BUFFER_PAGE_LRU ACTIVE INFORMATION SCHEMA NULL GPL
1354+INNODB_BUFFER_POOL_STATS ACTIVE INFORMATION SCHEMA NULL GPL
1355+BLACKHOLE ACTIVE STORAGE ENGINE NULL GPL
1356+ARCHIVE ACTIVE STORAGE ENGINE NULL GPL
1357+FEDERATED DISABLED STORAGE ENGINE NULL GPL
1358+partition ACTIVE STORAGE ENGINE NULL GPL
1359
1360=== added file 't/pt-mysql-summary/samples/temp006/mysql-processlist'
1361--- t/pt-mysql-summary/samples/temp006/mysql-processlist 1970-01-01 00:00:00 +0000
1362+++ t/pt-mysql-summary/samples/temp006/mysql-processlist 2012-12-04 16:32:31 +0000
1363@@ -0,0 +1,48 @@
1364+*************************** 1. row ***************************
1365+ Id: 1
1366+ User: system user
1367+ Host:
1368+ db: NULL
1369+ Command: Sleep
1370+ Time: 2510
1371+ State: NULL
1372+ Info: NULL
1373+ Rows_sent: 0
1374+Rows_examined: 0
1375+ Rows_read: 1
1376+*************************** 2. row ***************************
1377+ Id: 2
1378+ User: system user
1379+ Host:
1380+ db: NULL
1381+ Command: Sleep
1382+ Time: 2510
1383+ State: wsrep aborter idle
1384+ Info: NULL
1385+ Rows_sent: 0
1386+Rows_examined: 0
1387+ Rows_read: 1
1388+*************************** 3. row ***************************
1389+ Id: 3
1390+ User: system user
1391+ Host:
1392+ db: NULL
1393+ Command: Sleep
1394+ Time: 2507
1395+ State: NULL
1396+ Info: NULL
1397+ Rows_sent: 0
1398+Rows_examined: 0
1399+ Rows_read: 1
1400+*************************** 4. row ***************************
1401+ Id: 206
1402+ User: msandbox
1403+ Host: localhost
1404+ db: NULL
1405+ Command: Query
1406+ Time: 0
1407+ State: sleeping
1408+ Info: SHOW FULL PROCESSLIST
1409+ Rows_sent: 0
1410+Rows_examined: 0
1411+ Rows_read: 1
1412
1413=== added file 't/pt-mysql-summary/samples/temp006/mysql-slave'
1414=== added file 't/pt-mysql-summary/samples/temp006/mysql-status'
1415--- t/pt-mysql-summary/samples/temp006/mysql-status 1970-01-01 00:00:00 +0000
1416+++ t/pt-mysql-summary/samples/temp006/mysql-status 2012-12-04 16:32:31 +0000
1417@@ -0,0 +1,410 @@
1418+Aborted_clients 0
1419+Aborted_connects 0
1420+Binlog_cache_disk_use 1
1421+Binlog_cache_use 4
1422+Binlog_stmt_cache_disk_use 0
1423+Binlog_stmt_cache_use 1
1424+Bytes_received 3315595
1425+Bytes_sent 796598
1426+Com_admin_commands 1
1427+Com_assign_to_keycache 0
1428+Com_alter_db 0
1429+Com_alter_db_upgrade 0
1430+Com_alter_event 0
1431+Com_alter_function 0
1432+Com_alter_procedure 0
1433+Com_alter_server 0
1434+Com_alter_table 2
1435+Com_alter_tablespace 0
1436+Com_analyze 0
1437+Com_begin 1
1438+Com_binlog 0
1439+Com_call_procedure 0
1440+Com_change_db 59
1441+Com_change_master 0
1442+Com_check 0
1443+Com_checksum 1
1444+Com_commit 2
1445+Com_create_db 2
1446+Com_create_event 0
1447+Com_create_function 3
1448+Com_create_index 0
1449+Com_create_procedure 3
1450+Com_create_server 0
1451+Com_create_table 19
1452+Com_create_trigger 6
1453+Com_create_udf 0
1454+Com_create_user 0
1455+Com_create_view 7
1456+Com_dealloc_sql 0
1457+Com_delete 0
1458+Com_delete_multi 0
1459+Com_do 0
1460+Com_drop_db 1
1461+Com_drop_event 0
1462+Com_drop_function 0
1463+Com_drop_index 0
1464+Com_drop_procedure 0
1465+Com_drop_server 0
1466+Com_drop_table 1
1467+Com_drop_trigger 0
1468+Com_drop_user 0
1469+Com_drop_view 0
1470+Com_empty_query 0
1471+Com_execute_sql 0
1472+Com_flush 2
1473+Com_grant 0
1474+Com_ha_close 0
1475+Com_ha_open 0
1476+Com_ha_read 0
1477+Com_help 0
1478+Com_insert 1059
1479+Com_insert_select 0
1480+Com_install_plugin 0
1481+Com_kill 0
1482+Com_load 1
1483+Com_lock_tables 0
1484+Com_optimize 0
1485+Com_preload_keys 0
1486+Com_prepare_sql 0
1487+Com_purge 0
1488+Com_purge_before_date 0
1489+Com_release_savepoint 0
1490+Com_rename_table 0
1491+Com_rename_user 0
1492+Com_repair 0
1493+Com_replace 0
1494+Com_replace_select 0
1495+Com_reset 0
1496+Com_resignal 0
1497+Com_revoke 0
1498+Com_revoke_all 0
1499+Com_rollback 1
1500+Com_rollback_to_savepoint 0
1501+Com_savepoint 0
1502+Com_select 326
1503+Com_set_option 373
1504+Com_signal 0
1505+Com_show_authors 0
1506+Com_show_binlog_events 0
1507+Com_show_binlogs 11
1508+Com_show_charsets 0
1509+Com_show_client_statistics 0
1510+Com_show_collations 0
1511+Com_show_contributors 0
1512+Com_show_create_db 3
1513+Com_show_create_event 0
1514+Com_show_create_func 3
1515+Com_show_create_proc 3
1516+Com_show_create_table 96
1517+Com_show_create_trigger 6
1518+Com_show_databases 13
1519+Com_show_engine_logs 0
1520+Com_show_engine_mutex 0
1521+Com_show_engine_status 12
1522+Com_show_events 0
1523+Com_show_errors 0
1524+Com_show_fields 48
1525+Com_show_function_status 3
1526+Com_show_grants 0
1527+Com_show_index_statistics 0
1528+Com_show_keys 0
1529+Com_show_master_status 11
1530+Com_show_open_tables 0
1531+Com_show_plugins 11
1532+Com_show_privileges 0
1533+Com_show_procedure_status 3
1534+Com_show_processlist 11
1535+Com_show_profile 0
1536+Com_show_profiles 0
1537+Com_show_relaylog_events 0
1538+Com_show_slave_hosts 0
1539+Com_show_slave_status 11
1540+Com_show_slave_status_nolock 0
1541+Com_show_status 18
1542+Com_show_storage_engines 0
1543+Com_show_table_statistics 0
1544+Com_show_table_status 48
1545+Com_show_tables 7
1546+Com_show_temporary_tables 0
1547+Com_show_thread_statistics 0
1548+Com_show_triggers 48
1549+Com_show_user_statistics 0
1550+Com_show_variables 12
1551+Com_show_warnings 0
1552+Com_slave_start 0
1553+Com_slave_stop 0
1554+Com_stmt_close 0
1555+Com_stmt_execute 0
1556+Com_stmt_fetch 0
1557+Com_stmt_prepare 0
1558+Com_stmt_reprepare 0
1559+Com_stmt_reset 0
1560+Com_stmt_send_long_data 0
1561+Com_truncate 0
1562+Com_uninstall_plugin 0
1563+Com_unlock_tables 0
1564+Com_update 1
1565+Com_update_multi 0
1566+Com_xa_commit 0
1567+Com_xa_end 0
1568+Com_xa_prepare 0
1569+Com_xa_recover 0
1570+Com_xa_rollback 0
1571+Com_xa_start 0
1572+Compression OFF
1573+Connections 202
1574+Created_tmp_disk_tables 242
1575+Created_tmp_files 7
1576+Created_tmp_tables 976
1577+Delayed_errors 0
1578+Delayed_insert_threads 0
1579+Delayed_writes 0
1580+Flashcache_enabled OFF
1581+Flush_commands 3
1582+Handler_commit 220
1583+Handler_delete 0
1584+Handler_discover 0
1585+Handler_prepare 183
1586+Handler_read_first 26
1587+Handler_read_key 23
1588+Handler_read_last 0
1589+Handler_read_next 36
1590+Handler_read_prev 0
1591+Handler_read_rnd 0
1592+Handler_read_rnd_next 61902
1593+Handler_rollback 32
1594+Handler_savepoint 0
1595+Handler_savepoint_rollback 0
1596+Handler_update 6
1597+Handler_write 59905
1598+Innodb_adaptive_hash_cells 138337
1599+Innodb_adaptive_hash_heap_buffers 6
1600+Innodb_adaptive_hash_hash_searches 129190
1601+Innodb_adaptive_hash_non_hash_searches 53308
1602+Innodb_background_log_sync 45
1603+Innodb_buffer_pool_pages_data 708
1604+Innodb_buffer_pool_pages_dirty 0
1605+Innodb_buffer_pool_pages_flushed 916
1606+Innodb_buffer_pool_pages_LRU_flushed 0
1607+Innodb_buffer_pool_pages_free 1332
1608+Innodb_buffer_pool_pages_made_not_young 0
1609+Innodb_buffer_pool_pages_made_young 0
1610+Innodb_buffer_pool_pages_misc 7
1611+Innodb_buffer_pool_pages_old 241
1612+Innodb_buffer_pool_pages_total 2047
1613+Innodb_buffer_pool_read_ahead_rnd 0
1614+Innodb_buffer_pool_read_ahead 0
1615+Innodb_buffer_pool_read_ahead_evicted 0
1616+Innodb_buffer_pool_read_requests 447048
1617+Innodb_buffer_pool_reads 0
1618+Innodb_buffer_pool_wait_free 0
1619+Innodb_buffer_pool_write_requests 236593
1620+Innodb_checkpoint_age 0
1621+Innodb_checkpoint_max_age 7782360
1622+Innodb_checkpoint_target_age 7539162
1623+Innodb_data_fsyncs 131
1624+Innodb_data_pending_fsyncs 0
1625+Innodb_data_pending_reads 0
1626+Innodb_data_pending_writes 0
1627+Innodb_data_read 0
1628+Innodb_data_reads 0
1629+Innodb_data_writes 1067
1630+Innodb_data_written 36013056
1631+Innodb_dblwr_pages_written 742
1632+Innodb_dblwr_writes 17
1633+Innodb_deadlocks 0
1634+Innodb_dict_tables 27
1635+Innodb_have_atomic_builtins ON
1636+Innodb_history_list_length 1
1637+Innodb_ibuf_discarded_delete_marks 0
1638+Innodb_ibuf_discarded_deletes 0
1639+Innodb_ibuf_discarded_inserts 0
1640+Innodb_ibuf_free_list 0
1641+Innodb_ibuf_merged_delete_marks 0
1642+Innodb_ibuf_merged_deletes 0
1643+Innodb_ibuf_merged_inserts 0
1644+Innodb_ibuf_merges 0
1645+Innodb_ibuf_segment_size 2
1646+Innodb_ibuf_size 1
1647+Innodb_log_waits 0
1648+Innodb_log_write_requests 18226
1649+Innodb_log_writes 70
1650+Innodb_lsn_current 8809964
1651+Innodb_lsn_flushed 8809964
1652+Innodb_lsn_last_checkpoint 8809964
1653+Innodb_master_thread_1_second_loops 42
1654+Innodb_master_thread_10_second_loops 4
1655+Innodb_master_thread_background_loops 3
1656+Innodb_master_thread_main_flush_loops 3
1657+Innodb_master_thread_sleeps 42
1658+Innodb_max_trx_id 846
1659+Innodb_mem_adaptive_hash 672196
1660+Innodb_mem_dictionary 221035
1661+Innodb_mem_total 34062336
1662+Innodb_mutex_os_waits 6
1663+Innodb_mutex_spin_rounds 271
1664+Innodb_mutex_spin_waits 11
1665+Innodb_oldest_view_low_limit_trx_id 825
1666+Innodb_os_log_fsyncs 93
1667+Innodb_os_log_pending_fsyncs 0
1668+Innodb_os_log_pending_writes 0
1669+Innodb_os_log_written 8836608
1670+Innodb_page_size 16384
1671+Innodb_pages_created 708
1672+Innodb_pages_read 0
1673+Innodb_pages_written 916
1674+Innodb_purge_trx_id 824
1675+Innodb_purge_undo_no 0
1676+Innodb_row_lock_current_waits 0
1677+Innodb_current_row_locks 0
1678+Innodb_row_lock_time 0
1679+Innodb_row_lock_time_avg 0
1680+Innodb_row_lock_time_max 0
1681+Innodb_row_lock_waits 0
1682+Innodb_rows_deleted 0
1683+Innodb_rows_inserted 47315
1684+Innodb_rows_read 47274
1685+Innodb_rows_updated 0
1686+Innodb_s_lock_os_waits 24
1687+Innodb_s_lock_spin_rounds 720
1688+Innodb_s_lock_spin_waits 24
1689+Innodb_truncated_status_writes 0
1690+Innodb_x_lock_os_waits 9
1691+Innodb_x_lock_spin_rounds 270
1692+Innodb_x_lock_spin_waits 0
1693+Key_blocks_not_flushed 0
1694+Key_blocks_unused 14495
1695+Key_blocks_used 2
1696+Key_read_requests 47
1697+Key_reads 1
1698+Key_write_requests 12
1699+Key_writes 12
1700+Last_query_cost 0.000000
1701+Max_used_connections 4
1702+Not_flushed_delayed_rows 0
1703+Open_files 51
1704+Open_streams 0
1705+Open_table_definitions 50
1706+Open_tables 45
1707+Opened_files 1349
1708+Opened_table_definitions 107
1709+Opened_tables 109
1710+Performance_schema_cond_classes_lost 0
1711+Performance_schema_cond_instances_lost 0
1712+Performance_schema_file_classes_lost 0
1713+Performance_schema_file_handles_lost 0
1714+Performance_schema_file_instances_lost 0
1715+Performance_schema_locker_lost 0
1716+Performance_schema_mutex_classes_lost 0
1717+Performance_schema_mutex_instances_lost 0
1718+Performance_schema_rwlock_classes_lost 0
1719+Performance_schema_rwlock_instances_lost 0
1720+Performance_schema_table_handles_lost 0
1721+Performance_schema_table_instances_lost 0
1722+Performance_schema_thread_classes_lost 0
1723+Performance_schema_thread_instances_lost 0
1724+Prepared_stmt_count 0
1725+Qcache_free_blocks 0
1726+Qcache_free_memory 0
1727+Qcache_hits 0
1728+Qcache_inserts 0
1729+Qcache_lowmem_prunes 0
1730+Qcache_not_cached 0
1731+Qcache_queries_in_cache 0
1732+Qcache_total_blocks 0
1733+Queries 2450
1734+Questions 1450
1735+Rpl_status AUTH_MASTER
1736+Select_full_join 0
1737+Select_full_range_join 0
1738+Select_range 0
1739+Select_range_check 0
1740+Select_scan 243
1741+Slave_heartbeat_period 0.000
1742+Slave_open_temp_tables 0
1743+Slave_received_heartbeats 0
1744+Slave_retried_transactions 0
1745+Slave_running OFF
1746+Slow_launch_threads 0
1747+Slow_queries 0
1748+Sort_merge_passes 0
1749+Sort_range 0
1750+Sort_rows 0
1751+Sort_scan 2
1752+Ssl_accept_renegotiates 0
1753+Ssl_accepts 0
1754+Ssl_callback_cache_hits 0
1755+Ssl_cipher
1756+Ssl_cipher_list
1757+Ssl_client_connects 0
1758+Ssl_connect_renegotiates 0
1759+Ssl_ctx_verify_depth 0
1760+Ssl_ctx_verify_mode 0
1761+Ssl_default_timeout 0
1762+Ssl_finished_accepts 0
1763+Ssl_finished_connects 0
1764+Ssl_session_cache_hits 0
1765+Ssl_session_cache_misses 0
1766+Ssl_session_cache_mode NONE
1767+Ssl_session_cache_overflows 0
1768+Ssl_session_cache_size 0
1769+Ssl_session_cache_timeouts 0
1770+Ssl_sessions_reused 0
1771+Ssl_used_session_cache_entries 0
1772+Ssl_verify_depth 0
1773+Ssl_verify_mode 0
1774+Ssl_version
1775+Table_locks_immediate 214
1776+Table_locks_waited 0
1777+Tc_log_max_pages_used 0
1778+Tc_log_page_size 0
1779+Tc_log_page_waits 0
1780+Threads_cached 0
1781+Threads_connected 4
1782+Threads_created 201
1783+Threads_running 1
1784+Uptime 2511
1785+Uptime_since_flush_status 2511
1786+binlog_commits 5
1787+binlog_group_commits 5
1788+wsrep_local_state_uuid 968bdd7e-38cc-11e2-0800-a86d39553d83
1789+wsrep_protocol_version 4
1790+wsrep_last_committed 49
1791+wsrep_replicated 49
1792+wsrep_replicated_bytes 3372882
1793+wsrep_received 11
1794+wsrep_received_bytes 658
1795+wsrep_local_commits 4
1796+wsrep_local_cert_failures 0
1797+wsrep_local_bf_aborts 0
1798+wsrep_local_replays 0
1799+wsrep_local_send_queue 0
1800+wsrep_local_send_queue_avg 0.000000
1801+wsrep_local_recv_queue 0
1802+wsrep_local_recv_queue_avg 0.000000
1803+wsrep_flow_control_paused 0.000000
1804+wsrep_flow_control_sent 0
1805+wsrep_flow_control_recv 0
1806+wsrep_cert_deps_distance 1.000000
1807+wsrep_apply_oooe 0.000000
1808+wsrep_apply_oool 0.000000
1809+wsrep_apply_window 0.000000
1810+wsrep_commit_oooe 0.000000
1811+wsrep_commit_oool 0.000000
1812+wsrep_commit_window 0.000000
1813+wsrep_local_state 4
1814+wsrep_local_state_comment Synced
1815+wsrep_cert_index_size 73966
1816+wsrep_causal_reads 0
1817+wsrep_incoming_addresses 192.168.0.100,192.168.0.100,192.168.0.100
1818+wsrep_cluster_conf_id 3
1819+wsrep_cluster_size 3
1820+wsrep_cluster_state_uuid 968bdd7e-38cc-11e2-0800-a86d39553d83
1821+wsrep_cluster_status Primary
1822+wsrep_connected ON
1823+wsrep_local_index 0
1824+wsrep_provider_name Galera
1825+wsrep_provider_vendor Codership Oy <info@codership.com>
1826+wsrep_provider_version 2.2(r137)
1827+wsrep_ready ON
1828
1829=== added file 't/pt-mysql-summary/samples/temp006/mysql-status-defer'
1830--- t/pt-mysql-summary/samples/temp006/mysql-status-defer 1970-01-01 00:00:00 +0000
1831+++ t/pt-mysql-summary/samples/temp006/mysql-status-defer 2012-12-04 16:32:31 +0000
1832@@ -0,0 +1,410 @@
1833+Aborted_clients 0 0
1834+Aborted_connects 0 0
1835+Binlog_cache_disk_use 1 1
1836+Binlog_cache_use 4 4
1837+Binlog_stmt_cache_disk_use 0 0
1838+Binlog_stmt_cache_use 1 1
1839+Bytes_received 3315595 3317884
1840+Bytes_sent 796598 821862
1841+Com_admin_commands 1 1
1842+Com_assign_to_keycache 0 0
1843+Com_alter_db 0 0
1844+Com_alter_db_upgrade 0 0
1845+Com_alter_event 0 0
1846+Com_alter_function 0 0
1847+Com_alter_procedure 0 0
1848+Com_alter_server 0 0
1849+Com_alter_table 2 2
1850+Com_alter_tablespace 0 0
1851+Com_analyze 0 0
1852+Com_begin 1 1
1853+Com_binlog 0 0
1854+Com_call_procedure 0 0
1855+Com_change_db 59 59
1856+Com_change_master 0 0
1857+Com_check 0 0
1858+Com_checksum 1 1
1859+Com_commit 2 2
1860+Com_create_db 2 2
1861+Com_create_event 0 0
1862+Com_create_function 3 3
1863+Com_create_index 0 0
1864+Com_create_procedure 3 3
1865+Com_create_server 0 0
1866+Com_create_table 19 19
1867+Com_create_trigger 6 6
1868+Com_create_udf 0 0
1869+Com_create_user 0 0
1870+Com_create_view 7 7
1871+Com_dealloc_sql 0 0
1872+Com_delete 0 0
1873+Com_delete_multi 0 0
1874+Com_do 0 0
1875+Com_drop_db 1 1
1876+Com_drop_event 0 0
1877+Com_drop_function 0 0
1878+Com_drop_index 0 0
1879+Com_drop_procedure 0 0
1880+Com_drop_server 0 0
1881+Com_drop_table 1 1
1882+Com_drop_trigger 0 0
1883+Com_drop_user 0 0
1884+Com_drop_view 0 0
1885+Com_empty_query 0 0
1886+Com_execute_sql 0 0
1887+Com_flush 2 2
1888+Com_grant 0 0
1889+Com_ha_close 0 0
1890+Com_ha_open 0 0
1891+Com_ha_read 0 0
1892+Com_help 0 0
1893+Com_insert 1059 1059
1894+Com_insert_select 0 0
1895+Com_install_plugin 0 0
1896+Com_kill 0 0
1897+Com_load 1 1
1898+Com_lock_tables 0 0
1899+Com_optimize 0 0
1900+Com_preload_keys 0 0
1901+Com_prepare_sql 0 0
1902+Com_purge 0 0
1903+Com_purge_before_date 0 0
1904+Com_release_savepoint 0 0
1905+Com_rename_table 0 0
1906+Com_rename_user 0 0
1907+Com_repair 0 0
1908+Com_replace 0 0
1909+Com_replace_select 0 0
1910+Com_reset 0 0
1911+Com_resignal 0 0
1912+Com_revoke 0 0
1913+Com_revoke_all 0 0
1914+Com_rollback 1 1
1915+Com_rollback_to_savepoint 0 0
1916+Com_savepoint 0 0
1917+Com_select 326 345
1918+Com_set_option 373 373
1919+Com_signal 0 0
1920+Com_show_authors 0 0
1921+Com_show_binlog_events 0 0
1922+Com_show_binlogs 11 12
1923+Com_show_charsets 0 0
1924+Com_show_client_statistics 0 0
1925+Com_show_collations 0 0
1926+Com_show_contributors 0 0
1927+Com_show_create_db 3 3
1928+Com_show_create_event 0 0
1929+Com_show_create_func 3 3
1930+Com_show_create_proc 3 3
1931+Com_show_create_table 96 96
1932+Com_show_create_trigger 6 6
1933+Com_show_databases 13 14
1934+Com_show_engine_logs 0 0
1935+Com_show_engine_mutex 0 0
1936+Com_show_engine_status 12 13
1937+Com_show_events 0 0
1938+Com_show_errors 0 0
1939+Com_show_fields 48 48
1940+Com_show_function_status 3 3
1941+Com_show_grants 0 0
1942+Com_show_index_statistics 0 0
1943+Com_show_keys 0 0
1944+Com_show_master_status 11 12
1945+Com_show_open_tables 0 0
1946+Com_show_plugins 11 12
1947+Com_show_privileges 0 0
1948+Com_show_procedure_status 3 3
1949+Com_show_processlist 11 12
1950+Com_show_profile 0 0
1951+Com_show_profiles 0 0
1952+Com_show_relaylog_events 0 0
1953+Com_show_slave_hosts 0 0
1954+Com_show_slave_status 11 12
1955+Com_show_slave_status_nolock 0 0
1956+Com_show_status 18 19
1957+Com_show_storage_engines 0 0
1958+Com_show_table_statistics 0 0
1959+Com_show_table_status 48 48
1960+Com_show_tables 7 7
1961+Com_show_temporary_tables 0 0
1962+Com_show_thread_statistics 0 0
1963+Com_show_triggers 48 48
1964+Com_show_user_statistics 0 0
1965+Com_show_variables 12 12
1966+Com_show_warnings 0 0
1967+Com_slave_start 0 0
1968+Com_slave_stop 0 0
1969+Com_stmt_close 0 0
1970+Com_stmt_execute 0 0
1971+Com_stmt_fetch 0 0
1972+Com_stmt_prepare 0 0
1973+Com_stmt_reprepare 0 0
1974+Com_stmt_reset 0 0
1975+Com_stmt_send_long_data 0 0
1976+Com_truncate 0 0
1977+Com_uninstall_plugin 0 0
1978+Com_unlock_tables 0 0
1979+Com_update 1 1
1980+Com_update_multi 0 0
1981+Com_xa_commit 0 0
1982+Com_xa_end 0 0
1983+Com_xa_prepare 0 0
1984+Com_xa_recover 0 0
1985+Com_xa_rollback 0 0
1986+Com_xa_start 0 0
1987+Compression OFF OFF
1988+Connections 202 216
1989+Created_tmp_disk_tables 242 253
1990+Created_tmp_files 7 7
1991+Created_tmp_tables 976 1045
1992+Delayed_errors 0 0
1993+Delayed_insert_threads 0 0
1994+Delayed_writes 0 0
1995+Flashcache_enabled OFF OFF
1996+Flush_commands 3 3
1997+Handler_commit 220 220
1998+Handler_delete 0 0
1999+Handler_discover 0 0
2000+Handler_prepare 183 183
2001+Handler_read_first 26 26
2002+Handler_read_key 23 23
2003+Handler_read_last 0 0
2004+Handler_read_next 36 36
2005+Handler_read_prev 0 0
2006+Handler_read_rnd 0 0
2007+Handler_read_rnd_next 61902 62371
2008+Handler_rollback 32 32
2009+Handler_savepoint 0 0
2010+Handler_savepoint_rollback 0 0
2011+Handler_update 6 6
2012+Handler_write 59905 60367
2013+Innodb_adaptive_hash_cells 138337 138337
2014+Innodb_adaptive_hash_heap_buffers 6 6
2015+Innodb_adaptive_hash_hash_searches 129190 129190
2016+Innodb_adaptive_hash_non_hash_searches 53308 53308
2017+Innodb_background_log_sync 45 45
2018+Innodb_buffer_pool_pages_data 708 708
2019+Innodb_buffer_pool_pages_dirty 0 0
2020+Innodb_buffer_pool_pages_flushed 916 916
2021+Innodb_buffer_pool_pages_LRU_flushed 0 0
2022+Innodb_buffer_pool_pages_free 1332 1332
2023+Innodb_buffer_pool_pages_made_not_young 0 0
2024+Innodb_buffer_pool_pages_made_young 0 0
2025+Innodb_buffer_pool_pages_misc 7 7
2026+Innodb_buffer_pool_pages_old 241 241
2027+Innodb_buffer_pool_pages_total 2047 2047
2028+Innodb_buffer_pool_read_ahead_rnd 0 0
2029+Innodb_buffer_pool_read_ahead 0 0
2030+Innodb_buffer_pool_read_ahead_evicted 0 0
2031+Innodb_buffer_pool_read_requests 447048 447048
2032+Innodb_buffer_pool_reads 0 0
2033+Innodb_buffer_pool_wait_free 0 0
2034+Innodb_buffer_pool_write_requests 236593 236593
2035+Innodb_checkpoint_age 0 0
2036+Innodb_checkpoint_max_age 7782360 7782360
2037+Innodb_checkpoint_target_age 7539162 7539162
2038+Innodb_data_fsyncs 131 131
2039+Innodb_data_pending_fsyncs 0 0
2040+Innodb_data_pending_reads 0 0
2041+Innodb_data_pending_writes 0 0
2042+Innodb_data_read 0 0
2043+Innodb_data_reads 0 0
2044+Innodb_data_writes 1067 1067
2045+Innodb_data_written 36013056 36013056
2046+Innodb_dblwr_pages_written 742 742
2047+Innodb_dblwr_writes 17 17
2048+Innodb_deadlocks 0 0
2049+Innodb_dict_tables 27 27
2050+Innodb_have_atomic_builtins ON ON
2051+Innodb_history_list_length 1 1
2052+Innodb_ibuf_discarded_delete_marks 0 0
2053+Innodb_ibuf_discarded_deletes 0 0
2054+Innodb_ibuf_discarded_inserts 0 0
2055+Innodb_ibuf_free_list 0 0
2056+Innodb_ibuf_merged_delete_marks 0 0
2057+Innodb_ibuf_merged_deletes 0 0
2058+Innodb_ibuf_merged_inserts 0 0
2059+Innodb_ibuf_merges 0 0
2060+Innodb_ibuf_segment_size 2 2
2061+Innodb_ibuf_size 1 1
2062+Innodb_log_waits 0 0
2063+Innodb_log_write_requests 18226 18226
2064+Innodb_log_writes 70 70
2065+Innodb_lsn_current 8809964 8809964
2066+Innodb_lsn_flushed 8809964 8809964
2067+Innodb_lsn_last_checkpoint 8809964 8809964
2068+Innodb_master_thread_1_second_loops 42 42
2069+Innodb_master_thread_10_second_loops 4 4
2070+Innodb_master_thread_background_loops 3 3
2071+Innodb_master_thread_main_flush_loops 3 3
2072+Innodb_master_thread_sleeps 42 42
2073+Innodb_max_trx_id 846 846
2074+Innodb_mem_adaptive_hash 672196 672196
2075+Innodb_mem_dictionary 221035 221035
2076+Innodb_mem_total 34062336 34062336
2077+Innodb_mutex_os_waits 6 6
2078+Innodb_mutex_spin_rounds 271 271
2079+Innodb_mutex_spin_waits 11 11
2080+Innodb_oldest_view_low_limit_trx_id 825 825
2081+Innodb_os_log_fsyncs 93 93
2082+Innodb_os_log_pending_fsyncs 0 0
2083+Innodb_os_log_pending_writes 0 0
2084+Innodb_os_log_written 8836608 8836608
2085+Innodb_page_size 16384 16384
2086+Innodb_pages_created 708 708
2087+Innodb_pages_read 0 0
2088+Innodb_pages_written 916 916
2089+Innodb_purge_trx_id 824 824
2090+Innodb_purge_undo_no 0 0
2091+Innodb_row_lock_current_waits 0 0
2092+Innodb_current_row_locks 0 0
2093+Innodb_row_lock_time 0 0
2094+Innodb_row_lock_time_avg 0 0
2095+Innodb_row_lock_time_max 0 0
2096+Innodb_row_lock_waits 0 0
2097+Innodb_rows_deleted 0 0
2098+Innodb_rows_inserted 47315 47315
2099+Innodb_rows_read 47274 47274
2100+Innodb_rows_updated 0 0
2101+Innodb_s_lock_os_waits 24 24
2102+Innodb_s_lock_spin_rounds 720 720
2103+Innodb_s_lock_spin_waits 24 24
2104+Innodb_truncated_status_writes 0 0
2105+Innodb_x_lock_os_waits 9 9
2106+Innodb_x_lock_spin_rounds 270 270
2107+Innodb_x_lock_spin_waits 0 0
2108+Key_blocks_not_flushed 0 0
2109+Key_blocks_unused 14495 14495
2110+Key_blocks_used 2 2
2111+Key_read_requests 47 47
2112+Key_reads 1 1
2113+Key_write_requests 12 12
2114+Key_writes 12 12
2115+Last_query_cost 0.000000 0.000000
2116+Max_used_connections 4 4
2117+Not_flushed_delayed_rows 0 0
2118+Open_files 51 51
2119+Open_streams 0 0
2120+Open_table_definitions 50 50
2121+Open_tables 45 45
2122+Opened_files 1349 1397
2123+Opened_table_definitions 107 107
2124+Opened_tables 109 109
2125+Performance_schema_cond_classes_lost 0 0
2126+Performance_schema_cond_instances_lost 0 0
2127+Performance_schema_file_classes_lost 0 0
2128+Performance_schema_file_handles_lost 0 0
2129+Performance_schema_file_instances_lost 0 0
2130+Performance_schema_locker_lost 0 0
2131+Performance_schema_mutex_classes_lost 0 0
2132+Performance_schema_mutex_instances_lost 0 0
2133+Performance_schema_rwlock_classes_lost 0 0
2134+Performance_schema_rwlock_instances_lost 0 0
2135+Performance_schema_table_handles_lost 0 0
2136+Performance_schema_table_instances_lost 0 0
2137+Performance_schema_thread_classes_lost 0 0
2138+Performance_schema_thread_instances_lost 0 0
2139+Prepared_stmt_count 0 0
2140+Qcache_free_blocks 0 0
2141+Qcache_free_memory 0 0
2142+Qcache_hits 0 0
2143+Qcache_inserts 0 0
2144+Qcache_lowmem_prunes 0 0
2145+Qcache_not_cached 0 0
2146+Qcache_queries_in_cache 0 0
2147+Qcache_total_blocks 0 0
2148+Queries 2450 2492
2149+Questions 1450 1492
2150+Rpl_status AUTH_MASTER AUTH_MASTER
2151+Select_full_join 0 0
2152+Select_full_range_join 0 0
2153+Select_range 0 0
2154+Select_range_check 0 0
2155+Select_scan 243 248
2156+Slave_heartbeat_period 0.000 0.000
2157+Slave_open_temp_tables 0 0
2158+Slave_received_heartbeats 0 0
2159+Slave_retried_transactions 0 0
2160+Slave_running OFF OFF
2161+Slow_launch_threads 0 0
2162+Slow_queries 0 0
2163+Sort_merge_passes 0 0
2164+Sort_range 0 0
2165+Sort_rows 0 0
2166+Sort_scan 2 2
2167+Ssl_accept_renegotiates 0 0
2168+Ssl_accepts 0 0
2169+Ssl_callback_cache_hits 0 0
2170+Ssl_cipher
2171+Ssl_cipher_list
2172+Ssl_client_connects 0 0
2173+Ssl_connect_renegotiates 0 0
2174+Ssl_ctx_verify_depth 0 0
2175+Ssl_ctx_verify_mode 0 0
2176+Ssl_default_timeout 0 0
2177+Ssl_finished_accepts 0 0
2178+Ssl_finished_connects 0 0
2179+Ssl_session_cache_hits 0 0
2180+Ssl_session_cache_misses 0 0
2181+Ssl_session_cache_mode NONE NONE
2182+Ssl_session_cache_overflows 0 0
2183+Ssl_session_cache_size 0 0
2184+Ssl_session_cache_timeouts 0 0
2185+Ssl_sessions_reused 0 0
2186+Ssl_used_session_cache_entries 0 0
2187+Ssl_verify_depth 0 0
2188+Ssl_verify_mode 0 0
2189+Ssl_version
2190+Table_locks_immediate 214 215
2191+Table_locks_waited 0 0
2192+Tc_log_max_pages_used 0 0
2193+Tc_log_page_size 0 0
2194+Tc_log_page_waits 0 0
2195+Threads_cached 0 0
2196+Threads_connected 4 4
2197+Threads_created 201 215
2198+Threads_running 1 1
2199+Uptime 2511 2521
2200+Uptime_since_flush_status 2511 2521
2201+binlog_commits 5 5
2202+binlog_group_commits 5 5
2203+wsrep_local_state_uuid 968bdd7e-38cc-11e2-0800-a86d39553d83 968bdd7e-38cc-11e2-0800-a86d39553d83
2204+wsrep_protocol_version 4 4
2205+wsrep_last_committed 49 49
2206+wsrep_replicated 49 49
2207+wsrep_replicated_bytes 3372882 3372882
2208+wsrep_received 11 11
2209+wsrep_received_bytes 658 658
2210+wsrep_local_commits 4 4
2211+wsrep_local_cert_failures 0 0
2212+wsrep_local_bf_aborts 0 0
2213+wsrep_local_replays 0 0
2214+wsrep_local_send_queue 0 0
2215+wsrep_local_send_queue_avg 0.000000 0.000000
2216+wsrep_local_recv_queue 0 0
2217+wsrep_local_recv_queue_avg 0.000000 0.000000
2218+wsrep_flow_control_paused 0.000000 0.000000
2219+wsrep_flow_control_sent 0 0
2220+wsrep_flow_control_recv 0 0
2221+wsrep_cert_deps_distance 1.000000 1.000000
2222+wsrep_apply_oooe 0.000000 0.000000
2223+wsrep_apply_oool 0.000000 0.000000
2224+wsrep_apply_window 0.000000 0.000000
2225+wsrep_commit_oooe 0.000000 0.000000
2226+wsrep_commit_oool 0.000000 0.000000
2227+wsrep_commit_window 0.000000 0.000000
2228+wsrep_local_state 4 4
2229+wsrep_local_state_comment Synced Synced
2230+wsrep_cert_index_size 73966 73966
2231+wsrep_causal_reads 0 0
2232+wsrep_incoming_addresses 192.168.0.100,192.168.0.100,192.168.0.100 192.168.0.100,192.168.0.100,192.168.0.100
2233+wsrep_cluster_conf_id 3 3
2234+wsrep_cluster_size 3 3
2235+wsrep_cluster_state_uuid 968bdd7e-38cc-11e2-0800-a86d39553d83 968bdd7e-38cc-11e2-0800-a86d39553d83
2236+wsrep_cluster_status Primary Primary
2237+wsrep_connected ON ON
2238+wsrep_local_index 0 0
2239+wsrep_provider_name Galera Galera
2240+wsrep_provider_vendor Codership Oy <info@codership.com> Codership Oy <info@codership.com>
2241+wsrep_provider_version 2.2(r137) 2.2(r137)
2242+wsrep_ready ON ON
2243
2244=== added file 't/pt-mysql-summary/samples/temp006/mysql-users'
2245--- t/pt-mysql-summary/samples/temp006/mysql-users 1970-01-01 00:00:00 +0000
2246+++ t/pt-mysql-summary/samples/temp006/mysql-users 2012-12-04 16:32:31 +0000
2247@@ -0,0 +1,1 @@
2248+2 0 0 0
2249
2250=== added file 't/pt-mysql-summary/samples/temp006/mysql-variables'
2251--- t/pt-mysql-summary/samples/temp006/mysql-variables 1970-01-01 00:00:00 +0000
2252+++ t/pt-mysql-summary/samples/temp006/mysql-variables 2012-12-04 16:32:31 +0000
2253@@ -0,0 +1,422 @@
2254+auto_increment_increment 3
2255+auto_increment_offset 1
2256+autocommit ON
2257+automatic_sp_privileges ON
2258+back_log 50
2259+basedir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686
2260+big_tables OFF
2261+binlog_cache_size 32768
2262+binlog_direct_non_transactional_updates OFF
2263+binlog_format ROW
2264+binlog_stmt_cache_size 32768
2265+bulk_insert_buffer_size 8388608
2266+character_set_client latin1
2267+character_set_connection latin1
2268+character_set_database latin1
2269+character_set_filesystem binary
2270+character_set_results latin1
2271+character_set_server latin1
2272+character_set_system utf8
2273+character_sets_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/share/charsets/
2274+collation_connection latin1_swedish_ci
2275+collation_database latin1_swedish_ci
2276+collation_server latin1_swedish_ci
2277+completion_type NO_CHAIN
2278+concurrent_insert AUTO
2279+connect_timeout 10
2280+datadir /tmp/12345/data/
2281+date_format %Y-%m-%d
2282+datetime_format %Y-%m-%d %H:%i:%s
2283+default_storage_engine InnoDB
2284+default_week_format 0
2285+delay_key_write ON
2286+delayed_insert_limit 100
2287+delayed_insert_timeout 300
2288+delayed_queue_size 1000
2289+div_precision_increment 4
2290+enforce_storage_engine
2291+engine_condition_pushdown ON
2292+event_scheduler OFF
2293+expand_fast_index_creation OFF
2294+expire_logs_days 0
2295+fast_index_creation ON
2296+flush OFF
2297+flush_time 0
2298+foreign_key_checks ON
2299+ft_boolean_syntax + -><()~*:""&|
2300+ft_max_word_len 84
2301+ft_min_word_len 4
2302+ft_query_expansion_limit 20
2303+ft_stopword_file (built-in)
2304+general_log ON
2305+general_log_file genlog
2306+group_concat_max_len 1024
2307+have_compress YES
2308+have_crypt YES
2309+have_csv YES
2310+have_dynamic_loading YES
2311+have_flashcache YES
2312+have_geometry YES
2313+have_innodb YES
2314+have_ndbcluster NO
2315+have_openssl DISABLED
2316+have_partitioning YES
2317+have_profiling YES
2318+have_query_cache YES
2319+have_response_time_distribution YES
2320+have_rtree_keys YES
2321+have_ssl DISABLED
2322+have_symlink YES
2323+hostname hugmeir
2324+ignore_builtin_innodb OFF
2325+init_connect
2326+init_file
2327+init_slave
2328+innodb_adaptive_flushing ON
2329+innodb_adaptive_flushing_method estimate
2330+innodb_adaptive_hash_index ON
2331+innodb_adaptive_hash_index_partitions 1
2332+innodb_additional_mem_pool_size 8388608
2333+innodb_autoextend_increment 8
2334+innodb_autoinc_lock_mode 2
2335+innodb_blocking_buffer_pool_restore OFF
2336+innodb_buffer_pool_instances 1
2337+innodb_buffer_pool_populate OFF
2338+innodb_buffer_pool_restore_at_startup 0
2339+innodb_buffer_pool_shm_checksum ON
2340+innodb_buffer_pool_shm_key 0
2341+innodb_buffer_pool_size 33554432
2342+innodb_change_buffering all
2343+innodb_changed_pages_limit 1000000
2344+innodb_checkpoint_age_target 0
2345+innodb_checksums ON
2346+innodb_commit_concurrency 0
2347+innodb_concurrency_tickets 500
2348+innodb_corrupt_table_action assert
2349+innodb_data_file_path ibdata1:10M:autoextend
2350+innodb_data_home_dir /tmp/12345/data
2351+innodb_dict_size_limit 0
2352+innodb_disallow_writes OFF
2353+innodb_doublewrite ON
2354+innodb_doublewrite_file
2355+innodb_fake_changes OFF
2356+innodb_fast_checksum OFF
2357+innodb_fast_shutdown 1
2358+innodb_file_format Antelope
2359+innodb_file_format_check ON
2360+innodb_file_format_max Antelope
2361+innodb_file_per_table OFF
2362+innodb_flush_log_at_trx_commit 1
2363+innodb_flush_method
2364+innodb_flush_neighbor_pages area
2365+innodb_force_load_corrupted OFF
2366+innodb_force_recovery 0
2367+innodb_ibuf_accel_rate 100
2368+innodb_ibuf_active_contract 1
2369+innodb_ibuf_max_size 16760832
2370+innodb_import_table_from_xtrabackup 0
2371+innodb_io_capacity 200
2372+innodb_kill_idle_transaction 0
2373+innodb_large_prefix OFF
2374+innodb_lazy_drop_table 0
2375+innodb_lock_wait_timeout 3
2376+innodb_locks_unsafe_for_binlog ON
2377+innodb_log_block_size 512
2378+innodb_log_buffer_size 8388608
2379+innodb_log_file_size 5242880
2380+innodb_log_files_in_group 2
2381+innodb_log_group_home_dir /tmp/12345/data
2382+innodb_max_dirty_pages_pct 75
2383+innodb_max_purge_lag 0
2384+innodb_merge_sort_block_size 1048576
2385+innodb_mirrored_log_groups 1
2386+innodb_old_blocks_pct 37
2387+innodb_old_blocks_time 0
2388+innodb_open_files 300
2389+innodb_page_size 16384
2390+innodb_purge_batch_size 20
2391+innodb_purge_threads 1
2392+innodb_random_read_ahead OFF
2393+innodb_read_ahead linear
2394+innodb_read_ahead_threshold 56
2395+innodb_read_io_threads 4
2396+innodb_recovery_stats OFF
2397+innodb_recovery_update_relay_log OFF
2398+innodb_replication_delay 0
2399+innodb_rollback_on_timeout OFF
2400+innodb_rollback_segments 128
2401+innodb_show_locks_held 10
2402+innodb_show_verbose_locks 0
2403+innodb_spin_wait_delay 6
2404+innodb_stats_auto_update 1
2405+innodb_stats_method nulls_equal
2406+innodb_stats_on_metadata ON
2407+innodb_stats_sample_pages 8
2408+innodb_stats_update_need_lock 1
2409+innodb_strict_mode OFF
2410+innodb_support_xa ON
2411+innodb_sync_spin_loops 30
2412+innodb_table_locks ON
2413+innodb_thread_concurrency 0
2414+innodb_thread_concurrency_timer_based OFF
2415+innodb_thread_sleep_delay 10000
2416+innodb_track_changed_pages OFF
2417+innodb_use_global_flush_log_at_trx_commit ON
2418+innodb_use_native_aio ON
2419+innodb_use_sys_malloc ON
2420+innodb_use_sys_stats_table OFF
2421+innodb_version 1.1.8-rel29.1
2422+innodb_write_io_threads 4
2423+interactive_timeout 28800
2424+join_buffer_size 131072
2425+keep_files_on_create OFF
2426+key_buffer_size 16777216
2427+key_cache_age_threshold 300
2428+key_cache_block_size 1024
2429+key_cache_division_limit 100
2430+large_files_support ON
2431+large_page_size 0
2432+large_pages OFF
2433+lc_messages en_US
2434+lc_messages_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/share/
2435+lc_time_names en_US
2436+license GPL
2437+local_infile ON
2438+lock_wait_timeout 31536000
2439+locked_in_memory OFF
2440+log ON
2441+log_bin ON
2442+log_bin_trust_function_creators OFF
2443+log_error /tmp/12345/data/mysqld.log
2444+log_output FILE
2445+log_queries_not_using_indexes OFF
2446+log_slave_updates ON
2447+log_slow_admin_statements OFF
2448+log_slow_filter
2449+log_slow_queries OFF
2450+log_slow_rate_limit 1
2451+log_slow_rate_type session
2452+log_slow_slave_statements OFF
2453+log_slow_sp_statements ON
2454+log_slow_verbosity
2455+log_warnings 1
2456+log_warnings_suppress
2457+long_query_time 10.000000
2458+low_priority_updates OFF
2459+lower_case_file_system OFF
2460+lower_case_table_names 0
2461+max_allowed_packet 1048576
2462+max_binlog_cache_size 18446744073709547520
2463+max_binlog_files 0
2464+max_binlog_size 1073741824
2465+max_binlog_stmt_cache_size 18446744073709547520
2466+max_connect_errors 10
2467+max_connections 151
2468+max_delayed_threads 20
2469+max_error_count 64
2470+max_heap_table_size 16777216
2471+max_insert_delayed_threads 20
2472+max_join_size 18446744073709551615
2473+max_length_for_sort_data 1024
2474+max_long_data_size 1048576
2475+max_prepared_stmt_count 16382
2476+max_relay_log_size 0
2477+max_seeks_for_key 4294967295
2478+max_sort_length 1024
2479+max_sp_recursion_depth 0
2480+max_tmp_tables 32
2481+max_user_connections 0
2482+max_write_lock_count 4294967295
2483+metadata_locks_cache_size 1024
2484+min_examined_row_limit 0
2485+multi_range_count 256
2486+myisam_data_pointer_size 6
2487+myisam_max_sort_file_size 2146435072
2488+myisam_mmap_size 4294967295
2489+myisam_recover_options OFF
2490+myisam_repair_threads 1
2491+myisam_sort_buffer_size 8388608
2492+myisam_stats_method nulls_unequal
2493+myisam_use_mmap OFF
2494+net_buffer_length 16384
2495+net_read_timeout 30
2496+net_retry_count 10
2497+net_write_timeout 60
2498+new OFF
2499+old OFF
2500+old_alter_table OFF
2501+old_passwords OFF
2502+open_files_limit 1024
2503+optimizer_fix ON
2504+optimizer_prune_level 1
2505+optimizer_search_depth 62
2506+optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
2507+performance_schema OFF
2508+performance_schema_events_waits_history_long_size 10000
2509+performance_schema_events_waits_history_size 10
2510+performance_schema_max_cond_classes 80
2511+performance_schema_max_cond_instances 1000
2512+performance_schema_max_file_classes 50
2513+performance_schema_max_file_handles 32768
2514+performance_schema_max_file_instances 10000
2515+performance_schema_max_mutex_classes 200
2516+performance_schema_max_mutex_instances 1000000
2517+performance_schema_max_rwlock_classes 30
2518+performance_schema_max_rwlock_instances 1000000
2519+performance_schema_max_table_handles 100000
2520+performance_schema_max_table_instances 50000
2521+performance_schema_max_thread_classes 50
2522+performance_schema_max_thread_instances 1000
2523+pid_file /tmp/12345/data/mysql_sandbox12345.pid
2524+plugin_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/lib/mysql/plugin/
2525+port 12345
2526+preload_buffer_size 32768
2527+profiling OFF
2528+profiling_history_size 15
2529+protocol_version 10
2530+query_alloc_block_size 8192
2531+query_cache_limit 1048576
2532+query_cache_min_res_unit 4096
2533+query_cache_size 0
2534+query_cache_strip_comments OFF
2535+query_cache_type ON
2536+query_cache_wlock_invalidate OFF
2537+query_prealloc_size 8192
2538+query_response_time_range_base 10
2539+query_response_time_stats OFF
2540+range_alloc_block_size 4096
2541+read_buffer_size 131072
2542+read_only OFF
2543+read_rnd_buffer_size 262144
2544+relay_log mysql-relay-bin
2545+relay_log_index
2546+relay_log_info_file relay-log.info
2547+relay_log_purge ON
2548+relay_log_recovery OFF
2549+relay_log_space_limit 0
2550+report_host 127.0.0.1
2551+report_password
2552+report_port 12345
2553+report_user
2554+rpl_recovery_rank 0
2555+secure_auth OFF
2556+secure_file_priv
2557+server_id 12345
2558+skip_external_locking ON
2559+skip_name_resolve OFF
2560+skip_networking OFF
2561+skip_show_database OFF
2562+slave_compressed_protocol OFF
2563+slave_exec_mode STRICT
2564+slave_load_tmpdir /tmp
2565+slave_max_allowed_packet 1073741824
2566+slave_net_timeout 3600
2567+slave_skip_errors OFF
2568+slave_transaction_retries 10
2569+slave_type_conversions
2570+slow_launch_time 2
2571+slow_query_log OFF
2572+slow_query_log_file /tmp/12345/data/hugmeir-slow.log
2573+slow_query_log_timestamp_always OFF
2574+slow_query_log_timestamp_precision second
2575+slow_query_log_use_global_control
2576+socket /tmp/12345/mysql_sandbox12345.sock
2577+sort_buffer_size 2097152
2578+sql_auto_is_null OFF
2579+sql_big_selects ON
2580+sql_big_tables OFF
2581+sql_buffer_result OFF
2582+sql_log_bin ON
2583+sql_log_off OFF
2584+sql_low_priority_updates OFF
2585+sql_max_join_size 18446744073709551615
2586+sql_mode
2587+sql_notes ON
2588+sql_quote_show_create ON
2589+sql_safe_updates OFF
2590+sql_select_limit 18446744073709551615
2591+sql_slave_skip_counter 0
2592+sql_warnings OFF
2593+ssl_ca
2594+ssl_capath
2595+ssl_cert
2596+ssl_cipher
2597+ssl_key
2598+storage_engine InnoDB
2599+stored_program_cache 256
2600+sync_binlog 0
2601+sync_frm ON
2602+sync_master_info 0
2603+sync_relay_log 0
2604+sync_relay_log_info 0
2605+system_time_zone ART
2606+table_definition_cache 400
2607+table_open_cache 400
2608+thread_cache_size 0
2609+thread_concurrency 10
2610+thread_handling one-thread-per-connection
2611+thread_stack 196608
2612+thread_statistics OFF
2613+time_format %H:%i:%s
2614+time_zone SYSTEM
2615+timed_mutexes OFF
2616+tmp_table_size 16777216
2617+tmpdir /tmp
2618+transaction_alloc_block_size 8192
2619+transaction_prealloc_size 4096
2620+tx_isolation REPEATABLE-READ
2621+unique_checks ON
2622+updatable_views_with_limit YES
2623+userstat OFF
2624+version 5.5.28-23.7-log
2625+version_comment Percona XtraDB Cluster (GPL) 5.5.28-23.7, Revision 373, wsrep_23.7.r3821
2626+version_compile_machine i686
2627+version_compile_os Linux
2628+wait_timeout 28800
2629+wsrep_OSU_method TOI
2630+wsrep_auto_increment_control ON
2631+wsrep_causal_reads OFF
2632+wsrep_certify_nonPK ON
2633+wsrep_cluster_address gcomm://
2634+wsrep_cluster_name pt_sandbox_cluster
2635+wsrep_convert_LOCK_to_trx OFF
2636+wsrep_data_home_dir /tmp/12345/data/
2637+wsrep_dbug_option
2638+wsrep_debug OFF
2639+wsrep_drupal_282555_workaround OFF
2640+wsrep_forced_binlog_format NONE
2641+wsrep_log_conflicts OFF
2642+wsrep_max_ws_rows 131072
2643+wsrep_max_ws_size 1073741824
2644+wsrep_mysql_replication_bundle 0
2645+wsrep_node_address
2646+wsrep_node_incoming_address 192.168.0.100
2647+wsrep_node_name 12345
2648+wsrep_notify_cmd
2649+wsrep_on ON
2650+wsrep_provider /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/lib/libgalera_smm.so
2651+wsrep_provider_options base_host = 192.168.122.1; base_port = 12355; cert.log_conflicts = no; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = PT5M; gcache.dir = /tmp/12345/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /tmp/12345/data//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 2147483647; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://192.168.0.100:12355; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 192.168.122.1; pc.checksum = true; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT2S; pc.npvo = false; pc.version = 0; protonet.backend = asio; protonet.version = 0; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
2652+wsrep_recover OFF
2653+wsrep_replicate_myisam ON
2654+wsrep_retry_autocommit 1
2655+wsrep_slave_threads 2
2656+wsrep_sst_auth
2657+wsrep_sst_donor
2658+wsrep_sst_donor_rejects_queries OFF
2659+wsrep_sst_method rsync
2660+wsrep_sst_receive_address 192.168.0.100:12365
2661+wsrep_start_position 00000000-0000-0000-0000-000000000000:-1
2662+internal::nice_of_32578 0
2663+internal::oom_of_32578 0
2664+internal::nice_of_32419 0
2665+internal::oom_of_32419 0
2666+internal::nice_of_32324 0
2667+internal::oom_of_32324 0
2668+pt-summary-internal-pid_file_exists 1
2669+pt-summary-internal-current_time 2012-11-27 16:56
2670+pt-summary-internal-Config_File_path
2671+pt-summary-internal-mysql_executable /usr/bin/mysql
2672+pt-summary-internal-now 2012-11-27 17:38:42
2673+pt-summary-internal-user msandbox@%
2674+pt-summary-internal-FNV_64 Unknown
2675+pt-summary-internal-trigger_count 6
2676
2677=== added file 't/pt-mysql-summary/samples/temp006/mysqld-executables'
2678=== added file 't/pt-mysql-summary/samples/temp006/mysqld-instances'
2679--- t/pt-mysql-summary/samples/temp006/mysqld-instances 1970-01-01 00:00:00 +0000
2680+++ t/pt-mysql-summary/samples/temp006/mysqld-instances 2012-12-04 16:32:31 +0000
2681@@ -0,0 +1,4 @@
2682+ PID TTY STAT TIME COMMAND
2683+32324 pts/6 Sl 0:25 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12345/my.sandbox.cnf
2684+32419 pts/6 Sl 0:18 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12346/my.sandbox.cnf
2685+32578 pts/6 Sl 0:18 /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/bin/mysqld --defaults-file=/tmp/12347/my.sandbox.cnf
2686
2687=== added file 't/pt-mysql-summary/samples/temp006/mysqldump'
2688--- t/pt-mysql-summary/samples/temp006/mysqldump 1970-01-01 00:00:00 +0000
2689+++ t/pt-mysql-summary/samples/temp006/mysqldump 2012-12-04 16:32:31 +0000
2690@@ -0,0 +1,1128 @@
2691+
2692+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;
2693+
2694+USE `mysql`;
2695+/*!40101 SET @saved_cs_client = @@character_set_client */;
2696+/*!40101 SET character_set_client = utf8 */;
2697+CREATE TABLE `columns_priv` (
2698+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2699+ `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2700+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2701+ `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2702+ `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2703+ `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2704+ `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
2705+ PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
2706+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
2707+/*!40101 SET character_set_client = @saved_cs_client */;
2708+/*!40101 SET @saved_cs_client = @@character_set_client */;
2709+/*!40101 SET character_set_client = utf8 */;
2710+CREATE TABLE `db` (
2711+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2712+ `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2713+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2714+ `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2715+ `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2716+ `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2717+ `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2718+ `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2719+ `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2720+ `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2721+ `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2722+ `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2723+ `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2724+ `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2725+ `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2726+ `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2727+ `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2728+ `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2729+ `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2730+ `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2731+ `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2732+ `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2733+ PRIMARY KEY (`Host`,`Db`,`User`),
2734+ KEY `User` (`User`)
2735+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';
2736+/*!40101 SET character_set_client = @saved_cs_client */;
2737+/*!40101 SET @saved_cs_client = @@character_set_client */;
2738+/*!40101 SET character_set_client = utf8 */;
2739+CREATE TABLE `event` (
2740+ `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2741+ `name` char(64) NOT NULL DEFAULT '',
2742+ `body` longblob NOT NULL,
2743+ `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2744+ `execute_at` datetime DEFAULT NULL,
2745+ `interval_value` int(11) DEFAULT NULL,
2746+ `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,
2747+ `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2748+ `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
2749+ `last_executed` datetime DEFAULT NULL,
2750+ `starts` datetime DEFAULT NULL,
2751+ `ends` datetime DEFAULT NULL,
2752+ `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
2753+ `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
2754+ `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
2755+ `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2756+ `originator` int(10) unsigned NOT NULL,
2757+ `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
2758+ `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2759+ `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2760+ `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2761+ `body_utf8` longblob,
2762+ PRIMARY KEY (`db`,`name`)
2763+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';
2764+/*!40101 SET character_set_client = @saved_cs_client */;
2765+/*!40101 SET @saved_cs_client = @@character_set_client */;
2766+/*!40101 SET character_set_client = utf8 */;
2767+CREATE TABLE `func` (
2768+ `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2769+ `ret` tinyint(1) NOT NULL DEFAULT '0',
2770+ `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
2771+ `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
2772+ PRIMARY KEY (`name`)
2773+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';
2774+/*!40101 SET character_set_client = @saved_cs_client */;
2775+/*!40101 SET @saved_cs_client = @@character_set_client */;
2776+/*!40101 SET character_set_client = utf8 */;
2777+CREATE TABLE `help_category` (
2778+ `help_category_id` smallint(5) unsigned NOT NULL,
2779+ `name` char(64) NOT NULL,
2780+ `parent_category_id` smallint(5) unsigned DEFAULT NULL,
2781+ `url` char(128) NOT NULL,
2782+ PRIMARY KEY (`help_category_id`),
2783+ UNIQUE KEY `name` (`name`)
2784+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories';
2785+/*!40101 SET character_set_client = @saved_cs_client */;
2786+/*!40101 SET @saved_cs_client = @@character_set_client */;
2787+/*!40101 SET character_set_client = utf8 */;
2788+CREATE TABLE `help_keyword` (
2789+ `help_keyword_id` int(10) unsigned NOT NULL,
2790+ `name` char(64) NOT NULL,
2791+ PRIMARY KEY (`help_keyword_id`),
2792+ UNIQUE KEY `name` (`name`)
2793+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords';
2794+/*!40101 SET character_set_client = @saved_cs_client */;
2795+/*!40101 SET @saved_cs_client = @@character_set_client */;
2796+/*!40101 SET character_set_client = utf8 */;
2797+CREATE TABLE `help_relation` (
2798+ `help_topic_id` int(10) unsigned NOT NULL,
2799+ `help_keyword_id` int(10) unsigned NOT NULL,
2800+ PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
2801+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation';
2802+/*!40101 SET character_set_client = @saved_cs_client */;
2803+/*!40101 SET @saved_cs_client = @@character_set_client */;
2804+/*!40101 SET character_set_client = utf8 */;
2805+CREATE TABLE `help_topic` (
2806+ `help_topic_id` int(10) unsigned NOT NULL,
2807+ `name` char(64) NOT NULL,
2808+ `help_category_id` smallint(5) unsigned NOT NULL,
2809+ `description` text NOT NULL,
2810+ `example` text NOT NULL,
2811+ `url` char(128) NOT NULL,
2812+ PRIMARY KEY (`help_topic_id`),
2813+ UNIQUE KEY `name` (`name`)
2814+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics';
2815+/*!40101 SET character_set_client = @saved_cs_client */;
2816+/*!40101 SET @saved_cs_client = @@character_set_client */;
2817+/*!40101 SET character_set_client = utf8 */;
2818+CREATE TABLE `host` (
2819+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2820+ `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2821+ `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2822+ `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2823+ `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2824+ `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2825+ `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2826+ `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2827+ `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2828+ `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2829+ `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2830+ `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2831+ `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2832+ `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2833+ `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2834+ `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2835+ `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2836+ `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2837+ `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2838+ `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2839+ PRIMARY KEY (`Host`,`Db`)
2840+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges';
2841+/*!40101 SET character_set_client = @saved_cs_client */;
2842+/*!40101 SET @saved_cs_client = @@character_set_client */;
2843+/*!40101 SET character_set_client = utf8 */;
2844+CREATE TABLE `ndb_binlog_index` (
2845+ `Position` bigint(20) unsigned NOT NULL,
2846+ `File` varchar(255) NOT NULL,
2847+ `epoch` bigint(20) unsigned NOT NULL,
2848+ `inserts` bigint(20) unsigned NOT NULL,
2849+ `updates` bigint(20) unsigned NOT NULL,
2850+ `deletes` bigint(20) unsigned NOT NULL,
2851+ `schemaops` bigint(20) unsigned NOT NULL,
2852+ PRIMARY KEY (`epoch`)
2853+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2854+/*!40101 SET character_set_client = @saved_cs_client */;
2855+/*!40101 SET @saved_cs_client = @@character_set_client */;
2856+/*!40101 SET character_set_client = utf8 */;
2857+CREATE TABLE `plugin` (
2858+ `name` varchar(64) NOT NULL DEFAULT '',
2859+ `dl` varchar(128) NOT NULL DEFAULT '',
2860+ PRIMARY KEY (`name`)
2861+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins';
2862+/*!40101 SET character_set_client = @saved_cs_client */;
2863+/*!40101 SET @saved_cs_client = @@character_set_client */;
2864+/*!40101 SET character_set_client = utf8 */;
2865+CREATE TABLE `proc` (
2866+ `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2867+ `name` char(64) NOT NULL DEFAULT '',
2868+ `type` enum('FUNCTION','PROCEDURE') NOT NULL,
2869+ `specific_name` char(64) NOT NULL DEFAULT '',
2870+ `language` enum('SQL') NOT NULL DEFAULT 'SQL',
2871+ `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
2872+ `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
2873+ `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
2874+ `param_list` blob NOT NULL,
2875+ `returns` longblob NOT NULL,
2876+ `body` longblob NOT NULL,
2877+ `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2878+ `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2879+ `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
2880+ `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
2881+ `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
2882+ `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2883+ `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2884+ `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2885+ `body_utf8` longblob,
2886+ PRIMARY KEY (`db`,`name`,`type`)
2887+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';
2888+/*!40101 SET character_set_client = @saved_cs_client */;
2889+/*!40101 SET @saved_cs_client = @@character_set_client */;
2890+/*!40101 SET character_set_client = utf8 */;
2891+CREATE TABLE `procs_priv` (
2892+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2893+ `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2894+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2895+ `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
2896+ `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
2897+ `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
2898+ `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
2899+ `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2900+ PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
2901+ KEY `Grantor` (`Grantor`)
2902+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';
2903+/*!40101 SET character_set_client = @saved_cs_client */;
2904+/*!40101 SET @saved_cs_client = @@character_set_client */;
2905+/*!40101 SET character_set_client = utf8 */;
2906+CREATE TABLE `proxies_priv` (
2907+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2908+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2909+ `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2910+ `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2911+ `With_grant` tinyint(1) NOT NULL DEFAULT '0',
2912+ `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
2913+ `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2914+ PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
2915+ KEY `Grantor` (`Grantor`)
2916+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';
2917+/*!40101 SET character_set_client = @saved_cs_client */;
2918+/*!40101 SET @saved_cs_client = @@character_set_client */;
2919+/*!40101 SET character_set_client = utf8 */;
2920+CREATE TABLE `servers` (
2921+ `Server_name` char(64) NOT NULL DEFAULT '',
2922+ `Host` char(64) NOT NULL DEFAULT '',
2923+ `Db` char(64) NOT NULL DEFAULT '',
2924+ `Username` char(64) NOT NULL DEFAULT '',
2925+ `Password` char(64) NOT NULL DEFAULT '',
2926+ `Port` int(4) NOT NULL DEFAULT '0',
2927+ `Socket` char(64) NOT NULL DEFAULT '',
2928+ `Wrapper` char(64) NOT NULL DEFAULT '',
2929+ `Owner` char(64) NOT NULL DEFAULT '',
2930+ PRIMARY KEY (`Server_name`)
2931+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
2932+/*!40101 SET character_set_client = @saved_cs_client */;
2933+/*!40101 SET @saved_cs_client = @@character_set_client */;
2934+/*!40101 SET character_set_client = utf8 */;
2935+CREATE TABLE `tables_priv` (
2936+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2937+ `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2938+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2939+ `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2940+ `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
2941+ `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2942+ `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
2943+ `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
2944+ PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
2945+ KEY `Grantor` (`Grantor`)
2946+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';
2947+/*!40101 SET character_set_client = @saved_cs_client */;
2948+/*!40101 SET @saved_cs_client = @@character_set_client */;
2949+/*!40101 SET character_set_client = utf8 */;
2950+CREATE TABLE `time_zone` (
2951+ `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2952+ `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
2953+ PRIMARY KEY (`Time_zone_id`)
2954+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';
2955+/*!40101 SET character_set_client = @saved_cs_client */;
2956+/*!40101 SET @saved_cs_client = @@character_set_client */;
2957+/*!40101 SET character_set_client = utf8 */;
2958+CREATE TABLE `time_zone_leap_second` (
2959+ `Transition_time` bigint(20) NOT NULL,
2960+ `Correction` int(11) NOT NULL,
2961+ PRIMARY KEY (`Transition_time`)
2962+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';
2963+/*!40101 SET character_set_client = @saved_cs_client */;
2964+/*!40101 SET @saved_cs_client = @@character_set_client */;
2965+/*!40101 SET character_set_client = utf8 */;
2966+CREATE TABLE `time_zone_name` (
2967+ `Name` char(64) NOT NULL,
2968+ `Time_zone_id` int(10) unsigned NOT NULL,
2969+ PRIMARY KEY (`Name`)
2970+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';
2971+/*!40101 SET character_set_client = @saved_cs_client */;
2972+/*!40101 SET @saved_cs_client = @@character_set_client */;
2973+/*!40101 SET character_set_client = utf8 */;
2974+CREATE TABLE `time_zone_transition` (
2975+ `Time_zone_id` int(10) unsigned NOT NULL,
2976+ `Transition_time` bigint(20) NOT NULL,
2977+ `Transition_type_id` int(10) unsigned NOT NULL,
2978+ PRIMARY KEY (`Time_zone_id`,`Transition_time`)
2979+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';
2980+/*!40101 SET character_set_client = @saved_cs_client */;
2981+/*!40101 SET @saved_cs_client = @@character_set_client */;
2982+/*!40101 SET character_set_client = utf8 */;
2983+CREATE TABLE `time_zone_transition_type` (
2984+ `Time_zone_id` int(10) unsigned NOT NULL,
2985+ `Transition_type_id` int(10) unsigned NOT NULL,
2986+ `Offset` int(11) NOT NULL DEFAULT '0',
2987+ `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
2988+ `Abbreviation` char(8) NOT NULL DEFAULT '',
2989+ PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
2990+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';
2991+/*!40101 SET character_set_client = @saved_cs_client */;
2992+/*!40101 SET @saved_cs_client = @@character_set_client */;
2993+/*!40101 SET character_set_client = utf8 */;
2994+CREATE TABLE `user` (
2995+ `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2996+ `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2997+ `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
2998+ `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2999+ `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3000+ `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3001+ `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3002+ `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3003+ `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3004+ `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3005+ `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3006+ `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3007+ `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3008+ `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3009+ `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3010+ `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3011+ `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3012+ `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3013+ `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3014+ `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3015+ `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3016+ `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3017+ `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3018+ `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3019+ `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3020+ `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3021+ `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3022+ `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3023+ `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3024+ `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3025+ `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3026+ `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3027+ `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
3028+ `ssl_cipher` blob NOT NULL,
3029+ `x509_issuer` blob NOT NULL,
3030+ `x509_subject` blob NOT NULL,
3031+ `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
3032+ `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
3033+ `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
3034+ `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
3035+ `plugin` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
3036+ `authentication_string` text COLLATE utf8_bin NOT NULL,
3037+ PRIMARY KEY (`Host`,`User`)
3038+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
3039+/*!40101 SET character_set_client = @saved_cs_client */;
3040+
3041+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `percona_test` /*!40100 DEFAULT CHARACTER SET latin1 */;
3042+
3043+USE `percona_test`;
3044+/*!40101 SET @saved_cs_client = @@character_set_client */;
3045+/*!40101 SET character_set_client = utf8 */;
3046+CREATE TABLE `checksums` (
3047+ `db_tbl` varchar(128) NOT NULL,
3048+ `checksum` int(10) unsigned NOT NULL,
3049+ PRIMARY KEY (`db_tbl`)
3050+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3051+/*!40101 SET character_set_client = @saved_cs_client */;
3052+/*!40101 SET @saved_cs_client = @@character_set_client */;
3053+/*!40101 SET character_set_client = utf8 */;
3054+CREATE TABLE `load_data` (
3055+ `i` int(11) DEFAULT NULL
3056+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3057+/*!40101 SET character_set_client = @saved_cs_client */;
3058+/*!40101 SET @saved_cs_client = @@character_set_client */;
3059+/*!40101 SET character_set_client = utf8 */;
3060+CREATE TABLE `sentinel` (
3061+ `id` int(11) NOT NULL,
3062+ `ping` varchar(64) NOT NULL DEFAULT '',
3063+ PRIMARY KEY (`id`)
3064+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3065+/*!40101 SET character_set_client = @saved_cs_client */;
3066+
3067+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sakila` /*!40100 DEFAULT CHARACTER SET latin1 */;
3068+
3069+USE `sakila`;
3070+/*!40101 SET @saved_cs_client = @@character_set_client */;
3071+/*!40101 SET character_set_client = utf8 */;
3072+CREATE TABLE `actor` (
3073+ `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3074+ `first_name` varchar(45) NOT NULL,
3075+ `last_name` varchar(45) NOT NULL,
3076+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3077+ PRIMARY KEY (`actor_id`),
3078+ KEY `idx_actor_last_name` (`last_name`)
3079+) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8;
3080+/*!40101 SET character_set_client = @saved_cs_client */;
3081+SET @saved_cs_client = @@character_set_client;
3082+SET character_set_client = utf8;
3083+/*!50001 CREATE TABLE `actor_info` (
3084+ `actor_id` smallint(5) unsigned,
3085+ `first_name` varchar(45),
3086+ `last_name` varchar(45),
3087+ `film_info` text
3088+) ENGINE=MyISAM */;
3089+SET character_set_client = @saved_cs_client;
3090+/*!40101 SET @saved_cs_client = @@character_set_client */;
3091+/*!40101 SET character_set_client = utf8 */;
3092+CREATE TABLE `address` (
3093+ `address_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3094+ `address` varchar(50) NOT NULL,
3095+ `address2` varchar(50) DEFAULT NULL,
3096+ `district` varchar(20) NOT NULL,
3097+ `city_id` smallint(5) unsigned NOT NULL,
3098+ `postal_code` varchar(10) DEFAULT NULL,
3099+ `phone` varchar(20) NOT NULL,
3100+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3101+ PRIMARY KEY (`address_id`),
3102+ KEY `idx_fk_city_id` (`city_id`),
3103+ CONSTRAINT `fk_address_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON UPDATE CASCADE
3104+) ENGINE=InnoDB AUTO_INCREMENT=606 DEFAULT CHARSET=utf8;
3105+/*!40101 SET character_set_client = @saved_cs_client */;
3106+/*!40101 SET @saved_cs_client = @@character_set_client */;
3107+/*!40101 SET character_set_client = utf8 */;
3108+CREATE TABLE `category` (
3109+ `category_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
3110+ `name` varchar(25) NOT NULL,
3111+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3112+ PRIMARY KEY (`category_id`)
3113+) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
3114+/*!40101 SET character_set_client = @saved_cs_client */;
3115+/*!40101 SET @saved_cs_client = @@character_set_client */;
3116+/*!40101 SET character_set_client = utf8 */;
3117+CREATE TABLE `city` (
3118+ `city_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3119+ `city` varchar(50) NOT NULL,
3120+ `country_id` smallint(5) unsigned NOT NULL,
3121+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3122+ PRIMARY KEY (`city_id`),
3123+ KEY `idx_fk_country_id` (`country_id`),
3124+ CONSTRAINT `fk_city_country` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`) ON UPDATE CASCADE
3125+) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=utf8;
3126+/*!40101 SET character_set_client = @saved_cs_client */;
3127+/*!40101 SET @saved_cs_client = @@character_set_client */;
3128+/*!40101 SET character_set_client = utf8 */;
3129+CREATE TABLE `country` (
3130+ `country_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3131+ `country` varchar(50) NOT NULL,
3132+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3133+ PRIMARY KEY (`country_id`)
3134+) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8;
3135+/*!40101 SET character_set_client = @saved_cs_client */;
3136+/*!40101 SET @saved_cs_client = @@character_set_client */;
3137+/*!40101 SET character_set_client = utf8 */;
3138+CREATE TABLE `customer` (
3139+ `customer_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3140+ `store_id` tinyint(3) unsigned NOT NULL,
3141+ `first_name` varchar(45) NOT NULL,
3142+ `last_name` varchar(45) NOT NULL,
3143+ `email` varchar(50) DEFAULT NULL,
3144+ `address_id` smallint(5) unsigned NOT NULL,
3145+ `active` tinyint(1) NOT NULL DEFAULT '1',
3146+ `create_date` datetime NOT NULL,
3147+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3148+ PRIMARY KEY (`customer_id`),
3149+ KEY `idx_fk_store_id` (`store_id`),
3150+ KEY `idx_fk_address_id` (`address_id`),
3151+ KEY `idx_last_name` (`last_name`),
3152+ CONSTRAINT `fk_customer_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON UPDATE CASCADE,
3153+ CONSTRAINT `fk_customer_store` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON UPDATE CASCADE
3154+) ENGINE=InnoDB AUTO_INCREMENT=600 DEFAULT CHARSET=utf8;
3155+/*!40101 SET character_set_client = @saved_cs_client */;
3156+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3157+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3158+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3159+/*!50003 SET character_set_client = utf8 */ ;
3160+/*!50003 SET character_set_results = utf8 */ ;
3161+/*!50003 SET collation_connection = utf8_general_ci */ ;
3162+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3163+/*!50003 SET sql_mode = '' */ ;
3164+DELIMITER ;;
3165+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER customer_create_date BEFORE INSERT ON customer
3166+ FOR EACH ROW SET NEW.create_date = NOW() */;;
3167+DELIMITER ;
3168+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3169+/*!50003 SET character_set_client = @saved_cs_client */ ;
3170+/*!50003 SET character_set_results = @saved_cs_results */ ;
3171+/*!50003 SET collation_connection = @saved_col_connection */ ;
3172+SET @saved_cs_client = @@character_set_client;
3173+SET character_set_client = utf8;
3174+/*!50001 CREATE TABLE `customer_list` (
3175+ `ID` smallint(5) unsigned,
3176+ `name` varchar(91),
3177+ `address` varchar(50),
3178+ `zip code` varchar(10),
3179+ `phone` varchar(20),
3180+ `city` varchar(50),
3181+ `country` varchar(50),
3182+ `notes` varchar(6),
3183+ `SID` tinyint(3) unsigned
3184+) ENGINE=MyISAM */;
3185+SET character_set_client = @saved_cs_client;
3186+/*!40101 SET @saved_cs_client = @@character_set_client */;
3187+/*!40101 SET character_set_client = utf8 */;
3188+CREATE TABLE `film` (
3189+ `film_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3190+ `title` varchar(255) NOT NULL,
3191+ `description` text,
3192+ `release_year` year(4) DEFAULT NULL,
3193+ `language_id` tinyint(3) unsigned NOT NULL,
3194+ `original_language_id` tinyint(3) unsigned DEFAULT NULL,
3195+ `rental_duration` tinyint(3) unsigned NOT NULL DEFAULT '3',
3196+ `rental_rate` decimal(4,2) NOT NULL DEFAULT '4.99',
3197+ `length` smallint(5) unsigned DEFAULT NULL,
3198+ `replacement_cost` decimal(5,2) NOT NULL DEFAULT '19.99',
3199+ `rating` enum('G','PG','PG-13','R','NC-17') DEFAULT 'G',
3200+ `special_features` set('Trailers','Commentaries','Deleted Scenes','Behind the Scenes') DEFAULT NULL,
3201+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3202+ PRIMARY KEY (`film_id`),
3203+ KEY `idx_title` (`title`),
3204+ KEY `idx_fk_language_id` (`language_id`),
3205+ KEY `idx_fk_original_language_id` (`original_language_id`),
3206+ CONSTRAINT `fk_film_language` FOREIGN KEY (`language_id`) REFERENCES `language` (`language_id`) ON UPDATE CASCADE,
3207+ CONSTRAINT `fk_film_language_original` FOREIGN KEY (`original_language_id`) REFERENCES `language` (`language_id`) ON UPDATE CASCADE
3208+) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;
3209+/*!40101 SET character_set_client = @saved_cs_client */;
3210+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3211+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3212+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3213+/*!50003 SET character_set_client = utf8 */ ;
3214+/*!50003 SET character_set_results = utf8 */ ;
3215+/*!50003 SET collation_connection = utf8_general_ci */ ;
3216+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3217+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3218+DELIMITER ;;
3219+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW BEGIN
3220+ INSERT INTO film_text (film_id, title, description)
3221+ VALUES (new.film_id, new.title, new.description);
3222+ END */;;
3223+DELIMITER ;
3224+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3225+/*!50003 SET character_set_client = @saved_cs_client */ ;
3226+/*!50003 SET character_set_results = @saved_cs_results */ ;
3227+/*!50003 SET collation_connection = @saved_col_connection */ ;
3228+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3229+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3230+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3231+/*!50003 SET character_set_client = utf8 */ ;
3232+/*!50003 SET character_set_results = utf8 */ ;
3233+/*!50003 SET collation_connection = utf8_general_ci */ ;
3234+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3235+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3236+DELIMITER ;;
3237+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER `upd_film` AFTER UPDATE ON `film` FOR EACH ROW BEGIN
3238+ IF (old.title != new.title) or (old.description != new.description)
3239+ THEN
3240+ UPDATE film_text
3241+ SET title=new.title,
3242+ description=new.description,
3243+ film_id=new.film_id
3244+ WHERE film_id=old.film_id;
3245+ END IF;
3246+ END */;;
3247+DELIMITER ;
3248+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3249+/*!50003 SET character_set_client = @saved_cs_client */ ;
3250+/*!50003 SET character_set_results = @saved_cs_results */ ;
3251+/*!50003 SET collation_connection = @saved_col_connection */ ;
3252+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3253+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3254+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3255+/*!50003 SET character_set_client = utf8 */ ;
3256+/*!50003 SET character_set_results = utf8 */ ;
3257+/*!50003 SET collation_connection = utf8_general_ci */ ;
3258+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3259+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3260+DELIMITER ;;
3261+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER `del_film` AFTER DELETE ON `film` FOR EACH ROW BEGIN
3262+ DELETE FROM film_text WHERE film_id = old.film_id;
3263+ END */;;
3264+DELIMITER ;
3265+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3266+/*!50003 SET character_set_client = @saved_cs_client */ ;
3267+/*!50003 SET character_set_results = @saved_cs_results */ ;
3268+/*!50003 SET collation_connection = @saved_col_connection */ ;
3269+/*!40101 SET @saved_cs_client = @@character_set_client */;
3270+/*!40101 SET character_set_client = utf8 */;
3271+CREATE TABLE `film_actor` (
3272+ `actor_id` smallint(5) unsigned NOT NULL,
3273+ `film_id` smallint(5) unsigned NOT NULL,
3274+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3275+ PRIMARY KEY (`actor_id`,`film_id`),
3276+ KEY `idx_fk_film_id` (`film_id`),
3277+ CONSTRAINT `fk_film_actor_actor` FOREIGN KEY (`actor_id`) REFERENCES `actor` (`actor_id`) ON UPDATE CASCADE,
3278+ CONSTRAINT `fk_film_actor_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE
3279+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3280+/*!40101 SET character_set_client = @saved_cs_client */;
3281+/*!40101 SET @saved_cs_client = @@character_set_client */;
3282+/*!40101 SET character_set_client = utf8 */;
3283+CREATE TABLE `film_category` (
3284+ `film_id` smallint(5) unsigned NOT NULL,
3285+ `category_id` tinyint(3) unsigned NOT NULL,
3286+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3287+ PRIMARY KEY (`film_id`,`category_id`),
3288+ KEY `fk_film_category_category` (`category_id`),
3289+ CONSTRAINT `fk_film_category_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE,
3290+ CONSTRAINT `fk_film_category_category` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ON UPDATE CASCADE
3291+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3292+/*!40101 SET character_set_client = @saved_cs_client */;
3293+SET @saved_cs_client = @@character_set_client;
3294+SET character_set_client = utf8;
3295+/*!50001 CREATE TABLE `film_list` (
3296+ `FID` smallint(5) unsigned,
3297+ `title` varchar(255),
3298+ `description` text,
3299+ `category` varchar(25),
3300+ `price` decimal(4,2),
3301+ `length` smallint(5) unsigned,
3302+ `rating` enum('G','PG','PG-13','R','NC-17'),
3303+ `actors` text
3304+) ENGINE=MyISAM */;
3305+SET character_set_client = @saved_cs_client;
3306+/*!40101 SET @saved_cs_client = @@character_set_client */;
3307+/*!40101 SET character_set_client = utf8 */;
3308+CREATE TABLE `film_text` (
3309+ `film_id` smallint(6) NOT NULL,
3310+ `title` varchar(255) NOT NULL,
3311+ `description` text,
3312+ PRIMARY KEY (`film_id`)
3313+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3314+/*!40101 SET character_set_client = @saved_cs_client */;
3315+/*!40101 SET @saved_cs_client = @@character_set_client */;
3316+/*!40101 SET character_set_client = utf8 */;
3317+CREATE TABLE `inventory` (
3318+ `inventory_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
3319+ `film_id` smallint(5) unsigned NOT NULL,
3320+ `store_id` tinyint(3) unsigned NOT NULL,
3321+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3322+ PRIMARY KEY (`inventory_id`),
3323+ KEY `idx_fk_film_id` (`film_id`),
3324+ KEY `idx_store_id_film_id` (`store_id`,`film_id`),
3325+ CONSTRAINT `fk_inventory_store` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON UPDATE CASCADE,
3326+ CONSTRAINT `fk_inventory_film` FOREIGN KEY (`film_id`) REFERENCES `film` (`film_id`) ON UPDATE CASCADE
3327+) ENGINE=InnoDB AUTO_INCREMENT=4582 DEFAULT CHARSET=utf8;
3328+/*!40101 SET character_set_client = @saved_cs_client */;
3329+/*!40101 SET @saved_cs_client = @@character_set_client */;
3330+/*!40101 SET character_set_client = utf8 */;
3331+CREATE TABLE `language` (
3332+ `language_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
3333+ `name` char(20) NOT NULL,
3334+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3335+ PRIMARY KEY (`language_id`)
3336+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
3337+/*!40101 SET character_set_client = @saved_cs_client */;
3338+SET @saved_cs_client = @@character_set_client;
3339+SET character_set_client = utf8;
3340+/*!50001 CREATE TABLE `nicer_but_slower_film_list` (
3341+ `FID` smallint(5) unsigned,
3342+ `title` varchar(255),
3343+ `description` text,
3344+ `category` varchar(25),
3345+ `price` decimal(4,2),
3346+ `length` smallint(5) unsigned,
3347+ `rating` enum('G','PG','PG-13','R','NC-17'),
3348+ `actors` text
3349+) ENGINE=MyISAM */;
3350+SET character_set_client = @saved_cs_client;
3351+/*!40101 SET @saved_cs_client = @@character_set_client */;
3352+/*!40101 SET character_set_client = utf8 */;
3353+CREATE TABLE `payment` (
3354+ `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3355+ `customer_id` smallint(5) unsigned NOT NULL,
3356+ `staff_id` tinyint(3) unsigned NOT NULL,
3357+ `rental_id` int(11) DEFAULT NULL,
3358+ `amount` decimal(5,2) NOT NULL,
3359+ `payment_date` datetime NOT NULL,
3360+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3361+ PRIMARY KEY (`payment_id`),
3362+ KEY `idx_fk_staff_id` (`staff_id`),
3363+ KEY `idx_fk_customer_id` (`customer_id`),
3364+ KEY `fk_payment_rental` (`rental_id`),
3365+ CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE,
3366+ CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE,
3367+ CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE
3368+) ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8;
3369+/*!40101 SET character_set_client = @saved_cs_client */;
3370+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3371+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3372+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3373+/*!50003 SET character_set_client = utf8 */ ;
3374+/*!50003 SET character_set_results = utf8 */ ;
3375+/*!50003 SET collation_connection = utf8_general_ci */ ;
3376+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3377+/*!50003 SET sql_mode = '' */ ;
3378+DELIMITER ;;
3379+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER payment_date BEFORE INSERT ON payment
3380+ FOR EACH ROW SET NEW.payment_date = NOW() */;;
3381+DELIMITER ;
3382+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3383+/*!50003 SET character_set_client = @saved_cs_client */ ;
3384+/*!50003 SET character_set_results = @saved_cs_results */ ;
3385+/*!50003 SET collation_connection = @saved_col_connection */ ;
3386+/*!40101 SET @saved_cs_client = @@character_set_client */;
3387+/*!40101 SET character_set_client = utf8 */;
3388+CREATE TABLE `rental` (
3389+ `rental_id` int(11) NOT NULL AUTO_INCREMENT,
3390+ `rental_date` datetime NOT NULL,
3391+ `inventory_id` mediumint(8) unsigned NOT NULL,
3392+ `customer_id` smallint(5) unsigned NOT NULL,
3393+ `return_date` datetime DEFAULT NULL,
3394+ `staff_id` tinyint(3) unsigned NOT NULL,
3395+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3396+ PRIMARY KEY (`rental_id`),
3397+ UNIQUE KEY `rental_date` (`rental_date`,`inventory_id`,`customer_id`),
3398+ KEY `idx_fk_inventory_id` (`inventory_id`),
3399+ KEY `idx_fk_customer_id` (`customer_id`),
3400+ KEY `idx_fk_staff_id` (`staff_id`),
3401+ CONSTRAINT `fk_rental_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE,
3402+ CONSTRAINT `fk_rental_inventory` FOREIGN KEY (`inventory_id`) REFERENCES `inventory` (`inventory_id`) ON UPDATE CASCADE,
3403+ CONSTRAINT `fk_rental_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE
3404+) ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8;
3405+/*!40101 SET character_set_client = @saved_cs_client */;
3406+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3407+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3408+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3409+/*!50003 SET character_set_client = utf8 */ ;
3410+/*!50003 SET character_set_results = utf8 */ ;
3411+/*!50003 SET collation_connection = utf8_general_ci */ ;
3412+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3413+/*!50003 SET sql_mode = '' */ ;
3414+DELIMITER ;;
3415+/*!50003 CREATE*/ /*!50017 DEFINER=`msandbox`@`%`*/ /*!50003 TRIGGER rental_date BEFORE INSERT ON rental
3416+ FOR EACH ROW SET NEW.rental_date = NOW() */;;
3417+DELIMITER ;
3418+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3419+/*!50003 SET character_set_client = @saved_cs_client */ ;
3420+/*!50003 SET character_set_results = @saved_cs_results */ ;
3421+/*!50003 SET collation_connection = @saved_col_connection */ ;
3422+SET @saved_cs_client = @@character_set_client;
3423+SET character_set_client = utf8;
3424+/*!50001 CREATE TABLE `sales_by_film_category` (
3425+ `category` varchar(25),
3426+ `total_sales` decimal(27,2)
3427+) ENGINE=MyISAM */;
3428+SET character_set_client = @saved_cs_client;
3429+SET @saved_cs_client = @@character_set_client;
3430+SET character_set_client = utf8;
3431+/*!50001 CREATE TABLE `sales_by_store` (
3432+ `store` varchar(101),
3433+ `manager` varchar(91),
3434+ `total_sales` decimal(27,2)
3435+) ENGINE=MyISAM */;
3436+SET character_set_client = @saved_cs_client;
3437+/*!40101 SET @saved_cs_client = @@character_set_client */;
3438+/*!40101 SET character_set_client = utf8 */;
3439+CREATE TABLE `staff` (
3440+ `staff_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
3441+ `first_name` varchar(45) NOT NULL,
3442+ `last_name` varchar(45) NOT NULL,
3443+ `address_id` smallint(5) unsigned NOT NULL,
3444+ `picture` blob,
3445+ `email` varchar(50) DEFAULT NULL,
3446+ `store_id` tinyint(3) unsigned NOT NULL,
3447+ `active` tinyint(1) NOT NULL DEFAULT '1',
3448+ `username` varchar(16) NOT NULL,
3449+ `password` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
3450+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3451+ PRIMARY KEY (`staff_id`),
3452+ KEY `idx_fk_store_id` (`store_id`),
3453+ KEY `idx_fk_address_id` (`address_id`),
3454+ CONSTRAINT `fk_staff_store` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON UPDATE CASCADE,
3455+ CONSTRAINT `fk_staff_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON UPDATE CASCADE
3456+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3457+/*!40101 SET character_set_client = @saved_cs_client */;
3458+SET @saved_cs_client = @@character_set_client;
3459+SET character_set_client = utf8;
3460+/*!50001 CREATE TABLE `staff_list` (
3461+ `ID` tinyint(3) unsigned,
3462+ `name` varchar(91),
3463+ `address` varchar(50),
3464+ `zip code` varchar(10),
3465+ `phone` varchar(20),
3466+ `city` varchar(50),
3467+ `country` varchar(50),
3468+ `SID` tinyint(3) unsigned
3469+) ENGINE=MyISAM */;
3470+SET character_set_client = @saved_cs_client;
3471+/*!40101 SET @saved_cs_client = @@character_set_client */;
3472+/*!40101 SET character_set_client = utf8 */;
3473+CREATE TABLE `store` (
3474+ `store_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
3475+ `manager_staff_id` tinyint(3) unsigned NOT NULL,
3476+ `address_id` smallint(5) unsigned NOT NULL,
3477+ `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3478+ PRIMARY KEY (`store_id`),
3479+ UNIQUE KEY `idx_unique_manager` (`manager_staff_id`),
3480+ KEY `idx_fk_address_id` (`address_id`),
3481+ CONSTRAINT `fk_store_staff` FOREIGN KEY (`manager_staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE,
3482+ CONSTRAINT `fk_store_address` FOREIGN KEY (`address_id`) REFERENCES `address` (`address_id`) ON UPDATE CASCADE
3483+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3484+/*!40101 SET character_set_client = @saved_cs_client */;
3485+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3486+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3487+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3488+/*!50003 SET character_set_client = utf8 */ ;
3489+/*!50003 SET character_set_results = utf8 */ ;
3490+/*!50003 SET collation_connection = utf8_general_ci */ ;
3491+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3492+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3493+DELIMITER ;;
3494+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 FUNCTION `get_customer_balance`(p_customer_id INT, p_effective_date DATETIME) RETURNS decimal(5,2)
3495+ READS SQL DATA
3496+ DETERMINISTIC
3497+BEGIN
3498+
3499+
3500+
3501+
3502+
3503+
3504+
3505+
3506+ DECLARE v_rentfees DECIMAL(5,2);
3507+ DECLARE v_overfees INTEGER;
3508+ DECLARE v_payments DECIMAL(5,2);
3509+
3510+ SELECT IFNULL(SUM(film.rental_rate),0) INTO v_rentfees
3511+ FROM film, inventory, rental
3512+ WHERE film.film_id = inventory.film_id
3513+ AND inventory.inventory_id = rental.inventory_id
3514+ AND rental.rental_date <= p_effective_date
3515+ AND rental.customer_id = p_customer_id;
3516+
3517+ SELECT IFNULL(SUM(IF((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) > film.rental_duration,
3518+ ((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) - film.rental_duration),0)),0) INTO v_overfees
3519+ FROM rental, inventory, film
3520+ WHERE film.film_id = inventory.film_id
3521+ AND inventory.inventory_id = rental.inventory_id
3522+ AND rental.rental_date <= p_effective_date
3523+ AND rental.customer_id = p_customer_id;
3524+
3525+
3526+ SELECT IFNULL(SUM(payment.amount),0) INTO v_payments
3527+ FROM payment
3528+
3529+ WHERE payment.payment_date <= p_effective_date
3530+ AND payment.customer_id = p_customer_id;
3531+
3532+ RETURN v_rentfees + v_overfees - v_payments;
3533+END */;;
3534+DELIMITER ;
3535+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3536+/*!50003 SET character_set_client = @saved_cs_client */ ;
3537+/*!50003 SET character_set_results = @saved_cs_results */ ;
3538+/*!50003 SET collation_connection = @saved_col_connection */ ;
3539+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3540+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3541+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3542+/*!50003 SET character_set_client = utf8 */ ;
3543+/*!50003 SET character_set_results = utf8 */ ;
3544+/*!50003 SET collation_connection = utf8_general_ci */ ;
3545+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3546+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3547+DELIMITER ;;
3548+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 FUNCTION `inventory_held_by_customer`(p_inventory_id INT) RETURNS int(11)
3549+ READS SQL DATA
3550+BEGIN
3551+ DECLARE v_customer_id INT;
3552+ DECLARE EXIT HANDLER FOR NOT FOUND RETURN NULL;
3553+
3554+ SELECT customer_id INTO v_customer_id
3555+ FROM rental
3556+ WHERE return_date IS NULL
3557+ AND inventory_id = p_inventory_id;
3558+
3559+ RETURN v_customer_id;
3560+END */;;
3561+DELIMITER ;
3562+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3563+/*!50003 SET character_set_client = @saved_cs_client */ ;
3564+/*!50003 SET character_set_results = @saved_cs_results */ ;
3565+/*!50003 SET collation_connection = @saved_col_connection */ ;
3566+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3567+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3568+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3569+/*!50003 SET character_set_client = utf8 */ ;
3570+/*!50003 SET character_set_results = utf8 */ ;
3571+/*!50003 SET collation_connection = utf8_general_ci */ ;
3572+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3573+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3574+DELIMITER ;;
3575+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 FUNCTION `inventory_in_stock`(p_inventory_id INT) RETURNS tinyint(1)
3576+ READS SQL DATA
3577+BEGIN
3578+ DECLARE v_rentals INT;
3579+ DECLARE v_out INT;
3580+
3581+
3582+
3583+
3584+ SELECT COUNT(*) INTO v_rentals
3585+ FROM rental
3586+ WHERE inventory_id = p_inventory_id;
3587+
3588+ IF v_rentals = 0 THEN
3589+ RETURN TRUE;
3590+ END IF;
3591+
3592+ SELECT COUNT(rental_id) INTO v_out
3593+ FROM inventory LEFT JOIN rental USING(inventory_id)
3594+ WHERE inventory.inventory_id = p_inventory_id
3595+ AND rental.return_date IS NULL;
3596+
3597+ IF v_out > 0 THEN
3598+ RETURN FALSE;
3599+ ELSE
3600+ RETURN TRUE;
3601+ END IF;
3602+END */;;
3603+DELIMITER ;
3604+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3605+/*!50003 SET character_set_client = @saved_cs_client */ ;
3606+/*!50003 SET character_set_results = @saved_cs_results */ ;
3607+/*!50003 SET collation_connection = @saved_col_connection */ ;
3608+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3609+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3610+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3611+/*!50003 SET character_set_client = utf8 */ ;
3612+/*!50003 SET character_set_results = utf8 */ ;
3613+/*!50003 SET collation_connection = utf8_general_ci */ ;
3614+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3615+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3616+DELIMITER ;;
3617+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 PROCEDURE `film_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)
3618+ READS SQL DATA
3619+BEGIN
3620+ SELECT inventory_id
3621+ FROM inventory
3622+ WHERE film_id = p_film_id
3623+ AND store_id = p_store_id
3624+ AND inventory_in_stock(inventory_id);
3625+
3626+ SELECT FOUND_ROWS() INTO p_film_count;
3627+END */;;
3628+DELIMITER ;
3629+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3630+/*!50003 SET character_set_client = @saved_cs_client */ ;
3631+/*!50003 SET character_set_results = @saved_cs_results */ ;
3632+/*!50003 SET collation_connection = @saved_col_connection */ ;
3633+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3634+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3635+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3636+/*!50003 SET character_set_client = utf8 */ ;
3637+/*!50003 SET character_set_results = utf8 */ ;
3638+/*!50003 SET collation_connection = utf8_general_ci */ ;
3639+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3640+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3641+DELIMITER ;;
3642+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 PROCEDURE `film_not_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)
3643+ READS SQL DATA
3644+BEGIN
3645+ SELECT inventory_id
3646+ FROM inventory
3647+ WHERE film_id = p_film_id
3648+ AND store_id = p_store_id
3649+ AND NOT inventory_in_stock(inventory_id);
3650+
3651+ SELECT FOUND_ROWS() INTO p_film_count;
3652+END */;;
3653+DELIMITER ;
3654+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3655+/*!50003 SET character_set_client = @saved_cs_client */ ;
3656+/*!50003 SET character_set_results = @saved_cs_results */ ;
3657+/*!50003 SET collation_connection = @saved_col_connection */ ;
3658+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3659+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3660+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3661+/*!50003 SET character_set_client = utf8 */ ;
3662+/*!50003 SET character_set_results = utf8 */ ;
3663+/*!50003 SET collation_connection = utf8_general_ci */ ;
3664+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3665+/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
3666+DELIMITER ;;
3667+/*!50003 CREATE*/ /*!50020 DEFINER=`msandbox`@`%`*/ /*!50003 PROCEDURE `rewards_report`(
3668+ IN min_monthly_purchases TINYINT UNSIGNED
3669+ , IN min_dollar_amount_purchased DECIMAL(10,2) UNSIGNED
3670+ , OUT count_rewardees INT
3671+)
3672+ READS SQL DATA
3673+ COMMENT 'Provides a customizable report on best customers'
3674+proc: BEGIN
3675+
3676+ DECLARE last_month_start DATE;
3677+ DECLARE last_month_end DATE;
3678+
3679+
3680+ IF min_monthly_purchases = 0 THEN
3681+ SELECT 'Minimum monthly purchases parameter must be > 0';
3682+ LEAVE proc;
3683+ END IF;
3684+ IF min_dollar_amount_purchased = 0.00 THEN
3685+ SELECT 'Minimum monthly dollar amount purchased parameter must be > $0.00';
3686+ LEAVE proc;
3687+ END IF;
3688+
3689+
3690+ SET last_month_start = DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH);
3691+ SET last_month_start = STR_TO_DATE(CONCAT(YEAR(last_month_start),'-',MONTH(last_month_start),'-01'),'%Y-%m-%d');
3692+ SET last_month_end = LAST_DAY(last_month_start);
3693+
3694+
3695+ CREATE TEMPORARY TABLE tmpCustomer (customer_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY);
3696+
3697+
3698+ INSERT INTO tmpCustomer (customer_id)
3699+ SELECT p.customer_id
3700+ FROM payment AS p
3701+ WHERE DATE(p.payment_date) BETWEEN last_month_start AND last_month_end
3702+ GROUP BY customer_id
3703+ HAVING SUM(p.amount) > min_dollar_amount_purchased
3704+ AND COUNT(customer_id) > min_monthly_purchases;
3705+
3706+
3707+ SELECT COUNT(*) FROM tmpCustomer INTO count_rewardees;
3708+
3709+
3710+ SELECT c.*
3711+ FROM tmpCustomer AS t
3712+ INNER JOIN customer AS c ON t.customer_id = c.customer_id;
3713+
3714+
3715+ DROP TABLE tmpCustomer;
3716+END */;;
3717+DELIMITER ;
3718+/*!50003 SET sql_mode = @saved_sql_mode */ ;
3719+/*!50003 SET character_set_client = @saved_cs_client */ ;
3720+/*!50003 SET character_set_results = @saved_cs_results */ ;
3721+/*!50003 SET collation_connection = @saved_col_connection */ ;
3722+
3723+USE `mysql`;
3724+
3725+USE `percona_test`;
3726+
3727+USE `sakila`;
3728+/*!50001 DROP TABLE IF EXISTS `actor_info`*/;
3729+/*!50001 SET @saved_cs_client = @@character_set_client */;
3730+/*!50001 SET @saved_cs_results = @@character_set_results */;
3731+/*!50001 SET @saved_col_connection = @@collation_connection */;
3732+/*!50001 SET character_set_client = utf8 */;
3733+/*!50001 SET character_set_results = utf8 */;
3734+/*!50001 SET collation_connection = utf8_general_ci */;
3735+/*!50001 CREATE ALGORITHM=UNDEFINED */
3736+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY INVOKER */
3737+/*!50001 VIEW `actor_info` AS select `a`.`actor_id` AS `actor_id`,`a`.`first_name` AS `first_name`,`a`.`last_name` AS `last_name`,group_concat(distinct concat(`c`.`name`,': ',(select group_concat(`f`.`title` order by `f`.`title` ASC separator ', ') from ((`film` `f` join `film_category` `fc` on((`f`.`film_id` = `fc`.`film_id`))) join `film_actor` `fa` on((`f`.`film_id` = `fa`.`film_id`))) where ((`fc`.`category_id` = `c`.`category_id`) and (`fa`.`actor_id` = `a`.`actor_id`)))) order by `c`.`name` ASC separator '; ') AS `film_info` from (((`actor` `a` left join `film_actor` `fa` on((`a`.`actor_id` = `fa`.`actor_id`))) left join `film_category` `fc` on((`fa`.`film_id` = `fc`.`film_id`))) left join `category` `c` on((`fc`.`category_id` = `c`.`category_id`))) group by `a`.`actor_id`,`a`.`first_name`,`a`.`last_name` */;
3738+/*!50001 SET character_set_client = @saved_cs_client */;
3739+/*!50001 SET character_set_results = @saved_cs_results */;
3740+/*!50001 SET collation_connection = @saved_col_connection */;
3741+/*!50001 DROP TABLE IF EXISTS `customer_list`*/;
3742+/*!50001 SET @saved_cs_client = @@character_set_client */;
3743+/*!50001 SET @saved_cs_results = @@character_set_results */;
3744+/*!50001 SET @saved_col_connection = @@collation_connection */;
3745+/*!50001 SET character_set_client = utf8 */;
3746+/*!50001 SET character_set_results = utf8 */;
3747+/*!50001 SET collation_connection = utf8_general_ci */;
3748+/*!50001 CREATE ALGORITHM=UNDEFINED */
3749+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3750+/*!50001 VIEW `customer_list` AS select `cu`.`customer_id` AS `ID`,concat(`cu`.`first_name`,_utf8' ',`cu`.`last_name`) AS `name`,`a`.`address` AS `address`,`a`.`postal_code` AS `zip code`,`a`.`phone` AS `phone`,`city`.`city` AS `city`,`country`.`country` AS `country`,if(`cu`.`active`,_utf8'active',_utf8'') AS `notes`,`cu`.`store_id` AS `SID` from (((`customer` `cu` join `address` `a` on((`cu`.`address_id` = `a`.`address_id`))) join `city` on((`a`.`city_id` = `city`.`city_id`))) join `country` on((`city`.`country_id` = `country`.`country_id`))) */;
3751+/*!50001 SET character_set_client = @saved_cs_client */;
3752+/*!50001 SET character_set_results = @saved_cs_results */;
3753+/*!50001 SET collation_connection = @saved_col_connection */;
3754+/*!50001 DROP TABLE IF EXISTS `film_list`*/;
3755+/*!50001 SET @saved_cs_client = @@character_set_client */;
3756+/*!50001 SET @saved_cs_results = @@character_set_results */;
3757+/*!50001 SET @saved_col_connection = @@collation_connection */;
3758+/*!50001 SET character_set_client = utf8 */;
3759+/*!50001 SET character_set_results = utf8 */;
3760+/*!50001 SET collation_connection = utf8_general_ci */;
3761+/*!50001 CREATE ALGORITHM=UNDEFINED */
3762+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3763+/*!50001 VIEW `film_list` AS select `film`.`film_id` AS `FID`,`film`.`title` AS `title`,`film`.`description` AS `description`,`category`.`name` AS `category`,`film`.`rental_rate` AS `price`,`film`.`length` AS `length`,`film`.`rating` AS `rating`,group_concat(concat(`actor`.`first_name`,_utf8' ',`actor`.`last_name`) separator ', ') AS `actors` from ((((`category` left join `film_category` on((`category`.`category_id` = `film_category`.`category_id`))) left join `film` on((`film_category`.`film_id` = `film`.`film_id`))) join `film_actor` on((`film`.`film_id` = `film_actor`.`film_id`))) join `actor` on((`film_actor`.`actor_id` = `actor`.`actor_id`))) group by `film`.`film_id` */;
3764+/*!50001 SET character_set_client = @saved_cs_client */;
3765+/*!50001 SET character_set_results = @saved_cs_results */;
3766+/*!50001 SET collation_connection = @saved_col_connection */;
3767+/*!50001 DROP TABLE IF EXISTS `nicer_but_slower_film_list`*/;
3768+/*!50001 SET @saved_cs_client = @@character_set_client */;
3769+/*!50001 SET @saved_cs_results = @@character_set_results */;
3770+/*!50001 SET @saved_col_connection = @@collation_connection */;
3771+/*!50001 SET character_set_client = utf8 */;
3772+/*!50001 SET character_set_results = utf8 */;
3773+/*!50001 SET collation_connection = utf8_general_ci */;
3774+/*!50001 CREATE ALGORITHM=UNDEFINED */
3775+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3776+/*!50001 VIEW `nicer_but_slower_film_list` AS select `film`.`film_id` AS `FID`,`film`.`title` AS `title`,`film`.`description` AS `description`,`category`.`name` AS `category`,`film`.`rental_rate` AS `price`,`film`.`length` AS `length`,`film`.`rating` AS `rating`,group_concat(concat(concat(ucase(substr(`actor`.`first_name`,1,1)),lcase(substr(`actor`.`first_name`,2,length(`actor`.`first_name`))),_utf8' ',concat(ucase(substr(`actor`.`last_name`,1,1)),lcase(substr(`actor`.`last_name`,2,length(`actor`.`last_name`)))))) separator ', ') AS `actors` from ((((`category` left join `film_category` on((`category`.`category_id` = `film_category`.`category_id`))) left join `film` on((`film_category`.`film_id` = `film`.`film_id`))) join `film_actor` on((`film`.`film_id` = `film_actor`.`film_id`))) join `actor` on((`film_actor`.`actor_id` = `actor`.`actor_id`))) group by `film`.`film_id` */;
3777+/*!50001 SET character_set_client = @saved_cs_client */;
3778+/*!50001 SET character_set_results = @saved_cs_results */;
3779+/*!50001 SET collation_connection = @saved_col_connection */;
3780+/*!50001 DROP TABLE IF EXISTS `sales_by_film_category`*/;
3781+/*!50001 SET @saved_cs_client = @@character_set_client */;
3782+/*!50001 SET @saved_cs_results = @@character_set_results */;
3783+/*!50001 SET @saved_col_connection = @@collation_connection */;
3784+/*!50001 SET character_set_client = utf8 */;
3785+/*!50001 SET character_set_results = utf8 */;
3786+/*!50001 SET collation_connection = utf8_general_ci */;
3787+/*!50001 CREATE ALGORITHM=UNDEFINED */
3788+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3789+/*!50001 VIEW `sales_by_film_category` AS select `c`.`name` AS `category`,sum(`p`.`amount`) AS `total_sales` from (((((`payment` `p` join `rental` `r` on((`p`.`rental_id` = `r`.`rental_id`))) join `inventory` `i` on((`r`.`inventory_id` = `i`.`inventory_id`))) join `film` `f` on((`i`.`film_id` = `f`.`film_id`))) join `film_category` `fc` on((`f`.`film_id` = `fc`.`film_id`))) join `category` `c` on((`fc`.`category_id` = `c`.`category_id`))) group by `c`.`name` order by sum(`p`.`amount`) desc */;
3790+/*!50001 SET character_set_client = @saved_cs_client */;
3791+/*!50001 SET character_set_results = @saved_cs_results */;
3792+/*!50001 SET collation_connection = @saved_col_connection */;
3793+/*!50001 DROP TABLE IF EXISTS `sales_by_store`*/;
3794+/*!50001 SET @saved_cs_client = @@character_set_client */;
3795+/*!50001 SET @saved_cs_results = @@character_set_results */;
3796+/*!50001 SET @saved_col_connection = @@collation_connection */;
3797+/*!50001 SET character_set_client = utf8 */;
3798+/*!50001 SET character_set_results = utf8 */;
3799+/*!50001 SET collation_connection = utf8_general_ci */;
3800+/*!50001 CREATE ALGORITHM=UNDEFINED */
3801+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3802+/*!50001 VIEW `sales_by_store` AS select concat(`c`.`city`,_utf8',',`cy`.`country`) AS `store`,concat(`m`.`first_name`,_utf8' ',`m`.`last_name`) AS `manager`,sum(`p`.`amount`) AS `total_sales` from (((((((`payment` `p` join `rental` `r` on((`p`.`rental_id` = `r`.`rental_id`))) join `inventory` `i` on((`r`.`inventory_id` = `i`.`inventory_id`))) join `store` `s` on((`i`.`store_id` = `s`.`store_id`))) join `address` `a` on((`s`.`address_id` = `a`.`address_id`))) join `city` `c` on((`a`.`city_id` = `c`.`city_id`))) join `country` `cy` on((`c`.`country_id` = `cy`.`country_id`))) join `staff` `m` on((`s`.`manager_staff_id` = `m`.`staff_id`))) group by `s`.`store_id` order by `cy`.`country`,`c`.`city` */;
3803+/*!50001 SET character_set_client = @saved_cs_client */;
3804+/*!50001 SET character_set_results = @saved_cs_results */;
3805+/*!50001 SET collation_connection = @saved_col_connection */;
3806+/*!50001 DROP TABLE IF EXISTS `staff_list`*/;
3807+/*!50001 SET @saved_cs_client = @@character_set_client */;
3808+/*!50001 SET @saved_cs_results = @@character_set_results */;
3809+/*!50001 SET @saved_col_connection = @@collation_connection */;
3810+/*!50001 SET character_set_client = utf8 */;
3811+/*!50001 SET character_set_results = utf8 */;
3812+/*!50001 SET collation_connection = utf8_general_ci */;
3813+/*!50001 CREATE ALGORITHM=UNDEFINED */
3814+/*!50013 DEFINER=`msandbox`@`%` SQL SECURITY DEFINER */
3815+/*!50001 VIEW `staff_list` AS select `s`.`staff_id` AS `ID`,concat(`s`.`first_name`,_utf8' ',`s`.`last_name`) AS `name`,`a`.`address` AS `address`,`a`.`postal_code` AS `zip code`,`a`.`phone` AS `phone`,`city`.`city` AS `city`,`country`.`country` AS `country`,`s`.`store_id` AS `SID` from (((`staff` `s` join `address` `a` on((`s`.`address_id` = `a`.`address_id`))) join `city` on((`a`.`city_id` = `city`.`city_id`))) join `country` on((`city`.`country_id` = `country`.`country_id`))) */;
3816+/*!50001 SET character_set_client = @saved_cs_client */;
3817+/*!50001 SET character_set_results = @saved_cs_results */;
3818+/*!50001 SET collation_connection = @saved_col_connection */;
3819
3820=== added directory 't/pt-mysql-summary/samples/temp007'
3821=== added file 't/pt-mysql-summary/samples/temp007/collect.err'
3822=== added file 't/pt-mysql-summary/samples/temp007/innodb-status'
3823--- t/pt-mysql-summary/samples/temp007/innodb-status 1970-01-01 00:00:00 +0000
3824+++ t/pt-mysql-summary/samples/temp007/innodb-status 2012-12-04 16:32:31 +0000
3825@@ -0,0 +1,118 @@
3826+*************************** 1. row ***************************
3827+ Type: InnoDB
3828+ Name:
3829+Status:
3830+=====================================
3831+121127 18:59:59 INNODB MONITOR OUTPUT
3832+=====================================
3833+Per second averages calculated from the last 32 seconds
3834+-----------------
3835+BACKGROUND THREAD
3836+-----------------
3837+srv_master_thread loops: 32 1_second, 32 sleeps, 3 10_second, 4 background, 4 flush
3838+srv_master_thread log flush and writes: 35
3839+----------
3840+SEMAPHORES
3841+----------
3842+OS WAIT ARRAY INFO: reservation count 36, signal count 36
3843+Mutex spin waits 14, rounds 222, OS waits 4
3844+RW-shared spins 25, rounds 722, OS waits 24
3845+RW-excl spins 0, rounds 240, OS waits 8
3846+Spin rounds per wait: 15.86 mutex, 28.88 RW-shared, 240.00 RW-excl
3847+--------
3848+FILE I/O
3849+--------
3850+I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
3851+I/O thread 1 state: waiting for completed aio requests (log thread)
3852+I/O thread 2 state: waiting for completed aio requests (read thread)
3853+I/O thread 3 state: waiting for completed aio requests (read thread)
3854+I/O thread 4 state: waiting for completed aio requests (read thread)
3855+I/O thread 5 state: waiting for completed aio requests (read thread)
3856+I/O thread 6 state: waiting for completed aio requests (write thread)
3857+I/O thread 7 state: waiting for completed aio requests (write thread)
3858+I/O thread 8 state: waiting for completed aio requests (write thread)
3859+I/O thread 9 state: waiting for completed aio requests (write thread)
3860+Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
3861+ ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
3862+Pending flushes (fsync) log: 0; buffer pool: 0
3863+0 OS file reads, 955 OS file writes, 125 OS fsyncs
3864+0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
3865+-------------------------------------
3866+INSERT BUFFER AND ADAPTIVE HASH INDEX
3867+-------------------------------------
3868+Ibuf: size 1, free list len 0, seg size 2, 0 merges
3869+merged operations:
3870+ insert 0, delete mark 0, delete 0
3871+discarded operations:
3872+ insert 0, delete mark 0, delete 0
3873+Hash table size 138337, node heap has 7 buffer(s)
3874+0.00 hash searches/s, 0.00 non-hash searches/s
3875+---
3876+LOG
3877+---
3878+Log sequence number 8603780
3879+Log flushed up to 8603780
3880+Last checkpoint at 8603780
3881+Max checkpoint age 7782360
3882+Checkpoint age target 7539162
3883+Modified age 0
3884+Checkpoint age 0
3885+0 pending log writes, 0 pending chkp writes
3886+89 log i/o's done, 0.00 log i/o's/second
3887+----------------------
3888+BUFFER POOL AND MEMORY
3889+----------------------
3890+Total memory allocated 34062336; in additional pool allocated 0
3891+Internal hash tables (constant factor + variable factor)
3892+ Adaptive hash index 672196 (553348 + 118848)
3893+ Page hash 17692 (buffer pool 0 only)
3894+ Dictionary cache 219018 (139064 + 79954)
3895+ File system 41792 (41336 + 456)
3896+ Lock system 42228 (41908 + 320)
3897+ Recovery system 0 (0 + 0)
3898+Dictionary memory allocated 79954
3899+Buffer pool size 2047
3900+Buffer pool size, bytes 33538048
3901+Free buffers 1347
3902+Database pages 693
3903+Old database pages 235
3904+Modified db pages 0
3905+Pending reads 0
3906+Pending writes: LRU 0, flush list 0, single page 0
3907+Pages made young 0, not young 0
3908+0.00 youngs/s, 0.00 non-youngs/s
3909+Pages read 0, created 693, written 811
3910+0.00 reads/s, 0.00 creates/s, 0.00 writes/s
3911+No buffer pool page gets since the last printout
3912+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
3913+LRU len: 693, unzip_LRU len: 0
3914+I/O sum[0]:cur[0], unzip sum[0]:cur[0]
3915+--------------
3916+ROW OPERATIONS
3917+--------------
3918+0 queries inside InnoDB, 0 queries in queue
3919+1 read views open inside InnoDB
3920+---OLDEST VIEW---
3921+Normal read view
3922+Read view low limit trx n:o 300
3923+Read view up limit trx id 300
3924+Read view low limit trx id 300
3925+Read view individually stored trx ids:
3926+-----------------
3927+Main thread process no. 30877, id 2895674176, state: waiting for server activity
3928+Number of rows inserted 46315, updated 0, deleted 0, read 46274
3929+0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
3930+------------
3931+TRANSACTIONS
3932+------------
3933+Trx id counter 348
3934+Purge done for trx's n:o < 0 undo n:o < 0
3935+History list length 0
3936+LIST OF TRANSACTIONS FOR EACH SESSION:
3937+---TRANSACTION 0, not started
3938+MySQL thread id 18, OS thread handle 0xb6f31b40, query id 1170 localhost msandbox
3939+SHOW /*!50000 ENGINE*/ INNODB STATUS
3940+----------------------------
3941+END OF INNODB MONITOR OUTPUT
3942+============================
3943+
3944
3945=== added file 't/pt-mysql-summary/samples/temp007/mysql-databases'
3946--- t/pt-mysql-summary/samples/temp007/mysql-databases 1970-01-01 00:00:00 +0000
3947+++ t/pt-mysql-summary/samples/temp007/mysql-databases 2012-12-04 16:32:31 +0000
3948@@ -0,0 +1,5 @@
3949+information_schema
3950+mysql
3951+percona_test
3952+performance_schema
3953+sakila
3954
3955=== added file 't/pt-mysql-summary/samples/temp007/mysql-master-logs'
3956--- t/pt-mysql-summary/samples/temp007/mysql-master-logs 1970-01-01 00:00:00 +0000
3957+++ t/pt-mysql-summary/samples/temp007/mysql-master-logs 2012-12-04 16:32:31 +0000
3958@@ -0,0 +1,1 @@
3959+mysql-bin.000001 3259054
3960
3961=== added file 't/pt-mysql-summary/samples/temp007/mysql-master-status'
3962--- t/pt-mysql-summary/samples/temp007/mysql-master-status 1970-01-01 00:00:00 +0000
3963+++ t/pt-mysql-summary/samples/temp007/mysql-master-status 2012-12-04 16:32:31 +0000
3964@@ -0,0 +1,1 @@
3965+mysql-bin.000001 3259054
3966
3967=== added file 't/pt-mysql-summary/samples/temp007/mysql-plugins'
3968--- t/pt-mysql-summary/samples/temp007/mysql-plugins 1970-01-01 00:00:00 +0000
3969+++ t/pt-mysql-summary/samples/temp007/mysql-plugins 2012-12-04 16:32:31 +0000
3970@@ -0,0 +1,41 @@
3971+binlog ACTIVE STORAGE ENGINE NULL GPL
3972+wsrep ACTIVE STORAGE ENGINE NULL GPL
3973+mysql_native_password ACTIVE AUTHENTICATION NULL GPL
3974+mysql_old_password ACTIVE AUTHENTICATION NULL GPL
3975+MRG_MYISAM ACTIVE STORAGE ENGINE NULL GPL
3976+MyISAM ACTIVE STORAGE ENGINE NULL GPL
3977+MEMORY ACTIVE STORAGE ENGINE NULL GPL
3978+CSV ACTIVE STORAGE ENGINE NULL GPL
3979+PERFORMANCE_SCHEMA ACTIVE STORAGE ENGINE NULL GPL
3980+InnoDB ACTIVE STORAGE ENGINE NULL GPL
3981+INNODB_RSEG ACTIVE INFORMATION SCHEMA NULL GPL
3982+INNODB_UNDO_LOGS ACTIVE INFORMATION SCHEMA NULL GPL
3983+INNODB_TRX ACTIVE INFORMATION SCHEMA NULL GPL
3984+INNODB_LOCKS ACTIVE INFORMATION SCHEMA NULL GPL
3985+INNODB_LOCK_WAITS ACTIVE INFORMATION SCHEMA NULL GPL
3986+INNODB_CMP ACTIVE INFORMATION SCHEMA NULL GPL
3987+INNODB_CMP_RESET ACTIVE INFORMATION SCHEMA NULL GPL
3988+INNODB_CMPMEM ACTIVE INFORMATION SCHEMA NULL GPL
3989+INNODB_CMPMEM_RESET ACTIVE INFORMATION SCHEMA NULL GPL
3990+INNODB_SYS_TABLES ACTIVE INFORMATION SCHEMA NULL GPL
3991+INNODB_SYS_TABLESTATS ACTIVE INFORMATION SCHEMA NULL GPL
3992+INNODB_SYS_INDEXES ACTIVE INFORMATION SCHEMA NULL GPL
3993+INNODB_SYS_COLUMNS ACTIVE INFORMATION SCHEMA NULL GPL
3994+INNODB_SYS_FIELDS ACTIVE INFORMATION SCHEMA NULL GPL
3995+INNODB_SYS_FOREIGN ACTIVE INFORMATION SCHEMA NULL GPL
3996+INNODB_SYS_FOREIGN_COLS ACTIVE INFORMATION SCHEMA NULL GPL
3997+INNODB_SYS_STATS ACTIVE INFORMATION SCHEMA NULL GPL
3998+INNODB_TABLE_STATS ACTIVE INFORMATION SCHEMA NULL GPL
3999+INNODB_INDEX_STATS ACTIVE INFORMATION SCHEMA NULL GPL
4000+INNODB_BUFFER_POOL_PAGES ACTIVE INFORMATION SCHEMA NULL GPL
4001+INNODB_BUFFER_POOL_PAGES_INDEX ACTIVE INFORMATION SCHEMA NULL GPL
4002+INNODB_BUFFER_POOL_PAGES_BLOB ACTIVE INFORMATION SCHEMA NULL GPL
4003+XTRADB_ADMIN_COMMAND ACTIVE INFORMATION SCHEMA NULL GPL
4004+INNODB_CHANGED_PAGES ACTIVE INFORMATION SCHEMA NULL GPL
4005+INNODB_BUFFER_PAGE ACTIVE INFORMATION SCHEMA NULL GPL
4006+INNODB_BUFFER_PAGE_LRU ACTIVE INFORMATION SCHEMA NULL GPL
4007+INNODB_BUFFER_POOL_STATS ACTIVE INFORMATION SCHEMA NULL GPL
4008+BLACKHOLE ACTIVE STORAGE ENGINE NULL GPL
4009+ARCHIVE ACTIVE STORAGE ENGINE NULL GPL
4010+FEDERATED DISABLED STORAGE ENGINE NULL GPL
4011+partition ACTIVE STORAGE ENGINE NULL GPL
4012
4013=== added file 't/pt-mysql-summary/samples/temp007/mysql-processlist'
4014--- t/pt-mysql-summary/samples/temp007/mysql-processlist 1970-01-01 00:00:00 +0000
4015+++ t/pt-mysql-summary/samples/temp007/mysql-processlist 2012-12-04 16:32:31 +0000
4016@@ -0,0 +1,24 @@
4017+*************************** 1. row ***************************
4018+ Id: 4
4019+ User: msandbox
4020+ Host: localhost:49789
4021+ db: NULL
4022+ Command: Binlog Dump
4023+ Time: 88
4024+ State: Master has sent all binlog to slave; waiting for binlog to be updated
4025+ Info: NULL
4026+ Rows_sent: 0
4027+Rows_examined: 0
4028+ Rows_read: 2
4029+*************************** 2. row ***************************
4030+ Id: 19
4031+ User: msandbox
4032+ Host: localhost
4033+ db: NULL
4034+ Command: Query
4035+ Time: 0
4036+ State: NULL
4037+ Info: SHOW FULL PROCESSLIST
4038+ Rows_sent: 0
4039+Rows_examined: 0
4040+ Rows_read: 1
4041
4042=== added file 't/pt-mysql-summary/samples/temp007/mysql-slave'
4043=== added file 't/pt-mysql-summary/samples/temp007/mysql-status'
4044--- t/pt-mysql-summary/samples/temp007/mysql-status 1970-01-01 00:00:00 +0000
4045+++ t/pt-mysql-summary/samples/temp007/mysql-status 2012-12-04 16:32:31 +0000
4046@@ -0,0 +1,380 @@
4047+Aborted_clients 0
4048+Aborted_connects 0
4049+Binlog_cache_disk_use 1
4050+Binlog_cache_use 4
4051+Binlog_stmt_cache_disk_use 0
4052+Binlog_stmt_cache_use 1
4053+Bytes_received 3254928
4054+Bytes_sent 3284914
4055+Com_admin_commands 2
4056+Com_assign_to_keycache 0
4057+Com_alter_db 0
4058+Com_alter_db_upgrade 0
4059+Com_alter_event 0
4060+Com_alter_function 0
4061+Com_alter_procedure 0
4062+Com_alter_server 0
4063+Com_alter_table 0
4064+Com_alter_tablespace 0
4065+Com_analyze 0
4066+Com_begin 1
4067+Com_binlog 0
4068+Com_call_procedure 0
4069+Com_change_db 2
4070+Com_change_master 0
4071+Com_check 0
4072+Com_checksum 1
4073+Com_commit 2
4074+Com_create_db 2
4075+Com_create_event 0
4076+Com_create_function 3
4077+Com_create_index 0
4078+Com_create_procedure 3
4079+Com_create_server 0
4080+Com_create_table 19
4081+Com_create_trigger 6
4082+Com_create_udf 0
4083+Com_create_user 0
4084+Com_create_view 7
4085+Com_dealloc_sql 0
4086+Com_delete 0
4087+Com_delete_multi 0
4088+Com_do 0
4089+Com_drop_db 1
4090+Com_drop_event 0
4091+Com_drop_function 0
4092+Com_drop_index 0
4093+Com_drop_procedure 0
4094+Com_drop_server 0
4095+Com_drop_table 1
4096+Com_drop_trigger 0
4097+Com_drop_user 0
4098+Com_drop_view 0
4099+Com_empty_query 0
4100+Com_execute_sql 0
4101+Com_flush 0
4102+Com_grant 0
4103+Com_ha_close 0
4104+Com_ha_open 0
4105+Com_ha_read 0
4106+Com_help 0
4107+Com_insert 1059
4108+Com_insert_select 0
4109+Com_install_plugin 0
4110+Com_kill 0
4111+Com_load 1
4112+Com_lock_tables 0
4113+Com_optimize 0
4114+Com_preload_keys 0
4115+Com_prepare_sql 0
4116+Com_purge 0
4117+Com_purge_before_date 0
4118+Com_release_savepoint 0
4119+Com_rename_table 0
4120+Com_rename_user 0
4121+Com_repair 0
4122+Com_replace 0
4123+Com_replace_select 0
4124+Com_reset 0
4125+Com_resignal 0
4126+Com_revoke 0
4127+Com_revoke_all 0
4128+Com_rollback 1
4129+Com_rollback_to_savepoint 0
4130+Com_savepoint 0
4131+Com_select 17
4132+Com_set_option 12
4133+Com_signal 0
4134+Com_show_authors 0
4135+Com_show_binlog_events 0
4136+Com_show_binlogs 0
4137+Com_show_charsets 0
4138+Com_show_client_statistics 0
4139+Com_show_collations 0
4140+Com_show_contributors 0
4141+Com_show_create_db 0
4142+Com_show_create_event 0
4143+Com_show_create_func 0
4144+Com_show_create_proc 0
4145+Com_show_create_table 0
4146+Com_show_create_trigger 0
4147+Com_show_databases 0
4148+Com_show_engine_logs 0
4149+Com_show_engine_mutex 0
4150+Com_show_engine_status 1
4151+Com_show_events 0
4152+Com_show_errors 0
4153+Com_show_fields 0
4154+Com_show_function_status 0
4155+Com_show_grants 0
4156+Com_show_index_statistics 0
4157+Com_show_keys 0
4158+Com_show_master_status 0
4159+Com_show_open_tables 0
4160+Com_show_plugins 0
4161+Com_show_privileges 0
4162+Com_show_procedure_status 0
4163+Com_show_processlist 0
4164+Com_show_profile 0
4165+Com_show_profiles 0
4166+Com_show_relaylog_events 0
4167+Com_show_slave_hosts 0
4168+Com_show_slave_status 0
4169+Com_show_slave_status_nolock 0
4170+Com_show_status 1
4171+Com_show_storage_engines 0
4172+Com_show_table_statistics 0
4173+Com_show_table_status 0
4174+Com_show_tables 1
4175+Com_show_temporary_tables 0
4176+Com_show_thread_statistics 0
4177+Com_show_triggers 0
4178+Com_show_user_statistics 0
4179+Com_show_variables 2
4180+Com_show_warnings 0
4181+Com_slave_start 0
4182+Com_slave_stop 0
4183+Com_stmt_close 0
4184+Com_stmt_execute 0
4185+Com_stmt_fetch 0
4186+Com_stmt_prepare 0
4187+Com_stmt_reprepare 0
4188+Com_stmt_reset 0
4189+Com_stmt_send_long_data 0
4190+Com_truncate 0
4191+Com_uninstall_plugin 0
4192+Com_unlock_tables 0
4193+Com_update 1
4194+Com_update_multi 0
4195+Com_xa_commit 0
4196+Com_xa_end 0
4197+Com_xa_prepare 0
4198+Com_xa_recover 0
4199+Com_xa_rollback 0
4200+Com_xa_start 0
4201+Compression OFF
4202+Connections 15
4203+Created_tmp_disk_tables 0
4204+Created_tmp_files 7
4205+Created_tmp_tables 4
4206+Delayed_errors 0
4207+Delayed_insert_threads 0
4208+Delayed_writes 0
4209+Flashcache_enabled OFF
4210+Flush_commands 1
4211+Handler_commit 141
4212+Handler_delete 0
4213+Handler_discover 0
4214+Handler_prepare 122
4215+Handler_read_first 19
4216+Handler_read_key 16
4217+Handler_read_last 0
4218+Handler_read_next 0
4219+Handler_read_prev 0
4220+Handler_read_rnd 0
4221+Handler_read_rnd_next 49487
4222+Handler_rollback 15
4223+Handler_savepoint 0
4224+Handler_savepoint_rollback 0
4225+Handler_update 6
4226+Handler_write 47754
4227+Innodb_adaptive_hash_cells 138337
4228+Innodb_adaptive_hash_heap_buffers 6
4229+Innodb_adaptive_hash_hash_searches 128675
4230+Innodb_adaptive_hash_non_hash_searches 52783
4231+Innodb_background_log_sync 35
4232+Innodb_buffer_pool_pages_data 693
4233+Innodb_buffer_pool_pages_dirty 0
4234+Innodb_buffer_pool_pages_flushed 811
4235+Innodb_buffer_pool_pages_LRU_flushed 0
4236+Innodb_buffer_pool_pages_free 1347
4237+Innodb_buffer_pool_pages_made_not_young 0
4238+Innodb_buffer_pool_pages_made_young 0
4239+Innodb_buffer_pool_pages_misc 7
4240+Innodb_buffer_pool_pages_old 235
4241+Innodb_buffer_pool_pages_total 2047
4242+Innodb_buffer_pool_read_ahead_rnd 0
4243+Innodb_buffer_pool_read_ahead 0
4244+Innodb_buffer_pool_read_ahead_evicted 0
4245+Innodb_buffer_pool_read_requests 441583
4246+Innodb_buffer_pool_reads 0
4247+Innodb_buffer_pool_wait_free 0
4248+Innodb_buffer_pool_write_requests 234413
4249+Innodb_checkpoint_age 0
4250+Innodb_checkpoint_max_age 7782360
4251+Innodb_checkpoint_target_age 7539162
4252+Innodb_data_fsyncs 125
4253+Innodb_data_pending_fsyncs 0
4254+Innodb_data_pending_reads 0
4255+Innodb_data_pending_writes 0
4256+Innodb_data_read 0
4257+Innodb_data_reads 0
4258+Innodb_data_writes 955
4259+Innodb_data_written 32364544
4260+Innodb_dblwr_pages_written 637
4261+Innodb_dblwr_writes 16
4262+Innodb_deadlocks 0
4263+Innodb_dict_tables 26
4264+Innodb_have_atomic_builtins ON
4265+Innodb_history_list_length 0
4266+Innodb_ibuf_discarded_delete_marks 0
4267+Innodb_ibuf_discarded_deletes 0
4268+Innodb_ibuf_discarded_inserts 0
4269+Innodb_ibuf_free_list 0
4270+Innodb_ibuf_merged_delete_marks 0
4271+Innodb_ibuf_merged_deletes 0
4272+Innodb_ibuf_merged_inserts 0
4273+Innodb_ibuf_merges 0
4274+Innodb_ibuf_segment_size 2
4275+Innodb_ibuf_size 1
4276+Innodb_log_waits 0
4277+Innodb_log_write_requests 17776
4278+Innodb_log_writes 66
4279+Innodb_lsn_current 8603780
4280+Innodb_lsn_flushed 8603780
4281+Innodb_lsn_last_checkpoint 8603780
4282+Innodb_master_thread_1_second_loops 32
4283+Innodb_master_thread_10_second_loops 3
4284+Innodb_master_thread_background_loops 4
4285+Innodb_master_thread_main_flush_loops 4
4286+Innodb_master_thread_sleeps 32
4287+Innodb_max_trx_id 840
4288+Innodb_mem_adaptive_hash 672196
4289+Innodb_mem_dictionary 219018
4290+Innodb_mem_total 34062336
4291+Innodb_mutex_os_waits 4
4292+Innodb_mutex_spin_rounds 222
4293+Innodb_mutex_spin_waits 14
4294+Innodb_oldest_view_low_limit_trx_id 768
4295+Innodb_os_log_fsyncs 87
4296+Innodb_os_log_pending_fsyncs 0
4297+Innodb_os_log_pending_writes 0
4298+Innodb_os_log_written 8628736
4299+Innodb_page_size 16384
4300+Innodb_pages_created 693
4301+Innodb_pages_read 0
4302+Innodb_pages_written 811
4303+Innodb_purge_trx_id 0
4304+Innodb_purge_undo_no 0
4305+Innodb_row_lock_current_waits 0
4306+Innodb_current_row_locks 0
4307+Innodb_row_lock_time 0
4308+Innodb_row_lock_time_avg 0
4309+Innodb_row_lock_time_max 0
4310+Innodb_row_lock_waits 0
4311+Innodb_rows_deleted 0
4312+Innodb_rows_inserted 46315
4313+Innodb_rows_read 46274
4314+Innodb_rows_updated 0
4315+Innodb_s_lock_os_waits 24
4316+Innodb_s_lock_spin_rounds 722
4317+Innodb_s_lock_spin_waits 25
4318+Innodb_truncated_status_writes 0
4319+Innodb_x_lock_os_waits 8
4320+Innodb_x_lock_spin_rounds 240
4321+Innodb_x_lock_spin_waits 0
4322+Key_blocks_not_flushed 0
4323+Key_blocks_unused 14295
4324+Key_blocks_used 202
4325+Key_read_requests 28816
4326+Key_reads 1
4327+Key_write_requests 11127
4328+Key_writes 212
4329+Last_query_cost 0.000000
4330+Max_used_connections 2
4331+Not_flushed_delayed_rows 0
4332+Open_files 54
4333+Open_streams 0
4334+Open_table_definitions 60
4335+Open_tables 62
4336+Opened_files 235
4337+Opened_table_definitions 85
4338+Opened_tables 94
4339+Performance_schema_cond_classes_lost 0
4340+Performance_schema_cond_instances_lost 0
4341+Performance_schema_file_classes_lost 0
4342+Performance_schema_file_handles_lost 0
4343+Performance_schema_file_instances_lost 0
4344+Performance_schema_locker_lost 0
4345+Performance_schema_mutex_classes_lost 0
4346+Performance_schema_mutex_instances_lost 0
4347+Performance_schema_rwlock_classes_lost 0
4348+Performance_schema_rwlock_instances_lost 0
4349+Performance_schema_table_handles_lost 0
4350+Performance_schema_table_instances_lost 0
4351+Performance_schema_thread_classes_lost 0
4352+Performance_schema_thread_instances_lost 0
4353+Prepared_stmt_count 0
4354+Qcache_free_blocks 0
4355+Qcache_free_memory 0
4356+Qcache_hits 0
4357+Qcache_inserts 0
4358+Qcache_lowmem_prunes 0
4359+Qcache_not_cached 0
4360+Qcache_queries_in_cache 0
4361+Qcache_total_blocks 0
4362+Queries 1158
4363+Questions 158
4364+Rpl_status AUTH_MASTER
4365+Select_full_join 0
4366+Select_full_range_join 0
4367+Select_range 0
4368+Select_range_check 0
4369+Select_scan 5
4370+Slave_heartbeat_period 0.000
4371+Slave_open_temp_tables 0
4372+Slave_received_heartbeats 0
4373+Slave_retried_transactions 0
4374+Slave_running OFF
4375+Slow_launch_threads 0
4376+Slow_queries 0
4377+Sort_merge_passes 0
4378+Sort_range 0
4379+Sort_rows 0
4380+Sort_scan 0
4381+Ssl_accept_renegotiates 0
4382+Ssl_accepts 0
4383+Ssl_callback_cache_hits 0
4384+Ssl_cipher
4385+Ssl_cipher_list
4386+Ssl_client_connects 0
4387+Ssl_connect_renegotiates 0
4388+Ssl_ctx_verify_depth 0
4389+Ssl_ctx_verify_mode 0
4390+Ssl_default_timeout 0
4391+Ssl_finished_accepts 0
4392+Ssl_finished_connects 0
4393+Ssl_session_cache_hits 0
4394+Ssl_session_cache_misses 0
4395+Ssl_session_cache_mode NONE
4396+Ssl_session_cache_overflows 0
4397+Ssl_session_cache_size 0
4398+Ssl_session_cache_timeouts 0
4399+Ssl_sessions_reused 0
4400+Ssl_used_session_cache_entries 0
4401+Ssl_verify_depth 0
4402+Ssl_verify_mode 0
4403+Ssl_version
4404+Table_locks_immediate 189
4405+Table_locks_waited 0
4406+Tc_log_max_pages_used 0
4407+Tc_log_page_size 0
4408+Tc_log_page_waits 0
4409+Threads_cached 0
4410+Threads_connected 2
4411+Threads_created 14
4412+Threads_running 2
4413+Uptime 96
4414+Uptime_since_flush_status 96
4415+binlog_commits 5
4416+binlog_group_commits 5
4417+wsrep_cluster_conf_id 18446744073709551615
4418+wsrep_cluster_size 0
4419+wsrep_cluster_state_uuid
4420+wsrep_cluster_status Disconnected
4421+wsrep_connected OFF
4422+wsrep_local_index 4294967295
4423+wsrep_provider_name
4424+wsrep_provider_vendor
4425+wsrep_provider_version
4426+wsrep_ready ON
4427
4428=== added file 't/pt-mysql-summary/samples/temp007/mysql-status-defer'
4429--- t/pt-mysql-summary/samples/temp007/mysql-status-defer 1970-01-01 00:00:00 +0000
4430+++ t/pt-mysql-summary/samples/temp007/mysql-status-defer 2012-12-04 16:32:31 +0000
4431@@ -0,0 +1,380 @@
4432+Aborted_clients 0 0
4433+Aborted_connects 0 0
4434+Binlog_cache_disk_use 1 1
4435+Binlog_cache_use 4 4
4436+Binlog_stmt_cache_disk_use 0 0
4437+Binlog_stmt_cache_use 1 1
4438+Bytes_received 3254928 3257215
4439+Bytes_sent 3284914 3309052
4440+Com_admin_commands 2 2
4441+Com_assign_to_keycache 0 0
4442+Com_alter_db 0 0
4443+Com_alter_db_upgrade 0 0
4444+Com_alter_event 0 0
4445+Com_alter_function 0 0
4446+Com_alter_procedure 0 0
4447+Com_alter_server 0 0
4448+Com_alter_table 0 0
4449+Com_alter_tablespace 0 0
4450+Com_analyze 0 0
4451+Com_begin 1 1
4452+Com_binlog 0 0
4453+Com_call_procedure 0 0
4454+Com_change_db 2 2
4455+Com_change_master 0 0
4456+Com_check 0 0
4457+Com_checksum 1 1
4458+Com_commit 2 2
4459+Com_create_db 2 2
4460+Com_create_event 0 0
4461+Com_create_function 3 3
4462+Com_create_index 0 0
4463+Com_create_procedure 3 3
4464+Com_create_server 0 0
4465+Com_create_table 19 19
4466+Com_create_trigger 6 6
4467+Com_create_udf 0 0
4468+Com_create_user 0 0
4469+Com_create_view 7 7
4470+Com_dealloc_sql 0 0
4471+Com_delete 0 0
4472+Com_delete_multi 0 0
4473+Com_do 0 0
4474+Com_drop_db 1 1
4475+Com_drop_event 0 0
4476+Com_drop_function 0 0
4477+Com_drop_index 0 0
4478+Com_drop_procedure 0 0
4479+Com_drop_server 0 0
4480+Com_drop_table 1 1
4481+Com_drop_trigger 0 0
4482+Com_drop_user 0 0
4483+Com_drop_view 0 0
4484+Com_empty_query 0 0
4485+Com_execute_sql 0 0
4486+Com_flush 0 0
4487+Com_grant 0 0
4488+Com_ha_close 0 0
4489+Com_ha_open 0 0
4490+Com_ha_read 0 0
4491+Com_help 0 0
4492+Com_insert 1059 1059
4493+Com_insert_select 0 0
4494+Com_install_plugin 0 0
4495+Com_kill 0 0
4496+Com_load 1 1
4497+Com_lock_tables 0 0
4498+Com_optimize 0 0
4499+Com_preload_keys 0 0
4500+Com_prepare_sql 0 0
4501+Com_purge 0 0
4502+Com_purge_before_date 0 0
4503+Com_release_savepoint 0 0
4504+Com_rename_table 0 0
4505+Com_rename_user 0 0
4506+Com_repair 0 0
4507+Com_replace 0 0
4508+Com_replace_select 0 0
4509+Com_reset 0 0
4510+Com_resignal 0 0
4511+Com_revoke 0 0
4512+Com_revoke_all 0 0
4513+Com_rollback 1 1
4514+Com_rollback_to_savepoint 0 0
4515+Com_savepoint 0 0
4516+Com_select 17 36
4517+Com_set_option 12 12
4518+Com_signal 0 0
4519+Com_show_authors 0 0
4520+Com_show_binlog_events 0 0
4521+Com_show_binlogs 0 1
4522+Com_show_charsets 0 0
4523+Com_show_client_statistics 0 0
4524+Com_show_collations 0 0
4525+Com_show_contributors 0 0
4526+Com_show_create_db 0 0
4527+Com_show_create_event 0 0
4528+Com_show_create_func 0 0
4529+Com_show_create_proc 0 0
4530+Com_show_create_table 0 0
4531+Com_show_create_trigger 0 0
4532+Com_show_databases 0 1
4533+Com_show_engine_logs 0 0
4534+Com_show_engine_mutex 0 0
4535+Com_show_engine_status 1 2
4536+Com_show_events 0 0
4537+Com_show_errors 0 0
4538+Com_show_fields 0 0
4539+Com_show_function_status 0 0
4540+Com_show_grants 0 0
4541+Com_show_index_statistics 0 0
4542+Com_show_keys 0 0
4543+Com_show_master_status 0 1
4544+Com_show_open_tables 0 0
4545+Com_show_plugins 0 1
4546+Com_show_privileges 0 0
4547+Com_show_procedure_status 0 0
4548+Com_show_processlist 0 1
4549+Com_show_profile 0 0
4550+Com_show_profiles 0 0
4551+Com_show_relaylog_events 0 0
4552+Com_show_slave_hosts 0 0
4553+Com_show_slave_status 0 1
4554+Com_show_slave_status_nolock 0 0
4555+Com_show_status 1 2
4556+Com_show_storage_engines 0 0
4557+Com_show_table_statistics 0 0
4558+Com_show_table_status 0 0
4559+Com_show_tables 1 1
4560+Com_show_temporary_tables 0 0
4561+Com_show_thread_statistics 0 0
4562+Com_show_triggers 0 0
4563+Com_show_user_statistics 0 0
4564+Com_show_variables 2 2
4565+Com_show_warnings 0 0
4566+Com_slave_start 0 0
4567+Com_slave_stop 0 0
4568+Com_stmt_close 0 0
4569+Com_stmt_execute 0 0
4570+Com_stmt_fetch 0 0
4571+Com_stmt_prepare 0 0
4572+Com_stmt_reprepare 0 0
4573+Com_stmt_reset 0 0
4574+Com_stmt_send_long_data 0 0
4575+Com_truncate 0 0
4576+Com_uninstall_plugin 0 0
4577+Com_unlock_tables 0 0
4578+Com_update 1 1
4579+Com_update_multi 0 0
4580+Com_xa_commit 0 0
4581+Com_xa_end 0 0
4582+Com_xa_prepare 0 0
4583+Com_xa_recover 0 0
4584+Com_xa_rollback 0 0
4585+Com_xa_start 0 0
4586+Compression OFF OFF
4587+Connections 15 29
4588+Created_tmp_disk_tables 0 11
4589+Created_tmp_files 7 7
4590+Created_tmp_tables 4 73
4591+Delayed_errors 0 0
4592+Delayed_insert_threads 0 0
4593+Delayed_writes 0 0
4594+Flashcache_enabled OFF OFF
4595+Flush_commands 1 1
4596+Handler_commit 141 141
4597+Handler_delete 0 0
4598+Handler_discover 0 0
4599+Handler_prepare 122 122
4600+Handler_read_first 19 19
4601+Handler_read_key 16 16
4602+Handler_read_last 0 0
4603+Handler_read_next 0 0
4604+Handler_read_prev 0 0
4605+Handler_read_rnd 0 0
4606+Handler_read_rnd_next 49487 49926
4607+Handler_rollback 15 15
4608+Handler_savepoint 0 0
4609+Handler_savepoint_rollback 0 0
4610+Handler_update 6 6
4611+Handler_write 47754 48186
4612+Innodb_adaptive_hash_cells 138337 138337
4613+Innodb_adaptive_hash_heap_buffers 6 6
4614+Innodb_adaptive_hash_hash_searches 128675 128675
4615+Innodb_adaptive_hash_non_hash_searches 52783 52783
4616+Innodb_background_log_sync 35 35
4617+Innodb_buffer_pool_pages_data 693 693
4618+Innodb_buffer_pool_pages_dirty 0 0
4619+Innodb_buffer_pool_pages_flushed 811 811
4620+Innodb_buffer_pool_pages_LRU_flushed 0 0
4621+Innodb_buffer_pool_pages_free 1347 1347
4622+Innodb_buffer_pool_pages_made_not_young 0 0
4623+Innodb_buffer_pool_pages_made_young 0 0
4624+Innodb_buffer_pool_pages_misc 7 7
4625+Innodb_buffer_pool_pages_old 235 235
4626+Innodb_buffer_pool_pages_total 2047 2047
4627+Innodb_buffer_pool_read_ahead_rnd 0 0
4628+Innodb_buffer_pool_read_ahead 0 0
4629+Innodb_buffer_pool_read_ahead_evicted 0 0
4630+Innodb_buffer_pool_read_requests 441583 441583
4631+Innodb_buffer_pool_reads 0 0
4632+Innodb_buffer_pool_wait_free 0 0
4633+Innodb_buffer_pool_write_requests 234413 234413
4634+Innodb_checkpoint_age 0 0
4635+Innodb_checkpoint_max_age 7782360 7782360
4636+Innodb_checkpoint_target_age 7539162 7539162
4637+Innodb_data_fsyncs 125 125
4638+Innodb_data_pending_fsyncs 0 0
4639+Innodb_data_pending_reads 0 0
4640+Innodb_data_pending_writes 0 0
4641+Innodb_data_read 0 0
4642+Innodb_data_reads 0 0
4643+Innodb_data_writes 955 955
4644+Innodb_data_written 32364544 32364544
4645+Innodb_dblwr_pages_written 637 637
4646+Innodb_dblwr_writes 16 16
4647+Innodb_deadlocks 0 0
4648+Innodb_dict_tables 26 26
4649+Innodb_have_atomic_builtins ON ON
4650+Innodb_history_list_length 0 0
4651+Innodb_ibuf_discarded_delete_marks 0 0
4652+Innodb_ibuf_discarded_deletes 0 0
4653+Innodb_ibuf_discarded_inserts 0 0
4654+Innodb_ibuf_free_list 0 0
4655+Innodb_ibuf_merged_delete_marks 0 0
4656+Innodb_ibuf_merged_deletes 0 0
4657+Innodb_ibuf_merged_inserts 0 0
4658+Innodb_ibuf_merges 0 0
4659+Innodb_ibuf_segment_size 2 2
4660+Innodb_ibuf_size 1 1
4661+Innodb_log_waits 0 0
4662+Innodb_log_write_requests 17776 17776
4663+Innodb_log_writes 66 66
4664+Innodb_lsn_current 8603780 8603780
4665+Innodb_lsn_flushed 8603780 8603780
4666+Innodb_lsn_last_checkpoint 8603780 8603780
4667+Innodb_master_thread_1_second_loops 32 32
4668+Innodb_master_thread_10_second_loops 3 3
4669+Innodb_master_thread_background_loops 4 4
4670+Innodb_master_thread_main_flush_loops 4 4
4671+Innodb_master_thread_sleeps 32 32
4672+Innodb_max_trx_id 840 840
4673+Innodb_mem_adaptive_hash 672196 672196
4674+Innodb_mem_dictionary 219018 219018
4675+Innodb_mem_total 34062336 34062336
4676+Innodb_mutex_os_waits 4 4
4677+Innodb_mutex_spin_rounds 222 222
4678+Innodb_mutex_spin_waits 14 14
4679+Innodb_oldest_view_low_limit_trx_id 768 768
4680+Innodb_os_log_fsyncs 87 87
4681+Innodb_os_log_pending_fsyncs 0 0
4682+Innodb_os_log_pending_writes 0 0
4683+Innodb_os_log_written 8628736 8628736
4684+Innodb_page_size 16384 16384
4685+Innodb_pages_created 693 693
4686+Innodb_pages_read 0 0
4687+Innodb_pages_written 811 811
4688+Innodb_purge_trx_id 0 0
4689+Innodb_purge_undo_no 0 0
4690+Innodb_row_lock_current_waits 0 0
4691+Innodb_current_row_locks 0 0
4692+Innodb_row_lock_time 0 0
4693+Innodb_row_lock_time_avg 0 0
4694+Innodb_row_lock_time_max 0 0
4695+Innodb_row_lock_waits 0 0
4696+Innodb_rows_deleted 0 0
4697+Innodb_rows_inserted 46315 46315
4698+Innodb_rows_read 46274 46274
4699+Innodb_rows_updated 0 0
4700+Innodb_s_lock_os_waits 24 24
4701+Innodb_s_lock_spin_rounds 722 722
4702+Innodb_s_lock_spin_waits 25 25
4703+Innodb_truncated_status_writes 0 0
4704+Innodb_x_lock_os_waits 8 8
4705+Innodb_x_lock_spin_rounds 240 240
4706+Innodb_x_lock_spin_waits 0 0
4707+Key_blocks_not_flushed 0 0
4708+Key_blocks_unused 14295 14295
4709+Key_blocks_used 202 202
4710+Key_read_requests 28816 28816
4711+Key_reads 1 1
4712+Key_write_requests 11127 11127
4713+Key_writes 212 212
4714+Last_query_cost 0.000000 0.000000
4715+Max_used_connections 2 2
4716+Not_flushed_delayed_rows 0 0
4717+Open_files 54 54
4718+Open_streams 0 0
4719+Open_table_definitions 60 60
4720+Open_tables 62 62
4721+Opened_files 235 284
4722+Opened_table_definitions 85 85
4723+Opened_tables 94 94
4724+Performance_schema_cond_classes_lost 0 0
4725+Performance_schema_cond_instances_lost 0 0
4726+Performance_schema_file_classes_lost 0 0
4727+Performance_schema_file_handles_lost 0 0
4728+Performance_schema_file_instances_lost 0 0
4729+Performance_schema_locker_lost 0 0
4730+Performance_schema_mutex_classes_lost 0 0
4731+Performance_schema_mutex_instances_lost 0 0
4732+Performance_schema_rwlock_classes_lost 0 0
4733+Performance_schema_rwlock_instances_lost 0 0
4734+Performance_schema_table_handles_lost 0 0
4735+Performance_schema_table_instances_lost 0 0
4736+Performance_schema_thread_classes_lost 0 0
4737+Performance_schema_thread_instances_lost 0 0
4738+Prepared_stmt_count 0 0
4739+Qcache_free_blocks 0 0
4740+Qcache_free_memory 0 0
4741+Qcache_hits 0 0
4742+Qcache_inserts 0 0
4743+Qcache_lowmem_prunes 0 0
4744+Qcache_not_cached 0 0
4745+Qcache_queries_in_cache 0 0
4746+Qcache_total_blocks 0 0
4747+Queries 1158 1200
4748+Questions 158 200
4749+Rpl_status AUTH_MASTER AUTH_MASTER
4750+Select_full_join 0 0
4751+Select_full_range_join 0 0
4752+Select_range 0 0
4753+Select_range_check 0 0
4754+Select_scan 5 10
4755+Slave_heartbeat_period 0.000 0.000
4756+Slave_open_temp_tables 0 0
4757+Slave_received_heartbeats 0 0
4758+Slave_retried_transactions 0 0
4759+Slave_running OFF OFF
4760+Slow_launch_threads 0 0
4761+Slow_queries 0 0
4762+Sort_merge_passes 0 0
4763+Sort_range 0 0
4764+Sort_rows 0 0
4765+Sort_scan 0 0
4766+Ssl_accept_renegotiates 0 0
4767+Ssl_accepts 0 0
4768+Ssl_callback_cache_hits 0 0
4769+Ssl_cipher
4770+Ssl_cipher_list
4771+Ssl_client_connects 0 0
4772+Ssl_connect_renegotiates 0 0
4773+Ssl_ctx_verify_depth 0 0
4774+Ssl_ctx_verify_mode 0 0
4775+Ssl_default_timeout 0 0
4776+Ssl_finished_accepts 0 0
4777+Ssl_finished_connects 0 0
4778+Ssl_session_cache_hits 0 0
4779+Ssl_session_cache_misses 0 0
4780+Ssl_session_cache_mode NONE NONE
4781+Ssl_session_cache_overflows 0 0
4782+Ssl_session_cache_size 0 0
4783+Ssl_session_cache_timeouts 0 0
4784+Ssl_sessions_reused 0 0
4785+Ssl_used_session_cache_entries 0 0
4786+Ssl_verify_depth 0 0
4787+Ssl_verify_mode 0 0
4788+Ssl_version
4789+Table_locks_immediate 189 190
4790+Table_locks_waited 0 0
4791+Tc_log_max_pages_used 0 0
4792+Tc_log_page_size 0 0
4793+Tc_log_page_waits 0 0
4794+Threads_cached 0 0
4795+Threads_connected 2 2
4796+Threads_created 14 28
4797+Threads_running 2 2
4798+Uptime 96 107
4799+Uptime_since_flush_status 96 107
4800+binlog_commits 5 5
4801+binlog_group_commits 5 5
4802+wsrep_cluster_conf_id 18446744073709551615 18446744073709551615
4803+wsrep_cluster_size 0 0
4804+wsrep_cluster_state_uuid
4805+wsrep_cluster_status Disconnected Disconnected
4806+wsrep_connected OFF OFF
4807+wsrep_local_index 4294967295 4294967295
4808+wsrep_provider_name
4809+wsrep_provider_vendor
4810+wsrep_provider_version
4811+wsrep_ready ON ON
4812
4813=== added file 't/pt-mysql-summary/samples/temp007/mysql-users'
4814--- t/pt-mysql-summary/samples/temp007/mysql-users 1970-01-01 00:00:00 +0000
4815+++ t/pt-mysql-summary/samples/temp007/mysql-users 2012-12-04 16:32:31 +0000
4816@@ -0,0 +1,1 @@
4817+2 0 0 0
4818
4819=== added file 't/pt-mysql-summary/samples/temp007/mysql-variables'
4820--- t/pt-mysql-summary/samples/temp007/mysql-variables 1970-01-01 00:00:00 +0000
4821+++ t/pt-mysql-summary/samples/temp007/mysql-variables 2012-12-04 16:32:31 +0000
4822@@ -0,0 +1,423 @@
4823+auto_increment_increment 1
4824+auto_increment_offset 1
4825+autocommit ON
4826+automatic_sp_privileges ON
4827+back_log 50
4828+basedir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686
4829+big_tables OFF
4830+binlog_cache_size 32768
4831+binlog_direct_non_transactional_updates OFF
4832+binlog_format STATEMENT
4833+binlog_stmt_cache_size 32768
4834+bulk_insert_buffer_size 8388608
4835+character_set_client latin1
4836+character_set_connection latin1
4837+character_set_database latin1
4838+character_set_filesystem binary
4839+character_set_results latin1
4840+character_set_server latin1
4841+character_set_system utf8
4842+character_sets_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/share/charsets/
4843+collation_connection latin1_swedish_ci
4844+collation_database latin1_swedish_ci
4845+collation_server latin1_swedish_ci
4846+completion_type NO_CHAIN
4847+concurrent_insert AUTO
4848+connect_timeout 10
4849+datadir /tmp/12345/data/
4850+date_format %Y-%m-%d
4851+datetime_format %Y-%m-%d %H:%i:%s
4852+default_storage_engine InnoDB
4853+default_week_format 0
4854+delay_key_write ON
4855+delayed_insert_limit 100
4856+delayed_insert_timeout 300
4857+delayed_queue_size 1000
4858+div_precision_increment 4
4859+enforce_storage_engine
4860+engine_condition_pushdown ON
4861+event_scheduler OFF
4862+expand_fast_index_creation OFF
4863+expire_logs_days 0
4864+fast_index_creation ON
4865+flush OFF
4866+flush_time 0
4867+foreign_key_checks ON
4868+ft_boolean_syntax + -><()~*:""&|
4869+ft_max_word_len 84
4870+ft_min_word_len 4
4871+ft_query_expansion_limit 20
4872+ft_stopword_file (built-in)
4873+general_log ON
4874+general_log_file genlog
4875+group_concat_max_len 1024
4876+have_compress YES
4877+have_crypt YES
4878+have_csv YES
4879+have_dynamic_loading YES
4880+have_flashcache YES
4881+have_geometry YES
4882+have_innodb YES
4883+have_ndbcluster NO
4884+have_openssl DISABLED
4885+have_partitioning YES
4886+have_profiling YES
4887+have_query_cache YES
4888+have_response_time_distribution YES
4889+have_rtree_keys YES
4890+have_ssl DISABLED
4891+have_symlink YES
4892+hostname hugmeir
4893+ignore_builtin_innodb OFF
4894+init_connect
4895+init_file
4896+init_slave
4897+innodb_adaptive_flushing ON
4898+innodb_adaptive_flushing_method estimate
4899+innodb_adaptive_hash_index ON
4900+innodb_adaptive_hash_index_partitions 1
4901+innodb_additional_mem_pool_size 8388608
4902+innodb_autoextend_increment 8
4903+innodb_autoinc_lock_mode 1
4904+innodb_blocking_buffer_pool_restore OFF
4905+innodb_buffer_pool_instances 1
4906+innodb_buffer_pool_populate OFF
4907+innodb_buffer_pool_restore_at_startup 0
4908+innodb_buffer_pool_shm_checksum ON
4909+innodb_buffer_pool_shm_key 0
4910+innodb_buffer_pool_size 33554432
4911+innodb_change_buffering all
4912+innodb_changed_pages_limit 1000000
4913+innodb_checkpoint_age_target 0
4914+innodb_checksums ON
4915+innodb_commit_concurrency 0
4916+innodb_concurrency_tickets 500
4917+innodb_corrupt_table_action assert
4918+innodb_data_file_path ibdata1:10M:autoextend
4919+innodb_data_home_dir /tmp/12345/data
4920+innodb_dict_size_limit 0
4921+innodb_disallow_writes OFF
4922+innodb_doublewrite ON
4923+innodb_doublewrite_file
4924+innodb_fake_changes OFF
4925+innodb_fast_checksum OFF
4926+innodb_fast_shutdown 1
4927+innodb_file_format Antelope
4928+innodb_file_format_check ON
4929+innodb_file_format_max Antelope
4930+innodb_file_per_table OFF
4931+innodb_flush_log_at_trx_commit 1
4932+innodb_flush_method
4933+innodb_flush_neighbor_pages area
4934+innodb_force_load_corrupted OFF
4935+innodb_force_recovery 0
4936+innodb_ibuf_accel_rate 100
4937+innodb_ibuf_active_contract 1
4938+innodb_ibuf_max_size 16760832
4939+innodb_import_table_from_xtrabackup 0
4940+innodb_io_capacity 200
4941+innodb_kill_idle_transaction 0
4942+innodb_large_prefix OFF
4943+innodb_lazy_drop_table 0
4944+innodb_lock_wait_timeout 3
4945+innodb_locks_unsafe_for_binlog OFF
4946+innodb_log_block_size 512
4947+innodb_log_buffer_size 8388608
4948+innodb_log_file_size 5242880
4949+innodb_log_files_in_group 2
4950+innodb_log_group_home_dir /tmp/12345/data
4951+innodb_max_dirty_pages_pct 75
4952+innodb_max_purge_lag 0
4953+innodb_merge_sort_block_size 1048576
4954+innodb_mirrored_log_groups 1
4955+innodb_old_blocks_pct 37
4956+innodb_old_blocks_time 0
4957+innodb_open_files 300
4958+innodb_page_size 16384
4959+innodb_purge_batch_size 20
4960+innodb_purge_threads 1
4961+innodb_random_read_ahead OFF
4962+innodb_read_ahead linear
4963+innodb_read_ahead_threshold 56
4964+innodb_read_io_threads 4
4965+innodb_recovery_stats OFF
4966+innodb_recovery_update_relay_log OFF
4967+innodb_replication_delay 0
4968+innodb_rollback_on_timeout OFF
4969+innodb_rollback_segments 128
4970+innodb_show_locks_held 10
4971+innodb_show_verbose_locks 0
4972+innodb_spin_wait_delay 6
4973+innodb_stats_auto_update 1
4974+innodb_stats_method nulls_equal
4975+innodb_stats_on_metadata ON
4976+innodb_stats_sample_pages 8
4977+innodb_stats_update_need_lock 1
4978+innodb_strict_mode OFF
4979+innodb_support_xa ON
4980+innodb_sync_spin_loops 30
4981+innodb_table_locks ON
4982+innodb_thread_concurrency 0
4983+innodb_thread_concurrency_timer_based OFF
4984+innodb_thread_sleep_delay 10000
4985+innodb_track_changed_pages OFF
4986+innodb_use_global_flush_log_at_trx_commit ON
4987+innodb_use_native_aio ON
4988+innodb_use_sys_malloc ON
4989+innodb_use_sys_stats_table OFF
4990+innodb_version 1.1.8-rel29.1
4991+innodb_write_io_threads 4
4992+interactive_timeout 28800
4993+join_buffer_size 131072
4994+keep_files_on_create OFF
4995+key_buffer_size 16777216
4996+key_cache_age_threshold 300
4997+key_cache_block_size 1024
4998+key_cache_division_limit 100
4999+large_files_support ON
5000+large_page_size 0
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches