Merge lp:~percona-toolkit-dev/percona-toolkit/release-2.2.11 into lp:percona-toolkit/2.2

Proposed by Tomislav Plavcic on 2014-09-29
Status: Merged
Merged at revision: 610
Proposed branch: lp:~percona-toolkit-dev/percona-toolkit/release-2.2.11
Merge into: lp:percona-toolkit/2.2
Diff against target: 2637 lines (+1216/-164)
72 files modified
Changelog (+10/-0)
Makefile.PL (+1/-1)
bin/pt-align (+1/-1)
bin/pt-archiver (+2/-2)
bin/pt-config-diff (+2/-2)
bin/pt-deadlock-logger (+2/-2)
bin/pt-diskstats (+2/-2)
bin/pt-duplicate-key-checker (+2/-2)
bin/pt-fifo-split (+1/-1)
bin/pt-find (+2/-2)
bin/pt-fingerprint (+1/-1)
bin/pt-fk-error-logger (+2/-2)
bin/pt-heartbeat (+2/-2)
bin/pt-index-usage (+4/-2)
bin/pt-ioprofile (+1/-1)
bin/pt-kill (+2/-2)
bin/pt-mext (+1/-1)
bin/pt-mysql-summary (+14/-21)
bin/pt-online-schema-change (+2/-2)
bin/pt-pmp (+1/-1)
bin/pt-query-digest (+4/-2)
bin/pt-show-grants (+1/-1)
bin/pt-sift (+1/-1)
bin/pt-slave-delay (+2/-2)
bin/pt-slave-find (+1/-1)
bin/pt-slave-restart (+2/-2)
bin/pt-stalk (+20/-6)
bin/pt-summary (+2/-2)
bin/pt-table-checksum (+2/-2)
bin/pt-table-sync (+2/-2)
bin/pt-table-usage (+3/-1)
bin/pt-upgrade (+4/-2)
bin/pt-variable-advisor (+5/-5)
bin/pt-visual-explain (+1/-1)
config/deb/changelog (+12/-0)
config/rpm/percona-toolkit.spec (+1/-1)
config/sphinx-build/conf.py (+1/-1)
docs/percona-toolkit.pod (+1/-1)
docs/release_notes.rst (+28/-0)
lib/Percona/Toolkit.pm (+1/-1)
lib/Sandbox.pm (+4/-0)
lib/SlowLogParser.pm (+2/-0)
lib/VariableAdvisorRules.pm (+2/-2)
lib/bash/report_mysql_info.sh (+15/-24)
lib/bash/report_system_info.sh (+1/-1)
sandbox/start-sandbox (+1/-1)
t/lib/Percona/Toolkit.t (+16/-0)
t/lib/SlowLogParser.t (+20/-20)
t/lib/VariableAdvisorRules.t (+5/-5)
t/lib/bash/report_mysql_info.sh (+1/-0)
t/lib/bash/report_system_info.sh (+11/-1)
t/pt-duplicate-key-checker/standard_options.t (+26/-1)
t/pt-fifo-split/pt-fifo-split.t (+6/-0)
t/pt-mysql-summary/samples/my.cnf-001.txt (+2/-0)
t/pt-query-digest/samples/slow008_report.txt (+3/-3)
t/pt-query-digest/samples/slow011_report.txt (+2/-2)
t/pt-query-digest/samples/slow013_report.txt (+4/-4)
t/pt-query-digest/samples/slow013_report_fingerprint_user.txt (+2/-2)
t/pt-query-digest/samples/slow013_report_limit.txt (+1/-1)
t/pt-query-digest/samples/slow013_report_outliers.txt (+2/-2)
t/pt-query-digest/samples/slow013_report_user.txt (+2/-2)
t/pt-query-digest/samples/slow019_report.txt (+2/-2)
t/pt-query-digest/samples/slow055.txt (+1/-1)
t/pt-query-digest/samples/slow056.txt (+2/-2)
t/pt-query-digest/samples/slow057.txt (+1/-1)
t/pt-query-digest/samples/slow058.txt (+3/-3)
t/pt-summary/samples/dmidecode-006.txt (+920/-0)
t/pt-variable-advisor/samples/vars001-ignore-rules.txt (+2/-0)
t/pt-variable-advisor/samples/vars001-verbose-verbose.txt (+2/-0)
t/pt-variable-advisor/samples/vars001-verbose.txt (+2/-0)
t/pt-variable-advisor/samples/vars001.txt (+2/-0)
t/pt-variable-advisor/samples/vars002.txt (+2/-0)
To merge this branch: bzr merge lp:~percona-toolkit-dev/percona-toolkit/release-2.2.11
Reviewer Review Type Date Requested Status
Daniel Nichter 2014-09-29 Approve on 2014-10-13
Review via email: mp+236415@code.launchpad.net

Description of the change

Release branch for version 2.2.11

To post a comment you must log in.
Daniel Nichter (daniel-nichter) wrote :

