Merge lp:~percona-core/percona-toolkit/release-2.1.11 into lp:percona-toolkit/2.1

Proposed by Hrvoje Matijakovic
Status: Needs review
Proposed branch: lp:~percona-core/percona-toolkit/release-2.1.11
Merge into: lp:percona-toolkit/2.1
Diff against target: 2456 lines (+1689/-81)
42 files modified
Changelog (+2/-0)
Makefile.PL (+1/-1)
bin/pt-align (+2/-2)
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 (+2/-2)
bin/pt-find (+2/-2)
bin/pt-fingerprint (+2/-2)
bin/pt-fk-error-logger (+2/-2)
bin/pt-heartbeat (+2/-2)
bin/pt-index-usage (+2/-2)
bin/pt-ioprofile (+2/-2)
bin/pt-kill (+2/-2)
bin/pt-log-player (+2/-2)
bin/pt-mext (+2/-2)
bin/pt-mysql-summary (+2/-2)
bin/pt-online-schema-change (+2/-2)
bin/pt-pmp (+2/-2)
bin/pt-query-advisor (+2/-2)
bin/pt-query-digest (+2/-2)
bin/pt-show-grants (+2/-2)
bin/pt-sift (+2/-2)
bin/pt-slave-delay (+2/-2)
bin/pt-slave-find (+2/-2)
bin/pt-slave-restart (+2/-2)
bin/pt-stalk (+2/-2)
bin/pt-summary (+2/-2)
bin/pt-table-checksum (+2/-2)
bin/pt-table-sync (+2/-2)
bin/pt-table-usage (+2/-2)
bin/pt-tcp-model (+2/-2)
bin/pt-trend (+2/-2)
bin/pt-upgrade (+2/-2)
bin/pt-variable-advisor (+2/-2)
bin/pt-visual-explain (+2/-2)
config/deb/changelog (+7/-0)
config/sphinx-build/conf.py (+1/-1)
docs/percona-toolkit.pod (+2/-2)
docs/release_notes.rst (+1604/-5)
To merge this branch: bzr merge lp:~percona-core/percona-toolkit/release-2.1.11
Reviewer Review Type Date Requested Status
Percona Toolkit developers Pending
Review via email: mp+209228@code.launchpad.net
To post a comment you must log in.

Unmerged revisions

544. By Hrvoje Matijakovic

-PT-2.1.11-release notes

543. By Alexey Bychko

release 2.1.11

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'Changelog'
--- Changelog 2014-03-03 22:02:30 +0000
+++ Changelog 2014-03-04 12:35:02 +0000
@@ -1,5 +1,7 @@
1Changelog for Percona Toolkit1Changelog for Percona Toolkit
22
3v2.1.11 released 2014-03-04
4
3 * Fixed bug 1279502: --version-check behaves like spyware5 * Fixed bug 1279502: --version-check behaves like spyware
4 * Fixed bug 1199589: pt-archiver deletes data despite --dry-run6 * Fixed bug 1199589: pt-archiver deletes data despite --dry-run
57
68
=== modified file 'Makefile.PL'
--- Makefile.PL 2013-07-18 17:31:04 +0000
+++ Makefile.PL 2014-03-04 12:35:02 +0000
@@ -2,7 +2,7 @@
22
3WriteMakefile(3WriteMakefile(
4 NAME => 'percona-toolkit',4 NAME => 'percona-toolkit',
5 VERSION => '2.1.10',5 VERSION => '2.1.11',
6 EXE_FILES => [ <bin/*> ],6 EXE_FILES => [ <bin/*> ],
7 MAN1PODS => {7 MAN1PODS => {
8 'docs/percona-toolkit.pod' => 'blib/man1/percona-toolkit.1p',8 'docs/percona-toolkit.pod' => 'blib/man1/percona-toolkit.1p',
99
=== modified file 'bin/pt-align'
--- bin/pt-align 2013-07-18 17:31:04 +0000
+++ bin/pt-align 2014-03-04 12:35:02 +0000
@@ -199,7 +199,7 @@
199199
200=head1 COPYRIGHT, LICENSE, AND WARRANTY200=head1 COPYRIGHT, LICENSE, AND WARRANTY
201201
202This program is copyright 2011-2013 Percona Ireland Ltd,202This program is copyright 2011-2014 Percona Ireland Ltd,
2032010-2011 Baron Schwartz.2032010-2011 Baron Schwartz.
204204
205THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED205THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -218,6 +218,6 @@
218218
219=head1 VERSION219=head1 VERSION
220220
221pt-align 2.1.10221pt-align 2.1.11
222222
223=cut223=cut
224224
=== modified file 'bin/pt-archiver'
--- bin/pt-archiver 2014-03-03 22:02:30 +0000
+++ bin/pt-archiver 2014-03-04 12:35:02 +0000
@@ -7534,7 +7534,7 @@
75347534
7535=head1 COPYRIGHT, LICENSE, AND WARRANTY7535=head1 COPYRIGHT, LICENSE, AND WARRANTY
75367536
7537This program is copyright 2011-2013 Percona Ireland Ltd,7537This program is copyright 2011-2014 Percona Ireland Ltd,
75382007-2011 Baron Schwartz.75382007-2011 Baron Schwartz.
75397539
7540THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED7540THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -7553,6 +7553,6 @@
75537553
7554=head1 VERSION7554=head1 VERSION
75557555
7556pt-archiver 2.1.107556pt-archiver 2.1.11
75577557
7558=cut7558=cut
75597559
=== modified file 'bin/pt-config-diff'
--- bin/pt-config-diff 2014-03-03 22:02:30 +0000
+++ bin/pt-config-diff 2014-03-04 12:35:02 +0000
@@ -4832,7 +4832,7 @@
48324832
4833=head1 COPYRIGHT, LICENSE, AND WARRANTY4833=head1 COPYRIGHT, LICENSE, AND WARRANTY
48344834
4835This program is copyright 2011-2013 Percona Ireland Ltd.4835This program is copyright 2011-2014 Percona Ireland Ltd.
48364836
4837THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED4837THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
4838WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF4838WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -4850,6 +4850,6 @@
48504850
4851=head1 VERSION4851=head1 VERSION
48524852
4853pt-config-diff 2.1.104853pt-config-diff 2.1.11
48544854
4855=cut4855=cut
48564856
=== modified file 'bin/pt-deadlock-logger'
--- bin/pt-deadlock-logger 2014-03-03 22:02:30 +0000
+++ bin/pt-deadlock-logger 2014-03-04 12:35:02 +0000
@@ -4750,7 +4750,7 @@
47504750
4751=head1 COPYRIGHT, LICENSE, AND WARRANTY4751=head1 COPYRIGHT, LICENSE, AND WARRANTY
47524752
4753This program is copyright 2011-2013 Percona Ireland Ltd,4753This program is copyright 2011-2014 Percona Ireland Ltd,
47542007-2011 Baron Schwartz.47542007-2011 Baron Schwartz.
47554755
4756THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED4756THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -4769,6 +4769,6 @@
47694769
4770=head1 VERSION4770=head1 VERSION
47714771
4772pt-deadlock-logger 2.1.104772pt-deadlock-logger 2.1.11
47734773
4774=cut4774=cut
47754775
=== modified file 'bin/pt-diskstats'
--- bin/pt-diskstats 2014-03-03 22:02:30 +0000
+++ bin/pt-diskstats 2014-03-04 12:35:02 +0000
@@ -5530,7 +5530,7 @@
55305530
5531=head1 COPYRIGHT, LICENSE, AND WARRANTY5531=head1 COPYRIGHT, LICENSE, AND WARRANTY
55325532
5533This program is copyright 2011-2013 Percona Ireland Ltd,5533This program is copyright 2011-2014 Percona Ireland Ltd,
55342010-2011 Baron Schwartz.55342010-2011 Baron Schwartz.
55355535
5536THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED5536THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -5549,6 +5549,6 @@
55495549
5550=head1 VERSION5550=head1 VERSION
55515551
5552pt-diskstats 2.1.105552pt-diskstats 2.1.11
55535553
5554=cut5554=cut
55555555
=== modified file 'bin/pt-duplicate-key-checker'
--- bin/pt-duplicate-key-checker 2014-03-03 22:02:30 +0000
+++ bin/pt-duplicate-key-checker 2014-03-04 12:35:02 +0000
@@ -5400,7 +5400,7 @@
54005400
5401=head1 COPYRIGHT, LICENSE, AND WARRANTY5401=head1 COPYRIGHT, LICENSE, AND WARRANTY
54025402
5403This program is copyright 2011-2013 Percona Ireland Ltd,5403This program is copyright 2011-2014 Percona Ireland Ltd,
54042007-2011 Baron Schwartz.54042007-2011 Baron Schwartz.
54055405
5406THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED5406THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -5419,6 +5419,6 @@
54195419
5420=head1 VERSION5420=head1 VERSION
54215421
5422pt-duplicate-key-checker 2.1.105422pt-duplicate-key-checker 2.1.11
54235423
5424=cut5424=cut
54255425
=== modified file 'bin/pt-fifo-split'
--- bin/pt-fifo-split 2013-07-18 17:31:04 +0000
+++ bin/pt-fifo-split 2014-03-04 12:35:02 +0000
@@ -1549,7 +1549,7 @@
15491549
1550=head1 COPYRIGHT, LICENSE, AND WARRANTY1550=head1 COPYRIGHT, LICENSE, AND WARRANTY
15511551
1552This program is copyright 2011-2013 Percona Ireland Ltd,1552This program is copyright 2011-2014 Percona Ireland Ltd,
15532007-2011 Baron Schwartz.15532007-2011 Baron Schwartz.
15541554
1555THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED1555THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -1568,6 +1568,6 @@
15681568
1569=head1 VERSION1569=head1 VERSION
15701570
1571pt-fifo-split 2.1.101571pt-fifo-split 2.1.11
15721572
1573=cut1573=cut
15741574
=== modified file 'bin/pt-find'
--- bin/pt-find 2014-03-03 22:02:30 +0000
+++ bin/pt-find 2014-03-04 12:35:02 +0000
@@ -4858,7 +4858,7 @@
48584858
4859=head1 COPYRIGHT, LICENSE, AND WARRANTY4859=head1 COPYRIGHT, LICENSE, AND WARRANTY
48604860
4861This program is copyright 2011-2013 Percona Ireland Ltd,4861This program is copyright 2011-2014 Percona Ireland Ltd,
48622007-2011 Baron Schwartz.48622007-2011 Baron Schwartz.
48634863
4864THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED4864THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -4877,6 +4877,6 @@
48774877
4878=head1 VERSION4878=head1 VERSION
48794879
4880pt-find 2.1.104880pt-find 2.1.11
48814881
4882=cut4882=cut
48834883
=== modified file 'bin/pt-fingerprint'
--- bin/pt-fingerprint 2013-07-18 17:31:04 +0000
+++ bin/pt-fingerprint 2014-03-04 12:35:02 +0000
@@ -2129,7 +2129,7 @@
21292129
2130=head1 COPYRIGHT, LICENSE, AND WARRANTY2130=head1 COPYRIGHT, LICENSE, AND WARRANTY
21312131
2132This program is copyright 2011-2013 Percona Ireland Ltd.2132This program is copyright 2011-2014 Percona Ireland Ltd.
21332133
2134THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2134THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
2135WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF2135WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -2147,6 +2147,6 @@
21472147
2148=head1 VERSION2148=head1 VERSION
21492149
2150pt-fingerprint 2.1.102150pt-fingerprint 2.1.11
21512151
2152=cut2152=cut
21532153
=== modified file 'bin/pt-fk-error-logger'
--- bin/pt-fk-error-logger 2014-03-03 22:02:30 +0000
+++ bin/pt-fk-error-logger 2014-03-04 12:35:02 +0000
@@ -3990,7 +3990,7 @@
39903990
3991=head1 COPYRIGHT, LICENSE, AND WARRANTY3991=head1 COPYRIGHT, LICENSE, AND WARRANTY
39923992
3993This program is copyright 2011-2013 Percona Ireland Ltd.3993This program is copyright 2011-2014 Percona Ireland Ltd.
39943994
3995THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED3995THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
3996WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF3996WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -4008,6 +4008,6 @@
40084008
4009=head1 VERSION4009=head1 VERSION
40104010
4011pt-fk-error-logger 2.1.104011pt-fk-error-logger 2.1.11
40124012
4013=cut4013=cut
40144014
=== modified file 'bin/pt-heartbeat'
--- bin/pt-heartbeat 2014-03-03 22:02:30 +0000
+++ bin/pt-heartbeat 2014-03-04 12:35:02 +0000
@@ -6038,7 +6038,7 @@
60386038
6039=head1 COPYRIGHT, LICENSE, AND WARRANTY6039=head1 COPYRIGHT, LICENSE, AND WARRANTY
60406040
6041This program is copyright 2007-2013 Percona Ireland Ltd,6041This program is copyright 2007-2014 Percona Ireland Ltd,
60422006 Proven Scaling LLC and Six Apart Ltd.60422006 Proven Scaling LLC and Six Apart Ltd.
60436043
6044Feedback and improvements are welcome.6044Feedback and improvements are welcome.
@@ -6059,6 +6059,6 @@
60596059
6060=head1 VERSION6060=head1 VERSION
60616061
6062pt-heartbeat 2.1.106062pt-heartbeat 2.1.11
60636063
6064=cut6064=cut
60656065
=== modified file 'bin/pt-index-usage'
--- bin/pt-index-usage 2014-03-03 22:02:30 +0000
+++ bin/pt-index-usage 2014-03-04 12:35:02 +0000
@@ -7448,7 +7448,7 @@
74487448
7449=head1 COPYRIGHT, LICENSE, AND WARRANTY7449=head1 COPYRIGHT, LICENSE, AND WARRANTY
74507450
7451This program is copyright 2011-2013 Percona Ireland Ltd,7451This program is copyright 2011-2014 Percona Ireland Ltd,
74522010-2011 Baron Schwartz.74522010-2011 Baron Schwartz.
74537453
7454THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED7454THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -7467,6 +7467,6 @@
74677467
7468=head1 VERSION7468=head1 VERSION
74697469
7470pt-index-usage 2.1.107470pt-index-usage 2.1.11
74717471
7472=cut7472=cut
74737473
=== modified file 'bin/pt-ioprofile'
--- bin/pt-ioprofile 2013-07-18 17:31:04 +0000
+++ bin/pt-ioprofile 2014-03-04 12:35:02 +0000
@@ -1093,7 +1093,7 @@
10931093
1094=head1 COPYRIGHT, LICENSE, AND WARRANTY1094=head1 COPYRIGHT, LICENSE, AND WARRANTY
10951095
1096This program is copyright 2011-2013 Percona Ireland Ltd,1096This program is copyright 2011-2014 Percona Ireland Ltd,
10972010-2011 Baron Schwartz.10972010-2011 Baron Schwartz.
10981098
1099THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED1099THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -1112,7 +1112,7 @@
11121112
1113=head1 VERSION1113=head1 VERSION
11141114
1115pt-ioprofile 2.1.101115pt-ioprofile 2.1.11
11161116
1117=cut1117=cut
11181118
11191119
=== modified file 'bin/pt-kill'
--- bin/pt-kill 2014-03-03 22:02:30 +0000
+++ bin/pt-kill 2014-03-04 12:35:02 +0000
@@ -7749,7 +7749,7 @@
77497749
7750=head1 COPYRIGHT, LICENSE, AND WARRANTY7750=head1 COPYRIGHT, LICENSE, AND WARRANTY
77517751
7752This program is copyright 2011-2013 Percona Ireland Ltd,7752This program is copyright 2011-2014 Percona Ireland Ltd,
77532009-2011 Baron Schwartz.77532009-2011 Baron Schwartz.
77547754
7755THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED7755THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -7768,6 +7768,6 @@
77687768
7769=head1 VERSION7769=head1 VERSION
77707770
7771pt-kill 2.1.107771pt-kill 2.1.11
77727772
7773=cut7773=cut
77747774
=== modified file 'bin/pt-log-player'
--- bin/pt-log-player 2013-07-18 17:31:04 +0000
+++ bin/pt-log-player 2014-03-04 12:35:02 +0000
@@ -3655,7 +3655,7 @@
36553655
3656=head1 COPYRIGHT, LICENSE, AND WARRANTY3656=head1 COPYRIGHT, LICENSE, AND WARRANTY
36573657
3658This program is copyright 2008-2013 Percona Ireland Ltd.3658This program is copyright 2008-2014 Percona Ireland Ltd.
36593659
3660THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED3660THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
3661WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF3661WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -3673,6 +3673,6 @@
36733673
3674=head1 VERSION3674=head1 VERSION
36753675
3676pt-log-player 2.1.103676pt-log-player 2.1.11
36773677
3678=cut3678=cut
36793679
=== modified file 'bin/pt-mext'
--- bin/pt-mext 2013-07-18 17:31:04 +0000
+++ bin/pt-mext 2014-03-04 12:35:02 +0000
@@ -263,7 +263,7 @@
263263
264=head1 COPYRIGHT, LICENSE, AND WARRANTY264=head1 COPYRIGHT, LICENSE, AND WARRANTY
265265
266This program is copyright 2011-2013 Percona Ireland Ltd,266This program is copyright 2011-2014 Percona Ireland Ltd,
2672010 Baron Schwartz.2672010 Baron Schwartz.
268268
269THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED269THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -282,7 +282,7 @@
282282
283=head1 VERSION283=head1 VERSION
284284
285pt-mext 2.1.10285pt-mext 2.1.11
286286
287=cut287=cut
288288
289289
=== modified file 'bin/pt-mysql-summary'
--- bin/pt-mysql-summary 2013-07-18 17:31:04 +0000
+++ bin/pt-mysql-summary 2014-03-04 12:35:02 +0000
@@ -2992,7 +2992,7 @@
29922992
2993=head1 COPYRIGHT, LICENSE, AND WARRANTY2993=head1 COPYRIGHT, LICENSE, AND WARRANTY
29942994
2995This program is copyright 2011-2013 Percona Ireland Ltd,2995This program is copyright 2011-2014 Percona Ireland Ltd,
29962010-2011 Baron Schwartz.29962010-2011 Baron Schwartz.
29972997
2998THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2998THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -3011,7 +3011,7 @@
30113011
3012=head1 VERSION3012=head1 VERSION
30133013
3014pt-mysql-summary 2.1.103014pt-mysql-summary 2.1.11
30153015
3016=cut3016=cut
30173017
30183018
=== modified file 'bin/pt-online-schema-change'
--- bin/pt-online-schema-change 2014-03-03 22:02:30 +0000
+++ bin/pt-online-schema-change 2014-03-04 12:35:02 +0000
@@ -10906,7 +10906,7 @@
1090610906
10907=head1 COPYRIGHT, LICENSE, AND WARRANTY10907=head1 COPYRIGHT, LICENSE, AND WARRANTY
1090810908
10909This program is copyright 2011-2013 Percona Ireland Ltd.10909This program is copyright 2011-2014 Percona Ireland Ltd.
1091010910
10911THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED10911THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
10912WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF10912WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -10924,6 +10924,6 @@
1092410924
10925=head1 VERSION10925=head1 VERSION
1092610926
10927pt-online-schema-change 2.1.1010927pt-online-schema-change 2.1.11
1092810928
10929=cut10929=cut
1093010930
=== modified file 'bin/pt-pmp'
--- bin/pt-pmp 2013-07-18 17:31:04 +0000
+++ bin/pt-pmp 2014-03-04 12:35:02 +0000
@@ -385,7 +385,7 @@
385385
386=head1 COPYRIGHT, LICENSE, AND WARRANTY386=head1 COPYRIGHT, LICENSE, AND WARRANTY
387387
388This program is copyright 2011-2013 Percona Ireland Ltd,388This program is copyright 2011-2014 Percona Ireland Ltd,
3892010-2011 Baron Schwartz.3892010-2011 Baron Schwartz.
390390
391THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED391THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -404,7 +404,7 @@
404404
405=head1 VERSION405=head1 VERSION
406406
407pt-pmp 2.1.10407pt-pmp 2.1.11
408408
409=cut409=cut
410410
411411
=== modified file 'bin/pt-query-advisor'
--- bin/pt-query-advisor 2014-03-03 22:02:30 +0000
+++ bin/pt-query-advisor 2014-03-04 12:35:02 +0000
@@ -8688,7 +8688,7 @@
86888688
8689=head1 COPYRIGHT, LICENSE, AND WARRANTY8689=head1 COPYRIGHT, LICENSE, AND WARRANTY
86908690
8691This program is copyright 2010-2013 Percona Ireland Ltd.8691This program is copyright 2010-2014 Percona Ireland Ltd.
86928692
8693THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED8693THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
8694WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF8694WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -8706,6 +8706,6 @@
87068706
8707=head1 VERSION8707=head1 VERSION
87088708
8709pt-query-advisor 2.1.108709pt-query-advisor 2.1.11
87108710
8711=cut8711=cut
87128712
=== modified file 'bin/pt-query-digest'
--- bin/pt-query-digest 2014-03-03 22:02:30 +0000
+++ bin/pt-query-digest 2014-03-04 12:35:02 +0000
@@ -17432,7 +17432,7 @@
1743217432
17433=head1 COPYRIGHT, LICENSE, AND WARRANTY17433=head1 COPYRIGHT, LICENSE, AND WARRANTY
1743417434
17435This program is copyright 2008-2013 Percona Ireland Ltd.17435This program is copyright 2008-2014 Percona Ireland Ltd.
1743617436
17437THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED17437THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
17438WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF17438WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -17450,6 +17450,6 @@
1745017450
17451=head1 VERSION17451=head1 VERSION
1745217452
17453pt-query-digest 2.1.1017453pt-query-digest 2.1.11
1745417454
17455=cut17455=cut
1745617456
=== modified file 'bin/pt-show-grants'
--- bin/pt-show-grants 2013-07-18 17:31:04 +0000
+++ bin/pt-show-grants 2014-03-04 12:35:02 +0000
@@ -2285,7 +2285,7 @@
22852285
2286=head1 COPYRIGHT, LICENSE, AND WARRANTY2286=head1 COPYRIGHT, LICENSE, AND WARRANTY
22872287
2288This program is copyright 2011-2013 Percona Ireland Ltd,2288This program is copyright 2011-2014 Percona Ireland Ltd,
22892007-2011 Baron Schwartz.22892007-2011 Baron Schwartz.
22902290
2291THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2291THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -2304,6 +2304,6 @@
23042304
2305=head1 VERSION2305=head1 VERSION
23062306
2307pt-show-grants 2.1.102307pt-show-grants 2.1.11
23082308
2309=cut2309=cut
23102310
=== modified file 'bin/pt-sift'
--- bin/pt-sift 2013-07-18 17:31:04 +0000
+++ bin/pt-sift 2014-03-04 12:35:02 +0000
@@ -762,7 +762,7 @@
762762
763=head1 COPYRIGHT, LICENSE, AND WARRANTY763=head1 COPYRIGHT, LICENSE, AND WARRANTY
764764
765This program is copyright 2011-2013 Percona Ireland Ltd,765This program is copyright 2011-2014 Percona Ireland Ltd,
7662010-2011 Baron Schwartz.7662010-2011 Baron Schwartz.
767767
768THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED768THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -781,7 +781,7 @@
781781
782=head1 VERSION782=head1 VERSION
783783
784pt-sift 2.1.10784pt-sift 2.1.11
785785
786=cut786=cut
787787
788788
=== modified file 'bin/pt-slave-delay'
--- bin/pt-slave-delay 2014-03-03 22:02:30 +0000
+++ bin/pt-slave-delay 2014-03-04 12:35:02 +0000
@@ -4560,7 +4560,7 @@
45604560
4561=head1 COPYRIGHT, LICENSE, AND WARRANTY4561=head1 COPYRIGHT, LICENSE, AND WARRANTY
45624562
4563This program is copyright 2011-2013 Percona Ireland Ltd,4563This program is copyright 2011-2014 Percona Ireland Ltd,
45642007-2011 Sergey Zhuravle and Baron Schwartz.45642007-2011 Sergey Zhuravle and Baron Schwartz.
45654565
4566THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED4566THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -4579,6 +4579,6 @@
45794579
4580=head1 VERSION4580=head1 VERSION
45814581
4582pt-slave-delay 2.1.104582pt-slave-delay 2.1.11
45834583
4584=cut4584=cut
45854585
=== modified file 'bin/pt-slave-find'
--- bin/pt-slave-find 2013-07-18 17:31:04 +0000
+++ bin/pt-slave-find 2014-03-04 12:35:02 +0000
@@ -4006,7 +4006,7 @@
40064006
4007=head1 COPYRIGHT, LICENSE, AND WARRANTY4007=head1 COPYRIGHT, LICENSE, AND WARRANTY
40084008
4009This program is copyright 2011-2013 Percona Ireland Ltd,4009This program is copyright 2011-2014 Percona Ireland Ltd,
40102007-2011 Baron Schwartz.40102007-2011 Baron Schwartz.
40114011
4012THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED4012THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -4025,6 +4025,6 @@
40254025
4026=head1 VERSION4026=head1 VERSION
40274027
4028pt-slave-find 2.1.104028pt-slave-find 2.1.11
40294029
4030=cut4030=cut
40314031
=== modified file 'bin/pt-slave-restart'
--- bin/pt-slave-restart 2014-03-03 22:02:30 +0000
+++ bin/pt-slave-restart 2014-03-04 12:35:02 +0000
@@ -5479,7 +5479,7 @@
54795479
5480=head1 COPYRIGHT, LICENSE, AND WARRANTY5480=head1 COPYRIGHT, LICENSE, AND WARRANTY
54815481
5482This program is copyright 2011-2013 Percona Ireland Ltd,5482This program is copyright 2011-2014 Percona Ireland Ltd,
54832007-2011 Baron Schwartz.54832007-2011 Baron Schwartz.
54845484
5485THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED5485THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -5498,6 +5498,6 @@
54985498
5499=head1 VERSION5499=head1 VERSION
55005500
5501pt-slave-restart 2.1.105501pt-slave-restart 2.1.11
55025502
5503=cut5503=cut
55045504
=== modified file 'bin/pt-stalk'
--- bin/pt-stalk 2013-07-18 17:31:04 +0000
+++ bin/pt-stalk 2014-03-04 12:35:02 +0000
@@ -2004,7 +2004,7 @@
20042004
2005=head1 COPYRIGHT, LICENSE, AND WARRANTY2005=head1 COPYRIGHT, LICENSE, AND WARRANTY
20062006
2007This program is copyright 2011-2013 Percona Ireland Ltd,2007This program is copyright 2011-2014 Percona Ireland Ltd,
20082010-2011 Baron Schwartz.20082010-2011 Baron Schwartz.
20092009
2010THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2010THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -2023,7 +2023,7 @@
20232023
2024=head1 VERSION2024=head1 VERSION
20252025
2026pt-stalk 2.1.102026pt-stalk 2.1.11
20272027
2028=cut2028=cut
20292029
20302030
=== modified file 'bin/pt-summary'
--- bin/pt-summary 2013-07-18 17:31:04 +0000
+++ bin/pt-summary 2014-03-04 12:35:02 +0000
@@ -2663,7 +2663,7 @@
26632663
2664=head1 COPYRIGHT, LICENSE, AND WARRANTY2664=head1 COPYRIGHT, LICENSE, AND WARRANTY
26652665
2666This program is copyright 2011-2013 Percona Ireland Ltd,2666This program is copyright 2011-2014 Percona Ireland Ltd,
26672010-2011 Baron Schwartz.26672010-2011 Baron Schwartz.
26682668
2669THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2669THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -2682,7 +2682,7 @@
26822682
2683=head1 VERSION2683=head1 VERSION
26842684
2685pt-summary 2.1.102685pt-summary 2.1.11
26862686
2687=cut2687=cut
26882688
26892689
=== modified file 'bin/pt-table-checksum'
--- bin/pt-table-checksum 2014-03-03 22:02:30 +0000
+++ bin/pt-table-checksum 2014-03-04 12:35:02 +0000
@@ -11923,7 +11923,7 @@
1192311923
11924=head1 COPYRIGHT, LICENSE, AND WARRANTY11924=head1 COPYRIGHT, LICENSE, AND WARRANTY
1192511925
11926This program is copyright 2011-2013 Percona Ireland Ltd,11926This program is copyright 2011-2014 Percona Ireland Ltd,
119272007-2011 Baron Schwartz.119272007-2011 Baron Schwartz.
1192811928
11929THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED11929THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -11942,6 +11942,6 @@
1194211942
11943=head1 VERSION11943=head1 VERSION
1194411944
11945pt-table-checksum 2.1.1011945pt-table-checksum 2.1.11
1194611946
11947=cut11947=cut
1194811948
=== modified file 'bin/pt-table-sync'
--- bin/pt-table-sync 2014-03-03 22:02:30 +0000
+++ bin/pt-table-sync 2014-03-04 12:35:02 +0000
@@ -12613,7 +12613,7 @@
1261312613
12614=head1 COPYRIGHT, LICENSE, AND WARRANTY12614=head1 COPYRIGHT, LICENSE, AND WARRANTY
1261512615
12616This program is copyright 2011-2013 Percona Ireland Ltd,12616This program is copyright 2011-2014 Percona Ireland Ltd,
126172007-2011 Baron Schwartz.126172007-2011 Baron Schwartz.
1261812618
12619THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED12619THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -12632,6 +12632,6 @@
1263212632
12633=head1 VERSION12633=head1 VERSION
1263412634
12635pt-table-sync 2.1.1012635pt-table-sync 2.1.11
1263612636
12637=cut12637=cut
1263812638
=== modified file 'bin/pt-table-usage'
--- bin/pt-table-usage 2013-07-18 17:31:04 +0000
+++ bin/pt-table-usage 2014-03-04 12:35:02 +0000
@@ -7365,7 +7365,7 @@
73657365
7366=head1 COPYRIGHT, LICENSE, AND WARRANTY7366=head1 COPYRIGHT, LICENSE, AND WARRANTY
73677367
7368This program is copyright 2012-2013 Percona Ireland Ltd.7368This program is copyright 2012-2014 Percona Ireland Ltd.
73697369
7370THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED7370THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
7371WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF7371WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -7383,6 +7383,6 @@
73837383
7384=head1 VERSION7384=head1 VERSION
73857385
7386pt-table-usage 2.1.107386pt-table-usage 2.1.11
73877387
7388=cut7388=cut
73897389
=== modified file 'bin/pt-tcp-model'
--- bin/pt-tcp-model 2013-07-18 17:31:04 +0000
+++ bin/pt-tcp-model 2014-03-04 12:35:02 +0000
@@ -2513,7 +2513,7 @@
25132513
2514=head1 COPYRIGHT, LICENSE, AND WARRANTY2514=head1 COPYRIGHT, LICENSE, AND WARRANTY
25152515
2516This program is copyright 2011-2013 Percona Ireland Ltd,2516This program is copyright 2011-2014 Percona Ireland Ltd,
25172011 Baron Schwartz.25172011 Baron Schwartz.
25182518
2519THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2519THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -2532,6 +2532,6 @@
25322532
2533=head1 VERSION2533=head1 VERSION
25342534
2535pt-tcp-model 2.1.102535pt-tcp-model 2.1.11
25362536
2537=cut2537=cut
25382538
=== modified file 'bin/pt-trend'
--- bin/pt-trend 2013-07-18 17:31:04 +0000
+++ bin/pt-trend 2014-03-04 12:35:02 +0000
@@ -2214,7 +2214,7 @@
22142214
2215=head1 COPYRIGHT, LICENSE, AND WARRANTY2215=head1 COPYRIGHT, LICENSE, AND WARRANTY
22162216
2217This program is copyright 2011-2013 Percona Ireland Ltd,2217This program is copyright 2011-2014 Percona Ireland Ltd,
22182010-2011 Baron Schwartz.22182010-2011 Baron Schwartz.
22192219
2220THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED2220THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -2233,6 +2233,6 @@
22332233
2234=head1 VERSION2234=head1 VERSION
22352235
2236pt-trend 2.1.102236pt-trend 2.1.11
22372237
2238=cut2238=cut
22392239
=== modified file 'bin/pt-upgrade'
--- bin/pt-upgrade 2014-03-03 22:02:30 +0000
+++ bin/pt-upgrade 2014-03-04 12:35:02 +0000
@@ -13132,7 +13132,7 @@
1313213132
13133=head1 COPYRIGHT, LICENSE, AND WARRANTY13133=head1 COPYRIGHT, LICENSE, AND WARRANTY
1313413134
13135This program is copyright 2009-2013 Percona Ireland Ltd.13135This program is copyright 2009-2014 Percona Ireland Ltd.
1313613136
13137THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED13137THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
13138WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF13138WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -13150,6 +13150,6 @@
1315013150
13151=head1 VERSION13151=head1 VERSION
1315213152
13153pt-upgrade 2.1.1013153pt-upgrade 2.1.11
1315413154
13155=cut13155=cut
1315613156
=== modified file 'bin/pt-variable-advisor'
--- bin/pt-variable-advisor 2014-03-03 22:02:30 +0000
+++ bin/pt-variable-advisor 2014-03-04 12:35:02 +0000
@@ -5830,7 +5830,7 @@
58305830
5831=head1 COPYRIGHT, LICENSE, AND WARRANTY5831=head1 COPYRIGHT, LICENSE, AND WARRANTY
58325832
5833This program is copyright 2010-2013 Percona Ireland Ltd.5833This program is copyright 2010-2014 Percona Ireland Ltd.
58345834
5835THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED5835THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
5836WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF5836WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
@@ -5848,6 +5848,6 @@
58485848
5849=head1 VERSION5849=head1 VERSION
58505850
5851pt-variable-advisor 2.1.105851pt-variable-advisor 2.1.11
58525852
5853=cut5853=cut
58545854
=== modified file 'bin/pt-visual-explain'
--- bin/pt-visual-explain 2013-07-18 17:31:04 +0000
+++ bin/pt-visual-explain 2014-03-04 12:35:02 +0000
@@ -3124,7 +3124,7 @@
31243124
3125=head1 COPYRIGHT, LICENSE, AND WARRANTY3125=head1 COPYRIGHT, LICENSE, AND WARRANTY
31263126
3127This program is copyright 2011-2013 Percona Ireland Ltd,3127This program is copyright 2011-2014 Percona Ireland Ltd,
31282007-2011 Baron Schwartz.31282007-2011 Baron Schwartz.
31293129
3130THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED3130THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -3143,6 +3143,6 @@
31433143
3144=head1 VERSION3144=head1 VERSION
31453145
3146pt-visual-explain 2.1.103146pt-visual-explain 2.1.11
31473147
3148=cut3148=cut
31493149
=== modified file 'config/deb/changelog'
--- config/deb/changelog 2013-07-18 17:31:04 +0000
+++ config/deb/changelog 2014-03-04 12:35:02 +0000
@@ -1,3 +1,10 @@
1percona-toolkit (2.1.11) unstable; urgency=low
2
3 * Fixed bug 1279502: --version-check behaves like spyware
4 * Fixed bug 1199589: pt-archiver deletes data despite --dry-run
5
6 -- Percona Toolkit Developers <toolkit-dev@percona.com> Tue, 04 Mar 2014 09:20:40 +0000
7
1percona-toolkit (2.1.10) unstable; urgency=low8percona-toolkit (2.1.10) unstable; urgency=low
29
3 * Fixed bug 947893: Some tools use @@hostname without /*!50038*/10 * Fixed bug 947893: Some tools use @@hostname without /*!50038*/
411
=== modified file 'config/sphinx-build/conf.py'
--- config/sphinx-build/conf.py 2013-07-18 14:49:55 +0000
+++ config/sphinx-build/conf.py 2014-03-04 12:35:02 +0000
@@ -50,7 +50,7 @@
50# The short X.Y version.50# The short X.Y version.
51version = '2.1'51version = '2.1'
52# The full version, including alpha/beta/rc tags.52# The full version, including alpha/beta/rc tags.
53release = '2.1.10'53release = '2.1.11'
5454
55# The language for content autogenerated by Sphinx. Refer to documentation55# The language for content autogenerated by Sphinx. Refer to documentation
56# for a list of supported languages.56# for a list of supported languages.
5757
=== modified file 'docs/percona-toolkit.pod'
--- docs/percona-toolkit.pod 2013-07-18 14:49:55 +0000
+++ docs/percona-toolkit.pod 2014-03-04 12:35:02 +0000
@@ -511,7 +511,7 @@
511511
512=head1 COPYRIGHT, LICENSE, AND WARRANTY512=head1 COPYRIGHT, LICENSE, AND WARRANTY
513513
514Percona Toolkit is copyright 2011-2013 Percona Ireland Ltd and others.514Percona Toolkit is copyright 2011-2014 Percona Ireland Ltd and others.
515See each program's documentation for complete copyright notices.515See each program's documentation for complete copyright notices.
516516
517THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED517THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
@@ -530,6 +530,6 @@
530530
531=head1 VERSION531=head1 VERSION
532532
533Percona Toolkit v2.1.10 released 2013-07-18533Percona Toolkit v2.1.11 released 2014-03-04
534534
535=cut535=cut
536536
=== modified file 'docs/release_notes.rst'
--- docs/release_notes.rst 2013-07-18 17:31:04 +0000
+++ docs/release_notes.rst 2014-03-04 12:35:02 +0000
@@ -1,11 +1,1610 @@
1Release Notes1Release Notes
2*************2*************
33
4v2.1.10 released 2013-07-184v2.1.11 released 2014-03-04
5===========================5===========================
66
7Release Notes7Percona Toolkit 2.1.11 has been released. This release includes two bug fixes.
8*************8
9* Fixed bug #1199589: pt-archiver deletes data despite --dry-run
10
11In some cases pt-archiver would delete the data despite the --dry-run option.
12
13* Fixed bug #1279502: --version-check behaves like spyware
14
15The configuration for what information Percona Toolkit should retrieve is not hardcoded in the scripts. Instead, it is downloaded from v.percona.com. One of the possible parameters was the name of a binary file to execute with “–version.” This was fixed by removing the ability to execute arbitrary binary files with the version parameter.
16
17Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/.
18
19Changelog
20---------
21
22* Fixed bug #1199589: pt-archiver deletes data despite --dry-run
23* Fixed bug #1279502: --version-check behaves like spyware
24
25v2.1.10 released 2013-07-18
26===========================
27
28Percona Toolkit 2.1.10 has been released. This release includes eight bug fixes.
29
30* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
31
32Unfortunately, the relatively new --utc option for pt-heart was still
33broken because "[MySQL] interprets date as a value in the current time zone
34and converts it to an internal value in UTC." Now the tool works correctly
35with --utc by specifying "SET time_zone='+0:00'", and older versions of
36the tool can be made to work by specifying --set-vars "time_zone='+0:00'".
37
38* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
39
40Improved the pattern matching that caused the pt-deadlock-logger error when
41different timestamp format was used.
42
43* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
44
45pt-table-checksum was using the first non-unique index instead of the one
46with the highest cardinality due to a sorting bug.
47
48Percona Toolkit packages can be downloaded from
49http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
50Repositories (http://www.percona.com/software/repositories/).
51
52Changelog
53---------
54
55* Fixed bug #1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
56* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
57* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
58* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
59* Fixed bug #947893: Some tools use @@hostname without /*!50038*/
60* Fixed bug #1137556: pt-heartbeat docs don't account for --utc
61* Fixed bug #1146324: pt-query-digest 2.1 typo in docs
62* Fixed bug #1171968: pt-query-digest docs don't mention --type=rawlog
63
64v2.1.9 released 2013-02-14
65==========================
66
67Percona Toolkit 2.1.9 has been released. This release primarily aims to
68restore backwards-compatibility with pt-heartbeat 2.1.7 and older, but it
69also has important bug fixes for other tools.
70
71* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
72* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
73
74The previous release switched the time authority from Perl to MySQL, and from
75local time to UTC. Unfortunately, these changes caused a loss of precision and,
76if mixing versions of pt-heartbeat, made the tool report a huge amount of
77replication lag. This release makes the tool compatible with pt-heartbeat
782.1.7 and older again, but the UTC behavior introduced in 2.1.8 is now only
79available by specifying the new --utc option.
80
81* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
82
83This is an important bug fix for pt-table-sync: certain chunks from
84pt-table-checksum resulted in an impossible WHERE, causing the false-positive
85"Cannot nibble" error, if those chunks had diffs.
86
87* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
88
89MariaDB 5.5.28 (https://kb.askmonty.org/en/mariadb-5528-changelog/) fixed
90a bug: "Added warnings for duplicate key errors when using INSERT IGNORE".
91However, standard MySQL does not warn in this case, despite the docs saying
92that it should. Since pt-online-schema-change has always intended to ignore
93duplicate entry errors by using "INSERT IGNORE", it now handles the MariaDB
94case by also ignoring duplicate entry errors in the code.
95
96* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
97
98pt-online-schema-change 2.1.9 handles another case of changing the primary key.
99However, since changing the primary key is tricky, the tool stops if --alter
100contains "DROP PRIMARY KEY", and you have to specify --no-check-alter to
101acknowledge this case.
102
103* Fixed bug 1099933: pt-stalk is too verbose, fills up log
104
105Previously, pt-stalk printed a line for every check. Since the tool is
106designed to be a long-running daemon, this could result in huge log files
107with "matched=no" lines. The tool has a new --verbose option which makes it
108quieter by default.
109
110All users should upgrade, but in particular, users of versions 2.1.7 and
111older are strongly recommended to skip 2.1.8 and go directly to 2.1.9.
112
113Users of pt-heartbeat in 2.1.8 who prefer the UTC behavior should keep in
114mind that they will have to use the --utc option after upgrading.
115
116Percona Toolkit packages can be downloaded from
117http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
118Repositories (http://www.percona.com/software/repositories/).
119
120Changelog
121---------
122
123* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
124* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
125* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
126* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
127* Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function
128* Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump
129* Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors
130* Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
131* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
132* Fixed bug 1099933: pt-stalk is too verbose, fills up log
133
134v2.1.8 released 2012-12-21
135==========================
136
137Percona Toolkit 2.1.8 has been released. This release includes 28 bug fixes, beta support for MySQL 5.6, and extensive support for Percona XtraDB Cluster (PXC). Users intending on running the tools on Percona XtraDB Cluster or MySQL 5.6 should upgrade. The following tools have been verified to work on PXC versions 5.5.28 and newer:
138
139* pt-table-chcecksum
140* pt-online-schema-change
141* pt-archive
142* pt-mysql-summary
143* pt-heartbeat
144* pt-variable-advisor
145* pt-config-diff
146* pt-deadlock-logger
147
148However, there are limitations when running these tools on PXC; see the Percona XtraDB Cluster section in each tool's documentation for further details. All other tools, with the exception of pt-slave-find, pt-slave-delay and pt-slave-restart, should also work correctly, but in some cases they have not been modified to take advantage of PXC features, so they may behave differently in future releases.
149
150The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
151
152* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
153
154Slow logs which include timestamps but no query--which can happen if using slow_query_log_timestamp_always in Percona Server--were misparsed, resulting in an erroneous report. Now such no-query events show up in reports as ``/* No query */``.
155
156* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
157
158The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.
159
160* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
161
162Some renamed variables had caused the Percona Server section to work unreliably.
163
164* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
165
166When using --replicate-check-only, filter options like --databases and --tables were not applied.
167
168* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
169
170Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very high lag) with slaves running in different time zones. Now pt-heartbeat uses UTC regardless of the server or MySQL time zone.
171
172* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
173
174Since MyISAM tables can't have foreign keys, and the tool uses the information_schema to find child tables, this could cause unnecessary load on the server.
175
1762.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.
177
178Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
179
180Changelog
181---------
182
183* Beta support for MySQL 5.6
184* Beta support for Percona XtraDB Cluster
185* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
186* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
187* pt-upgrade: Added --[no]disable-query-cache
188* Fixed bug 927955: Bad pod2rst transformation
189* Fixed bug 898665: Bad online docs formatting for --[no]vars
190* Fixed bug 1022622: pt-config-diff is case-sensitive
191* Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments
192* Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
193* Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes
194* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
195* Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong
196* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
197* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
198* Fixed bug 823431: pt-query-advisor hangs on big queries
199* Fixed bug 996069: pt-query-advisor RES.001 is incorrect
200* Fixed bug 933465: pt-query-advisor false positive on RES.001
201* Fixed bug 937234: pt-query-advisor issues wrong RES.001
202* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
203* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
204* Fixed bug 957442: pt-query-digest with custom --group-by throws error
205* Fixed bug 887638: pt-query-digest prints negative byte offset
206* Fixed bug 831525: pt-query-digest help output mangled
207* Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error
208* Fixed bug 1046440: pt-stalk purge_samples slows down checks
209* Fixed bug 986847: pt-stalk does not report NFS iostat
210* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
211* Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used
212* Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef
213* Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950
214* Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611
215* Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
216
217v2.1.7 released 2012-11-19
218==========================
219
220Percona Toolkit 2.1.7 has been released which is a hotfix for two bugs when using pt-table-checksum with Percona XtraDB Cluster:
221
222* Bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
223* Bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
224
225If you're using pt-table-checksum with a Percona XtraDB Cluster, you should upgrade. Otherwise, users can wait until the next full release.
226
227Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
228
229Changelog
230---------
231
232* Fixed bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
233* Fixed bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
234
235v2.1.6 released 2012-11-13
236==========================
237
238Percona Toolkit 2.1.6 has been released. This release includes 33 bug fixes and three new features: pt-online-schema-change now handles renaming columns without losing data, removing one of the tool's limitations. pt-online-schema-change also got two new options: --default-engine and --statistics. Finally, pt-stalk now has a plugin hook interface, available through the --plugin option. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
239
240* Bug 978133: pt-query-digest review table privilege checks don't work
241
242The same checks were removed from pt-table-checksum on 2.1.3 and pt-table-sync on 2.1.4, so this just follows suit.
243
244* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
245
246A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
247
248* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
249
250If you run multiple instances of pt-table-checksum on a badly lagged server, actually respecting --run-time stops the instances from divebombing the server when the replica catches up.
251
252* Bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
253
254Fixed by choosing a key on the new table for the DELETE trigger.
255
256* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
257
258A follow up to the same fix in the previous release, this adds to warnings for cases in which pt-table-checksum may work incorrectly and require some user intervention: One for the case of master -> cluster, and one for cluster1 -> cluster2.
259
260* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
261
262This bug has hounded the toolkit for quite some time. In some platforms, trying to use LOAD DATA LOCAL INFILE would fail as if the user didn't have enough privileges to perform the operation. This was a misdiagnoses from MySQL; The actual problem was that the libmysqlclient.so provided by some vendors was compiled in a way that disallowed users from using the statement without some extra work. This fix adds an 'L' option to the DSNs the toolkit uses, tells the the tools to explicitly enables LOAD DATA LOCAL INFILE. This affected two pt-archiver and pt-upgrade, so if you are on an effected OS and need to use those, you can simply tag an L=1 to your DSN and everything should start working.
263
264* Bug 866075: pt-show-grant doesn't support column-level grants
265
266This was actually the 'hottest' bug in the tracker.
267
268This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
269
270Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
271
272Changelog
273---------
274
275* pt-online-schema-change: Columns can now be renamed without data loss
276* pt-online-schema-change: New --default-engine option
277* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
278* Fixed bug 1069951: --version-check default should be explicitly "off"
279* Fixed bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
280* Fixed bug 995896: Useless use of cat in Daemon.pm
281* Fixed bug 1039074: Tools exit 0 on error parsing options, should exit non-zero
282* Fixed bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
283* Fixed bug 1009510: pt-table-checksum breaks replication if a slave table is missing or different
284* Fixed bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
285* Fixed bug 1073532: pt-table-checksum error: Use of uninitialized value in int at line 2778
286* Fixed bug 1016131: pt-table-checksum can crash with --columns if none match
287* Fixed bug 1039569: pt-table-checksum dies if creating the --replicate table fails
288* Fixed bug 1059732: pt-table-checksum doesn't test all hash functions
289* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
290* Fixed bug 1043528: pt-deadlock-logger can't parse db/tbl/index on partitioned tables
291* Fixed bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
292* Fixed bug 1058285: pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
293* Fixed bug 1073996: pt-online-schema-change fails with "I need a max_rows argument"
294* Fixed bug 1039541: pt-online-schema-change --quiet doesn't disable --progress
295* Fixed bug 1045317: pt-online-schema-change doesn't report how many warnings it suppressed
296* Fixed bug 1060774: pt-upgrade fails if select column > 64 chars
297* Fixed bug 1070916: pt-mysql-summary may report the wrong cnf file
298* Fixed bug 903229: pt-mysql-summary incorrectly categorizes databases
299* Fixed bug 866075: pt-show-grant doesn't support column-level grants
300* Fixed bug 978133: pt-query-digest review table privilege checks don't work
301* Fixed bug 956981: pt-query-digest docs for event attributes link to defunct Maatkit wiki
302* Fixed bug 1047335: pt-duplicate-key-checker fails when it encounters a crashed table
303* Fixed bug 1047701: pt-stalk deletes non-empty files
304* Fixed bug 1070434: pt-stalk --no-stalk and --iterations 1 don't wait for the collect
305* Fixed bug 1052722: pt-fifo-split is processing n-1 rows initially
306* Fixed bug 1013407: pt-find documentation error with mtime and InnoDB
307* Fixed bug 1059757: pt-trend output has no header
308* Fixed bug 1063933: pt-visual-explain docs link to missing pdf
309* Fixed bug 1075773: pt-fk-error-logger crashes if there's no foreign key error
310* Fixed bug 1075775: pt-fk-error-logger --dest table example doesn't work
311
312v2.1.5 released 2012-10-08
313==========================
314
315Percona Toolkit 2.1.5 has been released. This release is less than two weeks after the release of 2.1.4 because we wanted to address these bugs quickly:
316
317* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
318
319* Bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
320
321* Bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
322
323The first two bugs fix how pt-table-checksum works with Percona XtraDB Cluster (PXC). Although the 2.1.4 release did introduce support for PXC, these bugs prevented pt-table-checksum from working correctly with a cluster.
324
325The third bug is also related to a feature new in 2.1.4: --version-check. The feature uses HTTPS/SSL by default, but some modules in pt-table-sync weren't update which could prevent it from working on older systems. Related, the version check web page mentioned in tools' documentation was also created.
326
327If you're using pt-table-checksum with a Percona XtraDB Cluster, you should definitely upgrade. Otherwise, users can wait until 2.1.6 for another full release.
328
329Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
330
331Changelog
332---------
333
334* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
335* Fixed bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
336* Fixed bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
337* Fixed bug 1060423: Missing version-check page
338
339v2.1.4 released 2012-09-20
340==========================
341
342Percona Toolkit 2.1.4 has been released. This release includes 26 bug fixes and three new features: Making pt-table-checksum work with Percona XtraDB Cluster, adding a --run-time option to pt-table-checksum, and implementing the "Version Check" feature, enabled through the --version-check switch. For further information on --version-check, see http://www.mysqlperformanceblog.com/2012/09/10/introducing-the-version-check-feature-in-percona-toolkit/. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
343
344* Fixed bug 1017626: pt-table-checksum doesn't work with Percona XtraDB Cluster
345
346Note that this requires Percona XtraDB Cluster 5.5.27-23.6 or newer, as the fix depends on this bug https://bugs.launchpad.net/codership-mysql/+bug/1023911 being resolved.
347
348* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
349
350Previously, users had no recourse but using --recursion-method in conjunction with a dsn table to sidestep this bug, so this fix is a huge usability gain. This was caused by the toolkit not copying the -F portion of the main dsn.
351
352* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
353
354Which were stopping pt-upgrade from working on a MySQL 4.1 host.
355
356* Fixed bug 1036747: pt-table-sync priv checks need to be removed
357
358The same checks were removed in the previous release from pt-table-checksum, so this continues the trend.
359
360* Fixed bug 1038995: pt-stalk --notify-by-email fails
361
362This was a bug in our shell option parsing library, and would potentially affect any option starting with 'no'.
363
364Like 2.1.3, this is another solid bug fix release, and 2.1 users are encouraged to upgrade.
365
366Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
367
368Changelog
369---------
370
371* pt-table-checksum: Percona XtraDB Cluster support
372* pt-table-checksum: Implemented the standard --run-time option
373* Implemented the version-check feature in several tools, enabled with the --version-check option
374* Fixed bug 856060: Document gdb dependency
375* Fixed bug 1041394: Unquoted arguments to tr break the bash tools
376* Fixed bug 1035311: pt-diskstats shows wrong device names
377* Fixed bug 1036804: pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
378* Fixed bug 1022658: pt-online-schema-change dropping FK limitation isn't documented
379* Fixed bug 1041372: pt-online-schema-changes fails if db+tbl name exceeds 64 characters
380* Fixed bug 1029178: pt-query-digest --type tcpdump memory usage keeps increasing
381* Fixed bug 1037211: pt-query-digest won't distill LOCK TABLES in lowercase
382* Fixed bug 942114: pt-stalk warns about bad "find" usage
383* Fixed bug 1035319: pt-stalk df -h throws away needed details
384* Fixed bug 1038995: pt-stalk --notify-by-email fails
385* Fixed bug 1038995: pt-stalk does not get all InnoDB lock data
386* Fixed bug 952722: pt-summary should show information about Fusion-io cards
387* Fixed bug 899415: pt-table-checksum doesn't work if slaves use RBR
388* Fixed bug 954588: pt-table-checksum --check-slave-lag docs aren't clear
389* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
390* Fixed bug 930693: pt-table-sync and text columns with just whitespace
391* Fixed bug 1028710: pt-table-sync base_count fails on n = 1000, base = 10
392* Fixed bug 1034717: pt-table-sync division by zero error with varchar primary key
393* Fixed bug 1036747: pt-table-sync priv checks need to be removed
394* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
395* Fixed bug 1035260: sh warnings in pt-summary and pt-mysql-summary
396* Fixed bug 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values
397* Fixed bug 916925: CentOS 5 yum dependency resolution for perl module is wrong
398* Fixed bug 1035950: Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
399
400v2.1.3 released 2012-08-03
401==========================
402
403Percona Toolkit 2.1.3 has been released. This release includes 31 bug fixes and one new feature: pt-kill --log-dsn to log information about killed queries to a table. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
404
405* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
406
407pt-table-checksum used to check the user's privileges, but the method was not always reliable, and due to http://bugs.mysql.com/bug.php?id=61846 it became quite unreliable on MySQL 5.5. So the privs check was removed altogether, meaning that the tool may fail later if the user's privileges are insufficient.
408
409* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
410
411In certain cases where the master and replicas have different schemas and/or tables, pt-table-checksum could break replication because the checksums table did not exist on a replica.
412
413* Fixed bug 821703: pt-query-digest --processlist may crash
414* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
415
416Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.
417
418* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
419
420pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.
421
422* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
423
424The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.
425
426* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
427
428This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.
429
430All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.
431
432Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
433
434Changelog
435---------
436
437* pt-kill: Implemented --log-dsn to log info about killed queries to a table
438* Fixed bug 1016127: Install hint for DBD::mysql is wrong
439* Fixed bug 984915: DSNParser does not check success of --set-vars
440* Fixed bug 889739: pt-config-diff doesn't diff quoted strings properly
441* Fixed bug 969669: pt-duplicate-key-checker --key-types=k doesn't work
442* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
443* Fixed bug 1028614: pt-index-usage ignores --database
444* Fixed bug 940733: pt-ioprofile leaves behind temp directory
445* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
446* Fixed bug 1016114: pt-online-schema-change docs don't mention default values
447* Fixed bug 1020997: pt-online-schema-change fails when table is empty
448* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
449* Fixed bug 937225: pt-query-advisor OUTER JOIN advice in JOI.003 is confusing
450* Fixed bug 821703: pt-query-digest --processlist may crash
451* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
452* Fixed bug 924950: pt-query-digest --group-by db may crash profile report
453* Fixed bug 1022851: pt-sift error: PREFIX: unbound variable
454* Fixed bug 969703: pt-sift defaults to '.' instead of '/var/lib/pt-talk'
455* Fixed bug 962330: pt-slave-delay incorrectly computes lag if started when slave is already lagging
456* Fixed bug 954990: pt-stalk --nostalk does not work
457* Fixed bug 977226: pt-summary doesn't detect LSI RAID control
458* Fixed bug 1030031: pt-table-checksum reports wrong number of DIFFS
459* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
460* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
461* Fixed bug 953141: pt-table-checksum ignores its default and explicit --recursion-method
462* Fixed bug 1030975: pt-table-sync crashes if sql_mode includes ANSI_QUOTES
463* Fixed bug 869005: pt-table-sync should always set REPEATABLE READ
464* Fixed bug 903510: pt-tcp-model crashes in --type=requests mode on empty file
465* Fixed bug 934310: pt-tcp-model --quantile docs wrong
466* Fixed bug 980318: pt-upgrade results truncated if hostnames are long
467* Fixed bug 821696: pt-variable-advisor shows too long of a snippet
468* Fixed bug 844880: pt-variable-advisor shows binary logging as both enabled and disabled
469
470v2.1.2 released 2012-06-12
471==========================
472
473Percona Toolkit 2.1.2 has been released. This is a very important release because it fixes a critical bug in pt-table-sync (bug 1003014) which caused various failures. All users of Percona Toolkit 2.1 should upgrade to this release. There were 47 other bug fixes, several new options, and other changes. The following is a high-level summary of the most important changes.
474
475In addition to the critical bug fix mentioned above, another important pt-table-sync bug was fixed, bug 1002365: --ignore-* options did not work with --replicate. The --lock-and-rename feature of the tool was also disabled unless running MySQL 5.5 or newer because it did not work reliably in earlier versions of MySQL.
476
477Several important pt-table-checksum bugs were fixed. First, a bug caused the tool to ignore the primary key. Second, the tool did not wait for the checksum table to replicate, so it could select from a nonexistent table on a replica and crash. Third, it did not check if all checksum queries were safe and chunk index with more than 3 columns could cause MySQL to scan many more rows than expected.
478
479pt-online-schema-change received many improvements and fixes: it did not retry deadlocks, but now it does; --no-swap-tables caused an error; it did not handle column renames; it did not allow disabling foreign key checks; --dry-run always failed on tables with foreign keys; it used different keys for chunking and triggers; etc. In short: pt-online-schema-change 2.1.2 is superior to 2.1.1.
480
481Two pt-archiver bugs were fixed: bug 979092, --sleep conflicts with bulk operations; and bug 903379, --file doesn't create a file.
482
483--recursion-method=none was implemented in pt-heartbeat, pt-online-schema-change, pt-slave-find, pt-slave-restart, pt-table-checksum, and pt-table-sync. This allows these tools to avoid executing SHOW SLAVE STATUS which requires a privilege not available to Amazon RDS users.
484
485Other bugs were fixed in pt-stalk, pt-variable-advisor, pt-duplicate-key-checker, pt-diskstats, pt-query-digest, pt-sift, pt-kill, pt-summary, and pt-deadlock-logger.
486
487Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly encouraged to upgrade.
488
489Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
490
491Changelog
492---------
493
494* pt-heartbeat: Implemented --recursion-method=none
495* pt-index-usage: MySQL 5.5 compatibility fixes
496* pt-log-player: MySQL 5.5 compatibility fixes
497* pt-online-schema-change: Added --chunk-index-columns
498* pt-online-schema-change: Added --[no]check-plan
499* pt-online-schema-change: Added --[no]drop-new-table
500* pt-online-schema-change: Implemented --recursion-method=none
501* pt-query-advisor: Added --report-type for JSON output
502* pt-query-digest: Removed --[no]zero-bool
503* pt-slave-delay: Added --database
504* pt-slave-find: Implemented --recursion-method=none
505* pt-slave-restart: Implemented --recursion-method=none
506* pt-table-checksum: Added --chunk-index-columns
507* pt-table-checksum: Added --[no]check-plan
508* pt-table-checksum: Implemented --recursion-method=none
509* pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer
510* pt-table-sync: Implemented --recursion-method=none
511* Fixed bug 945079: Shell tools TMPDIR may break
512* Fixed bug 912902: Some shell tools still use basename
513* Fixed bug 987694: There is no --recursion-method=none option
514* Fixed bug 886077: Passwords with commas don't work, expose part of password
515* Fixed bug 856024: Lintian warnings when building percona-toolkit Debian package
516* Fixed bug 903379: pt-archiver --file doesn't create a file
517* Fixed bug 979092: pt-archiver --sleep conflicts with bulk operations
518* Fixed bug 903443: pt-deadlock-logger crashes on MySQL 5.5
519* Fixed bug 941064: pt-deadlock-logger can't clear deadlocks on 5.5
520* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
521* Fixed bug 994176: pt-diskstats --group-by=all --headers=scroll prints a header for every sample
522* Fixed bug 894140: pt-duplicate-key-checker sometimes recreates a key it shouldn't
523* Fixed bug 923896: pt-kill: uninitialized value causes script to exit
524* Fixed bug 1003003: pt-online-schema-change uses different keys for chunking and triggers
525* Fixed bug 1003315: pt-online-schema-change --dry-run always fails on table with foreign keys
526* Fixed bug 1004551: pt-online-schema-change --no-swap-tables causes error
527* Fixed bug 976108: pt-online-schema-change doesn't allow to disable foreign key checks
528* Fixed bug 976109: pt-online-schema-change doesn't handle column renames
529* Fixed bug 988036: pt-online-schema-change causes deadlocks under heavy write load
530* Fixed bug 989227: pt-online-schema-change crashes with PTDEBUG
531* Fixed bug 994002: pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY
532* Fixed bug 994010: pt-online-schema-change 2.1.1 crashes without InnoDB
533* Fixed bug 996915: pt-online-schema-change crashes with invalid --max-load and --critical-load
534* Fixed bug 998831: pt-online-schema-change -- Should have an option to NOT drop tables on failure
535* Fixed bug 1002448: pt-online-schema-change: typo for finding usable indexes
536* Fixed bug 885382: pt-query-digest --embedded-attributes doesn't check cardinality
537* Fixed bug 888114: pt-query-digest report crashes with infinite loop
538* Fixed bug 949630: pt-query-digest mentions a Subversion repository
539* Fixed bug 844034: pt-show-grants --separate fails with proxy user
540* Fixed bug 946707: pt-sift loses STDIN after pt-diskstats
541* Fixed bug 994947: pt-stalk doesn't reset cycles_true after collection
542* Fixed bug 986151: pt-stalk-has mktemp error
543* Fixed bug 993436: pt-summary Memory: Total reports M instead of G
544* Fixed bug 1008778: pt-table-checksum doesn't wait for checksum table to replicate
545* Fixed bug 1010232: pt-table-checksum doesn't check the size of checksum chunks
546* Fixed bug 1011738: pt-table-checksum SKIPPED is zero but chunks were skipped
547* Fixed bug 919499: pt-table-checksum fails with binary log error in mysql >= 5.5.18
548* Fixed bug 972399: pt-table-checksum docs are not rendered right
549* Fixed bug 978432: pt-table-checksum ignoring primary key
550* Fixed bug 995274: pt-table-checksum can't use an undefined value as an ARRAY reference at line 2206
551* Fixed bug 996110: pt-table-checksum crashes if InnoDB is disabled
552* Fixed bug 987393: pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
553* Fixed bug 1002365: pt-table-sync --ignore-* options don't work with --replicate
554* Fixed bug 1003014: pt-table-sync --replicate and --sync-to-master error "index does not exist"
555* Fixed bug 823403: pt-table-sync --lock-and-rename doesn't work on 5.1
556* Fixed bug 898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values
557
558v2.1.1 released 2012-04-03
559==========================
560
561Percona Toolkit 2.1.1 has been released. This is the first release in the
562new 2.1 series which supersedes the 2.0 series. We will continue to fix bugs
563in 2.0, but 2.1 is now the focus of development.
564
5652.1 introduces a lot of new code for:
566
567* pt-online-schema-change (completely redesigned)
568* pt-mysql-summary (completely redesigned)
569* pt-summary (completely redesigned)
570* pt-fingerprint (new tool)
571* pt-table-usage (new tool)
572
573There were also several bug fixes.
574
575The redesigned tools are meant to replace their 2.0 counterparts because
576the 2.1 versions have the same or more functionality and they are simpler
577and more reliable. pt-online-schema-change was particularly enhanced to
578be as safe as possible given that the tool is inherently risky.
579
580Percona Toolkit packages can be downloaded from
581http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
582Repositories (http://www.percona.com/software/repositories/).
583
584Changelog
585---------
586
587* Completely redesigned pt-online-schema-change
588* Completely redesigned pt-mysql-summary
589* Completely redesigned pt-summary
590* Added new tool: pt-table-usage
591* Added new tool: pt-fingerprint
592* Fixed bug 955860: pt-stalk doesn't run vmstat, iostat, and mpstat for --run-time
593* Fixed bug 960513: SHOW TABLE STATUS is used needlessly
594* Fixed bug 969726: pt-online-schema-change loses foreign keys
595* Fixed bug 846028: pt-online-schema-change does not show progress until completed
596* Fixed bug 898695: pt-online-schema-change add useless ORDER BY
597* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
598* Fixed bug 963225: pt-query-digest fails to set history columns for disk tmp tables and disk filesort
599* Fixed bug 967451: Char chunking doesn't quote column name
600* Fixed bug 972399: pt-table-checksum docs are not rendered right
601* Fixed bug 896553: Various documentation spelling fixes
602* Fixed bug 949154: pt-variable-advisor advice for relay-log-space-limit
603* Fixed bug 953461: pt-upgrade manual broken 'output' section
604* Fixed bug 949653: pt-table-checksum docs don't mention risks posed by inconsistent schemas
605
606v2.0.4 released 2012-03-07
607==========================
608
609Percona Toolkit 2.0.4 has been released. 23 bugs were fixed in this release,
610and three new features were implemented. First, --filter was added to pt-kill
611which allows for arbitrary --group-by. Second, pt-online-schema-change now
612requires that its new --execute option be given, else the tool will just check
613the tables and exit. This is a safeguard to encourage users to read the
614documentation, particularly when replication is involved. Third, pt-stalk
615also received a new option: --[no]stalk. To collect immediately without
616stalking, specify --no-stalk and the tool will collect once and exit.
617
618This release is completely backwards compatible with previous 2.0 releases.
619Given the number of bug fixes, it's worth upgrading to 2.0.4.
620
621Changelog
622---------
623
624* Added --filter to pt-kill to allow arbitrary --group-by
625* Added --[no]stalk to pt-stalk (bug 932331)
626* Added --execute to pt-online-schema-change (bug 933232)
627* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
628* Fixed bug 928966: pt-pmp still uses insecure /tmp
629* Fixed bug 933232: pt-online-schema-change can break replication
630* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
631* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
632* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
633* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
634* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
635* Fixed bug 928226: pt-diskstats illegal division by zero
636* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
637* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
638* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
639* Fixed bug 932331: pt-stalk cannot collect without stalking
640* Fixed bug 932442: pt-table-checksum error when column name has two spaces
641* Fixed bug 932883: File Debian bug after each release
642* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
643* Fixed bug 944420: --daemonize doesn't always close STDIN
644* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
645* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
646* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
647* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
648* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
649* Fixed bug 940440: Bad grammar in pt-kill docs
650
651v2.0.3 released 2012-02-03
652==========================
653
654Percona Toolkit 2.0.3 has been released. The development team was very
655busy last month making this release significant: two completely
656redesigned and improved tools, pt-diskstats and pt-stalk, and 20 bug fixes.
657
658Both pt-diskstats and pt-stalk were redesigned and rewritten from the ground
659up. This allowed us to greatly improve these tools' functionality and
660increase testing for them. The accuracy and output of pt-diskstats was
661enhanced, and the tool was rewritten in Perl. pt-collect was removed and
662its functionality was put into a new, enhanced pt-stalk. pt-stalk is now
663designed to be a stable, long-running daemon on a variety of common platforms.
664It is worth re-reading the documentation for each of these tools.
665
666The 20 bug fixes cover a wide range of problems. The most important are
667fixes to pt-table-checksum, pt-iostats, and pt-kill. Apart from pt-diskstats,
668pt-stalk, and pt-collect (which was removed), no other tools were changed
669in backwards-incompatible ways, so it is worth reviewing the full changelog
670for this release and upgrading if you use any tools which had bug fixes.
671
672Thank you to the many people who reported bugs and submitted patches.
673
674Download the latest release of Percona Toolkit 2.0 from
675http://www.percona.com/software/percona-toolkit/
676or the Percona Software Repositories
677(http://www.percona.com/docs/wiki/repositories:start).
678
679Changelog
680---------
681
682* Completely redesigned pt-diskstats
683* Completely redesigned pt-stalk
684* Removed pt-collect and put its functionality in pt-stalk
685* Fixed bug 871438: Bash tools are insecure
686* Fixed bug 897758: Failed to prepare TableSyncChunk plugin: Use of uninitialized value $args{"chunk_range"} in lc at pt-table-sync line 3055
687* Fixed bug 919819: pt-kill --execute-command creates zombies
688* Fixed bug 925778: pt-ioprofile doesn't run without a file
689* Fixed bug 925477: pt-ioprofile docs refer to pt-iostats
690* Fixed bug 857091: pt-sift downloads http://percona.com/get/pt-pmp, which does not work
691* Fixed bug 857104: pt-sift tries to invoke mext, should be pt-mext
692* Fixed bug 872699: pt-diskstats: rd_avkb & wr_avkb derived incorrectly
693* Fixed bug 897029: pt-diskstats computes wrong values for md0
694* Fixed bug 882918: pt-stalk spams warning if oprofile isn't installed
695* Fixed bug 884504: pt-stalk doesn't check pt-collect
696* Fixed bug 897483: pt-online-schema-change "uninitialized value" due to update-foreign-keys-method
697* Fixed bug 925007: pt-online-schema-change Use of uninitialized value $tables{"old_table"} in concatenation (.) or string at line 4330
698* Fixed bug 915598: pt-config-diff ignores --ask-pass option
699* Fixed bug 919352: pt-table-checksum changes binlog_format even if already set to statement
700* Fixed bug 921700: pt-table-checksum doesn't add --where to chunk size test on replicas
701* Fixed bug 921802: pt-table-checksum does not recognize --recursion-method=processlist
702* Fixed bug 925855: pt-table-checksum index check is case-sensitive
703* Fixed bug 821709: pt-show-grants --revoke and --separate don't work together
704* Fixed bug 918247: Some tools use VALUE instead of VALUES
705
706v2.0.2 released 2012-01-05
707==========================
708
709Percona Toolkit 2.0.2 fixes one critical bug: pt-table-sync --replicate
710did not work with character values, causing an "Unknown column" error.
711If using Percona Toolkit 2.0.1, you should upgrade to 2.0.2.
712
713Download the latest release of Percona Toolkit 2.0 from
714http://www.percona.com/software/percona-toolkit/
715or the Percona Software Repositories
716(http://www.percona.com/docs/wiki/repositories:start).
717
718Changelog
719---------
720
721* Fixed bug 911996: pt-table-sync --replicate causes "Unknown column" error
722
723v2.0.1 released 2011-12-30
724==========================
725
726The Percona Toolkit development team is proud to announce a new major version:
7272.0. Beginning with Percona Toolkit 2.0, we are overhauling, redesigning, and
728improving the major tools. 2.0 tools are therefore not backwards compatible
729with 1.0 tools, which we still support but will not continue to develop.
730
731New in Percona Toolkit 2.0.1 is a completely redesigned pt-table-checksum.
732The original pt-table-checksum 1.0 was rather complex, but it worked well
733for many years. By contrast, the new pt-table-checksum 2.0 is much simpler but
734also much more efficient and reliable. We spent months rethinking, redesigning,
735and testing every aspect of the tool. The three most significant changes:
736pt-table-checksum 2.0 does only --replicate, it has only one chunking algorithm,
737and its memory usage is stable even with hundreds of thousands of tables and
738trillions of rows. The tool is now dedicated to verifying MySQL replication
739integrity, nothing else, which it does extremely well.
740
741In Percona Toolkit 2.0.1 we also fixed various small bugs and forked ioprofile
742and align (as pt-ioprofile and pt-align) from Aspersa.
743
744If you still need functionalities in the original pt-table-checksum,
745the latest Percona Toolkit 1.0 release remains available for download.
746Otherwise, all new development in Percona Toolkit will happen in 2.0.
747
748Download the latest release of Percona Toolkit 2.0 from
749http://www.percona.com/software/percona-toolkit/
750or the Percona Software Repositories
751(http://www.percona.com/docs/wiki/repositories:start).
752
753Changelog
754---------
755
756* Completely redesigned pt-table-checksum
757* Fixed bug 856065: pt-trend does not work
758* Fixed bug 887688: Prepared statements crash pt-query-digest
759* Fixed bug 888286: align not part of percona-toolkit
760* Fixed bug 897961: ptc 2.0 replicate-check error does not include hostname
761* Fixed bug 898318: ptc 2.0 --resume with --tables does not always work
762* Fixed bug 903513: MKDEBUG should be PTDEBUG
763* Fixed bug 908256: Percona Toolkit should include pt-ioprofile
764* Fixed bug 821717: pt-tcp-model --type=requests crashes
765* Fixed bug 844038: pt-online-schema-change documentation example w/drop-tmp-table does not work
766* Fixed bug 864205: Remove the query to reset @crc from pt-table-checksum
767* Fixed bug 898663: Typo in pt-log-player documentation
768
769v1.0.1 released 2011-09-01
770==========================
771
772Percona Toolkit 1.0.1 has been released. In July, Baron announced planned
773changes to Maatkit and Aspersa development;[1] Percona Toolkit is the
774result. In brief, Percona Toolkit is the combined fork of Maatkit and
775Aspersa, so although the toolkit is new, the programs are not. That means
776Percona Toolkit 1.0.1 is mature, stable, and production-ready. In fact,
777it's even a little more stable because we fixed a few bugs in this release.
778
779Percona Toolkit packages can be downloaded from
780http://www.percona.com/downloads/percona-toolkit/
781or the Percona Software Repositories
782(http://www.percona.com/docs/wiki/repositories:start).
783
784Although Maatkit and Aspersa development use Google Code, Percona Toolkit
785uses Launchpad: https://launchpad.net/percona-toolkit
786
787[1] http://www.xaprb.com/blog/2011/07/06/planned-change-in-maatkit-aspersa-development/
788
789Changelog
790---------
791
792* Fixed bug 819421: MasterSlave::is_replication_thread() doesn't match all
793* Fixed bug 821673: pt-table-checksum doesn't include --where in min max queries
794* Fixed bug 821688: pt-table-checksum SELECT MIN MAX for char chunking is wrong
795* Fixed bug 838211: pt-collect: line 24: [: : integer expression expected
796* Fixed bug 838248: pt-collect creates a "5.1" file
797
798v0.9.5 released 2011-08-04
799==========================
800
801Percona Toolkit 0.9.5 represents the completed transition from Maatkit and Aspersa. There are no bug fixes or new features, but some features have been removed (like --save-results from pt-query-digest). This release is the starting point for the 1.0 series where new development will happen, and no more changes will be made to the 0.9 series.
802
803Changelog
804---------
805
806* Forked, combined, and rebranded Maatkit and Aspersa as Percona Toolkit.
807
808Changelog
809---------
810
811* Fixed bug 947893: Some tools use @@hostname without /*!50038*/
812* Fixed bug 1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
813* Fixed bug 1163372: pt-heartbeat --utc --check always returns 0
814* Fixed bug 1137556: pt-heartbeat docs don't account for --utc
815* Fixed bug 1146324: pt-query-digest 2.1 typo in docs
816* Fixed bug 1171968: pt-query-digest docs don't mention --type=rawlog
817* Fixed bug 1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
818* Fixed bug 1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
819
820v2.1.10 released 2013-07-18
821===========================
822
823Percona Toolkit 2.1.10 has been released. This release includes eight bug fixes.
824
825* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
826
827Unfortunately, the relatively new --utc option for pt-heart was still
828broken because "[MySQL] interprets date as a value in the current time zone
829and converts it to an internal value in UTC." Now the tool works correctly
830with --utc by specifying "SET time_zone='+0:00'", and older versions of
831the tool can be made to work by specifying --set-vars "time_zone='+0:00'".
832
833* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
834
835Improved the pattern matching that caused the pt-deadlock-logger error when
836different timestamp format was used.
837
838* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
839
840pt-table-checksum was using the first non-unique index instead of the one
841with the highest cardinality due to a sorting bug.
842
843Percona Toolkit packages can be downloaded from
844http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
845Repositories (http://www.percona.com/software/repositories/).
846
847Changelog
848---------
849
850* Fixed bug #1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
851* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
852* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
853* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
854* Fixed bug #947893: Some tools use @@hostname without /*!50038*/
855* Fixed bug #1137556: pt-heartbeat docs don't account for --utc
856* Fixed bug #1146324: pt-query-digest 2.1 typo in docs
857* Fixed bug #1171968: pt-query-digest docs don't mention --type=rawlog
858
859v2.1.9 released 2013-02-14
860==========================
861
862Percona Toolkit 2.1.9 has been released. This release primarily aims to
863restore backwards-compatibility with pt-heartbeat 2.1.7 and older, but it
864also has important bug fixes for other tools.
865
866* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
867* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
868
869The previous release switched the time authority from Perl to MySQL, and from
870local time to UTC. Unfortunately, these changes caused a loss of precision and,
871if mixing versions of pt-heartbeat, made the tool report a huge amount of
872replication lag. This release makes the tool compatible with pt-heartbeat
8732.1.7 and older again, but the UTC behavior introduced in 2.1.8 is now only
874available by specifying the new --utc option.
875
876* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
877
878This is an important bug fix for pt-table-sync: certain chunks from
879pt-table-checksum resulted in an impossible WHERE, causing the false-positive
880"Cannot nibble" error, if those chunks had diffs.
881
882* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
883
884MariaDB 5.5.28 (https://kb.askmonty.org/en/mariadb-5528-changelog/) fixed
885a bug: "Added warnings for duplicate key errors when using INSERT IGNORE".
886However, standard MySQL does not warn in this case, despite the docs saying
887that it should. Since pt-online-schema-change has always intended to ignore
888duplicate entry errors by using "INSERT IGNORE", it now handles the MariaDB
889case by also ignoring duplicate entry errors in the code.
890
891* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
892
893pt-online-schema-change 2.1.9 handles another case of changing the primary key.
894However, since changing the primary key is tricky, the tool stops if --alter
895contains "DROP PRIMARY KEY", and you have to specify --no-check-alter to
896acknowledge this case.
897
898* Fixed bug 1099933: pt-stalk is too verbose, fills up log
899
900Previously, pt-stalk printed a line for every check. Since the tool is
901designed to be a long-running daemon, this could result in huge log files
902with "matched=no" lines. The tool has a new --verbose option which makes it
903quieter by default.
904
905All users should upgrade, but in particular, users of versions 2.1.7 and
906older are strongly recommended to skip 2.1.8 and go directly to 2.1.9.
907
908Users of pt-heartbeat in 2.1.8 who prefer the UTC behavior should keep in
909mind that they will have to use the --utc option after upgrading.
910
911Percona Toolkit packages can be downloaded from
912http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
913Repositories (http://www.percona.com/software/repositories/).
914
915Changelog
916---------
917
918* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
919* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
920* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
921* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
922* Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function
923* Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump
924* Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors
925* Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
926* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
927* Fixed bug 1099933: pt-stalk is too verbose, fills up log
928
929v2.1.8 released 2012-12-21
930==========================
931
932Percona Toolkit 2.1.8 has been released. This release includes 28 bug fixes, beta support for MySQL 5.6, and extensive support for Percona XtraDB Cluster (PXC). Users intending on running the tools on Percona XtraDB Cluster or MySQL 5.6 should upgrade. The following tools have been verified to work on PXC versions 5.5.28 and newer:
933
934* pt-table-chcecksum
935* pt-online-schema-change
936* pt-archive
937* pt-mysql-summary
938* pt-heartbeat
939* pt-variable-advisor
940* pt-config-diff
941* pt-deadlock-logger
942
943However, there are limitations when running these tools on PXC; see the Percona XtraDB Cluster section in each tool's documentation for further details. All other tools, with the exception of pt-slave-find, pt-slave-delay and pt-slave-restart, should also work correctly, but in some cases they have not been modified to take advantage of PXC features, so they may behave differently in future releases.
944
945The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
946
947* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
948
949Slow logs which include timestamps but no query--which can happen if using slow_query_log_timestamp_always in Percona Server--were misparsed, resulting in an erroneous report. Now such no-query events show up in reports as ``/* No query */``.
950
951* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
952
953The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.
954
955* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
956
957Some renamed variables had caused the Percona Server section to work unreliably.
958
959* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
960
961When using --replicate-check-only, filter options like --databases and --tables were not applied.
962
963* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
964
965Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very high lag) with slaves running in different time zones. Now pt-heartbeat uses UTC regardless of the server or MySQL time zone.
966
967* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
968
969Since MyISAM tables can't have foreign keys, and the tool uses the information_schema to find child tables, this could cause unnecessary load on the server.
970
9712.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.
972
973Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
974
975Changelog
976---------
977
978* Beta support for MySQL 5.6
979* Beta support for Percona XtraDB Cluster
980* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
981* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
982* pt-upgrade: Added --[no]disable-query-cache
983* Fixed bug 927955: Bad pod2rst transformation
984* Fixed bug 898665: Bad online docs formatting for --[no]vars
985* Fixed bug 1022622: pt-config-diff is case-sensitive
986* Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments
987* Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
988* Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes
989* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
990* Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong
991* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
992* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
993* Fixed bug 823431: pt-query-advisor hangs on big queries
994* Fixed bug 996069: pt-query-advisor RES.001 is incorrect
995* Fixed bug 933465: pt-query-advisor false positive on RES.001
996* Fixed bug 937234: pt-query-advisor issues wrong RES.001
997* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
998* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
999* Fixed bug 957442: pt-query-digest with custom --group-by throws error
1000* Fixed bug 887638: pt-query-digest prints negative byte offset
1001* Fixed bug 831525: pt-query-digest help output mangled
1002* Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error
1003* Fixed bug 1046440: pt-stalk purge_samples slows down checks
1004* Fixed bug 986847: pt-stalk does not report NFS iostat
1005* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1006* Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used
1007* Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef
1008* Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950
1009* Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611
1010* Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
1011
1012v2.1.7 released 2012-11-19
1013==========================
1014
1015Percona Toolkit 2.1.7 has been released which is a hotfix for two bugs when using pt-table-checksum with Percona XtraDB Cluster:
1016
1017* Bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1018* Bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1019
1020If you're using pt-table-checksum with a Percona XtraDB Cluster, you should upgrade. Otherwise, users can wait until the next full release.
1021
1022Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1023
1024Changelog
1025---------
1026
1027* Fixed bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1028* Fixed bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1029
1030v2.1.6 released 2012-11-13
1031==========================
1032
1033Percona Toolkit 2.1.6 has been released. This release includes 33 bug fixes and three new features: pt-online-schema-change now handles renaming columns without losing data, removing one of the tool's limitations. pt-online-schema-change also got two new options: --default-engine and --statistics. Finally, pt-stalk now has a plugin hook interface, available through the --plugin option. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
1034
1035* Bug 978133: pt-query-digest review table privilege checks don't work
1036
1037The same checks were removed from pt-table-checksum on 2.1.3 and pt-table-sync on 2.1.4, so this just follows suit.
1038
1039* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1040
1041A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
1042
1043* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1044
1045If you run multiple instances of pt-table-checksum on a badly lagged server, actually respecting --run-time stops the instances from divebombing the server when the replica catches up.
1046
1047* Bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1048
1049Fixed by choosing a key on the new table for the DELETE trigger.
1050
1051* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1052
1053A follow up to the same fix in the previous release, this adds to warnings for cases in which pt-table-checksum may work incorrectly and require some user intervention: One for the case of master -> cluster, and one for cluster1 -> cluster2.
1054
1055* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1056
1057This bug has hounded the toolkit for quite some time. In some platforms, trying to use LOAD DATA LOCAL INFILE would fail as if the user didn't have enough privileges to perform the operation. This was a misdiagnoses from MySQL; The actual problem was that the libmysqlclient.so provided by some vendors was compiled in a way that disallowed users from using the statement without some extra work. This fix adds an 'L' option to the DSNs the toolkit uses, tells the the tools to explicitly enables LOAD DATA LOCAL INFILE. This affected two pt-archiver and pt-upgrade, so if you are on an effected OS and need to use those, you can simply tag an L=1 to your DSN and everything should start working.
1058
1059* Bug 866075: pt-show-grant doesn't support column-level grants
1060
1061This was actually the 'hottest' bug in the tracker.
1062
1063This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
1064
1065Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1066
1067Changelog
1068---------
1069
1070* pt-online-schema-change: Columns can now be renamed without data loss
1071* pt-online-schema-change: New --default-engine option
1072* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
1073* Fixed bug 1069951: --version-check default should be explicitly "off"
1074* Fixed bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1075* Fixed bug 995896: Useless use of cat in Daemon.pm
1076* Fixed bug 1039074: Tools exit 0 on error parsing options, should exit non-zero
1077* Fixed bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1078* Fixed bug 1009510: pt-table-checksum breaks replication if a slave table is missing or different
1079* Fixed bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1080* Fixed bug 1073532: pt-table-checksum error: Use of uninitialized value in int at line 2778
1081* Fixed bug 1016131: pt-table-checksum can crash with --columns if none match
1082* Fixed bug 1039569: pt-table-checksum dies if creating the --replicate table fails
1083* Fixed bug 1059732: pt-table-checksum doesn't test all hash functions
1084* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1085* Fixed bug 1043528: pt-deadlock-logger can't parse db/tbl/index on partitioned tables
1086* Fixed bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1087* Fixed bug 1058285: pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
1088* Fixed bug 1073996: pt-online-schema-change fails with "I need a max_rows argument"
1089* Fixed bug 1039541: pt-online-schema-change --quiet doesn't disable --progress
1090* Fixed bug 1045317: pt-online-schema-change doesn't report how many warnings it suppressed
1091* Fixed bug 1060774: pt-upgrade fails if select column > 64 chars
1092* Fixed bug 1070916: pt-mysql-summary may report the wrong cnf file
1093* Fixed bug 903229: pt-mysql-summary incorrectly categorizes databases
1094* Fixed bug 866075: pt-show-grant doesn't support column-level grants
1095* Fixed bug 978133: pt-query-digest review table privilege checks don't work
1096* Fixed bug 956981: pt-query-digest docs for event attributes link to defunct Maatkit wiki
1097* Fixed bug 1047335: pt-duplicate-key-checker fails when it encounters a crashed table
1098* Fixed bug 1047701: pt-stalk deletes non-empty files
1099* Fixed bug 1070434: pt-stalk --no-stalk and --iterations 1 don't wait for the collect
1100* Fixed bug 1052722: pt-fifo-split is processing n-1 rows initially
1101* Fixed bug 1013407: pt-find documentation error with mtime and InnoDB
1102* Fixed bug 1059757: pt-trend output has no header
1103* Fixed bug 1063933: pt-visual-explain docs link to missing pdf
1104* Fixed bug 1075773: pt-fk-error-logger crashes if there's no foreign key error
1105* Fixed bug 1075775: pt-fk-error-logger --dest table example doesn't work
1106
1107v2.1.5 released 2012-10-08
1108==========================
1109
1110Percona Toolkit 2.1.5 has been released. This release is less than two weeks after the release of 2.1.4 because we wanted to address these bugs quickly:
1111
1112* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1113
1114* Bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1115
1116* Bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1117
1118The first two bugs fix how pt-table-checksum works with Percona XtraDB Cluster (PXC). Although the 2.1.4 release did introduce support for PXC, these bugs prevented pt-table-checksum from working correctly with a cluster.
1119
1120The third bug is also related to a feature new in 2.1.4: --version-check. The feature uses HTTPS/SSL by default, but some modules in pt-table-sync weren't update which could prevent it from working on older systems. Related, the version check web page mentioned in tools' documentation was also created.
1121
1122If you're using pt-table-checksum with a Percona XtraDB Cluster, you should definitely upgrade. Otherwise, users can wait until 2.1.6 for another full release.
1123
1124Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1125
1126Changelog
1127---------
1128
1129* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1130* Fixed bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1131* Fixed bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1132* Fixed bug 1060423: Missing version-check page
1133
1134v2.1.4 released 2012-09-20
1135==========================
1136
1137Percona Toolkit 2.1.4 has been released. This release includes 26 bug fixes and three new features: Making pt-table-checksum work with Percona XtraDB Cluster, adding a --run-time option to pt-table-checksum, and implementing the "Version Check" feature, enabled through the --version-check switch. For further information on --version-check, see http://www.mysqlperformanceblog.com/2012/09/10/introducing-the-version-check-feature-in-percona-toolkit/. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
1138
1139* Fixed bug 1017626: pt-table-checksum doesn't work with Percona XtraDB Cluster
1140
1141Note that this requires Percona XtraDB Cluster 5.5.27-23.6 or newer, as the fix depends on this bug https://bugs.launchpad.net/codership-mysql/+bug/1023911 being resolved.
1142
1143* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1144
1145Previously, users had no recourse but using --recursion-method in conjunction with a dsn table to sidestep this bug, so this fix is a huge usability gain. This was caused by the toolkit not copying the -F portion of the main dsn.
1146
1147* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1148
1149Which were stopping pt-upgrade from working on a MySQL 4.1 host.
1150
1151* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1152
1153The same checks were removed in the previous release from pt-table-checksum, so this continues the trend.
1154
1155* Fixed bug 1038995: pt-stalk --notify-by-email fails
1156
1157This was a bug in our shell option parsing library, and would potentially affect any option starting with 'no'.
1158
1159Like 2.1.3, this is another solid bug fix release, and 2.1 users are encouraged to upgrade.
1160
1161Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1162
1163Changelog
1164---------
1165
1166* pt-table-checksum: Percona XtraDB Cluster support
1167* pt-table-checksum: Implemented the standard --run-time option
1168* Implemented the version-check feature in several tools, enabled with the --version-check option
1169* Fixed bug 856060: Document gdb dependency
1170* Fixed bug 1041394: Unquoted arguments to tr break the bash tools
1171* Fixed bug 1035311: pt-diskstats shows wrong device names
1172* Fixed bug 1036804: pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
1173* Fixed bug 1022658: pt-online-schema-change dropping FK limitation isn't documented
1174* Fixed bug 1041372: pt-online-schema-changes fails if db+tbl name exceeds 64 characters
1175* Fixed bug 1029178: pt-query-digest --type tcpdump memory usage keeps increasing
1176* Fixed bug 1037211: pt-query-digest won't distill LOCK TABLES in lowercase
1177* Fixed bug 942114: pt-stalk warns about bad "find" usage
1178* Fixed bug 1035319: pt-stalk df -h throws away needed details
1179* Fixed bug 1038995: pt-stalk --notify-by-email fails
1180* Fixed bug 1038995: pt-stalk does not get all InnoDB lock data
1181* Fixed bug 952722: pt-summary should show information about Fusion-io cards
1182* Fixed bug 899415: pt-table-checksum doesn't work if slaves use RBR
1183* Fixed bug 954588: pt-table-checksum --check-slave-lag docs aren't clear
1184* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1185* Fixed bug 930693: pt-table-sync and text columns with just whitespace
1186* Fixed bug 1028710: pt-table-sync base_count fails on n = 1000, base = 10
1187* Fixed bug 1034717: pt-table-sync division by zero error with varchar primary key
1188* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1189* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1190* Fixed bug 1035260: sh warnings in pt-summary and pt-mysql-summary
1191* Fixed bug 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values
1192* Fixed bug 916925: CentOS 5 yum dependency resolution for perl module is wrong
1193* Fixed bug 1035950: Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
1194
1195v2.1.3 released 2012-08-03
1196==========================
1197
1198Percona Toolkit 2.1.3 has been released. This release includes 31 bug fixes and one new feature: pt-kill --log-dsn to log information about killed queries to a table. The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
1199
1200* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1201
1202pt-table-checksum used to check the user's privileges, but the method was not always reliable, and due to http://bugs.mysql.com/bug.php?id=61846 it became quite unreliable on MySQL 5.5. So the privs check was removed altogether, meaning that the tool may fail later if the user's privileges are insufficient.
1203
1204* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1205
1206In certain cases where the master and replicas have different schemas and/or tables, pt-table-checksum could break replication because the checksums table did not exist on a replica.
1207
1208* Fixed bug 821703: pt-query-digest --processlist may crash
1209* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1210
1211Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.
1212
1213* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1214
1215pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.
1216
1217* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1218
1219The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.
1220
1221* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1222
1223This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.
1224
1225All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.
1226
1227Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1228
1229Changelog
1230---------
1231
1232* pt-kill: Implemented --log-dsn to log info about killed queries to a table
1233* Fixed bug 1016127: Install hint for DBD::mysql is wrong
1234* Fixed bug 984915: DSNParser does not check success of --set-vars
1235* Fixed bug 889739: pt-config-diff doesn't diff quoted strings properly
1236* Fixed bug 969669: pt-duplicate-key-checker --key-types=k doesn't work
1237* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1238* Fixed bug 1028614: pt-index-usage ignores --database
1239* Fixed bug 940733: pt-ioprofile leaves behind temp directory
1240* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1241* Fixed bug 1016114: pt-online-schema-change docs don't mention default values
1242* Fixed bug 1020997: pt-online-schema-change fails when table is empty
1243* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1244* Fixed bug 937225: pt-query-advisor OUTER JOIN advice in JOI.003 is confusing
1245* Fixed bug 821703: pt-query-digest --processlist may crash
1246* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1247* Fixed bug 924950: pt-query-digest --group-by db may crash profile report
1248* Fixed bug 1022851: pt-sift error: PREFIX: unbound variable
1249* Fixed bug 969703: pt-sift defaults to '.' instead of '/var/lib/pt-talk'
1250* Fixed bug 962330: pt-slave-delay incorrectly computes lag if started when slave is already lagging
1251* Fixed bug 954990: pt-stalk --nostalk does not work
1252* Fixed bug 977226: pt-summary doesn't detect LSI RAID control
1253* Fixed bug 1030031: pt-table-checksum reports wrong number of DIFFS
1254* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1255* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1256* Fixed bug 953141: pt-table-checksum ignores its default and explicit --recursion-method
1257* Fixed bug 1030975: pt-table-sync crashes if sql_mode includes ANSI_QUOTES
1258* Fixed bug 869005: pt-table-sync should always set REPEATABLE READ
1259* Fixed bug 903510: pt-tcp-model crashes in --type=requests mode on empty file
1260* Fixed bug 934310: pt-tcp-model --quantile docs wrong
1261* Fixed bug 980318: pt-upgrade results truncated if hostnames are long
1262* Fixed bug 821696: pt-variable-advisor shows too long of a snippet
1263* Fixed bug 844880: pt-variable-advisor shows binary logging as both enabled and disabled
1264
1265v2.1.2 released 2012-06-12
1266==========================
1267
1268Percona Toolkit 2.1.2 has been released. This is a very important release because it fixes a critical bug in pt-table-sync (bug 1003014) which caused various failures. All users of Percona Toolkit 2.1 should upgrade to this release. There were 47 other bug fixes, several new options, and other changes. The following is a high-level summary of the most important changes.
1269
1270In addition to the critical bug fix mentioned above, another important pt-table-sync bug was fixed, bug 1002365: --ignore-* options did not work with --replicate. The --lock-and-rename feature of the tool was also disabled unless running MySQL 5.5 or newer because it did not work reliably in earlier versions of MySQL.
1271
1272Several important pt-table-checksum bugs were fixed. First, a bug caused the tool to ignore the primary key. Second, the tool did not wait for the checksum table to replicate, so it could select from a nonexistent table on a replica and crash. Third, it did not check if all checksum queries were safe and chunk index with more than 3 columns could cause MySQL to scan many more rows than expected.
1273
1274pt-online-schema-change received many improvements and fixes: it did not retry deadlocks, but now it does; --no-swap-tables caused an error; it did not handle column renames; it did not allow disabling foreign key checks; --dry-run always failed on tables with foreign keys; it used different keys for chunking and triggers; etc. In short: pt-online-schema-change 2.1.2 is superior to 2.1.1.
1275
1276Two pt-archiver bugs were fixed: bug 979092, --sleep conflicts with bulk operations; and bug 903379, --file doesn't create a file.
1277
1278--recursion-method=none was implemented in pt-heartbeat, pt-online-schema-change, pt-slave-find, pt-slave-restart, pt-table-checksum, and pt-table-sync. This allows these tools to avoid executing SHOW SLAVE STATUS which requires a privilege not available to Amazon RDS users.
1279
1280Other bugs were fixed in pt-stalk, pt-variable-advisor, pt-duplicate-key-checker, pt-diskstats, pt-query-digest, pt-sift, pt-kill, pt-summary, and pt-deadlock-logger.
1281
1282Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly encouraged to upgrade.
1283
1284Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1285
1286Changelog
1287---------
1288
1289* pt-heartbeat: Implemented --recursion-method=none
1290* pt-index-usage: MySQL 5.5 compatibility fixes
1291* pt-log-player: MySQL 5.5 compatibility fixes
1292* pt-online-schema-change: Added --chunk-index-columns
1293* pt-online-schema-change: Added --[no]check-plan
1294* pt-online-schema-change: Added --[no]drop-new-table
1295* pt-online-schema-change: Implemented --recursion-method=none
1296* pt-query-advisor: Added --report-type for JSON output
1297* pt-query-digest: Removed --[no]zero-bool
1298* pt-slave-delay: Added --database
1299* pt-slave-find: Implemented --recursion-method=none
1300* pt-slave-restart: Implemented --recursion-method=none
1301* pt-table-checksum: Added --chunk-index-columns
1302* pt-table-checksum: Added --[no]check-plan
1303* pt-table-checksum: Implemented --recursion-method=none
1304* pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer
1305* pt-table-sync: Implemented --recursion-method=none
1306* Fixed bug 945079: Shell tools TMPDIR may break
1307* Fixed bug 912902: Some shell tools still use basename
1308* Fixed bug 987694: There is no --recursion-method=none option
1309* Fixed bug 886077: Passwords with commas don't work, expose part of password
1310* Fixed bug 856024: Lintian warnings when building percona-toolkit Debian package
1311* Fixed bug 903379: pt-archiver --file doesn't create a file
1312* Fixed bug 979092: pt-archiver --sleep conflicts with bulk operations
1313* Fixed bug 903443: pt-deadlock-logger crashes on MySQL 5.5
1314* Fixed bug 941064: pt-deadlock-logger can't clear deadlocks on 5.5
1315* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1316* Fixed bug 994176: pt-diskstats --group-by=all --headers=scroll prints a header for every sample
1317* Fixed bug 894140: pt-duplicate-key-checker sometimes recreates a key it shouldn't
1318* Fixed bug 923896: pt-kill: uninitialized value causes script to exit
1319* Fixed bug 1003003: pt-online-schema-change uses different keys for chunking and triggers
1320* Fixed bug 1003315: pt-online-schema-change --dry-run always fails on table with foreign keys
1321* Fixed bug 1004551: pt-online-schema-change --no-swap-tables causes error
1322* Fixed bug 976108: pt-online-schema-change doesn't allow to disable foreign key checks
1323* Fixed bug 976109: pt-online-schema-change doesn't handle column renames
1324* Fixed bug 988036: pt-online-schema-change causes deadlocks under heavy write load
1325* Fixed bug 989227: pt-online-schema-change crashes with PTDEBUG
1326* Fixed bug 994002: pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY
1327* Fixed bug 994010: pt-online-schema-change 2.1.1 crashes without InnoDB
1328* Fixed bug 996915: pt-online-schema-change crashes with invalid --max-load and --critical-load
1329* Fixed bug 998831: pt-online-schema-change -- Should have an option to NOT drop tables on failure
1330* Fixed bug 1002448: pt-online-schema-change: typo for finding usable indexes
1331* Fixed bug 885382: pt-query-digest --embedded-attributes doesn't check cardinality
1332* Fixed bug 888114: pt-query-digest report crashes with infinite loop
1333* Fixed bug 949630: pt-query-digest mentions a Subversion repository
1334* Fixed bug 844034: pt-show-grants --separate fails with proxy user
1335* Fixed bug 946707: pt-sift loses STDIN after pt-diskstats
1336* Fixed bug 994947: pt-stalk doesn't reset cycles_true after collection
1337* Fixed bug 986151: pt-stalk-has mktemp error
1338* Fixed bug 993436: pt-summary Memory: Total reports M instead of G
1339* Fixed bug 1008778: pt-table-checksum doesn't wait for checksum table to replicate
1340* Fixed bug 1010232: pt-table-checksum doesn't check the size of checksum chunks
1341* Fixed bug 1011738: pt-table-checksum SKIPPED is zero but chunks were skipped
1342* Fixed bug 919499: pt-table-checksum fails with binary log error in mysql >= 5.5.18
1343* Fixed bug 972399: pt-table-checksum docs are not rendered right
1344* Fixed bug 978432: pt-table-checksum ignoring primary key
1345* Fixed bug 995274: pt-table-checksum can't use an undefined value as an ARRAY reference at line 2206
1346* Fixed bug 996110: pt-table-checksum crashes if InnoDB is disabled
1347* Fixed bug 987393: pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
1348* Fixed bug 1002365: pt-table-sync --ignore-* options don't work with --replicate
1349* Fixed bug 1003014: pt-table-sync --replicate and --sync-to-master error "index does not exist"
1350* Fixed bug 823403: pt-table-sync --lock-and-rename doesn't work on 5.1
1351* Fixed bug 898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values
1352
1353v2.1.1 released 2012-04-03
1354==========================
1355
1356Percona Toolkit 2.1.1 has been released. This is the first release in the
1357new 2.1 series which supersedes the 2.0 series. We will continue to fix bugs
1358in 2.0, but 2.1 is now the focus of development.
1359
13602.1 introduces a lot of new code for:
1361
1362* pt-online-schema-change (completely redesigned)
1363* pt-mysql-summary (completely redesigned)
1364* pt-summary (completely redesigned)
1365* pt-fingerprint (new tool)
1366* pt-table-usage (new tool)
1367
1368There were also several bug fixes.
1369
1370The redesigned tools are meant to replace their 2.0 counterparts because
1371the 2.1 versions have the same or more functionality and they are simpler
1372and more reliable. pt-online-schema-change was particularly enhanced to
1373be as safe as possible given that the tool is inherently risky.
1374
1375Percona Toolkit packages can be downloaded from
1376http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1377Repositories (http://www.percona.com/software/repositories/).
1378
1379Changelog
1380---------
1381
1382* Completely redesigned pt-online-schema-change
1383* Completely redesigned pt-mysql-summary
1384* Completely redesigned pt-summary
1385* Added new tool: pt-table-usage
1386* Added new tool: pt-fingerprint
1387* Fixed bug 955860: pt-stalk doesn't run vmstat, iostat, and mpstat for --run-time
1388* Fixed bug 960513: SHOW TABLE STATUS is used needlessly
1389* Fixed bug 969726: pt-online-schema-change loses foreign keys
1390* Fixed bug 846028: pt-online-schema-change does not show progress until completed
1391* Fixed bug 898695: pt-online-schema-change add useless ORDER BY
1392* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1393* Fixed bug 963225: pt-query-digest fails to set history columns for disk tmp tables and disk filesort
1394* Fixed bug 967451: Char chunking doesn't quote column name
1395* Fixed bug 972399: pt-table-checksum docs are not rendered right
1396* Fixed bug 896553: Various documentation spelling fixes
1397* Fixed bug 949154: pt-variable-advisor advice for relay-log-space-limit
1398* Fixed bug 953461: pt-upgrade manual broken 'output' section
1399* Fixed bug 949653: pt-table-checksum docs don't mention risks posed by inconsistent schemas
1400
1401v2.0.4 released 2012-03-07
1402==========================
1403
1404Percona Toolkit 2.0.4 has been released. 23 bugs were fixed in this release,
1405and three new features were implemented. First, --filter was added to pt-kill
1406which allows for arbitrary --group-by. Second, pt-online-schema-change now
1407requires that its new --execute option be given, else the tool will just check
1408the tables and exit. This is a safeguard to encourage users to read the
1409documentation, particularly when replication is involved. Third, pt-stalk
1410also received a new option: --[no]stalk. To collect immediately without
1411stalking, specify --no-stalk and the tool will collect once and exit.
1412
1413This release is completely backwards compatible with previous 2.0 releases.
1414Given the number of bug fixes, it's worth upgrading to 2.0.4.
1415
1416Changelog
1417---------
1418
1419* Added --filter to pt-kill to allow arbitrary --group-by
1420* Added --[no]stalk to pt-stalk (bug 932331)
1421* Added --execute to pt-online-schema-change (bug 933232)
1422* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
1423* Fixed bug 928966: pt-pmp still uses insecure /tmp
1424* Fixed bug 933232: pt-online-schema-change can break replication
1425* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
1426* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
1427* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
1428* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
1429* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
1430* Fixed bug 928226: pt-diskstats illegal division by zero
1431* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
1432* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
1433* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
1434* Fixed bug 932331: pt-stalk cannot collect without stalking
1435* Fixed bug 932442: pt-table-checksum error when column name has two spaces
1436* Fixed bug 932883: File Debian bug after each release
1437* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
1438* Fixed bug 944420: --daemonize doesn't always close STDIN
1439* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
1440* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
1441* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
1442* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
1443* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
1444* Fixed bug 940440: Bad grammar in pt-kill docs
1445
1446v2.0.3 released 2012-02-03
1447==========================
1448
1449Percona Toolkit 2.0.3 has been released. The development team was very
1450busy last month making this release significant: two completely
1451redesigned and improved tools, pt-diskstats and pt-stalk, and 20 bug fixes.
1452
1453Both pt-diskstats and pt-stalk were redesigned and rewritten from the ground
1454up. This allowed us to greatly improve these tools' functionality and
1455increase testing for them. The accuracy and output of pt-diskstats was
1456enhanced, and the tool was rewritten in Perl. pt-collect was removed and
1457its functionality was put into a new, enhanced pt-stalk. pt-stalk is now
1458designed to be a stable, long-running daemon on a variety of common platforms.
1459It is worth re-reading the documentation for each of these tools.
1460
1461The 20 bug fixes cover a wide range of problems. The most important are
1462fixes to pt-table-checksum, pt-iostats, and pt-kill. Apart from pt-diskstats,
1463pt-stalk, and pt-collect (which was removed), no other tools were changed
1464in backwards-incompatible ways, so it is worth reviewing the full changelog
1465for this release and upgrading if you use any tools which had bug fixes.
1466
1467Thank you to the many people who reported bugs and submitted patches.
1468
1469Download the latest release of Percona Toolkit 2.0 from
1470http://www.percona.com/software/percona-toolkit/
1471or the Percona Software Repositories
1472(http://www.percona.com/docs/wiki/repositories:start).
1473
1474Changelog
1475---------
1476
1477* Completely redesigned pt-diskstats
1478* Completely redesigned pt-stalk
1479* Removed pt-collect and put its functionality in pt-stalk
1480* Fixed bug 871438: Bash tools are insecure
1481* Fixed bug 897758: Failed to prepare TableSyncChunk plugin: Use of uninitialized value $args{"chunk_range"} in lc at pt-table-sync line 3055
1482* Fixed bug 919819: pt-kill --execute-command creates zombies
1483* Fixed bug 925778: pt-ioprofile doesn't run without a file
1484* Fixed bug 925477: pt-ioprofile docs refer to pt-iostats
1485* Fixed bug 857091: pt-sift downloads http://percona.com/get/pt-pmp, which does not work
1486* Fixed bug 857104: pt-sift tries to invoke mext, should be pt-mext
1487* Fixed bug 872699: pt-diskstats: rd_avkb & wr_avkb derived incorrectly
1488* Fixed bug 897029: pt-diskstats computes wrong values for md0
1489* Fixed bug 882918: pt-stalk spams warning if oprofile isn't installed
1490* Fixed bug 884504: pt-stalk doesn't check pt-collect
1491* Fixed bug 897483: pt-online-schema-change "uninitialized value" due to update-foreign-keys-method
1492* Fixed bug 925007: pt-online-schema-change Use of uninitialized value $tables{"old_table"} in concatenation (.) or string at line 4330
1493* Fixed bug 915598: pt-config-diff ignores --ask-pass option
1494* Fixed bug 919352: pt-table-checksum changes binlog_format even if already set to statement
1495* Fixed bug 921700: pt-table-checksum doesn't add --where to chunk size test on replicas
1496* Fixed bug 921802: pt-table-checksum does not recognize --recursion-method=processlist
1497* Fixed bug 925855: pt-table-checksum index check is case-sensitive
1498* Fixed bug 821709: pt-show-grants --revoke and --separate don't work together
1499* Fixed bug 918247: Some tools use VALUE instead of VALUES
1500
1501v2.0.2 released 2012-01-05
1502==========================
1503
1504Percona Toolkit 2.0.2 fixes one critical bug: pt-table-sync --replicate
1505did not work with character values, causing an "Unknown column" error.
1506If using Percona Toolkit 2.0.1, you should upgrade to 2.0.2.
1507
1508Download the latest release of Percona Toolkit 2.0 from
1509http://www.percona.com/software/percona-toolkit/
1510or the Percona Software Repositories
1511(http://www.percona.com/docs/wiki/repositories:start).
1512
1513Changelog
1514---------
1515
1516* Fixed bug 911996: pt-table-sync --replicate causes "Unknown column" error
1517
1518v2.0.1 released 2011-12-30
1519==========================
1520
1521The Percona Toolkit development team is proud to announce a new major version:
15222.0. Beginning with Percona Toolkit 2.0, we are overhauling, redesigning, and
1523improving the major tools. 2.0 tools are therefore not backwards compatible
1524with 1.0 tools, which we still support but will not continue to develop.
1525
1526New in Percona Toolkit 2.0.1 is a completely redesigned pt-table-checksum.
1527The original pt-table-checksum 1.0 was rather complex, but it worked well
1528for many years. By contrast, the new pt-table-checksum 2.0 is much simpler but
1529also much more efficient and reliable. We spent months rethinking, redesigning,
1530and testing every aspect of the tool. The three most significant changes:
1531pt-table-checksum 2.0 does only --replicate, it has only one chunking algorithm,
1532and its memory usage is stable even with hundreds of thousands of tables and
1533trillions of rows. The tool is now dedicated to verifying MySQL replication
1534integrity, nothing else, which it does extremely well.
1535
1536In Percona Toolkit 2.0.1 we also fixed various small bugs and forked ioprofile
1537and align (as pt-ioprofile and pt-align) from Aspersa.
1538
1539If you still need functionalities in the original pt-table-checksum,
1540the latest Percona Toolkit 1.0 release remains available for download.
1541Otherwise, all new development in Percona Toolkit will happen in 2.0.
1542
1543Download the latest release of Percona Toolkit 2.0 from
1544http://www.percona.com/software/percona-toolkit/
1545or the Percona Software Repositories
1546(http://www.percona.com/docs/wiki/repositories:start).
1547
1548Changelog
1549---------
1550
1551* Completely redesigned pt-table-checksum
1552* Fixed bug 856065: pt-trend does not work
1553* Fixed bug 887688: Prepared statements crash pt-query-digest
1554* Fixed bug 888286: align not part of percona-toolkit
1555* Fixed bug 897961: ptc 2.0 replicate-check error does not include hostname
1556* Fixed bug 898318: ptc 2.0 --resume with --tables does not always work
1557* Fixed bug 903513: MKDEBUG should be PTDEBUG
1558* Fixed bug 908256: Percona Toolkit should include pt-ioprofile
1559* Fixed bug 821717: pt-tcp-model --type=requests crashes
1560* Fixed bug 844038: pt-online-schema-change documentation example w/drop-tmp-table does not work
1561* Fixed bug 864205: Remove the query to reset @crc from pt-table-checksum
1562* Fixed bug 898663: Typo in pt-log-player documentation
1563
1564v1.0.1 released 2011-09-01
1565==========================
1566
1567Percona Toolkit 1.0.1 has been released. In July, Baron announced planned
1568changes to Maatkit and Aspersa development;[1] Percona Toolkit is the
1569result. In brief, Percona Toolkit is the combined fork of Maatkit and
1570Aspersa, so although the toolkit is new, the programs are not. That means
1571Percona Toolkit 1.0.1 is mature, stable, and production-ready. In fact,
1572it's even a little more stable because we fixed a few bugs in this release.
1573
1574Percona Toolkit packages can be downloaded from
1575http://www.percona.com/downloads/percona-toolkit/
1576or the Percona Software Repositories
1577(http://www.percona.com/docs/wiki/repositories:start).
1578
1579Although Maatkit and Aspersa development use Google Code, Percona Toolkit
1580uses Launchpad: https://launchpad.net/percona-toolkit
1581
1582[1] http://www.xaprb.com/blog/2011/07/06/planned-change-in-maatkit-aspersa-development/
1583
1584Changelog
1585---------
1586
1587* Fixed bug 819421: MasterSlave::is_replication_thread() doesn't match all
1588* Fixed bug 821673: pt-table-checksum doesn't include --where in min max queries
1589* Fixed bug 821688: pt-table-checksum SELECT MIN MAX for char chunking is wrong
1590* Fixed bug 838211: pt-collect: line 24: [: : integer expression expected
1591* Fixed bug 838248: pt-collect creates a "5.1" file
1592
1593v0.9.5 released 2011-08-04
1594==========================
1595
1596Percona Toolkit 0.9.5 represents the completed transition from Maatkit and Aspersa. There are no bug fixes or new features, but some features have been removed (like --save-results from pt-query-digest). This release is the starting point for the 1.0 series where new development will happen, and no more changes will be made to the 0.9 series.
1597
1598Changelog
1599---------
1600
1601* Forked, combined, and rebranded Maatkit and Aspersa as Percona Toolkit.
1602
1603Changelog
1604---------
1605
1606* Fixed bug 1279502: --version-check behaves like spyware
1607* Fixed bug 1199589: pt-archiver deletes data despite --dry-run
91608
10v2.1.10 released 2013-07-181609v2.1.10 released 2013-07-18
11===========================1610===========================

Subscribers

People subscribed via source and target branches