On quick look, looks good, just sort the changelog entries if you all want to continue this practice.

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'Changelog'
2--- Changelog 2014-08-06 19:55:47 +0000
3+++ Changelog 2014-09-29 19:43:03 +0000
4@@ -1,5 +1,15 @@
5 Changelog for Percona Toolkit
6
7+v2.2.11 released 2014-09-26
8+
9+ * Fixed bug 1262456: pt-query-digest doesn't report host details
10+ * Fixed bug 1264580: pt-mysql-summary incorrectly tries to parse key/value pairs in wsrep_provider_options resulting in incomplete my.cnf information
11+ * Fixed bug 1318985: pt-stalk should use SQL_NO_CACHE
12+ * Fixed bug 1348679: pt-stalk handles mysql user password in awkward way
13+ * Fixed bug 1365085: Various issues with tests
14+ * Fixed bug 1368379: pt-summary problem parsing dmidecode output on some machines
15+ * Fixed bug 1303388: Typo in pt-variable-advisor
16+
17 v2.2.10 released 2014-08-06
18
19 * Fixed bug 1287253: pt-table-checksum deadlock
20
21=== modified file 'Makefile.PL'
22--- Makefile.PL 2014-08-06 19:55:47 +0000
23+++ Makefile.PL 2014-09-29 19:43:03 +0000
24@@ -2,7 +2,7 @@
25
26 WriteMakefile(
27 NAME => 'percona-toolkit',
28- VERSION => '2.2.10',
29+ VERSION => '2.2.11',
30 EXE_FILES => [ <bin/*> ],
31 MAN1PODS => {
32 'docs/percona-toolkit.pod' => 'blib/man1/percona-toolkit.1p',
33
34=== modified file 'bin/pt-align'
35--- bin/pt-align 2014-08-05 20:37:42 +0000
36+++ bin/pt-align 2014-09-29 19:43:03 +0000
37@@ -1323,6 +1323,6 @@
38
39 =head1 VERSION
40
41-pt-align 2.2.10
42+pt-align 2.2.11
43
44 =cut
45
46=== modified file 'bin/pt-archiver'
47--- bin/pt-archiver 2014-08-05 20:37:42 +0000
48+++ bin/pt-archiver 2014-09-29 19:43:03 +0000
49@@ -43,7 +43,7 @@
50 {
51 package Percona::Toolkit;
52
53-our $VERSION = '2.2.10';
54+our $VERSION = '2.2.11';
55
56 use strict;
57 use warnings FATAL => 'all';
58@@ -7892,6 +7892,6 @@
59
60 =head1 VERSION
61
62-pt-archiver 2.2.10
63+pt-archiver 2.2.11
64
65 =cut
66
67=== modified file 'bin/pt-config-diff'
68--- bin/pt-config-diff 2014-08-05 20:37:42 +0000
69+++ bin/pt-config-diff 2014-09-29 19:43:03 +0000
70@@ -43,7 +43,7 @@
71 {
72 package Percona::Toolkit;
73
74-our $VERSION = '2.2.10';
75+our $VERSION = '2.2.11';
76
77 use strict;
78 use warnings FATAL => 'all';
79@@ -5733,6 +5733,6 @@
80
81 =head1 VERSION
82
83-pt-config-diff 2.2.10
84+pt-config-diff 2.2.11
85
86 =cut
87
88=== modified file 'bin/pt-deadlock-logger'
89--- bin/pt-deadlock-logger 2014-08-05 20:37:42 +0000
90+++ bin/pt-deadlock-logger 2014-09-29 19:43:03 +0000
91@@ -42,7 +42,7 @@
92 {
93 package Percona::Toolkit;
94
95-our $VERSION = '2.2.10';
96+our $VERSION = '2.2.11';
97
98 use strict;
99 use warnings FATAL => 'all';
100@@ -5523,6 +5523,6 @@
101
102 =head1 VERSION
103
104-pt-deadlock-logger 2.2.10
105+pt-deadlock-logger 2.2.11
106
107 =cut
108
109=== modified file 'bin/pt-diskstats'
110--- bin/pt-diskstats 2014-08-05 20:37:42 +0000
111+++ bin/pt-diskstats 2014-09-29 19:43:03 +0000
112@@ -38,7 +38,7 @@
113 {
114 package Percona::Toolkit;
115
116-our $VERSION = '2.2.10';
117+our $VERSION = '2.2.11';
118
119 use strict;
120 use warnings FATAL => 'all';
121@@ -5579,6 +5579,6 @@
122
123 =head1 VERSION
124
125-pt-diskstats 2.2.10
126+pt-diskstats 2.2.11
127
128 =cut
129
130=== modified file 'bin/pt-duplicate-key-checker'
131--- bin/pt-duplicate-key-checker 2014-08-05 20:37:42 +0000
132+++ bin/pt-duplicate-key-checker 2014-09-29 19:43:03 +0000
133@@ -39,7 +39,7 @@
134 {
135 package Percona::Toolkit;
136
137-our $VERSION = '2.2.10';
138+our $VERSION = '2.2.11';
139
140 use strict;
141 use warnings FATAL => 'all';
142@@ -5600,6 +5600,6 @@
143
144 =head1 VERSION
145
146-pt-duplicate-key-checker 2.2.10
147+pt-duplicate-key-checker 2.2.11
148
149 =cut
150
151=== modified file 'bin/pt-fifo-split'
152--- bin/pt-fifo-split 2014-08-05 20:37:42 +0000
153+++ bin/pt-fifo-split 2014-09-29 19:43:03 +0000
154@@ -1612,6 +1612,6 @@
155
156 =head1 VERSION
157
158-pt-fifo-split 2.2.10
159+pt-fifo-split 2.2.11
160
161 =cut
162
163=== modified file 'bin/pt-find'
164--- bin/pt-find 2014-08-05 20:37:42 +0000
165+++ bin/pt-find 2014-09-29 19:43:03 +0000
166@@ -35,7 +35,7 @@
167 {
168 package Percona::Toolkit;
169
170-our $VERSION = '2.2.10';
171+our $VERSION = '2.2.11';
172
173 use strict;
174 use warnings FATAL => 'all';
175@@ -4984,6 +4984,6 @@
176
177 =head1 VERSION
178
179-pt-find 2.2.10
180+pt-find 2.2.11
181
182 =cut
183
184=== modified file 'bin/pt-fingerprint'
185--- bin/pt-fingerprint 2014-08-05 20:37:42 +0000
186+++ bin/pt-fingerprint 2014-09-29 19:43:03 +0000
187@@ -2203,6 +2203,6 @@
188
189 =head1 VERSION
190
191-pt-fingerprint 2.2.10
192+pt-fingerprint 2.2.11
193
194 =cut
195
196=== modified file 'bin/pt-fk-error-logger'
197--- bin/pt-fk-error-logger 2014-08-05 20:37:42 +0000
198+++ bin/pt-fk-error-logger 2014-09-29 19:43:03 +0000
199@@ -37,7 +37,7 @@
200 {
201 package Percona::Toolkit;
202
203-our $VERSION = '2.2.10';
204+our $VERSION = '2.2.11';
205
206 use strict;
207 use warnings FATAL => 'all';
208@@ -4509,6 +4509,6 @@
209
210 =head1 VERSION
211
212-pt-fk-error-logger 2.2.10
213+pt-fk-error-logger 2.2.11
214
215 =cut
216
217=== modified file 'bin/pt-heartbeat'
218--- bin/pt-heartbeat 2014-08-05 20:37:42 +0000
219+++ bin/pt-heartbeat 2014-09-29 19:43:03 +0000
220@@ -38,7 +38,7 @@
221 {
222 package Percona::Toolkit;
223
224-our $VERSION = '2.2.10';
225+our $VERSION = '2.2.11';
226
227 use strict;
228 use warnings FATAL => 'all';
229@@ -6192,6 +6192,6 @@
230
231 =head1 VERSION
232
233-pt-heartbeat 2.2.10
234+pt-heartbeat 2.2.11
235
236 =cut
237
238=== modified file 'bin/pt-index-usage'
239--- bin/pt-index-usage 2014-08-05 20:37:42 +0000
240+++ bin/pt-index-usage 2014-09-29 19:43:03 +0000
241@@ -45,7 +45,7 @@
242 {
243 package Percona::Toolkit;
244
245-our $VERSION = '2.2.10';
246+our $VERSION = '2.2.11';
247
248 use strict;
249 use warnings FATAL => 'all';
250@@ -2845,6 +2845,7 @@
251 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
252 ) {
253 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
254+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
255 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
256 if ( $thread_id ) {
257 push @properties, 'Thread_id', $thread_id;
258@@ -2857,6 +2858,7 @@
259 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
260 ) {
261 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
262+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
263 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
264 if ( $thread_id ) {
265 push @properties, 'Thread_id', $thread_id;
266@@ -7546,6 +7548,6 @@
267
268 =head1 VERSION
269
270-pt-index-usage 2.2.10
271+pt-index-usage 2.2.11
272
273 =cut
274
275=== modified file 'bin/pt-ioprofile'
276--- bin/pt-ioprofile 2014-08-05 20:37:42 +0000
277+++ bin/pt-ioprofile 2014-09-29 19:43:03 +0000
278@@ -1119,7 +1119,7 @@
279
280 =head1 VERSION
281
282-pt-ioprofile 2.2.10
283+pt-ioprofile 2.2.11
284
285 =cut
286
287
288=== modified file 'bin/pt-kill'
289--- bin/pt-kill 2014-08-05 20:37:42 +0000
290+++ bin/pt-kill 2014-09-29 19:43:03 +0000
291@@ -47,7 +47,7 @@
292 {
293 package Percona::Toolkit;
294
295-our $VERSION = '2.2.10';
296+our $VERSION = '2.2.11';
297
298 use strict;
299 use warnings FATAL => 'all';
300@@ -8183,6 +8183,6 @@
301
302 =head1 VERSION
303
304-pt-kill 2.2.10
305+pt-kill 2.2.11
306
307 =cut
308
309=== modified file 'bin/pt-mext'
310--- bin/pt-mext 2014-08-05 20:37:42 +0000
311+++ bin/pt-mext 2014-09-29 19:43:03 +0000
312@@ -792,7 +792,7 @@
313
314 =head1 VERSION
315
316-pt-mext 2.2.10
317+pt-mext 2.2.11
318
319 =cut
320
321
322=== modified file 'bin/pt-mysql-summary'
323--- bin/pt-mysql-summary 2014-08-05 20:37:42 +0000
324+++ bin/pt-mysql-summary 2014-09-29 19:43:03 +0000
325@@ -1353,26 +1353,19 @@
326
327 [ -e "$file" ] || return
328
329- awk '
330- BEGIN {
331- FS="="
332- }
333- /^[ \t]*[a-zA-Z[]/ {
334- if (length($2)) {
335- gsub(/^[ \t]*/, "", $1);
336- gsub(/^[ \t]*/, "", $2);
337- gsub(/[ \t]*$/, "", $1);
338- gsub(/[ \t]*$/, "", $2);
339- printf("%-35s = %s\n", $1, $2);
340- }
341- else if ( $0 ~ /\[/ ) {
342- print "";
343- print $1;
344- }
345- else {
346- print $1;
347- }
348- }' "$file"
349+ perl -n -l -e '
350+ my $line = $_;
351+ if ( $line =~ /^[ \t]*[a-zA-Z[]/ ) {
352+ if ( $line=~/\s*(.*?)\s*=\s*(.*)\s*$/ ) {
353+ printf("%-35s = %s\n", $1, $2)
354+ }
355+ elsif ( $line =~ /\s*\[/ ) {
356+ print "\n$line"
357+ } else {
358+ print $line
359+ }
360+ }' "$file"
361+
362 }
363
364 find_checkpoint_age() {
365@@ -3090,7 +3083,7 @@
366
367 =head1 VERSION
368
369-pt-mysql-summary 2.2.10
370+pt-mysql-summary 2.2.11
371
372 =cut
373
374
375=== modified file 'bin/pt-online-schema-change'
376--- bin/pt-online-schema-change 2014-08-05 20:37:42 +0000
377+++ bin/pt-online-schema-change 2014-09-29 19:43:03 +0000
378@@ -54,7 +54,7 @@
379 {
380 package Percona::Toolkit;
381
382-our $VERSION = '2.2.10';
383+our $VERSION = '2.2.11';
384
385 use strict;
386 use warnings FATAL => 'all';
387@@ -11563,6 +11563,6 @@
388
389 =head1 VERSION
390
391-pt-online-schema-change 2.2.10
392+pt-online-schema-change 2.2.11
393
394 =cut
395
396=== modified file 'bin/pt-pmp'
397--- bin/pt-pmp 2014-08-05 20:37:42 +0000
398+++ bin/pt-pmp 2014-09-29 19:43:03 +0000
399@@ -889,7 +889,7 @@
400
401 =head1 VERSION
402
403-pt-pmp 2.2.10
404+pt-pmp 2.2.11
405
406 =cut
407
408
409=== modified file 'bin/pt-query-digest'
410--- bin/pt-query-digest 2014-08-05 20:37:42 +0000
411+++ bin/pt-query-digest 2014-09-29 19:43:03 +0000
412@@ -64,7 +64,7 @@
413 {
414 package Percona::Toolkit;
415
416-our $VERSION = '2.2.10';
417+our $VERSION = '2.2.11';
418
419 use strict;
420 use warnings FATAL => 'all';
421@@ -5039,6 +5039,7 @@
422 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
423 ) {
424 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
425+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
426 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
427 if ( $thread_id ) {
428 push @properties, 'Thread_id', $thread_id;
429@@ -5051,6 +5052,7 @@
430 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
431 ) {
432 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
433+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
434 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
435 if ( $thread_id ) {
436 push @properties, 'Thread_id', $thread_id;
437@@ -16593,6 +16595,6 @@
438
439 =head1 VERSION
440
441-pt-query-digest 2.2.10
442+pt-query-digest 2.2.11
443
444 =cut
445
446=== modified file 'bin/pt-show-grants'
447--- bin/pt-show-grants 2014-08-05 20:37:42 +0000
448+++ bin/pt-show-grants 2014-09-29 19:43:03 +0000
449@@ -2406,6 +2406,6 @@
450
451 =head1 VERSION
452
453-pt-show-grants 2.2.10
454+pt-show-grants 2.2.11
455
456 =cut
457
458=== modified file 'bin/pt-sift'
459--- bin/pt-sift 2014-08-05 20:37:42 +0000
460+++ bin/pt-sift 2014-09-29 19:43:03 +0000
461@@ -1237,7 +1237,7 @@
462
463 =head1 VERSION
464
465-pt-sift 2.2.10
466+pt-sift 2.2.11
467
468 =cut
469
470
471=== modified file 'bin/pt-slave-delay'
472--- bin/pt-slave-delay 2014-08-05 20:37:42 +0000
473+++ bin/pt-slave-delay 2014-09-29 19:43:03 +0000
474@@ -40,7 +40,7 @@
475 {
476 package Percona::Toolkit;
477
478-our $VERSION = '2.2.10';
479+our $VERSION = '2.2.11';
480
481 use strict;
482 use warnings FATAL => 'all';
483@@ -4869,6 +4869,6 @@
484
485 =head1 VERSION
486
487-pt-slave-delay 2.2.10
488+pt-slave-delay 2.2.11
489
490 =cut
491
492=== modified file 'bin/pt-slave-find'
493--- bin/pt-slave-find 2014-08-05 20:37:42 +0000
494+++ bin/pt-slave-find 2014-09-29 19:43:03 +0000
495@@ -4334,6 +4334,6 @@
496
497 =head1 VERSION
498
499-pt-slave-find 2.2.10
500+pt-slave-find 2.2.11
501
502 =cut
503
504=== modified file 'bin/pt-slave-restart'
505--- bin/pt-slave-restart 2014-08-05 20:37:42 +0000
506+++ bin/pt-slave-restart 2014-09-29 19:43:03 +0000
507@@ -41,7 +41,7 @@
508 {
509 package Percona::Toolkit;
510
511-our $VERSION = '2.2.10';
512+our $VERSION = '2.2.11';
513
514 use strict;
515 use warnings FATAL => 'all';
516@@ -5937,6 +5937,6 @@
517
518 =head1 VERSION
519
520-pt-slave-restart 2.2.10
521+pt-slave-restart 2.2.11
522
523 =cut
524
525=== modified file 'bin/pt-stalk'
526--- bin/pt-stalk 2014-08-05 20:37:42 +0000
527+++ bin/pt-stalk 2014-09-29 19:43:03 +0000
528@@ -1001,7 +1001,7 @@
529 }
530
531 lock_waits() {
532- local sql1="SELECT
533+ local sql1="SELECT SQL_NO_CACHE
534 CONCAT('thread ', b.trx_mysql_thread_id, ' from ', p.host) AS who_blocks,
535 IF(p.command = \"Sleep\", p.time, 0) AS idle_in_trx,
536 MAX(TIMESTAMPDIFF(SECOND, r.trx_wait_started, CURRENT_TIMESTAMP)) AS max_wait_time,
537@@ -1013,7 +1013,7 @@
538 GROUP BY who_blocks ORDER BY num_waiters DESC\G"
539 $CMD_MYSQL $EXT_ARGV -e "$sql1"
540
541- local sql2="SELECT
542+ local sql2="SELECT SQL_NO_CACHE
543 r.trx_id AS waiting_trx_id,
544 r.trx_mysql_thread_id AS waiting_thread,
545 TIMESTAMPDIFF(SECOND, r.trx_wait_started, CURRENT_TIMESTAMP) AS wait_time,
546@@ -1034,9 +1034,9 @@
547 }
548
549 transactions() {
550- $CMD_MYSQL $EXT_ARGV -e "SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX\G"
551- $CMD_MYSQL $EXT_ARGV -e "SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS\G"
552- $CMD_MYSQL $EXT_ARGV -e "SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS\G"
553+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_TRX\G"
554+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCKS\G"
555+ $CMD_MYSQL $EXT_ARGV -e "SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS\G"
556 }
557
558 innodb_status() {
559@@ -1447,9 +1447,19 @@
560 exit 0
561 fi
562
563+ # if ASK-PASS , request password on terminal without echoing. This will override --password
564+ if [ -n "$OPT_ASK_PASS" ]; then
565+ stty_orig=`stty -g` # save original terminal setting.
566+ echo -n "Enter MySQL password: ";
567+ stty -echo # turn-off echoing.
568+ read OPT_PASSWORD # read the password
569+ stty $stty_orig # restore terminal setting.
570+ fi
571+
572 MYSQL_ARGS="$(mysql_options)"
573 EXT_ARGV="$(arrange_mysql_options "$EXT_ARGV $MYSQL_ARGS")"
574
575+
576 # Check that mysql and mysqladmin are in PATH. If not, we're
577 # already dead in the water, so don't bother with cmd line opts,
578 # just error and exit.
579@@ -1650,6 +1660,10 @@
580
581 =over
582
583+=item --ask-pass
584+
585+Prompt for a password when connecting to MySQL.
586+
587 =item --collect
588
589 default: yes; negatable: yes
590@@ -2211,7 +2225,7 @@
591
592 =head1 VERSION
593
594-pt-stalk 2.2.10
595+pt-stalk 2.2.11
596
597 =cut
598
599
600=== modified file 'bin/pt-summary'
601--- bin/pt-summary 2014-08-05 20:37:42 +0000
602+++ bin/pt-summary 2014-09-29 19:43:03 +0000
603@@ -1506,7 +1506,7 @@
604 -e 's/>/}/g' \
605 -e 's/[ \t]*\n/\n/g' \
606 "${file}" \
607- | awk -F: '/Size|Type|Form.Factor|Type.Detail|[^ ]Locator/{printf("|%s", $2)}/Speed/{print "|" $2}' \
608+ | awk -F: '/Size|Type|Form.Factor|Type.Detail|^[\t ]+Locator/{printf("|%s", $2)}/^[\t ]+Speed/{print "|" $2}' \
609 | sed -e 's/No Module Installed/{EMPTY}/' \
610 | sort \
611 | awk -F'|' '{printf(" %-9s %-8s %-17s %-13s %-13s %-8s\n", $4, $2, $7, $3, $5, $6);}'
612@@ -2691,7 +2691,7 @@
613
614 =head1 VERSION
615
616-pt-summary 2.2.10
617+pt-summary 2.2.11
618
619 =cut
620
621
622=== modified file 'bin/pt-table-checksum'
623--- bin/pt-table-checksum 2014-08-05 20:37:42 +0000
624+++ bin/pt-table-checksum 2014-09-29 19:43:03 +0000
625@@ -57,7 +57,7 @@
626 {
627 package Percona::Toolkit;
628
629-our $VERSION = '2.2.10';
630+our $VERSION = '2.2.11';
631
632 use strict;
633 use warnings FATAL => 'all';
634@@ -12698,6 +12698,6 @@
635
636 =head1 VERSION
637
638-pt-table-checksum 2.2.10
639+pt-table-checksum 2.2.11
640
641 =cut
642
643=== modified file 'bin/pt-table-sync'
644--- bin/pt-table-sync 2014-08-05 20:37:42 +0000
645+++ bin/pt-table-sync 2014-09-29 19:43:03 +0000
646@@ -55,7 +55,7 @@
647 {
648 package Percona::Toolkit;
649
650-our $VERSION = '2.2.10';
651+our $VERSION = '2.2.11';
652
653 use strict;
654 use warnings FATAL => 'all';
655@@ -12768,6 +12768,6 @@
656
657 =head1 VERSION
658
659-pt-table-sync 2.2.10
660+pt-table-sync 2.2.11
661
662 =cut
663
664=== modified file 'bin/pt-table-usage'
665--- bin/pt-table-usage 2014-08-05 20:37:42 +0000
666+++ bin/pt-table-usage 2014-09-29 19:43:03 +0000
667@@ -1629,6 +1629,7 @@
668 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
669 ) {
670 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
671+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
672 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
673 if ( $thread_id ) {
674 push @properties, 'Thread_id', $thread_id;
675@@ -1641,6 +1642,7 @@
676 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
677 ) {
678 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
679+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
680 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
681 if ( $thread_id ) {
682 push @properties, 'Thread_id', $thread_id;
683@@ -7561,6 +7563,6 @@
684
685 =head1 VERSION
686
687-pt-table-usage 2.2.10
688+pt-table-usage 2.2.11
689
690 =cut
691
692=== modified file 'bin/pt-upgrade'
693--- bin/pt-upgrade 2014-08-05 20:37:42 +0000
694+++ bin/pt-upgrade 2014-09-29 19:43:03 +0000
695@@ -61,7 +61,7 @@
696 {
697 package Percona::Toolkit;
698
699-our $VERSION = '2.2.10';
700+our $VERSION = '2.2.11';
701
702 use strict;
703 use warnings FATAL => 'all';
704@@ -6610,6 +6610,7 @@
705 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
706 ) {
707 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
708+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
709 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
710 if ( $thread_id ) {
711 push @properties, 'Thread_id', $thread_id;
712@@ -6622,6 +6623,7 @@
713 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
714 ) {
715 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
716+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
717 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
718 if ( $thread_id ) {
719 push @properties, 'Thread_id', $thread_id;
720@@ -11238,6 +11240,6 @@
721
722 =head1 VERSION
723
724-pt-upgrade 2.2.10
725+pt-upgrade 2.2.11
726
727 =cut
728
729=== modified file 'bin/pt-variable-advisor'
730--- bin/pt-variable-advisor 2014-08-05 20:37:42 +0000
731+++ bin/pt-variable-advisor 2014-09-29 19:43:03 +0000
732@@ -44,7 +44,7 @@
733 {
734 package Percona::Toolkit;
735
736-our $VERSION = '2.2.10';
737+our $VERSION = '2.2.11';
738
739 use strict;
740 use warnings FATAL => 'all';
741@@ -3601,10 +3601,10 @@
742 },
743 },
744 {
745- id => 'expire_log_days',
746+ id => 'expire_logs_days',
747 code => sub {
748 my ( %args ) = @_;
749- return _var_eq($args{variables}->{expire_log_days}, 0)
750+ return _var_eq($args{variables}->{expire_logs_days}, 0)
751 && _var_seq($args{variables}->{log_bin}, "ON");
752 },
753 },
754@@ -5720,7 +5720,7 @@
755 Most applications should use the default REPEATABLE-READ transaction
756 isolation level, or in a few cases READ-COMMITTED.
757
758-=item expire_log_days
759+=item expire_logs_days
760
761 severity: warn
762
763@@ -6138,6 +6138,6 @@
764
765 =head1 VERSION
766
767-pt-variable-advisor 2.2.10
768+pt-variable-advisor 2.2.11
769
770 =cut
771
772=== modified file 'bin/pt-visual-explain'
773--- bin/pt-visual-explain 2014-08-05 20:37:42 +0000
774+++ bin/pt-visual-explain 2014-09-29 19:43:03 +0000
775@@ -3243,6 +3243,6 @@
776
777 =head1 VERSION
778
779-pt-visual-explain 2.2.10
780+pt-visual-explain 2.2.11
781
782 =cut
783
784=== modified file 'config/deb/changelog'
785--- config/deb/changelog 2014-08-06 19:55:47 +0000
786+++ config/deb/changelog 2014-09-29 19:43:03 +0000
787@@ -1,3 +1,15 @@
788+percona-toolkit (2.2.11) unstable; urgency=low
789+
790+ * Fixed bug 1262456: pt-query-digest doesn't report host details
791+ * Fixed bug 1264580: pt-mysql-summary incorrectly tries to parse key/value pairs in wsrep_provider_options resulting in incomplete my.cnf information
792+ * Fixed bug 1318985: pt-stalk should use SQL_NO_CACHE
793+ * Fixed bug 1348679: pt-stalk handles mysql user password in awkward way
794+ * Fixed bug 1365085: Various issues with tests
795+ * Fixed bug 1368379: pt-summary problem parsing dmidecode output on some machines
796+ * Fixed bug 1303388: Typo in pt-variable-advisor
797+
798+ -- Percona Toolkit Developers <toolkit-dev@percona.com> Thu, 25 Sep 2014 13:43:24 +0000
799+
800 percona-toolkit (2.2.10) unstable; urgency=low
801
802 * Fixed bug 1287253: pt-table-checksum deadlock
803
804=== modified file 'config/rpm/percona-toolkit.spec'
805--- config/rpm/percona-toolkit.spec 2013-03-14 16:58:03 +0000
806+++ config/rpm/percona-toolkit.spec 2014-09-29 19:43:03 +0000
807@@ -9,7 +9,7 @@
808 Source: percona-toolkit-%{version}.tar.gz
809 BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root
810 BuildArch: noarch
811-Requires: perl(DBI) >= 1.13, perl(DBD::mysql) >= 1.0, perl(Time::HiRes), perl(IO::Socket::SSL)
812+Requires: perl(DBI) >= 1.13, perl(DBD::mysql) >= 1.0, perl(Time::HiRes), perl(IO::Socket::SSL), perl(Digest::MD5)
813 AutoReq: no
814
815 %description
816
817=== modified file 'config/sphinx-build/conf.py'
818--- config/sphinx-build/conf.py 2014-08-06 19:55:47 +0000
819+++ config/sphinx-build/conf.py 2014-09-29 19:43:03 +0000
820@@ -50,7 +50,7 @@
821 # The short X.Y version.
822 version = '2.2'
823 # The full version, including alpha/beta/rc tags.
824-release = '2.2.10'
825+release = '2.2.11'
826
827 # The language for content autogenerated by Sphinx. Refer to documentation
828 # for a list of supported languages.
829
830=== modified file 'docs/percona-toolkit.pod'
831--- docs/percona-toolkit.pod 2014-08-06 19:55:47 +0000
832+++ docs/percona-toolkit.pod 2014-09-29 19:43:03 +0000
833@@ -557,6 +557,6 @@
834
835 =head1 VERSION
836
837-Percona Toolkit v2.2.10 released 2014-08-06
838+Percona Toolkit v2.2.11 released 2014-09-25
839
840 =cut
841
842=== modified file 'docs/release_notes.rst'
843--- docs/release_notes.rst 2014-08-06 19:55:47 +0000
844+++ docs/release_notes.rst 2014-09-29 19:43:03 +0000
845@@ -1,6 +1,34 @@
846 Release Notes
847 *************
848
849+v2.2.11 released 2014-09-26
850+===========================
851+
852+Percona Toolkit 2.2.11 has been released. This release contains seven bug fixes.
853+
854+Bugs Fixed:
855+
856+* Fixed bug 1262456: pt-query-digest didn't report host details when host was using skip-name-resolve option. Fixed by using the IP of the host instead of it's name, when the hostname is missing.
857+
858+* Fixed bug 1264580: pt-mysql-summary was incorrectly parsing key/value pairs in the wsrep_provider_options option, which resulted in incomplete my.cnf information.
859+
860+* Fixed bug 1318985: pt-stalk is now using ``SQL_NO_CACHE`` when executing queries for locks and transactions. Previously this could lead to situations where most of the queries that were ``waiting on query cache mutex`` were the pt-stalk queries (INNODB_TRX).
861+
862+* Fixed bug 1348679: When using ``-- -p`` option to enter the password for pt-stalk it would ask user to re-enter the password every time tool connects to the server to retrieve the information. New option ``--ask-pass`` has been introduced that can be used to specify the password only once.
863+
864+* Fixed bug 1368379: A parsing error caused pt-summary ( specifically the ``report_system_info`` module) to choke on the "Memory Device" parameter named "Configured Clock Speed" when using dmidecode to report memory slot information.
865+
866+Changelog
867+---------
868+
869+* Fixed bug 1262456: pt-query-digest doesn't report host details
870+* Fixed bug 1264580: pt-mysql-summary incorrectly tries to parse key/value pairs in wsrep_provider_options resulting in incomplete my.cnf information
871+* Fixed bug 1318985: pt-stalk should use SQL_NO_CACHE
872+* Fixed bug 1348679: pt-stalk handles mysql user password in awkward way
873+* Fixed bug 1365085: Various issues with tests
874+* Fixed bug 1368379: pt-summary problem parsing dmidecode output on some machines
875+* Fixed bug 1303388: Typo in pt-variable-advisor
876+
877 v2.2.10 released 2014-08-06
878 ===========================
879
880
881=== modified file 'lib/Percona/Toolkit.pm'
882--- lib/Percona/Toolkit.pm 2014-08-05 20:37:42 +0000
883+++ lib/Percona/Toolkit.pm 2014-09-29 19:43:03 +0000
884@@ -18,7 +18,7 @@
885 # ###########################################################################
886 package Percona::Toolkit;
887
888-our $VERSION = '2.2.10';
889+our $VERSION = '2.2.11';
890
891 use strict;
892 use warnings FATAL => 'all';
893
894=== modified file 'lib/Sandbox.pm'
895--- lib/Sandbox.pm 2014-05-28 20:31:10 +0000
896+++ lib/Sandbox.pm 2014-09-29 19:43:03 +0000
897@@ -374,6 +374,10 @@
898 . join(", ", map { "mysql.$_" } @tables_in_mysql)
899 . ", "
900 . join(", ", map { "sakila.$_" } @tables_in_sakila);
901+
902+ # remove leading "," if any
903+ $sql =~ s/CHECKSUM TABLES\s+,/CHECKSUM TABLES /;
904+
905 my @checksums = @{$dbh->selectall_arrayref($sql, {Slice => {} })};
906
907 # Diff the two sets of checksums: host to master (ref).
908
909=== modified file 'lib/SlowLogParser.pm'
910--- lib/SlowLogParser.pm 2014-07-30 20:25:29 +0000
911+++ lib/SlowLogParser.pm 2014-09-29 19:43:03 +0000
912@@ -162,6 +162,7 @@
913 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
914 ) {
915 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
916+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
917 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
918 # 5.6 has the thread id on the User@Host line
919 if ( $thread_id ) {
920@@ -177,6 +178,7 @@
921 && ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
922 ) {
923 PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
924+ $host ||= $ip; # sometimes host is missing when using skip-name-resolve (LP #issue 1262456)
925 push @properties, 'user', $user, 'host', $host, 'ip', $ip;
926 # 5.6 has the thread id on the User@Host line
927 if ( $thread_id ) {
928
929=== modified file 'lib/VariableAdvisorRules.pm'
930--- lib/VariableAdvisorRules.pm 2013-08-08 15:35:19 +0000
931+++ lib/VariableAdvisorRules.pm 2014-09-29 19:43:03 +0000
932@@ -430,10 +430,10 @@
933 },
934 },
935 {
936- id => 'expire_log_days',
937+ id => 'expire_logs_days',
938 code => sub {
939 my ( %args ) = @_;
940- return _var_eq($args{variables}->{expire_log_days}, 0)
941+ return _var_eq($args{variables}->{expire_logs_days}, 0)
942 && _var_seq($args{variables}->{log_bin}, "ON");
943 },
944 },
945
946=== modified file 'lib/bash/report_mysql_info.sh'
947--- lib/bash/report_mysql_info.sh 2013-12-12 05:49:59 +0000
948+++ lib/bash/report_mysql_info.sh 2014-09-29 19:43:03 +0000
949@@ -345,37 +345,28 @@
950 echo
951 }
952
953-# Pretty-prints the my.cnf file. It's super annoying, but some *modern*
954-# versions of awk don't support POSIX character sets in regular
955-# expressions, like [[:space:]] (looking at you, Debian). So
956-# the below patterns contain [<space><tab>] and must remain that way.
957+# Pretty-prints the my.cnf file.
958 pretty_print_cnf_file () {
959 local file="$1"
960
961 [ -e "$file" ] || return
962
963- awk '
964- BEGIN {
965- FS="="
966- }
967- /^[ \t]*[a-zA-Z[]/ {
968- if (length($2)) {
969- gsub(/^[ \t]*/, "", $1);
970- gsub(/^[ \t]*/, "", $2);
971- gsub(/[ \t]*$/, "", $1);
972- gsub(/[ \t]*$/, "", $2);
973- printf("%-35s = %s\n", $1, $2);
974- }
975- else if ( $0 ~ /\[/ ) {
976- print "";
977- print $1;
978- }
979- else {
980- print $1;
981- }
982- }' "$file"
983+ perl -n -l -e '
984+ my $line = $_;
985+ if ( $line =~ /^\s*[a-zA-Z[]/ ) {
986+ if ( $line=~/\s*(.*?)\s*=\s*(.*)\s*$/ ) {
987+ printf("%-35s = %s\n", $1, $2)
988+ }
989+ elsif ( $line =~ /\s*\[/ ) {
990+ print "\n$line"
991+ } else {
992+ print $line
993+ }
994+ }' "$file"
995+
996 }
997
998+
999 find_checkpoint_age() {
1000 local file="$1"
1001 awk '
1002
1003=== modified file 'lib/bash/report_system_info.sh'
1004--- lib/bash/report_system_info.sh 2012-08-24 22:39:58 +0000
1005+++ lib/bash/report_system_info.sh 2014-09-29 19:43:03 +0000
1006@@ -230,7 +230,7 @@
1007 -e 's/>/}/g' \
1008 -e 's/[ \t]*\n/\n/g' \
1009 "${file}" \
1010- | awk -F: '/Size|Type|Form.Factor|Type.Detail|[^ ]Locator/{printf("|%s", $2)}/Speed/{print "|" $2}' \
1011+ | awk -F: '/Size|Type|Form.Factor|Type.Detail|^[\t ]+Locator/{printf("|%s", $2)}/^[\t ]+Speed/{print "|" $2}' \
1012 | sed -e 's/No Module Installed/{EMPTY}/' \
1013 | sort \
1014 | awk -F'|' '{printf(" %-9s %-8s %-17s %-13s %-13s %-8s\n", $4, $2, $7, $3, $5, $6);}'
1015
1016=== modified file 'sandbox/start-sandbox'
1017--- sandbox/start-sandbox 2014-04-30 14:53:04 +0000
1018+++ sandbox/start-sandbox 2014-09-29 19:43:03 +0000
1019@@ -240,7 +240,7 @@
1020
1021 if [ $type = "cluster" -o $APP = "pxc" ]; then
1022 ip=$(perl -MNet::Address::IP::Local -le 'print Net::Address::IP::Local->public')
1023- version=`$PERCONA_TOOLKIT_SANDBOX/$mysqld -V --bind-address $ip 2>/dev/null | awk '{print $3}' | cut -d. -f 1,2`;
1024+ version=`$PERCONA_TOOLKIT_SANDBOX/$mysqld -V --query_cache_size=0 --query_cache_type=0 --bind-address $ip 2>/dev/null | awk '{print $3}' | cut -d. -f 1,2`;
1025 else
1026 version=`$PERCONA_TOOLKIT_SANDBOX/$mysqld -V 2>/dev/null | awk '{print $3}' | cut -d. -f 1,2`;
1027 fi
1028
1029=== modified file 't/lib/Percona/Toolkit.t'
1030--- t/lib/Percona/Toolkit.t 2013-08-08 19:34:29 +0000
1031+++ t/lib/Percona/Toolkit.t 2014-09-29 19:43:03 +0000
1032@@ -75,6 +75,8 @@
1033 unless $root eq $trunk;
1034
1035 my @tags = split /\n/, `$bzr tags`;
1036+ # sort the version numbers (some bzr versions do not sort them)
1037+ @tags = sort { calc_value($a) <=> calc_value($b) } @tags;
1038 my ($current_tag) = $tags[-1] =~ /^(\S+)/;
1039
1040 is(
1041@@ -84,4 +86,18 @@
1042 );
1043 }
1044
1045+# we use this function to help sort version numbers
1046+sub calc_value {
1047+ my $version = shift;
1048+ $version =~ s/ +[^ ]*$//;
1049+ my $value = 0;
1050+ my $exp = 0;
1051+ foreach my $num (reverse split /\./, $version) {
1052+ $value += $num * 10 ** $exp++;
1053+ }
1054+ print "$version = $value\n";
1055+ return $value;
1056+}
1057+
1058+
1059 done_testing;
1060
1061=== modified file 't/lib/SlowLogParser.t'
1062--- t/lib/SlowLogParser.t 2014-07-30 20:25:29 +0000
1063+++ t/lib/SlowLogParser.t 2014-09-29 19:43:03 +0000
1064@@ -587,7 +587,7 @@
1065 'ip' => '1.2.3.8',
1066 'arg' => 'administrator command: Quit',
1067 'Thread_id' => '5',
1068- 'host' => '',
1069+ 'host' => '1.2.3.8',
1070 'Rows_examined' => '0',
1071 'user' => 'meow',
1072 'Query_time' => '0.000002',
1073@@ -602,7 +602,7 @@
1074 'ip' => '1.2.3.8',
1075 arg => 'SET NAMES utf8',
1076 'Thread_id' => '6',
1077- 'host' => '',
1078+ 'host' => '1.2.3.8',
1079 'Rows_examined' => '0',
1080 'user' => 'meow',
1081 'Query_time' => '0.000899',
1082@@ -616,7 +616,7 @@
1083 'arg' => 'SELECT MIN(id),MAX(id) FROM tbl',
1084 'ip' => '1.2.3.8',
1085 'Thread_id' => '6',
1086- 'host' => '',
1087+ 'host' => '1.2.3.8',
1088 'Rows_examined' => '0',
1089 'user' => 'meow',
1090 'Query_time' => '0.018799',
1091@@ -664,7 +664,7 @@
1092 'arg' => 'administrator command: Quit',
1093 'ip' => '1.2.3.8',
1094 'Thread_id' => '5',
1095- 'host' => '',
1096+ 'host' => '1.2.3.8',
1097 'Rows_examined' => '0',
1098 'user' => 'meow',
1099 'Query_time' => '0.000002',
1100@@ -679,7 +679,7 @@
1101 'ip' => '1.2.3.8',
1102 arg => 'SET NAMES utf8',
1103 'Thread_id' => '6',
1104- 'host' => '',
1105+ 'host' => '1.2.3.8',
1106 'Rows_examined' => '0',
1107 'user' => 'meow',
1108 'Query_time' => '0.000899',
1109@@ -694,7 +694,7 @@
1110 'arg' => 'administrator command: Quit',
1111 'ip' => '1.2.3.8',
1112 'Thread_id' => '7',
1113- 'host' => '',
1114+ 'host' => '1.2.3.8',
1115 'Rows_examined' => '0',
1116 'user' => 'meow',
1117 'Query_time' => '0.018799',
1118@@ -709,7 +709,7 @@
1119 'ip' => '1.2.3.8',
1120 arg => 'SET NAMES utf8',
1121 'Thread_id' => '9',
1122- 'host' => '',
1123+ 'host' => '1.2.3.8',
1124 'Rows_examined' => '0',
1125 'user' => 'meow',
1126 'Query_time' => '0.000899',
1127@@ -731,7 +731,7 @@
1128 'arg' => 'SET autocommit=1',
1129 'ip' => '10.1.250.19',
1130 'Thread_id' => '39387',
1131- 'host' => '',
1132+ 'host' => '10.1.250.19',
1133 'Rows_examined' => '0',
1134 'user' => 'sabapp',
1135 'Query_time' => '0.000018',
1136@@ -745,7 +745,7 @@
1137 'arg' => 'SET autocommit=1',
1138 'ip' => '10.1.250.19',
1139 'Thread_id' => '39387',
1140- 'host' => '',
1141+ 'host' => '10.1.250.19',
1142 'Rows_examined' => '0',
1143 'user' => 'sabapp',
1144 'Query_time' => '0.000018',
1145@@ -769,7 +769,7 @@
1146 'arg' => 'SET autocommit=1',
1147 'ip' => '10.1.250.19',
1148 'Thread_id' => '39796',
1149- 'host' => '',
1150+ 'host' => '10.1.250.19',
1151 'pos_in_log' => '0',
1152 'Rows_examined' => '0',
1153 'user' => 'foo_app',
1154@@ -785,7 +785,7 @@
1155 'ip' => '10.1.12.201',
1156 'ts' => '081127 8:51:20',
1157 'Thread_id' => '39947',
1158- 'host' => '',
1159+ 'host' => '10.1.12.201',
1160 'pos_in_log' => '174',
1161 'Rows_examined' => '226',
1162 'Query_time' => '0.149435',
1163@@ -800,7 +800,7 @@
1164 'ip' => '10.1.12.201',
1165 'ts' => '081127 8:51:21',
1166 'Thread_id' => '39947',
1167- 'host' => '',
1168+ 'host' => '10.1.12.201',
1169 'pos_in_log' => '385',
1170 'Rows_examined' => '0',
1171 'Query_time' => '0.000005',
1172@@ -815,7 +815,7 @@
1173 'arg' => 'SET autocommit=0',
1174 'ip' => '10.1.250.19',
1175 'Thread_id' => '39796',
1176- 'host' => '',
1177+ 'host' => '10.1.250.19',
1178 'pos_in_log' => '600',
1179 'Rows_examined' => '0',
1180 'user' => 'foo_app',
1181@@ -829,7 +829,7 @@
1182 'arg' => 'commit',
1183 'ip' => '10.1.250.19',
1184 'Thread_id' => '39796',
1185- 'host' => '',
1186+ 'host' => '10.1.250.19',
1187 'pos_in_log' => '782',
1188 'Rows_examined' => '0',
1189 'user' => 'foo_app',
1190@@ -965,7 +965,7 @@
1191 Thread_id => '5',
1192 arg => 'administrator command: Quit',
1193 cmd => 'Admin',
1194- host => '',
1195+ host => '1.2.3.8',
1196 ip => '1.2.3.8',
1197 pos_in_log => '0',
1198 user => 'meow',
1199@@ -980,7 +980,7 @@
1200 arg => 'SET NAMES utf8',
1201 cmd => 'Query',
1202 db => 'db',
1203- host => '',
1204+ host => '1.2.3.8',
1205 ip => '1.2.3.8',
1206 pos_in_log => '221',
1207 user => 'meow',
1208@@ -995,7 +995,7 @@
1209 arg => 'administrator command: Quit',
1210 cmd => 'Admin',
1211 db => 'db2',
1212- host => '',
1213+ host => '1.2.3.8',
1214 ip => '1.2.3.8',
1215 pos_in_log => '435',
1216 user => 'meow',
1217@@ -1184,7 +1184,7 @@
1218 arg => 'SELECT missing_a_schema_above from crash_me',
1219 bytes => 43,
1220 cmd => 'Query',
1221- host => '',
1222+ host => '10.1.12.30',
1223 ip => '10.1.12.30',
1224 pos_in_log => '0',
1225 ts => '081126 13:08:25',
1226@@ -1319,7 +1319,7 @@
1227 Last_errno => 0,
1228 Killed => 0,
1229 db => 'test_db',
1230- host => '',
1231+ host => '127.0.0.1',
1232 Schema => 'test_db',
1233 ip => '127.0.0.1',
1234 timestamp => '1111111111',
1235@@ -1340,7 +1340,7 @@
1236 arg => 'update t set b = b + 30 where user_id=1',
1237 bytes => 39,
1238 cmd => 'Query',
1239- host => '',
1240+ host => '127.0.0.1',
1241 ip => '127.0.0.1',
1242 pos_in_log => 596,
1243 timestamp => '2222222222',
1244
1245=== modified file 't/lib/VariableAdvisorRules.t'
1246--- t/lib/VariableAdvisorRules.t 2013-08-08 15:35:19 +0000
1247+++ t/lib/VariableAdvisorRules.t 2014-09-29 19:43:03 +0000
1248@@ -276,12 +276,12 @@
1249 },
1250
1251
1252- { name => "expire_log_days",
1253- vars => [qw(expire_log_days 0 log_bin ON)],
1254- advice => [qw(expire_log_days)],
1255+ { name => "expire_logs_days",
1256+ vars => [qw(expire_logs_days 0 log_bin ON)],
1257+ advice => [qw(expire_logs_days)],
1258 },
1259- { name => "expire_log_days, log_bin OFF, only warns about log_bin",
1260- vars => [qw(expire_log_days 0 log_bin OFF)],
1261+ { name => "expire_logs_days, log_bin OFF, only warns about log_bin",
1262+ vars => [qw(expire_logs_days 0 log_bin OFF)],
1263 advice => [qw(log_bin)],
1264 },
1265 { name => "innodb_file_io_threads",
1266
1267=== modified file 't/lib/bash/report_mysql_info.sh'
1268--- t/lib/bash/report_mysql_info.sh 2013-12-12 05:49:59 +0000
1269+++ t/lib/bash/report_mysql_info.sh 2014-09-29 19:43:03 +0000
1270@@ -172,6 +172,7 @@
1271 ssl = 1
1272 server-id = 1
1273 log-bin = sl1-bin
1274+wsrep_provider_options = "gcache.size=64M;base_host=10.1.2.102; base_port=4567; cert.log_conflicts=no;etc=etc;"
1275
1276 [mysql.server]
1277 user = mysql
1278
1279=== modified file 't/lib/bash/report_system_info.sh'
1280--- t/lib/bash/report_system_info.sh 2012-08-24 22:39:58 +0000
1281+++ t/lib/bash/report_system_info.sh 2014-09-29 19:43:03 +0000
1282@@ -1,6 +1,6 @@
1283 #!/usr/bin/env bash
1284
1285-plan 53
1286+plan 54
1287
1288 . "$LIB_DIR/alt_cmds.sh"
1289 . "$LIB_DIR/log_warn_die.sh"
1290@@ -1040,6 +1040,16 @@
1291 parse_dmidecode_mem_devices "$samples/dmidecode-005.txt" > "$PT_TMPDIR/got"
1292 no_diff "$PT_TMPDIR/got" "$PT_TMPDIR/expected" "dmidecode-005.txt"
1293
1294+cat <<EOF > "$PT_TMPDIR/expected"
1295+ Locator Size Speed Form Factor Type Type Detail
1296+ ========= ======== ================= ============= ============= ===========
1297+ DIMM 1 8192 MB 1600 MHz SODIMM DDR3 Synchronous
1298+ DIMM 2 8192 MB 1600 MHz SODIMM DDR3 Synchronous
1299+EOF
1300+parse_dmidecode_mem_devices "$samples/dmidecode-006.txt" > "$PT_TMPDIR/got"
1301+no_diff "$PT_TMPDIR/got" "$PT_TMPDIR/expected" "dmidecode-006.txt"
1302+
1303+
1304 # parse_arcconf
1305
1306 cat <<EOF > "$PT_TMPDIR/expected"
1307
1308=== modified file 't/pt-duplicate-key-checker/standard_options.t'
1309--- t/pt-duplicate-key-checker/standard_options.t 2013-12-12 02:17:16 +0000
1310+++ t/pt-duplicate-key-checker/standard_options.t 2014-09-29 19:43:03 +0000
1311@@ -28,7 +28,32 @@
1312
1313 diag(`touch $pid_file`);
1314
1315-$output = `$cmd -d issue_295 --pid $pid_file 2>&1`;
1316+
1317+# to test this issue I must set a timeout in case the command doesn't come back
1318+
1319+eval {
1320+ # we define an alarm signal handler
1321+ local $SIG{'ALRM'} = sub { die "timed out\n" };
1322+
1323+ # and set the alarm 'clock' to 5 seconds
1324+ alarm(5);
1325+
1326+ # here's the actual command. correct bahaviour is to die with messsage "PID file <pid_file> exists"
1327+ # Incorrect behavior is anything else, including not returning control after 5 seconds
1328+ $output = `$cmd -d issue_295 --pid $pid_file 2>&1`;
1329+
1330+};
1331+
1332+if ($@) {
1333+ if ($@ eq "timed out\n") {
1334+ print "I timed out\n";
1335+ }
1336+ else {
1337+ print "Something else went wrong: $@\n";
1338+ }
1339+}
1340+
1341+
1342 like(
1343 $output,
1344 qr{PID file $pid_file exists},
1345
1346=== modified file 't/pt-fifo-split/pt-fifo-split.t'
1347--- t/pt-fifo-split/pt-fifo-split.t 2013-03-04 19:06:34 +0000
1348+++ t/pt-fifo-split/pt-fifo-split.t 2014-09-29 19:43:03 +0000
1349@@ -47,6 +47,12 @@
1350 my ($n_reads) = @_;
1351 my $last_inode = 0;
1352 my @data;
1353+
1354+ # This test still freezes on some centos systems,
1355+ # so we're going to bluntly sleep for a few secs to avoid deadlock
1356+ # TODO: figure out if there is a proper way to do this.
1357+ sleep(3);
1358+
1359 for (1..$n_reads) {
1360 PerconaTest::wait_until(sub {
1361 my $inode;
1362
1363=== modified file 't/pt-mysql-summary/samples/my.cnf-001.txt'
1364--- t/pt-mysql-summary/samples/my.cnf-001.txt 2011-07-01 16:29:50 +0000
1365+++ t/pt-mysql-summary/samples/my.cnf-001.txt 2014-09-29 19:43:03 +0000
1366@@ -24,6 +24,8 @@
1367 server-id = 1
1368 log-bin=sl1-bin
1369
1370+wsrep_provider_options = "gcache.size=64M;base_host=10.1.2.102; base_port=4567; cert.log_conflicts=no;etc=etc;"
1371+
1372 [mysql.server]
1373 user=mysql
1374 ####basedir=/var/lib
1375
1376=== modified file 't/pt-query-digest/samples/slow008_report.txt'
1377--- t/pt-query-digest/samples/slow008_report.txt 2013-01-11 16:45:20 +0000
1378+++ t/pt-query-digest/samples/slow008_report.txt 2014-09-29 19:43:03 +0000
1379@@ -12,7 +12,7 @@
1380 # Query size 43 31 31 31 31 31 0 31
1381 # String:
1382 # Databases db2
1383-# Hosts
1384+# Hosts 1.2.3.8
1385 # Users meow
1386 # Query_time distribution
1387 # 1us
1388@@ -42,7 +42,7 @@
1389 # Query size 19 14 14 14 14 14 0 14
1390 # String:
1391 # Databases db
1392-# Hosts
1393+# Hosts 1.2.3.8
1394 # Users meow
1395 # Query_time distribution
1396 # 1us
1397@@ -68,7 +68,7 @@
1398 # Query size 37 27 27 27 27 27 0 27
1399 # String:
1400 # Databases db1
1401-# Hosts
1402+# Hosts 1.2.3.8
1403 # Users meow
1404 # Query_time distribution
1405 # 1us ################################################################
1406
1407=== modified file 't/pt-query-digest/samples/slow011_report.txt'
1408--- t/pt-query-digest/samples/slow011_report.txt 2013-01-11 16:45:20 +0000
1409+++ t/pt-query-digest/samples/slow011_report.txt 2014-09-29 19:43:03 +0000
1410@@ -12,7 +12,7 @@
1411 # Query size 65 54 27 27 27 27 0 27
1412 # String:
1413 # Databases db1 (1/50%), db2 (1/50%)
1414-# Hosts
1415+# Hosts 1.2.3.8
1416 # Users meow
1417 # Query_time distribution
1418 # 1us ################################################################
1419@@ -38,7 +38,7 @@
1420 # Query size 34 28 14 14 14 14 0 14
1421 # String:
1422 # Databases db
1423-# Hosts
1424+# Hosts 1.2.3.8
1425 # Users meow
1426 # Query_time distribution
1427 # 1us
1428
1429=== modified file 't/pt-query-digest/samples/slow013_report.txt'
1430--- t/pt-query-digest/samples/slow013_report.txt 2013-01-11 16:45:20 +0000
1431+++ t/pt-query-digest/samples/slow013_report.txt 2014-09-29 19:43:03 +0000
1432@@ -13,7 +13,7 @@
1433 # Query size 14 11 11 11 11 11 0 11
1434 # String:
1435 # Databases test
1436-# Hosts
1437+# Hosts 10.1.12.201
1438 # Users mytopuser
1439 # Query_time distribution
1440 # 1us
1441@@ -40,7 +40,7 @@
1442 # Query size 42 32 16 16 16 16 0 16
1443 # String:
1444 # Databases abc
1445-# Hosts
1446+# Hosts 10.1.250.19
1447 # Users foo_app
1448 # Query_time distribution
1449 # 1us
1450@@ -67,7 +67,7 @@
1451 # Query size 7 6 6 6 6 6 0 6
1452 # String:
1453 # Databases abc
1454-# Hosts
1455+# Hosts 10.1.250.19
1456 # Users foo_app
1457 # Query_time distribution
1458 # 1us
1459@@ -94,7 +94,7 @@
1460 # Query size 35 27 27 27 27 27 0 27
1461 # String:
1462 # Databases test
1463-# Hosts
1464+# Hosts 10.1.12.201
1465 # Users mytopuser
1466 # Query_time distribution
1467 # 1us ################################################################
1468
1469=== modified file 't/pt-query-digest/samples/slow013_report_fingerprint_user.txt'
1470--- t/pt-query-digest/samples/slow013_report_fingerprint_user.txt 2013-01-11 16:45:20 +0000
1471+++ t/pt-query-digest/samples/slow013_report_fingerprint_user.txt 2014-09-29 19:43:03 +0000
1472@@ -27,7 +27,7 @@
1473 # Query size 14 11 11 11 11 11 0 11
1474 # String:
1475 # Databases test
1476-# Hosts
1477+# Hosts 10.1.12.201
1478 # Users mytopuser
1479 # Query_time distribution
1480 # 1us
1481@@ -58,7 +58,7 @@
1482 # Query size 50 38 11 27 19 27 11.31 19
1483 # String:
1484 # Databases test
1485-# Hosts
1486+# Hosts 10.1.12.201
1487 # Query_time distribution
1488 # 1us ################################################################
1489 # 10us
1490
1491=== modified file 't/pt-query-digest/samples/slow013_report_limit.txt'
1492--- t/pt-query-digest/samples/slow013_report_limit.txt 2013-01-11 16:45:20 +0000
1493+++ t/pt-query-digest/samples/slow013_report_limit.txt 2014-09-29 19:43:03 +0000
1494@@ -13,7 +13,7 @@
1495 # Query size 14 11 11 11 11 11 0 11
1496 # String:
1497 # Databases test
1498-# Hosts
1499+# Hosts 10.1.12.201
1500 # Users mytopuser
1501 # Query_time distribution
1502 # 1us
1503
1504=== modified file 't/pt-query-digest/samples/slow013_report_outliers.txt'
1505--- t/pt-query-digest/samples/slow013_report_outliers.txt 2013-01-11 16:45:20 +0000
1506+++ t/pt-query-digest/samples/slow013_report_outliers.txt 2014-09-29 19:43:03 +0000
1507@@ -17,7 +17,7 @@
1508 # Query size 50 38 11 27 19 27 11.31 19
1509 # String:
1510 # Databases test
1511-# Hosts
1512+# Hosts 10.1.12.201
1513 # Query_time distribution
1514 # 1us ################################################################
1515 # 10us
1516@@ -43,7 +43,7 @@
1517 # Query size 50 38 6 16 12.67 15.25 4.48 15.25
1518 # String:
1519 # Databases abc
1520-# Hosts
1521+# Hosts 10.1.250.19
1522 # Query_time distribution
1523 # 1us
1524 # 10us ################################################################
1525
1526=== modified file 't/pt-query-digest/samples/slow013_report_user.txt'
1527--- t/pt-query-digest/samples/slow013_report_user.txt 2013-01-11 16:45:20 +0000
1528+++ t/pt-query-digest/samples/slow013_report_user.txt 2014-09-29 19:43:03 +0000
1529@@ -17,7 +17,7 @@
1530 # Query size 50 38 11 27 19 27 11.31 19
1531 # String:
1532 # Databases test
1533-# Hosts
1534+# Hosts 10.1.12.201
1535 # Query_time distribution
1536 # 1us ################################################################
1537 # 10us
1538@@ -43,7 +43,7 @@
1539 # Query size 50 38 6 16 12.67 15.25 4.48 15.25
1540 # String:
1541 # Databases abc
1542-# Hosts
1543+# Hosts 10.1.250.19
1544 # Query_time distribution
1545 # 1us
1546 # 10us ################################################################
1547
1548=== modified file 't/pt-query-digest/samples/slow019_report.txt'
1549--- t/pt-query-digest/samples/slow019_report.txt 2013-01-11 16:45:20 +0000
1550+++ t/pt-query-digest/samples/slow019_report.txt 2014-09-29 19:43:03 +0000
1551@@ -12,7 +12,7 @@
1552 # Query size 79 54 27 27 27 27 0 27
1553 # String:
1554 # Databases db1 (1/50%), db2 (1/50%)
1555-# Hosts
1556+# Hosts 1.2.3.8
1557 # Users meow
1558 # Query_time distribution
1559 # 1us ################################################################
1560@@ -38,7 +38,7 @@
1561 # Query size 20 14 14 14 14 14 0 14
1562 # String:
1563 # Databases db
1564-# Hosts
1565+# Hosts 1.2.3.8
1566 # Users meow
1567 # Query_time distribution
1568 # 1us
1569
1570=== modified file 't/pt-query-digest/samples/slow055.txt'
1571--- t/pt-query-digest/samples/slow055.txt 2013-01-11 16:45:20 +0000
1572+++ t/pt-query-digest/samples/slow055.txt 2014-09-29 19:43:03 +0000
1573@@ -15,7 +15,7 @@
1574 # Rows examine 0 0 0 0 0 0 0 0
1575 # Query size 100 72 14 31 24 30.19 6.95 26.08
1576 # String:
1577-# Hosts
1578+# Hosts 1.2.3.8
1579 # Users meow
1580 # Query_time distribution
1581 # 1us ################################################################
1582
1583=== modified file 't/pt-query-digest/samples/slow056.txt'
1584--- t/pt-query-digest/samples/slow056.txt 2013-01-11 16:45:20 +0000
1585+++ t/pt-query-digest/samples/slow056.txt 2014-09-29 19:43:03 +0000
1586@@ -15,7 +15,7 @@
1587 # Query size 100 39 39 39 39 39 0 39
1588 # String:
1589 # Databases test_db
1590-# Hosts
1591+# Hosts 127.0.0.1
1592 # Last errno 0
1593 # Users root
1594 # Query_time distribution
1595@@ -51,7 +51,7 @@
1596 # Query size 0 0 0 0 0 0 0 0
1597 # String:
1598 # Databases test_db
1599-# Hosts
1600+# Hosts 127.0.0.1
1601 # Last errno 0
1602 # Users root
1603 # Query_time distribution
1604
1605=== modified file 't/pt-query-digest/samples/slow057.txt'
1606--- t/pt-query-digest/samples/slow057.txt 2013-06-26 23:16:15 +0000
1607+++ t/pt-query-digest/samples/slow057.txt 2014-09-29 19:43:03 +0000
1608@@ -15,7 +15,7 @@
1609 # Rows examine 0 0 0 0 0 0 0 0
1610 # Query size 100 82 14 27 20.50 26.08 6.12 26.08
1611 # String:
1612-# Hosts
1613+# Hosts 1.2.3.8
1614 # Users meow
1615 # Query_time distribution
1616 # 1us ################################
1617
1618=== modified file 't/pt-query-digest/samples/slow058.txt'
1619--- t/pt-query-digest/samples/slow058.txt 2013-08-03 19:17:05 +0000
1620+++ t/pt-query-digest/samples/slow058.txt 2014-09-29 19:43:03 +0000
1621@@ -12,7 +12,7 @@
1622 # Query size 24 52 26 26 26 26 0 26
1623 # String:
1624 # Databases db
1625-# Hosts
1626+# Hosts 1.2.3.8
1627 # Users meow
1628 # Query_time distribution
1629 # 1us
1630@@ -41,7 +41,7 @@
1631 # Query size 25 54 27 27 27 27 0 27
1632 # String:
1633 # Databases db
1634-# Hosts
1635+# Hosts 1.2.3.8
1636 # Users meow
1637 # Query_time distribution
1638 # 1us
1639@@ -70,7 +70,7 @@
1640 # Query size 50 108 54 54 54 54 0 54
1641 # String:
1642 # Databases db
1643-# Hosts
1644+# Hosts 1.2.3.8
1645 # Users meow
1646 # Query_time distribution
1647 # 1us ################################################################
1648
1649=== added file 't/pt-summary/samples/dmidecode-006.txt'
1650--- t/pt-summary/samples/dmidecode-006.txt 1970-01-01 00:00:00 +0000
1651+++ t/pt-summary/samples/dmidecode-006.txt 2014-09-29 19:43:03 +0000
1652@@ -0,0 +1,920 @@
1653+# dmidecode 2.12
1654+# SMBIOS entry point at 0x000f04d0
1655+SMBIOS 2.8 present.
1656+84 structures occupying 3168 bytes.
1657+Table at 0x000EC170.
1658+
1659+Handle 0x0000, DMI type 0, 24 bytes
1660+BIOS Information
1661+ Vendor: Intel Corp.
1662+ Version: WYLPT10H.86A.0027.2014.0710.1904
1663+ Release Date: 07/10/2014
1664+ Address: 0xF0000
1665+ Runtime Size: 64 kB
1666+ ROM Size: 6656 kB
1667+ Characteristics:
1668+ PCI is supported
1669+ BIOS is upgradeable
1670+ BIOS shadowing is allowed
1671+ Boot from CD is supported
1672+ Selectable boot is supported
1673+ BIOS ROM is socketed
1674+ EDD is supported
1675+ 5.25"/1.2 MB floppy services are supported (int 13h)
1676+ 3.5"/720 kB floppy services are supported (int 13h)
1677+ 3.5"/2.88 MB floppy services are supported (int 13h)
1678+ Print screen service is supported (int 5h)
1679+ Serial services are supported (int 14h)
1680+ Printer services are supported (int 17h)
1681+ ACPI is supported
1682+ USB legacy is supported
1683+ BIOS boot specification is supported
1684+ Targeted content distribution is supported
1685+ UEFI is supported
1686+ BIOS Revision: 4.6
1687+
1688+Handle 0x0001, DMI type 1, 27 bytes
1689+System Information
1690+ Manufacturer:
1691+ Product Name:
1692+ Version:
1693+ Serial Number:
1694+ UUID: CF181A80-34D4-11E1-BA8E-C03FD5602091
1695+ Wake-up Type: Power Switch
1696+ SKU Number:
1697+ Family:
1698+
1699+Handle 0x0002, DMI type 2, 15 bytes
1700+Base Board Information
1701+ Manufacturer: Intel Corporation
1702+ Product Name: D34010WYK
1703+ Version: H14771-303
1704+ Serial Number: GEWY401001F8
1705+ Asset Tag:
1706+ Features:
1707+ Board is a hosting board
1708+ Board is replaceable
1709+ Location In Chassis: To be filled by O.E.M.
1710+ Chassis Handle: 0x0003
1711+ Type: Motherboard
1712+ Contained Object Handles: 0
1713+
1714+Handle 0x0003, DMI type 3, 25 bytes
1715+Chassis Information
1716+ Manufacturer:
1717+ Type: Desktop
1718+ Lock: Not Present
1719+ Version:
1720+ Serial Number:
1721+ Asset Tag:
1722+ Boot-up State: Safe
1723+ Power Supply State: Safe
1724+ Thermal State: Safe
1725+ Security Status: None
1726+ OEM Information: 0x00000000
1727+ Height: Unspecified
1728+ Number Of Power Cords: 1
1729+ Contained Elements: 1
1730+ <OUT OF SPEC> (0)
1731+ SKU Number: To be filled by O.E.M.
1732+
1733+Handle 0x0004, DMI type 8, 9 bytes
1734+Port Connector Information
1735+ Internal Reference Designator: J1A1
1736+ Internal Connector Type: None
1737+ External Reference Designator: PS2Mouse
1738+ External Connector Type: PS/2
1739+ Port Type: Mouse Port
1740+
1741+Handle 0x0005, DMI type 8, 9 bytes
1742+Port Connector Information
1743+ Internal Reference Designator: J1A1
1744+ Internal Connector Type: None
1745+ External Reference Designator: Keyboard
1746+ External Connector Type: PS/2
1747+ Port Type: Keyboard Port
1748+
1749+Handle 0x0006, DMI type 8, 9 bytes
1750+Port Connector Information
1751+ Internal Reference Designator: J2A1
1752+ Internal Connector Type: None
1753+ External Reference Designator: TV Out
1754+ External Connector Type: Mini Centronics Type-14
1755+ Port Type: Other
1756+
1757+Handle 0x0007, DMI type 8, 9 bytes
1758+Port Connector Information
1759+ Internal Reference Designator: J2A2A
1760+ Internal Connector Type: None
1761+ External Reference Designator: COM A
1762+ External Connector Type: DB-9 male
1763+ Port Type: Serial Port 16550A Compatible
1764+
1765+Handle 0x0008, DMI type 8, 9 bytes
1766+Port Connector Information
1767+ Internal Reference Designator: J2A2B
1768+ Internal Connector Type: None
1769+ External Reference Designator: Video
1770+ External Connector Type: DB-15 female
1771+ Port Type: Video Port
1772+
1773+Handle 0x0009, DMI type 8, 9 bytes
1774+Port Connector Information
1775+ Internal Reference Designator: J3A1
1776+ Internal Connector Type: None
1777+ External Reference Designator: USB1
1778+ External Connector Type: Access Bus (USB)
1779+ Port Type: USB
1780+
1781+Handle 0x000A, DMI type 8, 9 bytes
1782+Port Connector Information
1783+ Internal Reference Designator: J3A1
1784+ Internal Connector Type: None
1785+ External Reference Designator: USB2
1786+ External Connector Type: Access Bus (USB)
1787+ Port Type: USB
1788+
1789+Handle 0x000B, DMI type 8, 9 bytes
1790+Port Connector Information
1791+ Internal Reference Designator: J3A1
1792+ Internal Connector Type: None
1793+ External Reference Designator: USB3
1794+ External Connector Type: Access Bus (USB)
1795+ Port Type: USB
1796+
1797+Handle 0x000C, DMI type 8, 9 bytes
1798+Port Connector Information
1799+ Internal Reference Designator: J9A1 - TPM HDR
1800+ Internal Connector Type: Other
1801+ External Reference Designator: Not Specified
1802+ External Connector Type: None
1803+ Port Type: Other
1804+
1805+Handle 0x000D, DMI type 8, 9 bytes
1806+Port Connector Information
1807+ Internal Reference Designator: J9C1 - PCIE DOCKING CONN
1808+ Internal Connector Type: Other
1809+ External Reference Designator: Not Specified
1810+ External Connector Type: None
1811+ Port Type: Other
1812+
1813+Handle 0x000E, DMI type 8, 9 bytes
1814+Port Connector Information
1815+ Internal Reference Designator: J2B3 - CPU FAN
1816+ Internal Connector Type: Other
1817+ External Reference Designator: Not Specified
1818+ External Connector Type: None
1819+ Port Type: Other
1820+
1821+Handle 0x000F, DMI type 8, 9 bytes
1822+Port Connector Information
1823+ Internal Reference Designator: J6C2 - EXT HDMI
1824+ Internal Connector Type: Other
1825+ External Reference Designator: Not Specified
1826+ External Connector Type: None
1827+ Port Type: Other
1828+
1829+Handle 0x0010, DMI type 8, 9 bytes
1830+Port Connector Information
1831+ Internal Reference Designator: J3C1 - GMCH FAN
1832+ Internal Connector Type: Other
1833+ External Reference Designator: Not Specified
1834+ External Connector Type: None
1835+ Port Type: Other
1836+
1837+Handle 0x0011, DMI type 8, 9 bytes
1838+Port Connector Information
1839+ Internal Reference Designator: J1D1 - ITP
1840+ Internal Connector Type: Other
1841+ External Reference Designator: Not Specified
1842+ External Connector Type: None
1843+ Port Type: Other
1844+
1845+Handle 0x0012, DMI type 8, 9 bytes
1846+Port Connector Information
1847+ Internal Reference Designator: J9E2 - MDC INTPSR
1848+ Internal Connector Type: Other
1849+ External Reference Designator: Not Specified
1850+ External Connector Type: None
1851+ Port Type: Other
1852+
1853+Handle 0x0013, DMI type 8, 9 bytes
1854+Port Connector Information
1855+ Internal Reference Designator: J9E4 - MDC INTPSR
1856+ Internal Connector Type: Other
1857+ External Reference Designator: Not Specified
1858+ External Connector Type: None
1859+ Port Type: Other
1860+
1861+Handle 0x0014, DMI type 8, 9 bytes
1862+Port Connector Information
1863+ Internal Reference Designator: J9E3 - LPC HOT DOCKING
1864+ Internal Connector Type: Other
1865+ External Reference Designator: Not Specified
1866+ External Connector Type: None
1867+ Port Type: Other
1868+
1869+Handle 0x0015, DMI type 8, 9 bytes
1870+Port Connector Information
1871+ Internal Reference Designator: J9E1 - SCAN MATRIX
1872+ Internal Connector Type: Other
1873+ External Reference Designator: Not Specified
1874+ External Connector Type: None
1875+ Port Type: Other
1876+
1877+Handle 0x0016, DMI type 8, 9 bytes
1878+Port Connector Information
1879+ Internal Reference Designator: J9G1 - LPC SIDE BAND
1880+ Internal Connector Type: Other
1881+ External Reference Designator: Not Specified
1882+ External Connector Type: None
1883+ Port Type: Other
1884+
1885+Handle 0x0017, DMI type 8, 9 bytes
1886+Port Connector Information
1887+ Internal Reference Designator: J8F1 - UNIFIED
1888+ Internal Connector Type: Other
1889+ External Reference Designator: Not Specified
1890+ External Connector Type: None
1891+ Port Type: Other
1892+
1893+Handle 0x0018, DMI type 8, 9 bytes
1894+Port Connector Information
1895+ Internal Reference Designator: J6F1 - LVDS
1896+ Internal Connector Type: Other
1897+ External Reference Designator: Not Specified
1898+ External Connector Type: None
1899+ Port Type: Other
1900+
1901+Handle 0x0019, DMI type 8, 9 bytes
1902+Port Connector Information
1903+ Internal Reference Designator: J2F1 - LAI FAN
1904+ Internal Connector Type: Other
1905+ External Reference Designator: Not Specified
1906+ External Connector Type: None
1907+ Port Type: Other
1908+
1909+Handle 0x001A, DMI type 8, 9 bytes
1910+Port Connector Information
1911+ Internal Reference Designator: J2G1 - GFX VID
1912+ Internal Connector Type: Other
1913+ External Reference Designator: Not Specified
1914+ External Connector Type: None
1915+ Port Type: Other
1916+
1917+Handle 0x001B, DMI type 8, 9 bytes
1918+Port Connector Information
1919+ Internal Reference Designator: J1G6 - AC JACK
1920+ Internal Connector Type: Other
1921+ External Reference Designator: Not Specified
1922+ External Connector Type: None
1923+ Port Type: Other
1924+
1925+Handle 0x001C, DMI type 9, 17 bytes
1926+System Slot Information
1927+ Designation: J6B2
1928+ Type: x16 PCI Express
1929+ Current Usage: Available
1930+ Length: Long
1931+ ID: 0
1932+ Characteristics:
1933+ 3.3 V is provided
1934+ Opening is shared
1935+ PME signal is supported
1936+ Bus Address: 0000:00:01.0
1937+
1938+Handle 0x001D, DMI type 10, 10 bytes
1939+On Board Device 1 Information
1940+ Type: Video
1941+ Status: Enabled
1942+ Description: Intel(R) HD Graphics Device
1943+On Board Device 2 Information
1944+ Type: Ethernet
1945+ Status: Enabled
1946+ Description: Intel(R) WGI218V Gigabit Network Device
1947+On Board Device 3 Information
1948+ Type: Sound
1949+ Status: Enabled
1950+ Description: Realtek High Definition Audio Device
1951+
1952+Handle 0x001E, DMI type 11, 5 bytes
1953+OEM Strings
1954+ String 1: To Be Filled By O.E.M.
1955+
1956+Handle 0x001F, DMI type 12, 5 bytes
1957+System Configuration Options
1958+ Option 1: To Be Filled By O.E.M.
1959+
1960+Handle 0x0020, DMI type 24, 5 bytes
1961+Hardware Security
1962+ Power-On Password Status: Disabled
1963+ Keyboard Password Status: Disabled
1964+ Administrator Password Status: Disabled
1965+ Front Panel Reset Status: Disabled
1966+
1967+Handle 0x0021, DMI type 32, 20 bytes
1968+System Boot Information
1969+ Status: No errors detected
1970+
1971+Handle 0x0022, DMI type 34, 11 bytes
1972+Management Device
1973+ Description: LM78-1
1974+ Type: LM78
1975+ Address: 0x00000000
1976+ Address Type: I/O Port
1977+
1978+Handle 0x0023, DMI type 26, 22 bytes
1979+Voltage Probe
1980+ Description: LM78A
1981+ Location: <OUT OF SPEC>
1982+ Status: <OUT OF SPEC>
1983+ Maximum Value: Unknown
1984+ Minimum Value: Unknown
1985+ Resolution: Unknown
1986+ Tolerance: Unknown
1987+ Accuracy: Unknown
1988+ OEM-specific Information: 0x00000000
1989+ Nominal Value: Unknown
1990+
1991+Handle 0x0024, DMI type 36, 16 bytes
1992+Management Device Threshold Data
1993+ Lower Non-critical Threshold: 1
1994+ Upper Non-critical Threshold: 2
1995+ Lower Critical Threshold: 3
1996+ Upper Critical Threshold: 4
1997+ Lower Non-recoverable Threshold: 5
1998+ Upper Non-recoverable Threshold: 6
1999+
2000+Handle 0x0025, DMI type 35, 11 bytes
2001+Management Device Component
2002+ Description: To Be Filled By O.E.M.
2003+ Management Device Handle: 0x0022
2004+ Component Handle: 0x0022
2005+ Threshold Handle: 0x0023
2006+
2007+Handle 0x0026, DMI type 28, 22 bytes
2008+Temperature Probe
2009+ Description: LM78A
2010+ Location: <OUT OF SPEC>
2011+ Status: <OUT OF SPEC>
2012+ Maximum Value: Unknown
2013+ Minimum Value: Unknown
2014+ Resolution: Unknown
2015+ Tolerance: Unknown
2016+ Accuracy: Unknown
2017+ OEM-specific Information: 0x00000000
2018+ Nominal Value: Unknown
2019+
2020+Handle 0x0027, DMI type 36, 16 bytes
2021+Management Device Threshold Data
2022+ Lower Non-critical Threshold: 1
2023+ Upper Non-critical Threshold: 2
2024+ Lower Critical Threshold: 3
2025+ Upper Critical Threshold: 4
2026+ Lower Non-recoverable Threshold: 5
2027+ Upper Non-recoverable Threshold: 6
2028+
2029+Handle 0x0028, DMI type 35, 11 bytes
2030+Management Device Component
2031+ Description: To Be Filled By O.E.M.
2032+ Management Device Handle: 0x0022
2033+ Component Handle: 0x0025
2034+ Threshold Handle: 0x0026
2035+
2036+Handle 0x0029, DMI type 27, 15 bytes
2037+Cooling Device
2038+ Temperature Probe Handle: 0x0026
2039+ Type: <OUT OF SPEC>
2040+ Status: <OUT OF SPEC>
2041+ Cooling Unit Group: 1
2042+ OEM-specific Information: 0x00000000
2043+ Nominal Speed: Unknown Or Non-rotating
2044+ Description: Cooling Dev 1
2045+
2046+Handle 0x002A, DMI type 36, 16 bytes
2047+Management Device Threshold Data
2048+ Lower Non-critical Threshold: 1
2049+ Upper Non-critical Threshold: 2
2050+ Lower Critical Threshold: 3
2051+ Upper Critical Threshold: 4
2052+ Lower Non-recoverable Threshold: 5
2053+ Upper Non-recoverable Threshold: 6
2054+
2055+Handle 0x002B, DMI type 35, 11 bytes
2056+Management Device Component
2057+ Description: To Be Filled By O.E.M.
2058+ Management Device Handle: 0x0022
2059+ Component Handle: 0x0028
2060+ Threshold Handle: 0x0029
2061+
2062+Handle 0x002C, DMI type 27, 15 bytes
2063+Cooling Device
2064+ Temperature Probe Handle: 0x0026
2065+ Type: <OUT OF SPEC>
2066+ Status: <OUT OF SPEC>
2067+ Cooling Unit Group: 1
2068+ OEM-specific Information: 0x00000000
2069+ Nominal Speed: Unknown Or Non-rotating
2070+ Description: Not Specified
2071+
2072+Handle 0x002D, DMI type 36, 16 bytes
2073+Management Device Threshold Data
2074+ Lower Non-critical Threshold: 1
2075+ Upper Non-critical Threshold: 2
2076+ Lower Critical Threshold: 3
2077+ Upper Critical Threshold: 4
2078+ Lower Non-recoverable Threshold: 5
2079+ Upper Non-recoverable Threshold: 6
2080+
2081+Handle 0x002E, DMI type 35, 11 bytes
2082+Management Device Component
2083+ Description: To Be Filled By O.E.M.
2084+ Management Device Handle: 0x0022
2085+ Component Handle: 0x002B
2086+ Threshold Handle: 0x002C
2087+
2088+Handle 0x002F, DMI type 29, 22 bytes
2089+Electrical Current Probe
2090+ Description: ABC
2091+ Location: <OUT OF SPEC>
2092+ Status: <OUT OF SPEC>
2093+ Maximum Value: Unknown
2094+ Minimum Value: Unknown
2095+ Resolution: Unknown
2096+ Tolerance: Unknown
2097+ Accuracy: Unknown
2098+ OEM-specific Information: 0x00000000
2099+ Nominal Value: Unknown
2100+
2101+Handle 0x0030, DMI type 36, 16 bytes
2102+Management Device Threshold Data
2103+
2104+Handle 0x0031, DMI type 35, 11 bytes
2105+Management Device Component
2106+ Description: To Be Filled By O.E.M.
2107+ Management Device Handle: 0x0022
2108+ Component Handle: 0x002E
2109+ Threshold Handle: 0x002C
2110+
2111+Handle 0x0032, DMI type 26, 22 bytes
2112+Voltage Probe
2113+ Description: LM78A
2114+ Location: Power Unit
2115+ Status: OK
2116+ Maximum Value: Unknown
2117+ Minimum Value: Unknown
2118+ Resolution: Unknown
2119+ Tolerance: Unknown
2120+ Accuracy: Unknown
2121+ OEM-specific Information: 0x00000000
2122+ Nominal Value: Unknown
2123+
2124+Handle 0x0033, DMI type 28, 22 bytes
2125+Temperature Probe
2126+ Description: LM78A
2127+ Location: Power Unit
2128+ Status: OK
2129+ Maximum Value: Unknown
2130+ Minimum Value: Unknown
2131+ Resolution: Unknown
2132+ Tolerance: Unknown
2133+ Accuracy: Unknown
2134+ OEM-specific Information: 0x00000000
2135+ Nominal Value: Unknown
2136+
2137+Handle 0x0034, DMI type 27, 15 bytes
2138+Cooling Device
2139+ Temperature Probe Handle: 0x0033
2140+ Type: Power Supply Fan
2141+ Status: OK
2142+ Cooling Unit Group: 1
2143+ OEM-specific Information: 0x00000000
2144+ Nominal Speed: Unknown Or Non-rotating
2145+ Description: Cooling Dev 1
2146+
2147+Handle 0x0035, DMI type 29, 22 bytes
2148+Electrical Current Probe
2149+ Description: ABC
2150+ Location: Power Unit
2151+ Status: OK
2152+ Maximum Value: Unknown
2153+ Minimum Value: Unknown
2154+ Resolution: Unknown
2155+ Tolerance: Unknown
2156+ Accuracy: Unknown
2157+ OEM-specific Information: 0x00000000
2158+ Nominal Value: Unknown
2159+
2160+Handle 0x0036, DMI type 39, 22 bytes
2161+System Power Supply
2162+ Power Unit Group: 1
2163+ Location: To Be Filled By O.E.M.
2164+ Name: To Be Filled By O.E.M.
2165+ Manufacturer: To Be Filled By O.E.M.
2166+ Serial Number: To Be Filled By O.E.M.
2167+ Asset Tag: To Be Filled By O.E.M.
2168+ Model Part Number: To Be Filled By O.E.M.
2169+ Revision: To Be Filled By O.E.M.
2170+ Max Power Capacity: Unknown
2171+ Status: Present, OK
2172+ Type: Switching
2173+ Input Voltage Range Switching: Auto-switch
2174+ Plugged: Yes
2175+ Hot Replaceable: No
2176+ Input Voltage Probe Handle: 0x0032
2177+ Cooling Device Handle: 0x0034
2178+ Input Current Probe Handle: 0x0035
2179+
2180+Handle 0x0037, DMI type 41, 11 bytes
2181+Onboard Device
2182+ Reference Designation: CPU1
2183+ Type: Video
2184+ Status: Enabled
2185+ Type Instance: 1
2186+ Bus Address: 0000:00:02.0
2187+
2188+Handle 0x0038, DMI type 41, 11 bytes
2189+Onboard Device
2190+ Reference Designation: ILAN
2191+ Type: Ethernet
2192+ Status: Enabled
2193+ Type Instance: 1
2194+ Bus Address: 0000:00:19.0
2195+
2196+Handle 0x0039, DMI type 41, 11 bytes
2197+Onboard Device
2198+ Reference Designation: AUDIO1
2199+ Type: Sound
2200+ Status: Enabled
2201+ Type Instance: 1
2202+ Bus Address: 0000:00:1b.0
2203+
2204+Handle 0x003A, DMI type 4, 42 bytes
2205+Processor Information
2206+ Socket Designation: CPU 1
2207+ Type: Central Processor
2208+ Family: Core i3
2209+ Manufacturer: Intel(R) Corp.
2210+ ID: 51 06 04 00 FF FB EB BF
2211+ Signature: Type 0, Family 6, Model 69, Stepping 1
2212+ Flags:
2213+ FPU (Floating-point unit on-chip)
2214+ VME (Virtual mode extension)
2215+ DE (Debugging extension)
2216+ PSE (Page size extension)
2217+ TSC (Time stamp counter)
2218+ MSR (Model specific registers)
2219+ PAE (Physical address extension)
2220+ MCE (Machine check exception)
2221+ CX8 (CMPXCHG8 instruction supported)
2222+ APIC (On-chip APIC hardware supported)
2223+ SEP (Fast system call)
2224+ MTRR (Memory type range registers)
2225+ PGE (Page global enable)
2226+ MCA (Machine check architecture)
2227+ CMOV (Conditional move instruction supported)
2228+ PAT (Page attribute table)
2229+ PSE-36 (36-bit page size extension)
2230+ CLFSH (CLFLUSH instruction supported)
2231+ DS (Debug store)
2232+ ACPI (ACPI supported)
2233+ MMX (MMX technology supported)
2234+ FXSR (FXSAVE and FXSTOR instructions supported)
2235+ SSE (Streaming SIMD extensions)
2236+ SSE2 (Streaming SIMD extensions 2)
2237+ SS (Self-snoop)
2238+ HTT (Multi-threading)
2239+ TM (Thermal monitor supported)
2240+ PBE (Pending break enabled)
2241+ Version: Intel(R) Core(TM) i3-4010U CPU @ 1.70GHz
2242+ Voltage: 1.2 V
2243+ External Clock: 100 MHz
2244+ Max Speed: 1700 MHz
2245+ Current Speed: 1700 MHz
2246+ Status: Populated, Enabled
2247+ Upgrade: <OUT OF SPEC>
2248+ L1 Cache Handle: 0x003C
2249+ L2 Cache Handle: 0x003B
2250+ L3 Cache Handle: 0x003D
2251+ Serial Number: Not Specified
2252+ Asset Tag: Fill By OEM
2253+ Part Number: Fill By OEM
2254+ Core Count: 2
2255+ Core Enabled: 2
2256+ Thread Count: 4
2257+ Characteristics:
2258+ 64-bit capable
2259+
2260+Handle 0x003B, DMI type 7, 19 bytes
2261+Cache Information
2262+ Socket Designation: CPU Internal L2
2263+ Configuration: Enabled, Not Socketed, Level 2
2264+ Operational Mode: Write Back
2265+ Location: Internal
2266+ Installed Size: 512 kB
2267+ Maximum Size: 512 kB
2268+ Supported SRAM Types:
2269+ Unknown
2270+ Installed SRAM Type: Unknown
2271+ Speed: Unknown
2272+ Error Correction Type: Single-bit ECC
2273+ System Type: Unified
2274+ Associativity: 8-way Set-associative
2275+
2276+Handle 0x003C, DMI type 7, 19 bytes
2277+Cache Information
2278+ Socket Designation: CPU Internal L1
2279+ Configuration: Enabled, Not Socketed, Level 1
2280+ Operational Mode: Write Back
2281+ Location: Internal
2282+ Installed Size: 128 kB
2283+ Maximum Size: 128 kB
2284+ Supported SRAM Types:
2285+ Unknown
2286+ Installed SRAM Type: Unknown
2287+ Speed: Unknown
2288+ Error Correction Type: Single-bit ECC
2289+ System Type: Other
2290+ Associativity: 8-way Set-associative
2291+
2292+Handle 0x003D, DMI type 7, 19 bytes
2293+Cache Information
2294+ Socket Designation: CPU Internal L3
2295+ Configuration: Enabled, Not Socketed, Level 3
2296+ Operational Mode: Write Back
2297+ Location: Internal
2298+ Installed Size: 3072 kB
2299+ Maximum Size: 3072 kB
2300+ Supported SRAM Types:
2301+ Unknown
2302+ Installed SRAM Type: Unknown
2303+ Speed: Unknown
2304+ Error Correction Type: Single-bit ECC
2305+ System Type: Unified
2306+ Associativity: 12-way Set-associative
2307+
2308+Handle 0x003E, DMI type 16, 23 bytes
2309+Physical Memory Array
2310+ Location: System Board Or Motherboard
2311+ Use: System Memory
2312+ Error Correction Type: None
2313+ Maximum Capacity: 16 GB
2314+ Error Information Handle: Not Provided
2315+ Number Of Devices: 2
2316+
2317+Handle 0x003F, DMI type 17, 40 bytes
2318+Memory Device
2319+ Array Handle: 0x003E
2320+ Error Information Handle: Not Provided
2321+ Total Width: 64 bits
2322+ Data Width: 64 bits
2323+ Size: 8192 MB
2324+ Form Factor: SODIMM
2325+ Set: None
2326+ Locator: DIMM 1
2327+ Bank Locator: Channel A Slot 0
2328+ Type: DDR3
2329+ Type Detail: Synchronous
2330+ Speed: 1600 MHz
2331+ Manufacturer: 1315
2332+ Serial Number: 102007000000
2333+ Asset Tag: 9876543210
2334+ Part Number: CT102464BF160B.C16
2335+ Rank: 2
2336+ Configured Clock Speed: 1600 MHz
2337+ Minimum voltage: 1.350 V
2338+ Maximum voltage: 1.500 V
2339+ Configured voltage: 1.350 V
2340+
2341+Handle 0x0040, DMI type 20, 35 bytes
2342+Memory Device Mapped Address
2343+ Starting Address: 0x00000000000
2344+ Ending Address: 0x001FFFFFFFF
2345+ Range Size: 8 GB
2346+ Physical Device Handle: 0x003F
2347+ Memory Array Mapped Address Handle: 0x0043
2348+ Partition Row Position: Unknown
2349+ Interleave Position: Unknown
2350+ Interleaved Data Depth: Unknown
2351+
2352+Handle 0x0041, DMI type 17, 40 bytes
2353+Memory Device
2354+ Array Handle: 0x003E
2355+ Error Information Handle: Not Provided
2356+ Total Width: 64 bits
2357+ Data Width: 64 bits
2358+ Size: 8192 MB
2359+ Form Factor: SODIMM
2360+ Set: None
2361+ Locator: DIMM 2
2362+ Bank Locator: Channel B Slot 0
2363+ Type: DDR3
2364+ Type Detail: Synchronous
2365+ Speed: 1600 MHz
2366+ Manufacturer: 1315
2367+ Serial Number: 037018000000
2368+ Asset Tag: 9876543210
2369+ Part Number: CT102464BF160B.C16
2370+ Rank: 2
2371+ Configured Clock Speed: 1600 MHz
2372+ Minimum voltage: 1.350 V
2373+ Maximum voltage: 1.500 V
2374+ Configured voltage: 1.350 V
2375+
2376+Handle 0x0042, DMI type 20, 35 bytes
2377+Memory Device Mapped Address
2378+ Starting Address: 0x00200000000
2379+ Ending Address: 0x003FFFFFFFF
2380+ Range Size: 8 GB
2381+ Physical Device Handle: 0x0041
2382+ Memory Array Mapped Address Handle: 0x0043
2383+ Partition Row Position: Unknown
2384+ Interleave Position: Unknown
2385+ Interleaved Data Depth: Unknown
2386+
2387+Handle 0x0043, DMI type 19, 31 bytes
2388+Memory Array Mapped Address
2389+ Starting Address: 0x00000000000
2390+ Ending Address: 0x003FFFFFFFF
2391+ Range Size: 16 GB
2392+ Physical Array Handle: 0x003E
2393+ Partition Width: 2
2394+
2395+Handle 0x0054, DMI type 136, 6 bytes
2396+OEM-specific Type
2397+ Header and Data:
2398+ 88 06 54 00 5A 5A
2399+
2400+Handle 0x0055, DMI type 131, 64 bytes
2401+OEM-specific Type
2402+ Header and Data:
2403+ 83 40 55 00 31 00 00 00 00 00 00 00 00 00 00 00
2404+ F8 00 43 9C 00 00 00 00 01 00 00 00 05 00 09 00
2405+ AA 06 0D 00 00 00 00 00 C8 00 59 15 00 00 00 00
2406+ 00 00 00 00 26 00 00 00 76 50 72 6F 00 00 00 00
2407+
2408+Handle 0x0057, DMI type 9, 17 bytes
2409+System Slot Information
2410+ Designation: PCIeSlot
2411+ Type: x1 PCI Express 2 x1
2412+ Current Usage: Available
2413+ Length: Short
2414+ ID: 7
2415+ Characteristics:
2416+ 3.3 V is provided
2417+ Opening is shared
2418+ PME signal is supported
2419+ Bus Address: 0000:00:1c.5
2420+
2421+Handle 0x0058, DMI type 9, 17 bytes
2422+System Slot Information
2423+ Designation: PCIeSlot
2424+ Type: x1 PCI Express 2 x1
2425+ Current Usage: Available
2426+ Length: Short
2427+ ID: 5
2428+ Characteristics:
2429+ 3.3 V is provided
2430+ Opening is shared
2431+ PME signal is supported
2432+ Bus Address: 0000:00:1c.6
2433+
2434+Handle 0x0059, DMI type 9, 17 bytes
2435+System Slot Information
2436+ Designation: PCIeSlot
2437+ Type: x4 PCI Express 2 x4
2438+ Current Usage: Available
2439+ Length: Short
2440+ ID: 4
2441+ Characteristics:
2442+ 3.3 V is provided
2443+ Opening is shared
2444+ PME signal is supported
2445+ Bus Address: 0000:00:1c.1
2446+
2447+Handle 0x005A, DMI type 9, 17 bytes
2448+System Slot Information
2449+ Designation: PCI Slot
2450+ Type: 32-bit PCI
2451+ Current Usage: Available
2452+ Length: Short
2453+ ID: 3
2454+ Characteristics:
2455+ 3.3 V is provided
2456+ Opening is shared
2457+ PME signal is supported
2458+ Bus Address: 0000:ff:00.0
2459+
2460+Handle 0x005B, DMI type 9, 17 bytes
2461+System Slot Information
2462+ Designation: PCI Slot
2463+ Type: 32-bit PCI
2464+ Current Usage: Available
2465+ Length: Short
2466+ ID: 2
2467+ Characteristics:
2468+ 3.3 V is provided
2469+ Opening is shared
2470+ PME signal is supported
2471+ Bus Address: 0000:ff:01.0
2472+
2473+Handle 0x005C, DMI type 9, 17 bytes
2474+System Slot Information
2475+ Designation: PCI Slot
2476+ Type: 32-bit PCI
2477+ Current Usage: Available
2478+ Length: Short
2479+ ID: 1
2480+ Characteristics:
2481+ 3.3 V is provided
2482+ Opening is shared
2483+ PME signal is supported
2484+ Bus Address: 0000:ff:02.0
2485+
2486+Handle 0x005D, DMI type 13, 22 bytes
2487+BIOS Language Information
2488+ Language Description Format: Long
2489+ Installable Languages: 1
2490+ en|US|iso8859-1
2491+ Currently Installed Language: en|US|iso8859-1
2492+
2493+Handle 0x0060, DMI type 9, 17 bytes
2494+System Slot Information
2495+ Designation: PCIeSlot
2496+ Type: x1 PCI Express 2 x1
2497+ Current Usage: Available
2498+ Length: Short
2499+ ID: 7
2500+ Characteristics:
2501+ 3.3 V is provided
2502+ Opening is shared
2503+ PME signal is supported
2504+ Bus Address: 0000:00:1c.5
2505+
2506+Handle 0x0061, DMI type 9, 17 bytes
2507+System Slot Information
2508+ Designation: PCIeSlot
2509+ Type: x1 PCI Express 2 x1
2510+ Current Usage: Available
2511+ Length: Short
2512+ ID: 5
2513+ Characteristics:
2514+ 3.3 V is provided
2515+ Opening is shared
2516+ PME signal is supported
2517+ Bus Address: 0000:00:1c.6
2518+
2519+Handle 0x0062, DMI type 9, 17 bytes
2520+System Slot Information
2521+ Designation: PCIeSlot
2522+ Type: x4 PCI Express 2 x4
2523+ Current Usage: Available
2524+ Length: Short
2525+ ID: 4
2526+ Characteristics:
2527+ 3.3 V is provided
2528+ Opening is shared
2529+ PME signal is supported
2530+ Bus Address: 0000:00:1c.1
2531+
2532+Handle 0x0063, DMI type 9, 17 bytes
2533+System Slot Information
2534+ Designation: PCI Slot
2535+ Type: 32-bit PCI
2536+ Current Usage: Available
2537+ Length: Short
2538+ ID: 3
2539+ Characteristics:
2540+ 3.3 V is provided
2541+ Opening is shared
2542+ PME signal is supported
2543+ Bus Address: 0000:ff:00.0
2544+
2545+Handle 0x0064, DMI type 9, 17 bytes
2546+System Slot Information
2547+ Designation: PCI Slot
2548+ Type: 32-bit PCI
2549+ Current Usage: Available
2550+ Length: Short
2551+ ID: 2
2552+ Characteristics:
2553+ 3.3 V is provided
2554+ Opening is shared
2555+ PME signal is supported
2556+ Bus Address: 0000:ff:01.0
2557+
2558+Handle 0x0065, DMI type 9, 17 bytes
2559+System Slot Information
2560+ Designation: PCI Slot
2561+ Type: 32-bit PCI
2562+ Current Usage: Available
2563+ Length: Short
2564+ ID: 1
2565+ Characteristics:
2566+ 3.3 V is provided
2567+ Opening is shared
2568+ PME signal is supported
2569+ Bus Address: 0000:ff:02.0
2570+
2571+Handle 0x0066, DMI type 127, 4 bytes
2572+End Of Table
2573
2574=== modified file 't/pt-variable-advisor/samples/vars001-ignore-rules.txt'
2575--- t/pt-variable-advisor/samples/vars001-ignore-rules.txt 2011-06-24 22:02:05 +0000
2576+++ t/pt-variable-advisor/samples/vars001-ignore-rules.txt 2014-09-29 19:43:03 +0000
2577@@ -10,6 +10,8 @@
2578
2579 # WARN slave_net_timeout: This variable is set too high.
2580
2581+# WARN expire_logs_days: Binary logs are enabled, but automatic purging is not enabled.
2582+
2583 # NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later.
2584
2585 # NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance.
2586
2587=== modified file 't/pt-variable-advisor/samples/vars001-verbose-verbose.txt'
2588--- t/pt-variable-advisor/samples/vars001-verbose-verbose.txt 2011-07-13 22:36:14 +0000
2589+++ t/pt-variable-advisor/samples/vars001-verbose-verbose.txt 2014-09-29 19:43:03 +0000
2590@@ -10,6 +10,8 @@
2591
2592 # WARN slave_net_timeout: This variable is set too high. This is too long to wait before noticing that the connection to the master has failed and retrying. This should probably be set to 60 seconds or less. It is also a good idea to use pt-heartbeat to ensure that the connection does not appear to time out when the master is simply idle.
2593
2594+# WARN expire_logs_days: Binary logs are enabled, but automatic purging is not enabled. If you do not purge binary logs, your disk will fill up. If you delete binary logs externally to MySQL, you will cause unwanted behaviors. Always ask MySQL to purge obsolete logs, never delete them externally.
2595+
2596 # NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later. Some people prefer to set innodb_file_per_table and allocate a fixed-size file for ibdata1.
2597
2598 # NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance.
2599
2600=== modified file 't/pt-variable-advisor/samples/vars001-verbose.txt'
2601--- t/pt-variable-advisor/samples/vars001-verbose.txt 2011-06-24 22:02:05 +0000
2602+++ t/pt-variable-advisor/samples/vars001-verbose.txt 2014-09-29 19:43:03 +0000
2603@@ -10,6 +10,8 @@
2604
2605 # WARN slave_net_timeout: This variable is set too high. This is too long to wait before noticing that the connection to the master has failed and retrying.
2606
2607+# WARN expire_logs_days: Binary logs are enabled, but automatic purging is not enabled. If you do not purge binary logs, your disk will fill up.
2608+
2609 # NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later. Some people prefer to set innodb_file_per_table and allocate a fixed-size file for ibdata1.
2610
2611 # NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance.
2612
2613=== modified file 't/pt-variable-advisor/samples/vars001.txt'
2614--- t/pt-variable-advisor/samples/vars001.txt 2011-06-24 22:02:05 +0000
2615+++ t/pt-variable-advisor/samples/vars001.txt 2014-09-29 19:43:03 +0000
2616@@ -10,6 +10,8 @@
2617
2618 # WARN slave_net_timeout: This variable is set too high.
2619
2620+# WARN expire_logs_days: Binary logs are enabled, but automatic purging is not enabled.
2621+
2622 # NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later.
2623
2624 # NOTE innodb_flush_method: Most production database servers that use InnoDB should set innodb_flush_method to O_DIRECT to avoid double-buffering, unless the I/O system is very low performance.
2625
2626=== modified file 't/pt-variable-advisor/samples/vars002.txt'
2627--- t/pt-variable-advisor/samples/vars002.txt 2011-06-24 22:02:05 +0000
2628+++ t/pt-variable-advisor/samples/vars002.txt 2014-09-29 19:43:03 +0000
2629@@ -10,6 +10,8 @@
2630
2631 # WARN slave_net_timeout: This variable is set too high.
2632
2633+# WARN expire_logs_days: Binary logs are enabled, but automatic purging is not enabled.
2634+
2635 # NOTE innodb_data_file_path: Auto-extending InnoDB files can consume a lot of disk space that is very difficult to reclaim later.
2636
2637 # WARN myisam_recover_options: myisam_recover_options should be set to some value such as BACKUP,FORCE to ensure that table corruption is noticed.

Subscribers

People subscribed via source and target branches