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
1=== modified file 'Changelog'
2--- Changelog 2014-03-03 22:02:30 +0000
3+++ Changelog 2014-03-04 12:35:02 +0000
4@@ -1,5 +1,7 @@
5 Changelog for Percona Toolkit
6
7+v2.1.11 released 2014-03-04
8+
9 * Fixed bug 1279502: --version-check behaves like spyware
10 * Fixed bug 1199589: pt-archiver deletes data despite --dry-run
11
12
13=== modified file 'Makefile.PL'
14--- Makefile.PL 2013-07-18 17:31:04 +0000
15+++ Makefile.PL 2014-03-04 12:35:02 +0000
16@@ -2,7 +2,7 @@
17
18 WriteMakefile(
19 NAME => 'percona-toolkit',
20- VERSION => '2.1.10',
21+ VERSION => '2.1.11',
22 EXE_FILES => [ <bin/*> ],
23 MAN1PODS => {
24 'docs/percona-toolkit.pod' => 'blib/man1/percona-toolkit.1p',
25
26=== modified file 'bin/pt-align'
27--- bin/pt-align 2013-07-18 17:31:04 +0000
28+++ bin/pt-align 2014-03-04 12:35:02 +0000
29@@ -199,7 +199,7 @@
30
31 =head1 COPYRIGHT, LICENSE, AND WARRANTY
32
33-This program is copyright 2011-2013 Percona Ireland Ltd,
34+This program is copyright 2011-2014 Percona Ireland Ltd,
35 2010-2011 Baron Schwartz.
36
37 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
38@@ -218,6 +218,6 @@
39
40 =head1 VERSION
41
42-pt-align 2.1.10
43+pt-align 2.1.11
44
45 =cut
46
47=== modified file 'bin/pt-archiver'
48--- bin/pt-archiver 2014-03-03 22:02:30 +0000
49+++ bin/pt-archiver 2014-03-04 12:35:02 +0000
50@@ -7534,7 +7534,7 @@
51
52 =head1 COPYRIGHT, LICENSE, AND WARRANTY
53
54-This program is copyright 2011-2013 Percona Ireland Ltd,
55+This program is copyright 2011-2014 Percona Ireland Ltd,
56 2007-2011 Baron Schwartz.
57
58 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
59@@ -7553,6 +7553,6 @@
60
61 =head1 VERSION
62
63-pt-archiver 2.1.10
64+pt-archiver 2.1.11
65
66 =cut
67
68=== modified file 'bin/pt-config-diff'
69--- bin/pt-config-diff 2014-03-03 22:02:30 +0000
70+++ bin/pt-config-diff 2014-03-04 12:35:02 +0000
71@@ -4832,7 +4832,7 @@
72
73 =head1 COPYRIGHT, LICENSE, AND WARRANTY
74
75-This program is copyright 2011-2013 Percona Ireland Ltd.
76+This program is copyright 2011-2014 Percona Ireland Ltd.
77
78 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
79 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
80@@ -4850,6 +4850,6 @@
81
82 =head1 VERSION
83
84-pt-config-diff 2.1.10
85+pt-config-diff 2.1.11
86
87 =cut
88
89=== modified file 'bin/pt-deadlock-logger'
90--- bin/pt-deadlock-logger 2014-03-03 22:02:30 +0000
91+++ bin/pt-deadlock-logger 2014-03-04 12:35:02 +0000
92@@ -4750,7 +4750,7 @@
93
94 =head1 COPYRIGHT, LICENSE, AND WARRANTY
95
96-This program is copyright 2011-2013 Percona Ireland Ltd,
97+This program is copyright 2011-2014 Percona Ireland Ltd,
98 2007-2011 Baron Schwartz.
99
100 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
101@@ -4769,6 +4769,6 @@
102
103 =head1 VERSION
104
105-pt-deadlock-logger 2.1.10
106+pt-deadlock-logger 2.1.11
107
108 =cut
109
110=== modified file 'bin/pt-diskstats'
111--- bin/pt-diskstats 2014-03-03 22:02:30 +0000
112+++ bin/pt-diskstats 2014-03-04 12:35:02 +0000
113@@ -5530,7 +5530,7 @@
114
115 =head1 COPYRIGHT, LICENSE, AND WARRANTY
116
117-This program is copyright 2011-2013 Percona Ireland Ltd,
118+This program is copyright 2011-2014 Percona Ireland Ltd,
119 2010-2011 Baron Schwartz.
120
121 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
122@@ -5549,6 +5549,6 @@
123
124 =head1 VERSION
125
126-pt-diskstats 2.1.10
127+pt-diskstats 2.1.11
128
129 =cut
130
131=== modified file 'bin/pt-duplicate-key-checker'
132--- bin/pt-duplicate-key-checker 2014-03-03 22:02:30 +0000
133+++ bin/pt-duplicate-key-checker 2014-03-04 12:35:02 +0000
134@@ -5400,7 +5400,7 @@
135
136 =head1 COPYRIGHT, LICENSE, AND WARRANTY
137
138-This program is copyright 2011-2013 Percona Ireland Ltd,
139+This program is copyright 2011-2014 Percona Ireland Ltd,
140 2007-2011 Baron Schwartz.
141
142 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
143@@ -5419,6 +5419,6 @@
144
145 =head1 VERSION
146
147-pt-duplicate-key-checker 2.1.10
148+pt-duplicate-key-checker 2.1.11
149
150 =cut
151
152=== modified file 'bin/pt-fifo-split'
153--- bin/pt-fifo-split 2013-07-18 17:31:04 +0000
154+++ bin/pt-fifo-split 2014-03-04 12:35:02 +0000
155@@ -1549,7 +1549,7 @@
156
157 =head1 COPYRIGHT, LICENSE, AND WARRANTY
158
159-This program is copyright 2011-2013 Percona Ireland Ltd,
160+This program is copyright 2011-2014 Percona Ireland Ltd,
161 2007-2011 Baron Schwartz.
162
163 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
164@@ -1568,6 +1568,6 @@
165
166 =head1 VERSION
167
168-pt-fifo-split 2.1.10
169+pt-fifo-split 2.1.11
170
171 =cut
172
173=== modified file 'bin/pt-find'
174--- bin/pt-find 2014-03-03 22:02:30 +0000
175+++ bin/pt-find 2014-03-04 12:35:02 +0000
176@@ -4858,7 +4858,7 @@
177
178 =head1 COPYRIGHT, LICENSE, AND WARRANTY
179
180-This program is copyright 2011-2013 Percona Ireland Ltd,
181+This program is copyright 2011-2014 Percona Ireland Ltd,
182 2007-2011 Baron Schwartz.
183
184 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
185@@ -4877,6 +4877,6 @@
186
187 =head1 VERSION
188
189-pt-find 2.1.10
190+pt-find 2.1.11
191
192 =cut
193
194=== modified file 'bin/pt-fingerprint'
195--- bin/pt-fingerprint 2013-07-18 17:31:04 +0000
196+++ bin/pt-fingerprint 2014-03-04 12:35:02 +0000
197@@ -2129,7 +2129,7 @@
198
199 =head1 COPYRIGHT, LICENSE, AND WARRANTY
200
201-This program is copyright 2011-2013 Percona Ireland Ltd.
202+This program is copyright 2011-2014 Percona Ireland Ltd.
203
204 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
205 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
206@@ -2147,6 +2147,6 @@
207
208 =head1 VERSION
209
210-pt-fingerprint 2.1.10
211+pt-fingerprint 2.1.11
212
213 =cut
214
215=== modified file 'bin/pt-fk-error-logger'
216--- bin/pt-fk-error-logger 2014-03-03 22:02:30 +0000
217+++ bin/pt-fk-error-logger 2014-03-04 12:35:02 +0000
218@@ -3990,7 +3990,7 @@
219
220 =head1 COPYRIGHT, LICENSE, AND WARRANTY
221
222-This program is copyright 2011-2013 Percona Ireland Ltd.
223+This program is copyright 2011-2014 Percona Ireland Ltd.
224
225 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
226 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
227@@ -4008,6 +4008,6 @@
228
229 =head1 VERSION
230
231-pt-fk-error-logger 2.1.10
232+pt-fk-error-logger 2.1.11
233
234 =cut
235
236=== modified file 'bin/pt-heartbeat'
237--- bin/pt-heartbeat 2014-03-03 22:02:30 +0000
238+++ bin/pt-heartbeat 2014-03-04 12:35:02 +0000
239@@ -6038,7 +6038,7 @@
240
241 =head1 COPYRIGHT, LICENSE, AND WARRANTY
242
243-This program is copyright 2007-2013 Percona Ireland Ltd,
244+This program is copyright 2007-2014 Percona Ireland Ltd,
245 2006 Proven Scaling LLC and Six Apart Ltd.
246
247 Feedback and improvements are welcome.
248@@ -6059,6 +6059,6 @@
249
250 =head1 VERSION
251
252-pt-heartbeat 2.1.10
253+pt-heartbeat 2.1.11
254
255 =cut
256
257=== modified file 'bin/pt-index-usage'
258--- bin/pt-index-usage 2014-03-03 22:02:30 +0000
259+++ bin/pt-index-usage 2014-03-04 12:35:02 +0000
260@@ -7448,7 +7448,7 @@
261
262 =head1 COPYRIGHT, LICENSE, AND WARRANTY
263
264-This program is copyright 2011-2013 Percona Ireland Ltd,
265+This program is copyright 2011-2014 Percona Ireland Ltd,
266 2010-2011 Baron Schwartz.
267
268 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
269@@ -7467,6 +7467,6 @@
270
271 =head1 VERSION
272
273-pt-index-usage 2.1.10
274+pt-index-usage 2.1.11
275
276 =cut
277
278=== modified file 'bin/pt-ioprofile'
279--- bin/pt-ioprofile 2013-07-18 17:31:04 +0000
280+++ bin/pt-ioprofile 2014-03-04 12:35:02 +0000
281@@ -1093,7 +1093,7 @@
282
283 =head1 COPYRIGHT, LICENSE, AND WARRANTY
284
285-This program is copyright 2011-2013 Percona Ireland Ltd,
286+This program is copyright 2011-2014 Percona Ireland Ltd,
287 2010-2011 Baron Schwartz.
288
289 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
290@@ -1112,7 +1112,7 @@
291
292 =head1 VERSION
293
294-pt-ioprofile 2.1.10
295+pt-ioprofile 2.1.11
296
297 =cut
298
299
300=== modified file 'bin/pt-kill'
301--- bin/pt-kill 2014-03-03 22:02:30 +0000
302+++ bin/pt-kill 2014-03-04 12:35:02 +0000
303@@ -7749,7 +7749,7 @@
304
305 =head1 COPYRIGHT, LICENSE, AND WARRANTY
306
307-This program is copyright 2011-2013 Percona Ireland Ltd,
308+This program is copyright 2011-2014 Percona Ireland Ltd,
309 2009-2011 Baron Schwartz.
310
311 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
312@@ -7768,6 +7768,6 @@
313
314 =head1 VERSION
315
316-pt-kill 2.1.10
317+pt-kill 2.1.11
318
319 =cut
320
321=== modified file 'bin/pt-log-player'
322--- bin/pt-log-player 2013-07-18 17:31:04 +0000
323+++ bin/pt-log-player 2014-03-04 12:35:02 +0000
324@@ -3655,7 +3655,7 @@
325
326 =head1 COPYRIGHT, LICENSE, AND WARRANTY
327
328-This program is copyright 2008-2013 Percona Ireland Ltd.
329+This program is copyright 2008-2014 Percona Ireland Ltd.
330
331 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
332 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
333@@ -3673,6 +3673,6 @@
334
335 =head1 VERSION
336
337-pt-log-player 2.1.10
338+pt-log-player 2.1.11
339
340 =cut
341
342=== modified file 'bin/pt-mext'
343--- bin/pt-mext 2013-07-18 17:31:04 +0000
344+++ bin/pt-mext 2014-03-04 12:35:02 +0000
345@@ -263,7 +263,7 @@
346
347 =head1 COPYRIGHT, LICENSE, AND WARRANTY
348
349-This program is copyright 2011-2013 Percona Ireland Ltd,
350+This program is copyright 2011-2014 Percona Ireland Ltd,
351 2010 Baron Schwartz.
352
353 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
354@@ -282,7 +282,7 @@
355
356 =head1 VERSION
357
358-pt-mext 2.1.10
359+pt-mext 2.1.11
360
361 =cut
362
363
364=== modified file 'bin/pt-mysql-summary'
365--- bin/pt-mysql-summary 2013-07-18 17:31:04 +0000
366+++ bin/pt-mysql-summary 2014-03-04 12:35:02 +0000
367@@ -2992,7 +2992,7 @@
368
369 =head1 COPYRIGHT, LICENSE, AND WARRANTY
370
371-This program is copyright 2011-2013 Percona Ireland Ltd,
372+This program is copyright 2011-2014 Percona Ireland Ltd,
373 2010-2011 Baron Schwartz.
374
375 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
376@@ -3011,7 +3011,7 @@
377
378 =head1 VERSION
379
380-pt-mysql-summary 2.1.10
381+pt-mysql-summary 2.1.11
382
383 =cut
384
385
386=== modified file 'bin/pt-online-schema-change'
387--- bin/pt-online-schema-change 2014-03-03 22:02:30 +0000
388+++ bin/pt-online-schema-change 2014-03-04 12:35:02 +0000
389@@ -10906,7 +10906,7 @@
390
391 =head1 COPYRIGHT, LICENSE, AND WARRANTY
392
393-This program is copyright 2011-2013 Percona Ireland Ltd.
394+This program is copyright 2011-2014 Percona Ireland Ltd.
395
396 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
397 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
398@@ -10924,6 +10924,6 @@
399
400 =head1 VERSION
401
402-pt-online-schema-change 2.1.10
403+pt-online-schema-change 2.1.11
404
405 =cut
406
407=== modified file 'bin/pt-pmp'
408--- bin/pt-pmp 2013-07-18 17:31:04 +0000
409+++ bin/pt-pmp 2014-03-04 12:35:02 +0000
410@@ -385,7 +385,7 @@
411
412 =head1 COPYRIGHT, LICENSE, AND WARRANTY
413
414-This program is copyright 2011-2013 Percona Ireland Ltd,
415+This program is copyright 2011-2014 Percona Ireland Ltd,
416 2010-2011 Baron Schwartz.
417
418 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
419@@ -404,7 +404,7 @@
420
421 =head1 VERSION
422
423-pt-pmp 2.1.10
424+pt-pmp 2.1.11
425
426 =cut
427
428
429=== modified file 'bin/pt-query-advisor'
430--- bin/pt-query-advisor 2014-03-03 22:02:30 +0000
431+++ bin/pt-query-advisor 2014-03-04 12:35:02 +0000
432@@ -8688,7 +8688,7 @@
433
434 =head1 COPYRIGHT, LICENSE, AND WARRANTY
435
436-This program is copyright 2010-2013 Percona Ireland Ltd.
437+This program is copyright 2010-2014 Percona Ireland Ltd.
438
439 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
440 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
441@@ -8706,6 +8706,6 @@
442
443 =head1 VERSION
444
445-pt-query-advisor 2.1.10
446+pt-query-advisor 2.1.11
447
448 =cut
449
450=== modified file 'bin/pt-query-digest'
451--- bin/pt-query-digest 2014-03-03 22:02:30 +0000
452+++ bin/pt-query-digest 2014-03-04 12:35:02 +0000
453@@ -17432,7 +17432,7 @@
454
455 =head1 COPYRIGHT, LICENSE, AND WARRANTY
456
457-This program is copyright 2008-2013 Percona Ireland Ltd.
458+This program is copyright 2008-2014 Percona Ireland Ltd.
459
460 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
461 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
462@@ -17450,6 +17450,6 @@
463
464 =head1 VERSION
465
466-pt-query-digest 2.1.10
467+pt-query-digest 2.1.11
468
469 =cut
470
471=== modified file 'bin/pt-show-grants'
472--- bin/pt-show-grants 2013-07-18 17:31:04 +0000
473+++ bin/pt-show-grants 2014-03-04 12:35:02 +0000
474@@ -2285,7 +2285,7 @@
475
476 =head1 COPYRIGHT, LICENSE, AND WARRANTY
477
478-This program is copyright 2011-2013 Percona Ireland Ltd,
479+This program is copyright 2011-2014 Percona Ireland Ltd,
480 2007-2011 Baron Schwartz.
481
482 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
483@@ -2304,6 +2304,6 @@
484
485 =head1 VERSION
486
487-pt-show-grants 2.1.10
488+pt-show-grants 2.1.11
489
490 =cut
491
492=== modified file 'bin/pt-sift'
493--- bin/pt-sift 2013-07-18 17:31:04 +0000
494+++ bin/pt-sift 2014-03-04 12:35:02 +0000
495@@ -762,7 +762,7 @@
496
497 =head1 COPYRIGHT, LICENSE, AND WARRANTY
498
499-This program is copyright 2011-2013 Percona Ireland Ltd,
500+This program is copyright 2011-2014 Percona Ireland Ltd,
501 2010-2011 Baron Schwartz.
502
503 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
504@@ -781,7 +781,7 @@
505
506 =head1 VERSION
507
508-pt-sift 2.1.10
509+pt-sift 2.1.11
510
511 =cut
512
513
514=== modified file 'bin/pt-slave-delay'
515--- bin/pt-slave-delay 2014-03-03 22:02:30 +0000
516+++ bin/pt-slave-delay 2014-03-04 12:35:02 +0000
517@@ -4560,7 +4560,7 @@
518
519 =head1 COPYRIGHT, LICENSE, AND WARRANTY
520
521-This program is copyright 2011-2013 Percona Ireland Ltd,
522+This program is copyright 2011-2014 Percona Ireland Ltd,
523 2007-2011 Sergey Zhuravle and Baron Schwartz.
524
525 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
526@@ -4579,6 +4579,6 @@
527
528 =head1 VERSION
529
530-pt-slave-delay 2.1.10
531+pt-slave-delay 2.1.11
532
533 =cut
534
535=== modified file 'bin/pt-slave-find'
536--- bin/pt-slave-find 2013-07-18 17:31:04 +0000
537+++ bin/pt-slave-find 2014-03-04 12:35:02 +0000
538@@ -4006,7 +4006,7 @@
539
540 =head1 COPYRIGHT, LICENSE, AND WARRANTY
541
542-This program is copyright 2011-2013 Percona Ireland Ltd,
543+This program is copyright 2011-2014 Percona Ireland Ltd,
544 2007-2011 Baron Schwartz.
545
546 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
547@@ -4025,6 +4025,6 @@
548
549 =head1 VERSION
550
551-pt-slave-find 2.1.10
552+pt-slave-find 2.1.11
553
554 =cut
555
556=== modified file 'bin/pt-slave-restart'
557--- bin/pt-slave-restart 2014-03-03 22:02:30 +0000
558+++ bin/pt-slave-restart 2014-03-04 12:35:02 +0000
559@@ -5479,7 +5479,7 @@
560
561 =head1 COPYRIGHT, LICENSE, AND WARRANTY
562
563-This program is copyright 2011-2013 Percona Ireland Ltd,
564+This program is copyright 2011-2014 Percona Ireland Ltd,
565 2007-2011 Baron Schwartz.
566
567 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
568@@ -5498,6 +5498,6 @@
569
570 =head1 VERSION
571
572-pt-slave-restart 2.1.10
573+pt-slave-restart 2.1.11
574
575 =cut
576
577=== modified file 'bin/pt-stalk'
578--- bin/pt-stalk 2013-07-18 17:31:04 +0000
579+++ bin/pt-stalk 2014-03-04 12:35:02 +0000
580@@ -2004,7 +2004,7 @@
581
582 =head1 COPYRIGHT, LICENSE, AND WARRANTY
583
584-This program is copyright 2011-2013 Percona Ireland Ltd,
585+This program is copyright 2011-2014 Percona Ireland Ltd,
586 2010-2011 Baron Schwartz.
587
588 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
589@@ -2023,7 +2023,7 @@
590
591 =head1 VERSION
592
593-pt-stalk 2.1.10
594+pt-stalk 2.1.11
595
596 =cut
597
598
599=== modified file 'bin/pt-summary'
600--- bin/pt-summary 2013-07-18 17:31:04 +0000
601+++ bin/pt-summary 2014-03-04 12:35:02 +0000
602@@ -2663,7 +2663,7 @@
603
604 =head1 COPYRIGHT, LICENSE, AND WARRANTY
605
606-This program is copyright 2011-2013 Percona Ireland Ltd,
607+This program is copyright 2011-2014 Percona Ireland Ltd,
608 2010-2011 Baron Schwartz.
609
610 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
611@@ -2682,7 +2682,7 @@
612
613 =head1 VERSION
614
615-pt-summary 2.1.10
616+pt-summary 2.1.11
617
618 =cut
619
620
621=== modified file 'bin/pt-table-checksum'
622--- bin/pt-table-checksum 2014-03-03 22:02:30 +0000
623+++ bin/pt-table-checksum 2014-03-04 12:35:02 +0000
624@@ -11923,7 +11923,7 @@
625
626 =head1 COPYRIGHT, LICENSE, AND WARRANTY
627
628-This program is copyright 2011-2013 Percona Ireland Ltd,
629+This program is copyright 2011-2014 Percona Ireland Ltd,
630 2007-2011 Baron Schwartz.
631
632 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
633@@ -11942,6 +11942,6 @@
634
635 =head1 VERSION
636
637-pt-table-checksum 2.1.10
638+pt-table-checksum 2.1.11
639
640 =cut
641
642=== modified file 'bin/pt-table-sync'
643--- bin/pt-table-sync 2014-03-03 22:02:30 +0000
644+++ bin/pt-table-sync 2014-03-04 12:35:02 +0000
645@@ -12613,7 +12613,7 @@
646
647 =head1 COPYRIGHT, LICENSE, AND WARRANTY
648
649-This program is copyright 2011-2013 Percona Ireland Ltd,
650+This program is copyright 2011-2014 Percona Ireland Ltd,
651 2007-2011 Baron Schwartz.
652
653 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
654@@ -12632,6 +12632,6 @@
655
656 =head1 VERSION
657
658-pt-table-sync 2.1.10
659+pt-table-sync 2.1.11
660
661 =cut
662
663=== modified file 'bin/pt-table-usage'
664--- bin/pt-table-usage 2013-07-18 17:31:04 +0000
665+++ bin/pt-table-usage 2014-03-04 12:35:02 +0000
666@@ -7365,7 +7365,7 @@
667
668 =head1 COPYRIGHT, LICENSE, AND WARRANTY
669
670-This program is copyright 2012-2013 Percona Ireland Ltd.
671+This program is copyright 2012-2014 Percona Ireland Ltd.
672
673 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
674 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
675@@ -7383,6 +7383,6 @@
676
677 =head1 VERSION
678
679-pt-table-usage 2.1.10
680+pt-table-usage 2.1.11
681
682 =cut
683
684=== modified file 'bin/pt-tcp-model'
685--- bin/pt-tcp-model 2013-07-18 17:31:04 +0000
686+++ bin/pt-tcp-model 2014-03-04 12:35:02 +0000
687@@ -2513,7 +2513,7 @@
688
689 =head1 COPYRIGHT, LICENSE, AND WARRANTY
690
691-This program is copyright 2011-2013 Percona Ireland Ltd,
692+This program is copyright 2011-2014 Percona Ireland Ltd,
693 2011 Baron Schwartz.
694
695 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
696@@ -2532,6 +2532,6 @@
697
698 =head1 VERSION
699
700-pt-tcp-model 2.1.10
701+pt-tcp-model 2.1.11
702
703 =cut
704
705=== modified file 'bin/pt-trend'
706--- bin/pt-trend 2013-07-18 17:31:04 +0000
707+++ bin/pt-trend 2014-03-04 12:35:02 +0000
708@@ -2214,7 +2214,7 @@
709
710 =head1 COPYRIGHT, LICENSE, AND WARRANTY
711
712-This program is copyright 2011-2013 Percona Ireland Ltd,
713+This program is copyright 2011-2014 Percona Ireland Ltd,
714 2010-2011 Baron Schwartz.
715
716 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
717@@ -2233,6 +2233,6 @@
718
719 =head1 VERSION
720
721-pt-trend 2.1.10
722+pt-trend 2.1.11
723
724 =cut
725
726=== modified file 'bin/pt-upgrade'
727--- bin/pt-upgrade 2014-03-03 22:02:30 +0000
728+++ bin/pt-upgrade 2014-03-04 12:35:02 +0000
729@@ -13132,7 +13132,7 @@
730
731 =head1 COPYRIGHT, LICENSE, AND WARRANTY
732
733-This program is copyright 2009-2013 Percona Ireland Ltd.
734+This program is copyright 2009-2014 Percona Ireland Ltd.
735
736 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
737 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
738@@ -13150,6 +13150,6 @@
739
740 =head1 VERSION
741
742-pt-upgrade 2.1.10
743+pt-upgrade 2.1.11
744
745 =cut
746
747=== modified file 'bin/pt-variable-advisor'
748--- bin/pt-variable-advisor 2014-03-03 22:02:30 +0000
749+++ bin/pt-variable-advisor 2014-03-04 12:35:02 +0000
750@@ -5830,7 +5830,7 @@
751
752 =head1 COPYRIGHT, LICENSE, AND WARRANTY
753
754-This program is copyright 2010-2013 Percona Ireland Ltd.
755+This program is copyright 2010-2014 Percona Ireland Ltd.
756
757 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
758 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
759@@ -5848,6 +5848,6 @@
760
761 =head1 VERSION
762
763-pt-variable-advisor 2.1.10
764+pt-variable-advisor 2.1.11
765
766 =cut
767
768=== modified file 'bin/pt-visual-explain'
769--- bin/pt-visual-explain 2013-07-18 17:31:04 +0000
770+++ bin/pt-visual-explain 2014-03-04 12:35:02 +0000
771@@ -3124,7 +3124,7 @@
772
773 =head1 COPYRIGHT, LICENSE, AND WARRANTY
774
775-This program is copyright 2011-2013 Percona Ireland Ltd,
776+This program is copyright 2011-2014 Percona Ireland Ltd,
777 2007-2011 Baron Schwartz.
778
779 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
780@@ -3143,6 +3143,6 @@
781
782 =head1 VERSION
783
784-pt-visual-explain 2.1.10
785+pt-visual-explain 2.1.11
786
787 =cut
788
789=== modified file 'config/deb/changelog'
790--- config/deb/changelog 2013-07-18 17:31:04 +0000
791+++ config/deb/changelog 2014-03-04 12:35:02 +0000
792@@ -1,3 +1,10 @@
793+percona-toolkit (2.1.11) unstable; urgency=low
794+
795+ * Fixed bug 1279502: --version-check behaves like spyware
796+ * Fixed bug 1199589: pt-archiver deletes data despite --dry-run
797+
798+ -- Percona Toolkit Developers <toolkit-dev@percona.com> Tue, 04 Mar 2014 09:20:40 +0000
799+
800 percona-toolkit (2.1.10) unstable; urgency=low
801
802 * Fixed bug 947893: Some tools use @@hostname without /*!50038*/
803
804=== modified file 'config/sphinx-build/conf.py'
805--- config/sphinx-build/conf.py 2013-07-18 14:49:55 +0000
806+++ config/sphinx-build/conf.py 2014-03-04 12:35:02 +0000
807@@ -50,7 +50,7 @@
808 # The short X.Y version.
809 version = '2.1'
810 # The full version, including alpha/beta/rc tags.
811-release = '2.1.10'
812+release = '2.1.11'
813
814 # The language for content autogenerated by Sphinx. Refer to documentation
815 # for a list of supported languages.
816
817=== modified file 'docs/percona-toolkit.pod'
818--- docs/percona-toolkit.pod 2013-07-18 14:49:55 +0000
819+++ docs/percona-toolkit.pod 2014-03-04 12:35:02 +0000
820@@ -511,7 +511,7 @@
821
822 =head1 COPYRIGHT, LICENSE, AND WARRANTY
823
824-Percona Toolkit is copyright 2011-2013 Percona Ireland Ltd and others.
825+Percona Toolkit is copyright 2011-2014 Percona Ireland Ltd and others.
826 See each program's documentation for complete copyright notices.
827
828 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
829@@ -530,6 +530,6 @@
830
831 =head1 VERSION
832
833-Percona Toolkit v2.1.10 released 2013-07-18
834+Percona Toolkit v2.1.11 released 2014-03-04
835
836 =cut
837
838=== modified file 'docs/release_notes.rst'
839--- docs/release_notes.rst 2013-07-18 17:31:04 +0000
840+++ docs/release_notes.rst 2014-03-04 12:35:02 +0000
841@@ -1,11 +1,1610 @@
842 Release Notes
843 *************
844
845-v2.1.10 released 2013-07-18
846-===========================
847-
848-Release Notes
849-*************
850+v2.1.11 released 2014-03-04
851+===========================
852+
853+Percona Toolkit 2.1.11 has been released. This release includes two bug fixes.
854+
855+* Fixed bug #1199589: pt-archiver deletes data despite --dry-run
856+
857+In some cases pt-archiver would delete the data despite the --dry-run option.
858+
859+* Fixed bug #1279502: --version-check behaves like spyware
860+
861+The 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.
862+
863+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/.
864+
865+Changelog
866+---------
867+
868+* Fixed bug #1199589: pt-archiver deletes data despite --dry-run
869+* Fixed bug #1279502: --version-check behaves like spyware
870+
871+v2.1.10 released 2013-07-18
872+===========================
873+
874+Percona Toolkit 2.1.10 has been released. This release includes eight bug fixes.
875+
876+* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
877+
878+Unfortunately, the relatively new --utc option for pt-heart was still
879+broken because "[MySQL] interprets date as a value in the current time zone
880+and converts it to an internal value in UTC." Now the tool works correctly
881+with --utc by specifying "SET time_zone='+0:00'", and older versions of
882+the tool can be made to work by specifying --set-vars "time_zone='+0:00'".
883+
884+* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
885+
886+Improved the pattern matching that caused the pt-deadlock-logger error when
887+different timestamp format was used.
888+
889+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
890+
891+pt-table-checksum was using the first non-unique index instead of the one
892+with the highest cardinality due to a sorting bug.
893+
894+Percona Toolkit packages can be downloaded from
895+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
896+Repositories (http://www.percona.com/software/repositories/).
897+
898+Changelog
899+---------
900+
901+* Fixed bug #1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
902+* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
903+* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
904+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
905+* Fixed bug #947893: Some tools use @@hostname without /*!50038*/
906+* Fixed bug #1137556: pt-heartbeat docs don't account for --utc
907+* Fixed bug #1146324: pt-query-digest 2.1 typo in docs
908+* Fixed bug #1171968: pt-query-digest docs don't mention --type=rawlog
909+
910+v2.1.9 released 2013-02-14
911+==========================
912+
913+Percona Toolkit 2.1.9 has been released. This release primarily aims to
914+restore backwards-compatibility with pt-heartbeat 2.1.7 and older, but it
915+also has important bug fixes for other tools.
916+
917+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
918+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
919+
920+The previous release switched the time authority from Perl to MySQL, and from
921+local time to UTC. Unfortunately, these changes caused a loss of precision and,
922+if mixing versions of pt-heartbeat, made the tool report a huge amount of
923+replication lag. This release makes the tool compatible with pt-heartbeat
924+2.1.7 and older again, but the UTC behavior introduced in 2.1.8 is now only
925+available by specifying the new --utc option.
926+
927+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
928+
929+This is an important bug fix for pt-table-sync: certain chunks from
930+pt-table-checksum resulted in an impossible WHERE, causing the false-positive
931+"Cannot nibble" error, if those chunks had diffs.
932+
933+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
934+
935+MariaDB 5.5.28 (https://kb.askmonty.org/en/mariadb-5528-changelog/) fixed
936+a bug: "Added warnings for duplicate key errors when using INSERT IGNORE".
937+However, standard MySQL does not warn in this case, despite the docs saying
938+that it should. Since pt-online-schema-change has always intended to ignore
939+duplicate entry errors by using "INSERT IGNORE", it now handles the MariaDB
940+case by also ignoring duplicate entry errors in the code.
941+
942+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
943+
944+pt-online-schema-change 2.1.9 handles another case of changing the primary key.
945+However, since changing the primary key is tricky, the tool stops if --alter
946+contains "DROP PRIMARY KEY", and you have to specify --no-check-alter to
947+acknowledge this case.
948+
949+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
950+
951+Previously, pt-stalk printed a line for every check. Since the tool is
952+designed to be a long-running daemon, this could result in huge log files
953+with "matched=no" lines. The tool has a new --verbose option which makes it
954+quieter by default.
955+
956+All users should upgrade, but in particular, users of versions 2.1.7 and
957+older are strongly recommended to skip 2.1.8 and go directly to 2.1.9.
958+
959+Users of pt-heartbeat in 2.1.8 who prefer the UTC behavior should keep in
960+mind that they will have to use the --utc option after upgrading.
961+
962+Percona Toolkit packages can be downloaded from
963+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
964+Repositories (http://www.percona.com/software/repositories/).
965+
966+Changelog
967+---------
968+
969+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
970+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
971+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
972+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
973+* Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function
974+* Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump
975+* Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors
976+* Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
977+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
978+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
979+
980+v2.1.8 released 2012-12-21
981+==========================
982+
983+Percona 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:
984+
985+* pt-table-chcecksum
986+* pt-online-schema-change
987+* pt-archive
988+* pt-mysql-summary
989+* pt-heartbeat
990+* pt-variable-advisor
991+* pt-config-diff
992+* pt-deadlock-logger
993+
994+However, 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.
995+
996+The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
997+
998+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
999+
1000+Slow 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 */``.
1001+
1002+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1003+
1004+The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.
1005+
1006+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1007+
1008+Some renamed variables had caused the Percona Server section to work unreliably.
1009+
1010+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1011+
1012+When using --replicate-check-only, filter options like --databases and --tables were not applied.
1013+
1014+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1015+
1016+Previously, 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.
1017+
1018+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1019+
1020+Since 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.
1021+
1022+2.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.
1023+
1024+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1025+
1026+Changelog
1027+---------
1028+
1029+* Beta support for MySQL 5.6
1030+* Beta support for Percona XtraDB Cluster
1031+* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1032+* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1033+* pt-upgrade: Added --[no]disable-query-cache
1034+* Fixed bug 927955: Bad pod2rst transformation
1035+* Fixed bug 898665: Bad online docs formatting for --[no]vars
1036+* Fixed bug 1022622: pt-config-diff is case-sensitive
1037+* Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments
1038+* Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
1039+* Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes
1040+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1041+* Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong
1042+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1043+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1044+* Fixed bug 823431: pt-query-advisor hangs on big queries
1045+* Fixed bug 996069: pt-query-advisor RES.001 is incorrect
1046+* Fixed bug 933465: pt-query-advisor false positive on RES.001
1047+* Fixed bug 937234: pt-query-advisor issues wrong RES.001
1048+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
1049+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1050+* Fixed bug 957442: pt-query-digest with custom --group-by throws error
1051+* Fixed bug 887638: pt-query-digest prints negative byte offset
1052+* Fixed bug 831525: pt-query-digest help output mangled
1053+* Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error
1054+* Fixed bug 1046440: pt-stalk purge_samples slows down checks
1055+* Fixed bug 986847: pt-stalk does not report NFS iostat
1056+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1057+* Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used
1058+* Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef
1059+* Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950
1060+* Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611
1061+* Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
1062+
1063+v2.1.7 released 2012-11-19
1064+==========================
1065+
1066+Percona Toolkit 2.1.7 has been released which is a hotfix for two bugs when using pt-table-checksum with Percona XtraDB Cluster:
1067+
1068+* Bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1069+* Bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1070+
1071+If you're using pt-table-checksum with a Percona XtraDB Cluster, you should upgrade. Otherwise, users can wait until the next full release.
1072+
1073+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1074+
1075+Changelog
1076+---------
1077+
1078+* Fixed bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1079+* Fixed bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1080+
1081+v2.1.6 released 2012-11-13
1082+==========================
1083+
1084+Percona 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:
1085+
1086+* Bug 978133: pt-query-digest review table privilege checks don't work
1087+
1088+The 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.
1089+
1090+* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1091+
1092+A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
1093+
1094+* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1095+
1096+If 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.
1097+
1098+* Bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1099+
1100+Fixed by choosing a key on the new table for the DELETE trigger.
1101+
1102+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1103+
1104+A 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.
1105+
1106+* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1107+
1108+This 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.
1109+
1110+* Bug 866075: pt-show-grant doesn't support column-level grants
1111+
1112+This was actually the 'hottest' bug in the tracker.
1113+
1114+This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
1115+
1116+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1117+
1118+Changelog
1119+---------
1120+
1121+* pt-online-schema-change: Columns can now be renamed without data loss
1122+* pt-online-schema-change: New --default-engine option
1123+* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
1124+* Fixed bug 1069951: --version-check default should be explicitly "off"
1125+* Fixed bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1126+* Fixed bug 995896: Useless use of cat in Daemon.pm
1127+* Fixed bug 1039074: Tools exit 0 on error parsing options, should exit non-zero
1128+* Fixed bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1129+* Fixed bug 1009510: pt-table-checksum breaks replication if a slave table is missing or different
1130+* Fixed bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1131+* Fixed bug 1073532: pt-table-checksum error: Use of uninitialized value in int at line 2778
1132+* Fixed bug 1016131: pt-table-checksum can crash with --columns if none match
1133+* Fixed bug 1039569: pt-table-checksum dies if creating the --replicate table fails
1134+* Fixed bug 1059732: pt-table-checksum doesn't test all hash functions
1135+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1136+* Fixed bug 1043528: pt-deadlock-logger can't parse db/tbl/index on partitioned tables
1137+* Fixed bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1138+* Fixed bug 1058285: pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
1139+* Fixed bug 1073996: pt-online-schema-change fails with "I need a max_rows argument"
1140+* Fixed bug 1039541: pt-online-schema-change --quiet doesn't disable --progress
1141+* Fixed bug 1045317: pt-online-schema-change doesn't report how many warnings it suppressed
1142+* Fixed bug 1060774: pt-upgrade fails if select column > 64 chars
1143+* Fixed bug 1070916: pt-mysql-summary may report the wrong cnf file
1144+* Fixed bug 903229: pt-mysql-summary incorrectly categorizes databases
1145+* Fixed bug 866075: pt-show-grant doesn't support column-level grants
1146+* Fixed bug 978133: pt-query-digest review table privilege checks don't work
1147+* Fixed bug 956981: pt-query-digest docs for event attributes link to defunct Maatkit wiki
1148+* Fixed bug 1047335: pt-duplicate-key-checker fails when it encounters a crashed table
1149+* Fixed bug 1047701: pt-stalk deletes non-empty files
1150+* Fixed bug 1070434: pt-stalk --no-stalk and --iterations 1 don't wait for the collect
1151+* Fixed bug 1052722: pt-fifo-split is processing n-1 rows initially
1152+* Fixed bug 1013407: pt-find documentation error with mtime and InnoDB
1153+* Fixed bug 1059757: pt-trend output has no header
1154+* Fixed bug 1063933: pt-visual-explain docs link to missing pdf
1155+* Fixed bug 1075773: pt-fk-error-logger crashes if there's no foreign key error
1156+* Fixed bug 1075775: pt-fk-error-logger --dest table example doesn't work
1157+
1158+v2.1.5 released 2012-10-08
1159+==========================
1160+
1161+Percona 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:
1162+
1163+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1164+
1165+* Bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1166+
1167+* Bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1168+
1169+The 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.
1170+
1171+The 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.
1172+
1173+If 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.
1174+
1175+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1176+
1177+Changelog
1178+---------
1179+
1180+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1181+* Fixed bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1182+* Fixed bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1183+* Fixed bug 1060423: Missing version-check page
1184+
1185+v2.1.4 released 2012-09-20
1186+==========================
1187+
1188+Percona 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:
1189+
1190+* Fixed bug 1017626: pt-table-checksum doesn't work with Percona XtraDB Cluster
1191+
1192+Note 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.
1193+
1194+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1195+
1196+Previously, 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.
1197+
1198+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1199+
1200+Which were stopping pt-upgrade from working on a MySQL 4.1 host.
1201+
1202+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1203+
1204+The same checks were removed in the previous release from pt-table-checksum, so this continues the trend.
1205+
1206+* Fixed bug 1038995: pt-stalk --notify-by-email fails
1207+
1208+This was a bug in our shell option parsing library, and would potentially affect any option starting with 'no'.
1209+
1210+Like 2.1.3, this is another solid bug fix release, and 2.1 users are encouraged to upgrade.
1211+
1212+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1213+
1214+Changelog
1215+---------
1216+
1217+* pt-table-checksum: Percona XtraDB Cluster support
1218+* pt-table-checksum: Implemented the standard --run-time option
1219+* Implemented the version-check feature in several tools, enabled with the --version-check option
1220+* Fixed bug 856060: Document gdb dependency
1221+* Fixed bug 1041394: Unquoted arguments to tr break the bash tools
1222+* Fixed bug 1035311: pt-diskstats shows wrong device names
1223+* Fixed bug 1036804: pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
1224+* Fixed bug 1022658: pt-online-schema-change dropping FK limitation isn't documented
1225+* Fixed bug 1041372: pt-online-schema-changes fails if db+tbl name exceeds 64 characters
1226+* Fixed bug 1029178: pt-query-digest --type tcpdump memory usage keeps increasing
1227+* Fixed bug 1037211: pt-query-digest won't distill LOCK TABLES in lowercase
1228+* Fixed bug 942114: pt-stalk warns about bad "find" usage
1229+* Fixed bug 1035319: pt-stalk df -h throws away needed details
1230+* Fixed bug 1038995: pt-stalk --notify-by-email fails
1231+* Fixed bug 1038995: pt-stalk does not get all InnoDB lock data
1232+* Fixed bug 952722: pt-summary should show information about Fusion-io cards
1233+* Fixed bug 899415: pt-table-checksum doesn't work if slaves use RBR
1234+* Fixed bug 954588: pt-table-checksum --check-slave-lag docs aren't clear
1235+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1236+* Fixed bug 930693: pt-table-sync and text columns with just whitespace
1237+* Fixed bug 1028710: pt-table-sync base_count fails on n = 1000, base = 10
1238+* Fixed bug 1034717: pt-table-sync division by zero error with varchar primary key
1239+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1240+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1241+* Fixed bug 1035260: sh warnings in pt-summary and pt-mysql-summary
1242+* Fixed bug 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values
1243+* Fixed bug 916925: CentOS 5 yum dependency resolution for perl module is wrong
1244+* Fixed bug 1035950: Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
1245+
1246+v2.1.3 released 2012-08-03
1247+==========================
1248+
1249+Percona 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:
1250+
1251+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1252+
1253+pt-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.
1254+
1255+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1256+
1257+In 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.
1258+
1259+* Fixed bug 821703: pt-query-digest --processlist may crash
1260+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1261+
1262+Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.
1263+
1264+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1265+
1266+pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.
1267+
1268+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1269+
1270+The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.
1271+
1272+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1273+
1274+This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.
1275+
1276+All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.
1277+
1278+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1279+
1280+Changelog
1281+---------
1282+
1283+* pt-kill: Implemented --log-dsn to log info about killed queries to a table
1284+* Fixed bug 1016127: Install hint for DBD::mysql is wrong
1285+* Fixed bug 984915: DSNParser does not check success of --set-vars
1286+* Fixed bug 889739: pt-config-diff doesn't diff quoted strings properly
1287+* Fixed bug 969669: pt-duplicate-key-checker --key-types=k doesn't work
1288+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1289+* Fixed bug 1028614: pt-index-usage ignores --database
1290+* Fixed bug 940733: pt-ioprofile leaves behind temp directory
1291+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1292+* Fixed bug 1016114: pt-online-schema-change docs don't mention default values
1293+* Fixed bug 1020997: pt-online-schema-change fails when table is empty
1294+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1295+* Fixed bug 937225: pt-query-advisor OUTER JOIN advice in JOI.003 is confusing
1296+* Fixed bug 821703: pt-query-digest --processlist may crash
1297+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1298+* Fixed bug 924950: pt-query-digest --group-by db may crash profile report
1299+* Fixed bug 1022851: pt-sift error: PREFIX: unbound variable
1300+* Fixed bug 969703: pt-sift defaults to '.' instead of '/var/lib/pt-talk'
1301+* Fixed bug 962330: pt-slave-delay incorrectly computes lag if started when slave is already lagging
1302+* Fixed bug 954990: pt-stalk --nostalk does not work
1303+* Fixed bug 977226: pt-summary doesn't detect LSI RAID control
1304+* Fixed bug 1030031: pt-table-checksum reports wrong number of DIFFS
1305+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1306+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1307+* Fixed bug 953141: pt-table-checksum ignores its default and explicit --recursion-method
1308+* Fixed bug 1030975: pt-table-sync crashes if sql_mode includes ANSI_QUOTES
1309+* Fixed bug 869005: pt-table-sync should always set REPEATABLE READ
1310+* Fixed bug 903510: pt-tcp-model crashes in --type=requests mode on empty file
1311+* Fixed bug 934310: pt-tcp-model --quantile docs wrong
1312+* Fixed bug 980318: pt-upgrade results truncated if hostnames are long
1313+* Fixed bug 821696: pt-variable-advisor shows too long of a snippet
1314+* Fixed bug 844880: pt-variable-advisor shows binary logging as both enabled and disabled
1315+
1316+v2.1.2 released 2012-06-12
1317+==========================
1318+
1319+Percona 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.
1320+
1321+In 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.
1322+
1323+Several 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.
1324+
1325+pt-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.
1326+
1327+Two pt-archiver bugs were fixed: bug 979092, --sleep conflicts with bulk operations; and bug 903379, --file doesn't create a file.
1328+
1329+--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.
1330+
1331+Other 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.
1332+
1333+Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly encouraged to upgrade.
1334+
1335+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1336+
1337+Changelog
1338+---------
1339+
1340+* pt-heartbeat: Implemented --recursion-method=none
1341+* pt-index-usage: MySQL 5.5 compatibility fixes
1342+* pt-log-player: MySQL 5.5 compatibility fixes
1343+* pt-online-schema-change: Added --chunk-index-columns
1344+* pt-online-schema-change: Added --[no]check-plan
1345+* pt-online-schema-change: Added --[no]drop-new-table
1346+* pt-online-schema-change: Implemented --recursion-method=none
1347+* pt-query-advisor: Added --report-type for JSON output
1348+* pt-query-digest: Removed --[no]zero-bool
1349+* pt-slave-delay: Added --database
1350+* pt-slave-find: Implemented --recursion-method=none
1351+* pt-slave-restart: Implemented --recursion-method=none
1352+* pt-table-checksum: Added --chunk-index-columns
1353+* pt-table-checksum: Added --[no]check-plan
1354+* pt-table-checksum: Implemented --recursion-method=none
1355+* pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer
1356+* pt-table-sync: Implemented --recursion-method=none
1357+* Fixed bug 945079: Shell tools TMPDIR may break
1358+* Fixed bug 912902: Some shell tools still use basename
1359+* Fixed bug 987694: There is no --recursion-method=none option
1360+* Fixed bug 886077: Passwords with commas don't work, expose part of password
1361+* Fixed bug 856024: Lintian warnings when building percona-toolkit Debian package
1362+* Fixed bug 903379: pt-archiver --file doesn't create a file
1363+* Fixed bug 979092: pt-archiver --sleep conflicts with bulk operations
1364+* Fixed bug 903443: pt-deadlock-logger crashes on MySQL 5.5
1365+* Fixed bug 941064: pt-deadlock-logger can't clear deadlocks on 5.5
1366+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1367+* Fixed bug 994176: pt-diskstats --group-by=all --headers=scroll prints a header for every sample
1368+* Fixed bug 894140: pt-duplicate-key-checker sometimes recreates a key it shouldn't
1369+* Fixed bug 923896: pt-kill: uninitialized value causes script to exit
1370+* Fixed bug 1003003: pt-online-schema-change uses different keys for chunking and triggers
1371+* Fixed bug 1003315: pt-online-schema-change --dry-run always fails on table with foreign keys
1372+* Fixed bug 1004551: pt-online-schema-change --no-swap-tables causes error
1373+* Fixed bug 976108: pt-online-schema-change doesn't allow to disable foreign key checks
1374+* Fixed bug 976109: pt-online-schema-change doesn't handle column renames
1375+* Fixed bug 988036: pt-online-schema-change causes deadlocks under heavy write load
1376+* Fixed bug 989227: pt-online-schema-change crashes with PTDEBUG
1377+* Fixed bug 994002: pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY
1378+* Fixed bug 994010: pt-online-schema-change 2.1.1 crashes without InnoDB
1379+* Fixed bug 996915: pt-online-schema-change crashes with invalid --max-load and --critical-load
1380+* Fixed bug 998831: pt-online-schema-change -- Should have an option to NOT drop tables on failure
1381+* Fixed bug 1002448: pt-online-schema-change: typo for finding usable indexes
1382+* Fixed bug 885382: pt-query-digest --embedded-attributes doesn't check cardinality
1383+* Fixed bug 888114: pt-query-digest report crashes with infinite loop
1384+* Fixed bug 949630: pt-query-digest mentions a Subversion repository
1385+* Fixed bug 844034: pt-show-grants --separate fails with proxy user
1386+* Fixed bug 946707: pt-sift loses STDIN after pt-diskstats
1387+* Fixed bug 994947: pt-stalk doesn't reset cycles_true after collection
1388+* Fixed bug 986151: pt-stalk-has mktemp error
1389+* Fixed bug 993436: pt-summary Memory: Total reports M instead of G
1390+* Fixed bug 1008778: pt-table-checksum doesn't wait for checksum table to replicate
1391+* Fixed bug 1010232: pt-table-checksum doesn't check the size of checksum chunks
1392+* Fixed bug 1011738: pt-table-checksum SKIPPED is zero but chunks were skipped
1393+* Fixed bug 919499: pt-table-checksum fails with binary log error in mysql >= 5.5.18
1394+* Fixed bug 972399: pt-table-checksum docs are not rendered right
1395+* Fixed bug 978432: pt-table-checksum ignoring primary key
1396+* Fixed bug 995274: pt-table-checksum can't use an undefined value as an ARRAY reference at line 2206
1397+* Fixed bug 996110: pt-table-checksum crashes if InnoDB is disabled
1398+* Fixed bug 987393: pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
1399+* Fixed bug 1002365: pt-table-sync --ignore-* options don't work with --replicate
1400+* Fixed bug 1003014: pt-table-sync --replicate and --sync-to-master error "index does not exist"
1401+* Fixed bug 823403: pt-table-sync --lock-and-rename doesn't work on 5.1
1402+* Fixed bug 898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values
1403+
1404+v2.1.1 released 2012-04-03
1405+==========================
1406+
1407+Percona Toolkit 2.1.1 has been released. This is the first release in the
1408+new 2.1 series which supersedes the 2.0 series. We will continue to fix bugs
1409+in 2.0, but 2.1 is now the focus of development.
1410+
1411+2.1 introduces a lot of new code for:
1412+
1413+* pt-online-schema-change (completely redesigned)
1414+* pt-mysql-summary (completely redesigned)
1415+* pt-summary (completely redesigned)
1416+* pt-fingerprint (new tool)
1417+* pt-table-usage (new tool)
1418+
1419+There were also several bug fixes.
1420+
1421+The redesigned tools are meant to replace their 2.0 counterparts because
1422+the 2.1 versions have the same or more functionality and they are simpler
1423+and more reliable. pt-online-schema-change was particularly enhanced to
1424+be as safe as possible given that the tool is inherently risky.
1425+
1426+Percona Toolkit packages can be downloaded from
1427+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1428+Repositories (http://www.percona.com/software/repositories/).
1429+
1430+Changelog
1431+---------
1432+
1433+* Completely redesigned pt-online-schema-change
1434+* Completely redesigned pt-mysql-summary
1435+* Completely redesigned pt-summary
1436+* Added new tool: pt-table-usage
1437+* Added new tool: pt-fingerprint
1438+* Fixed bug 955860: pt-stalk doesn't run vmstat, iostat, and mpstat for --run-time
1439+* Fixed bug 960513: SHOW TABLE STATUS is used needlessly
1440+* Fixed bug 969726: pt-online-schema-change loses foreign keys
1441+* Fixed bug 846028: pt-online-schema-change does not show progress until completed
1442+* Fixed bug 898695: pt-online-schema-change add useless ORDER BY
1443+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1444+* Fixed bug 963225: pt-query-digest fails to set history columns for disk tmp tables and disk filesort
1445+* Fixed bug 967451: Char chunking doesn't quote column name
1446+* Fixed bug 972399: pt-table-checksum docs are not rendered right
1447+* Fixed bug 896553: Various documentation spelling fixes
1448+* Fixed bug 949154: pt-variable-advisor advice for relay-log-space-limit
1449+* Fixed bug 953461: pt-upgrade manual broken 'output' section
1450+* Fixed bug 949653: pt-table-checksum docs don't mention risks posed by inconsistent schemas
1451+
1452+v2.0.4 released 2012-03-07
1453+==========================
1454+
1455+Percona Toolkit 2.0.4 has been released. 23 bugs were fixed in this release,
1456+and three new features were implemented. First, --filter was added to pt-kill
1457+which allows for arbitrary --group-by. Second, pt-online-schema-change now
1458+requires that its new --execute option be given, else the tool will just check
1459+the tables and exit. This is a safeguard to encourage users to read the
1460+documentation, particularly when replication is involved. Third, pt-stalk
1461+also received a new option: --[no]stalk. To collect immediately without
1462+stalking, specify --no-stalk and the tool will collect once and exit.
1463+
1464+This release is completely backwards compatible with previous 2.0 releases.
1465+Given the number of bug fixes, it's worth upgrading to 2.0.4.
1466+
1467+Changelog
1468+---------
1469+
1470+* Added --filter to pt-kill to allow arbitrary --group-by
1471+* Added --[no]stalk to pt-stalk (bug 932331)
1472+* Added --execute to pt-online-schema-change (bug 933232)
1473+* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
1474+* Fixed bug 928966: pt-pmp still uses insecure /tmp
1475+* Fixed bug 933232: pt-online-schema-change can break replication
1476+* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
1477+* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
1478+* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
1479+* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
1480+* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
1481+* Fixed bug 928226: pt-diskstats illegal division by zero
1482+* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
1483+* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
1484+* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
1485+* Fixed bug 932331: pt-stalk cannot collect without stalking
1486+* Fixed bug 932442: pt-table-checksum error when column name has two spaces
1487+* Fixed bug 932883: File Debian bug after each release
1488+* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
1489+* Fixed bug 944420: --daemonize doesn't always close STDIN
1490+* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
1491+* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
1492+* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
1493+* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
1494+* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
1495+* Fixed bug 940440: Bad grammar in pt-kill docs
1496+
1497+v2.0.3 released 2012-02-03
1498+==========================
1499+
1500+Percona Toolkit 2.0.3 has been released. The development team was very
1501+busy last month making this release significant: two completely
1502+redesigned and improved tools, pt-diskstats and pt-stalk, and 20 bug fixes.
1503+
1504+Both pt-diskstats and pt-stalk were redesigned and rewritten from the ground
1505+up. This allowed us to greatly improve these tools' functionality and
1506+increase testing for them. The accuracy and output of pt-diskstats was
1507+enhanced, and the tool was rewritten in Perl. pt-collect was removed and
1508+its functionality was put into a new, enhanced pt-stalk. pt-stalk is now
1509+designed to be a stable, long-running daemon on a variety of common platforms.
1510+It is worth re-reading the documentation for each of these tools.
1511+
1512+The 20 bug fixes cover a wide range of problems. The most important are
1513+fixes to pt-table-checksum, pt-iostats, and pt-kill. Apart from pt-diskstats,
1514+pt-stalk, and pt-collect (which was removed), no other tools were changed
1515+in backwards-incompatible ways, so it is worth reviewing the full changelog
1516+for this release and upgrading if you use any tools which had bug fixes.
1517+
1518+Thank you to the many people who reported bugs and submitted patches.
1519+
1520+Download the latest release of Percona Toolkit 2.0 from
1521+http://www.percona.com/software/percona-toolkit/
1522+or the Percona Software Repositories
1523+(http://www.percona.com/docs/wiki/repositories:start).
1524+
1525+Changelog
1526+---------
1527+
1528+* Completely redesigned pt-diskstats
1529+* Completely redesigned pt-stalk
1530+* Removed pt-collect and put its functionality in pt-stalk
1531+* Fixed bug 871438: Bash tools are insecure
1532+* Fixed bug 897758: Failed to prepare TableSyncChunk plugin: Use of uninitialized value $args{"chunk_range"} in lc at pt-table-sync line 3055
1533+* Fixed bug 919819: pt-kill --execute-command creates zombies
1534+* Fixed bug 925778: pt-ioprofile doesn't run without a file
1535+* Fixed bug 925477: pt-ioprofile docs refer to pt-iostats
1536+* Fixed bug 857091: pt-sift downloads http://percona.com/get/pt-pmp, which does not work
1537+* Fixed bug 857104: pt-sift tries to invoke mext, should be pt-mext
1538+* Fixed bug 872699: pt-diskstats: rd_avkb & wr_avkb derived incorrectly
1539+* Fixed bug 897029: pt-diskstats computes wrong values for md0
1540+* Fixed bug 882918: pt-stalk spams warning if oprofile isn't installed
1541+* Fixed bug 884504: pt-stalk doesn't check pt-collect
1542+* Fixed bug 897483: pt-online-schema-change "uninitialized value" due to update-foreign-keys-method
1543+* Fixed bug 925007: pt-online-schema-change Use of uninitialized value $tables{"old_table"} in concatenation (.) or string at line 4330
1544+* Fixed bug 915598: pt-config-diff ignores --ask-pass option
1545+* Fixed bug 919352: pt-table-checksum changes binlog_format even if already set to statement
1546+* Fixed bug 921700: pt-table-checksum doesn't add --where to chunk size test on replicas
1547+* Fixed bug 921802: pt-table-checksum does not recognize --recursion-method=processlist
1548+* Fixed bug 925855: pt-table-checksum index check is case-sensitive
1549+* Fixed bug 821709: pt-show-grants --revoke and --separate don't work together
1550+* Fixed bug 918247: Some tools use VALUE instead of VALUES
1551+
1552+v2.0.2 released 2012-01-05
1553+==========================
1554+
1555+Percona Toolkit 2.0.2 fixes one critical bug: pt-table-sync --replicate
1556+did not work with character values, causing an "Unknown column" error.
1557+If using Percona Toolkit 2.0.1, you should upgrade to 2.0.2.
1558+
1559+Download the latest release of Percona Toolkit 2.0 from
1560+http://www.percona.com/software/percona-toolkit/
1561+or the Percona Software Repositories
1562+(http://www.percona.com/docs/wiki/repositories:start).
1563+
1564+Changelog
1565+---------
1566+
1567+* Fixed bug 911996: pt-table-sync --replicate causes "Unknown column" error
1568+
1569+v2.0.1 released 2011-12-30
1570+==========================
1571+
1572+The Percona Toolkit development team is proud to announce a new major version:
1573+2.0. Beginning with Percona Toolkit 2.0, we are overhauling, redesigning, and
1574+improving the major tools. 2.0 tools are therefore not backwards compatible
1575+with 1.0 tools, which we still support but will not continue to develop.
1576+
1577+New in Percona Toolkit 2.0.1 is a completely redesigned pt-table-checksum.
1578+The original pt-table-checksum 1.0 was rather complex, but it worked well
1579+for many years. By contrast, the new pt-table-checksum 2.0 is much simpler but
1580+also much more efficient and reliable. We spent months rethinking, redesigning,
1581+and testing every aspect of the tool. The three most significant changes:
1582+pt-table-checksum 2.0 does only --replicate, it has only one chunking algorithm,
1583+and its memory usage is stable even with hundreds of thousands of tables and
1584+trillions of rows. The tool is now dedicated to verifying MySQL replication
1585+integrity, nothing else, which it does extremely well.
1586+
1587+In Percona Toolkit 2.0.1 we also fixed various small bugs and forked ioprofile
1588+and align (as pt-ioprofile and pt-align) from Aspersa.
1589+
1590+If you still need functionalities in the original pt-table-checksum,
1591+the latest Percona Toolkit 1.0 release remains available for download.
1592+Otherwise, all new development in Percona Toolkit will happen in 2.0.
1593+
1594+Download the latest release of Percona Toolkit 2.0 from
1595+http://www.percona.com/software/percona-toolkit/
1596+or the Percona Software Repositories
1597+(http://www.percona.com/docs/wiki/repositories:start).
1598+
1599+Changelog
1600+---------
1601+
1602+* Completely redesigned pt-table-checksum
1603+* Fixed bug 856065: pt-trend does not work
1604+* Fixed bug 887688: Prepared statements crash pt-query-digest
1605+* Fixed bug 888286: align not part of percona-toolkit
1606+* Fixed bug 897961: ptc 2.0 replicate-check error does not include hostname
1607+* Fixed bug 898318: ptc 2.0 --resume with --tables does not always work
1608+* Fixed bug 903513: MKDEBUG should be PTDEBUG
1609+* Fixed bug 908256: Percona Toolkit should include pt-ioprofile
1610+* Fixed bug 821717: pt-tcp-model --type=requests crashes
1611+* Fixed bug 844038: pt-online-schema-change documentation example w/drop-tmp-table does not work
1612+* Fixed bug 864205: Remove the query to reset @crc from pt-table-checksum
1613+* Fixed bug 898663: Typo in pt-log-player documentation
1614+
1615+v1.0.1 released 2011-09-01
1616+==========================
1617+
1618+Percona Toolkit 1.0.1 has been released. In July, Baron announced planned
1619+changes to Maatkit and Aspersa development;[1] Percona Toolkit is the
1620+result. In brief, Percona Toolkit is the combined fork of Maatkit and
1621+Aspersa, so although the toolkit is new, the programs are not. That means
1622+Percona Toolkit 1.0.1 is mature, stable, and production-ready. In fact,
1623+it's even a little more stable because we fixed a few bugs in this release.
1624+
1625+Percona Toolkit packages can be downloaded from
1626+http://www.percona.com/downloads/percona-toolkit/
1627+or the Percona Software Repositories
1628+(http://www.percona.com/docs/wiki/repositories:start).
1629+
1630+Although Maatkit and Aspersa development use Google Code, Percona Toolkit
1631+uses Launchpad: https://launchpad.net/percona-toolkit
1632+
1633+[1] http://www.xaprb.com/blog/2011/07/06/planned-change-in-maatkit-aspersa-development/
1634+
1635+Changelog
1636+---------
1637+
1638+* Fixed bug 819421: MasterSlave::is_replication_thread() doesn't match all
1639+* Fixed bug 821673: pt-table-checksum doesn't include --where in min max queries
1640+* Fixed bug 821688: pt-table-checksum SELECT MIN MAX for char chunking is wrong
1641+* Fixed bug 838211: pt-collect: line 24: [: : integer expression expected
1642+* Fixed bug 838248: pt-collect creates a "5.1" file
1643+
1644+v0.9.5 released 2011-08-04
1645+==========================
1646+
1647+Percona 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.
1648+
1649+Changelog
1650+---------
1651+
1652+* Forked, combined, and rebranded Maatkit and Aspersa as Percona Toolkit.
1653+
1654+Changelog
1655+---------
1656+
1657+* Fixed bug 947893: Some tools use @@hostname without /*!50038*/
1658+* Fixed bug 1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
1659+* Fixed bug 1163372: pt-heartbeat --utc --check always returns 0
1660+* Fixed bug 1137556: pt-heartbeat docs don't account for --utc
1661+* Fixed bug 1146324: pt-query-digest 2.1 typo in docs
1662+* Fixed bug 1171968: pt-query-digest docs don't mention --type=rawlog
1663+* Fixed bug 1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
1664+* Fixed bug 1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
1665+
1666+v2.1.10 released 2013-07-18
1667+===========================
1668+
1669+Percona Toolkit 2.1.10 has been released. This release includes eight bug fixes.
1670+
1671+* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
1672+
1673+Unfortunately, the relatively new --utc option for pt-heart was still
1674+broken because "[MySQL] interprets date as a value in the current time zone
1675+and converts it to an internal value in UTC." Now the tool works correctly
1676+with --utc by specifying "SET time_zone='+0:00'", and older versions of
1677+the tool can be made to work by specifying --set-vars "time_zone='+0:00'".
1678+
1679+* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
1680+
1681+Improved the pattern matching that caused the pt-deadlock-logger error when
1682+different timestamp format was used.
1683+
1684+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
1685+
1686+pt-table-checksum was using the first non-unique index instead of the one
1687+with the highest cardinality due to a sorting bug.
1688+
1689+Percona Toolkit packages can be downloaded from
1690+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1691+Repositories (http://www.percona.com/software/repositories/).
1692+
1693+Changelog
1694+---------
1695+
1696+* Fixed bug #1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
1697+* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
1698+* Fixed bug #1163372: pt-heartbeat --utc --check always returns 0
1699+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
1700+* Fixed bug #947893: Some tools use @@hostname without /*!50038*/
1701+* Fixed bug #1137556: pt-heartbeat docs don't account for --utc
1702+* Fixed bug #1146324: pt-query-digest 2.1 typo in docs
1703+* Fixed bug #1171968: pt-query-digest docs don't mention --type=rawlog
1704+
1705+v2.1.9 released 2013-02-14
1706+==========================
1707+
1708+Percona Toolkit 2.1.9 has been released. This release primarily aims to
1709+restore backwards-compatibility with pt-heartbeat 2.1.7 and older, but it
1710+also has important bug fixes for other tools.
1711+
1712+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
1713+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
1714+
1715+The previous release switched the time authority from Perl to MySQL, and from
1716+local time to UTC. Unfortunately, these changes caused a loss of precision and,
1717+if mixing versions of pt-heartbeat, made the tool report a huge amount of
1718+replication lag. This release makes the tool compatible with pt-heartbeat
1719+2.1.7 and older again, but the UTC behavior introduced in 2.1.8 is now only
1720+available by specifying the new --utc option.
1721+
1722+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
1723+
1724+This is an important bug fix for pt-table-sync: certain chunks from
1725+pt-table-checksum resulted in an impossible WHERE, causing the false-positive
1726+"Cannot nibble" error, if those chunks had diffs.
1727+
1728+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
1729+
1730+MariaDB 5.5.28 (https://kb.askmonty.org/en/mariadb-5528-changelog/) fixed
1731+a bug: "Added warnings for duplicate key errors when using INSERT IGNORE".
1732+However, standard MySQL does not warn in this case, despite the docs saying
1733+that it should. Since pt-online-schema-change has always intended to ignore
1734+duplicate entry errors by using "INSERT IGNORE", it now handles the MariaDB
1735+case by also ignoring duplicate entry errors in the code.
1736+
1737+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
1738+
1739+pt-online-schema-change 2.1.9 handles another case of changing the primary key.
1740+However, since changing the primary key is tricky, the tool stops if --alter
1741+contains "DROP PRIMARY KEY", and you have to specify --no-check-alter to
1742+acknowledge this case.
1743+
1744+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
1745+
1746+Previously, pt-stalk printed a line for every check. Since the tool is
1747+designed to be a long-running daemon, this could result in huge log files
1748+with "matched=no" lines. The tool has a new --verbose option which makes it
1749+quieter by default.
1750+
1751+All users should upgrade, but in particular, users of versions 2.1.7 and
1752+older are strongly recommended to skip 2.1.8 and go directly to 2.1.9.
1753+
1754+Users of pt-heartbeat in 2.1.8 who prefer the UTC behavior should keep in
1755+mind that they will have to use the --utc option after upgrading.
1756+
1757+Percona Toolkit packages can be downloaded from
1758+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1759+Repositories (http://www.percona.com/software/repositories/).
1760+
1761+Changelog
1762+---------
1763+
1764+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
1765+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
1766+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
1767+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
1768+* Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function
1769+* Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump
1770+* Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors
1771+* Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
1772+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
1773+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
1774+
1775+v2.1.8 released 2012-12-21
1776+==========================
1777+
1778+Percona 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:
1779+
1780+* pt-table-chcecksum
1781+* pt-online-schema-change
1782+* pt-archive
1783+* pt-mysql-summary
1784+* pt-heartbeat
1785+* pt-variable-advisor
1786+* pt-config-diff
1787+* pt-deadlock-logger
1788+
1789+However, 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.
1790+
1791+The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
1792+
1793+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
1794+
1795+Slow 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 */``.
1796+
1797+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1798+
1799+The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.
1800+
1801+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1802+
1803+Some renamed variables had caused the Percona Server section to work unreliably.
1804+
1805+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1806+
1807+When using --replicate-check-only, filter options like --databases and --tables were not applied.
1808+
1809+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1810+
1811+Previously, 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.
1812+
1813+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1814+
1815+Since 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.
1816+
1817+2.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.
1818+
1819+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1820+
1821+Changelog
1822+---------
1823+
1824+* Beta support for MySQL 5.6
1825+* Beta support for Percona XtraDB Cluster
1826+* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1827+* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1828+* pt-upgrade: Added --[no]disable-query-cache
1829+* Fixed bug 927955: Bad pod2rst transformation
1830+* Fixed bug 898665: Bad online docs formatting for --[no]vars
1831+* Fixed bug 1022622: pt-config-diff is case-sensitive
1832+* Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments
1833+* Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
1834+* Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes
1835+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1836+* Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong
1837+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1838+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1839+* Fixed bug 823431: pt-query-advisor hangs on big queries
1840+* Fixed bug 996069: pt-query-advisor RES.001 is incorrect
1841+* Fixed bug 933465: pt-query-advisor false positive on RES.001
1842+* Fixed bug 937234: pt-query-advisor issues wrong RES.001
1843+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
1844+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1845+* Fixed bug 957442: pt-query-digest with custom --group-by throws error
1846+* Fixed bug 887638: pt-query-digest prints negative byte offset
1847+* Fixed bug 831525: pt-query-digest help output mangled
1848+* Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error
1849+* Fixed bug 1046440: pt-stalk purge_samples slows down checks
1850+* Fixed bug 986847: pt-stalk does not report NFS iostat
1851+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1852+* Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used
1853+* Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef
1854+* Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950
1855+* Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611
1856+* Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
1857+
1858+v2.1.7 released 2012-11-19
1859+==========================
1860+
1861+Percona Toolkit 2.1.7 has been released which is a hotfix for two bugs when using pt-table-checksum with Percona XtraDB Cluster:
1862+
1863+* Bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1864+* Bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1865+
1866+If you're using pt-table-checksum with a Percona XtraDB Cluster, you should upgrade. Otherwise, users can wait until the next full release.
1867+
1868+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1869+
1870+Changelog
1871+---------
1872+
1873+* Fixed bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1874+* Fixed bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1875+
1876+v2.1.6 released 2012-11-13
1877+==========================
1878+
1879+Percona 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:
1880+
1881+* Bug 978133: pt-query-digest review table privilege checks don't work
1882+
1883+The 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.
1884+
1885+* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1886+
1887+A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
1888+
1889+* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1890+
1891+If 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.
1892+
1893+* Bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1894+
1895+Fixed by choosing a key on the new table for the DELETE trigger.
1896+
1897+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1898+
1899+A 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.
1900+
1901+* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1902+
1903+This 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.
1904+
1905+* Bug 866075: pt-show-grant doesn't support column-level grants
1906+
1907+This was actually the 'hottest' bug in the tracker.
1908+
1909+This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
1910+
1911+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1912+
1913+Changelog
1914+---------
1915+
1916+* pt-online-schema-change: Columns can now be renamed without data loss
1917+* pt-online-schema-change: New --default-engine option
1918+* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
1919+* Fixed bug 1069951: --version-check default should be explicitly "off"
1920+* Fixed bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1921+* Fixed bug 995896: Useless use of cat in Daemon.pm
1922+* Fixed bug 1039074: Tools exit 0 on error parsing options, should exit non-zero
1923+* Fixed bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1924+* Fixed bug 1009510: pt-table-checksum breaks replication if a slave table is missing or different
1925+* Fixed bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1926+* Fixed bug 1073532: pt-table-checksum error: Use of uninitialized value in int at line 2778
1927+* Fixed bug 1016131: pt-table-checksum can crash with --columns if none match
1928+* Fixed bug 1039569: pt-table-checksum dies if creating the --replicate table fails
1929+* Fixed bug 1059732: pt-table-checksum doesn't test all hash functions
1930+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1931+* Fixed bug 1043528: pt-deadlock-logger can't parse db/tbl/index on partitioned tables
1932+* Fixed bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1933+* Fixed bug 1058285: pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
1934+* Fixed bug 1073996: pt-online-schema-change fails with "I need a max_rows argument"
1935+* Fixed bug 1039541: pt-online-schema-change --quiet doesn't disable --progress
1936+* Fixed bug 1045317: pt-online-schema-change doesn't report how many warnings it suppressed
1937+* Fixed bug 1060774: pt-upgrade fails if select column > 64 chars
1938+* Fixed bug 1070916: pt-mysql-summary may report the wrong cnf file
1939+* Fixed bug 903229: pt-mysql-summary incorrectly categorizes databases
1940+* Fixed bug 866075: pt-show-grant doesn't support column-level grants
1941+* Fixed bug 978133: pt-query-digest review table privilege checks don't work
1942+* Fixed bug 956981: pt-query-digest docs for event attributes link to defunct Maatkit wiki
1943+* Fixed bug 1047335: pt-duplicate-key-checker fails when it encounters a crashed table
1944+* Fixed bug 1047701: pt-stalk deletes non-empty files
1945+* Fixed bug 1070434: pt-stalk --no-stalk and --iterations 1 don't wait for the collect
1946+* Fixed bug 1052722: pt-fifo-split is processing n-1 rows initially
1947+* Fixed bug 1013407: pt-find documentation error with mtime and InnoDB
1948+* Fixed bug 1059757: pt-trend output has no header
1949+* Fixed bug 1063933: pt-visual-explain docs link to missing pdf
1950+* Fixed bug 1075773: pt-fk-error-logger crashes if there's no foreign key error
1951+* Fixed bug 1075775: pt-fk-error-logger --dest table example doesn't work
1952+
1953+v2.1.5 released 2012-10-08
1954+==========================
1955+
1956+Percona 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:
1957+
1958+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1959+
1960+* Bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1961+
1962+* Bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1963+
1964+The 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.
1965+
1966+The 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.
1967+
1968+If 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.
1969+
1970+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
1971+
1972+Changelog
1973+---------
1974+
1975+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1976+* Fixed bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1977+* Fixed bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1978+* Fixed bug 1060423: Missing version-check page
1979+
1980+v2.1.4 released 2012-09-20
1981+==========================
1982+
1983+Percona 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:
1984+
1985+* Fixed bug 1017626: pt-table-checksum doesn't work with Percona XtraDB Cluster
1986+
1987+Note 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.
1988+
1989+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1990+
1991+Previously, 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.
1992+
1993+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1994+
1995+Which were stopping pt-upgrade from working on a MySQL 4.1 host.
1996+
1997+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1998+
1999+The same checks were removed in the previous release from pt-table-checksum, so this continues the trend.
2000+
2001+* Fixed bug 1038995: pt-stalk --notify-by-email fails
2002+
2003+This was a bug in our shell option parsing library, and would potentially affect any option starting with 'no'.
2004+
2005+Like 2.1.3, this is another solid bug fix release, and 2.1 users are encouraged to upgrade.
2006+
2007+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
2008+
2009+Changelog
2010+---------
2011+
2012+* pt-table-checksum: Percona XtraDB Cluster support
2013+* pt-table-checksum: Implemented the standard --run-time option
2014+* Implemented the version-check feature in several tools, enabled with the --version-check option
2015+* Fixed bug 856060: Document gdb dependency
2016+* Fixed bug 1041394: Unquoted arguments to tr break the bash tools
2017+* Fixed bug 1035311: pt-diskstats shows wrong device names
2018+* Fixed bug 1036804: pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
2019+* Fixed bug 1022658: pt-online-schema-change dropping FK limitation isn't documented
2020+* Fixed bug 1041372: pt-online-schema-changes fails if db+tbl name exceeds 64 characters
2021+* Fixed bug 1029178: pt-query-digest --type tcpdump memory usage keeps increasing
2022+* Fixed bug 1037211: pt-query-digest won't distill LOCK TABLES in lowercase
2023+* Fixed bug 942114: pt-stalk warns about bad "find" usage
2024+* Fixed bug 1035319: pt-stalk df -h throws away needed details
2025+* Fixed bug 1038995: pt-stalk --notify-by-email fails
2026+* Fixed bug 1038995: pt-stalk does not get all InnoDB lock data
2027+* Fixed bug 952722: pt-summary should show information about Fusion-io cards
2028+* Fixed bug 899415: pt-table-checksum doesn't work if slaves use RBR
2029+* Fixed bug 954588: pt-table-checksum --check-slave-lag docs aren't clear
2030+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
2031+* Fixed bug 930693: pt-table-sync and text columns with just whitespace
2032+* Fixed bug 1028710: pt-table-sync base_count fails on n = 1000, base = 10
2033+* Fixed bug 1034717: pt-table-sync division by zero error with varchar primary key
2034+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
2035+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
2036+* Fixed bug 1035260: sh warnings in pt-summary and pt-mysql-summary
2037+* Fixed bug 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values
2038+* Fixed bug 916925: CentOS 5 yum dependency resolution for perl module is wrong
2039+* Fixed bug 1035950: Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
2040+
2041+v2.1.3 released 2012-08-03
2042+==========================
2043+
2044+Percona 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:
2045+
2046+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
2047+
2048+pt-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.
2049+
2050+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
2051+
2052+In 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.
2053+
2054+* Fixed bug 821703: pt-query-digest --processlist may crash
2055+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
2056+
2057+Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.
2058+
2059+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
2060+
2061+pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.
2062+
2063+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
2064+
2065+The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.
2066+
2067+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
2068+
2069+This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.
2070+
2071+All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.
2072+
2073+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
2074+
2075+Changelog
2076+---------
2077+
2078+* pt-kill: Implemented --log-dsn to log info about killed queries to a table
2079+* Fixed bug 1016127: Install hint for DBD::mysql is wrong
2080+* Fixed bug 984915: DSNParser does not check success of --set-vars
2081+* Fixed bug 889739: pt-config-diff doesn't diff quoted strings properly
2082+* Fixed bug 969669: pt-duplicate-key-checker --key-types=k doesn't work
2083+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
2084+* Fixed bug 1028614: pt-index-usage ignores --database
2085+* Fixed bug 940733: pt-ioprofile leaves behind temp directory
2086+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
2087+* Fixed bug 1016114: pt-online-schema-change docs don't mention default values
2088+* Fixed bug 1020997: pt-online-schema-change fails when table is empty
2089+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
2090+* Fixed bug 937225: pt-query-advisor OUTER JOIN advice in JOI.003 is confusing
2091+* Fixed bug 821703: pt-query-digest --processlist may crash
2092+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
2093+* Fixed bug 924950: pt-query-digest --group-by db may crash profile report
2094+* Fixed bug 1022851: pt-sift error: PREFIX: unbound variable
2095+* Fixed bug 969703: pt-sift defaults to '.' instead of '/var/lib/pt-talk'
2096+* Fixed bug 962330: pt-slave-delay incorrectly computes lag if started when slave is already lagging
2097+* Fixed bug 954990: pt-stalk --nostalk does not work
2098+* Fixed bug 977226: pt-summary doesn't detect LSI RAID control
2099+* Fixed bug 1030031: pt-table-checksum reports wrong number of DIFFS
2100+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
2101+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
2102+* Fixed bug 953141: pt-table-checksum ignores its default and explicit --recursion-method
2103+* Fixed bug 1030975: pt-table-sync crashes if sql_mode includes ANSI_QUOTES
2104+* Fixed bug 869005: pt-table-sync should always set REPEATABLE READ
2105+* Fixed bug 903510: pt-tcp-model crashes in --type=requests mode on empty file
2106+* Fixed bug 934310: pt-tcp-model --quantile docs wrong
2107+* Fixed bug 980318: pt-upgrade results truncated if hostnames are long
2108+* Fixed bug 821696: pt-variable-advisor shows too long of a snippet
2109+* Fixed bug 844880: pt-variable-advisor shows binary logging as both enabled and disabled
2110+
2111+v2.1.2 released 2012-06-12
2112+==========================
2113+
2114+Percona 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.
2115+
2116+In 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.
2117+
2118+Several 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.
2119+
2120+pt-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.
2121+
2122+Two pt-archiver bugs were fixed: bug 979092, --sleep conflicts with bulk operations; and bug 903379, --file doesn't create a file.
2123+
2124+--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.
2125+
2126+Other 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.
2127+
2128+Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly encouraged to upgrade.
2129+
2130+Percona Toolkit packages can be downloaded from http://www.percona.com/downloads/percona-toolkit/ or the Percona Software Repositories (http://www.percona.com/software/repositories/).
2131+
2132+Changelog
2133+---------
2134+
2135+* pt-heartbeat: Implemented --recursion-method=none
2136+* pt-index-usage: MySQL 5.5 compatibility fixes
2137+* pt-log-player: MySQL 5.5 compatibility fixes
2138+* pt-online-schema-change: Added --chunk-index-columns
2139+* pt-online-schema-change: Added --[no]check-plan
2140+* pt-online-schema-change: Added --[no]drop-new-table
2141+* pt-online-schema-change: Implemented --recursion-method=none
2142+* pt-query-advisor: Added --report-type for JSON output
2143+* pt-query-digest: Removed --[no]zero-bool
2144+* pt-slave-delay: Added --database
2145+* pt-slave-find: Implemented --recursion-method=none
2146+* pt-slave-restart: Implemented --recursion-method=none
2147+* pt-table-checksum: Added --chunk-index-columns
2148+* pt-table-checksum: Added --[no]check-plan
2149+* pt-table-checksum: Implemented --recursion-method=none
2150+* pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer
2151+* pt-table-sync: Implemented --recursion-method=none
2152+* Fixed bug 945079: Shell tools TMPDIR may break
2153+* Fixed bug 912902: Some shell tools still use basename
2154+* Fixed bug 987694: There is no --recursion-method=none option
2155+* Fixed bug 886077: Passwords with commas don't work, expose part of password
2156+* Fixed bug 856024: Lintian warnings when building percona-toolkit Debian package
2157+* Fixed bug 903379: pt-archiver --file doesn't create a file
2158+* Fixed bug 979092: pt-archiver --sleep conflicts with bulk operations
2159+* Fixed bug 903443: pt-deadlock-logger crashes on MySQL 5.5
2160+* Fixed bug 941064: pt-deadlock-logger can't clear deadlocks on 5.5
2161+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
2162+* Fixed bug 994176: pt-diskstats --group-by=all --headers=scroll prints a header for every sample
2163+* Fixed bug 894140: pt-duplicate-key-checker sometimes recreates a key it shouldn't
2164+* Fixed bug 923896: pt-kill: uninitialized value causes script to exit
2165+* Fixed bug 1003003: pt-online-schema-change uses different keys for chunking and triggers
2166+* Fixed bug 1003315: pt-online-schema-change --dry-run always fails on table with foreign keys
2167+* Fixed bug 1004551: pt-online-schema-change --no-swap-tables causes error
2168+* Fixed bug 976108: pt-online-schema-change doesn't allow to disable foreign key checks
2169+* Fixed bug 976109: pt-online-schema-change doesn't handle column renames
2170+* Fixed bug 988036: pt-online-schema-change causes deadlocks under heavy write load
2171+* Fixed bug 989227: pt-online-schema-change crashes with PTDEBUG
2172+* Fixed bug 994002: pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY
2173+* Fixed bug 994010: pt-online-schema-change 2.1.1 crashes without InnoDB
2174+* Fixed bug 996915: pt-online-schema-change crashes with invalid --max-load and --critical-load
2175+* Fixed bug 998831: pt-online-schema-change -- Should have an option to NOT drop tables on failure
2176+* Fixed bug 1002448: pt-online-schema-change: typo for finding usable indexes
2177+* Fixed bug 885382: pt-query-digest --embedded-attributes doesn't check cardinality
2178+* Fixed bug 888114: pt-query-digest report crashes with infinite loop
2179+* Fixed bug 949630: pt-query-digest mentions a Subversion repository
2180+* Fixed bug 844034: pt-show-grants --separate fails with proxy user
2181+* Fixed bug 946707: pt-sift loses STDIN after pt-diskstats
2182+* Fixed bug 994947: pt-stalk doesn't reset cycles_true after collection
2183+* Fixed bug 986151: pt-stalk-has mktemp error
2184+* Fixed bug 993436: pt-summary Memory: Total reports M instead of G
2185+* Fixed bug 1008778: pt-table-checksum doesn't wait for checksum table to replicate
2186+* Fixed bug 1010232: pt-table-checksum doesn't check the size of checksum chunks
2187+* Fixed bug 1011738: pt-table-checksum SKIPPED is zero but chunks were skipped
2188+* Fixed bug 919499: pt-table-checksum fails with binary log error in mysql >= 5.5.18
2189+* Fixed bug 972399: pt-table-checksum docs are not rendered right
2190+* Fixed bug 978432: pt-table-checksum ignoring primary key
2191+* Fixed bug 995274: pt-table-checksum can't use an undefined value as an ARRAY reference at line 2206
2192+* Fixed bug 996110: pt-table-checksum crashes if InnoDB is disabled
2193+* Fixed bug 987393: pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
2194+* Fixed bug 1002365: pt-table-sync --ignore-* options don't work with --replicate
2195+* Fixed bug 1003014: pt-table-sync --replicate and --sync-to-master error "index does not exist"
2196+* Fixed bug 823403: pt-table-sync --lock-and-rename doesn't work on 5.1
2197+* Fixed bug 898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values
2198+
2199+v2.1.1 released 2012-04-03
2200+==========================
2201+
2202+Percona Toolkit 2.1.1 has been released. This is the first release in the
2203+new 2.1 series which supersedes the 2.0 series. We will continue to fix bugs
2204+in 2.0, but 2.1 is now the focus of development.
2205+
2206+2.1 introduces a lot of new code for:
2207+
2208+* pt-online-schema-change (completely redesigned)
2209+* pt-mysql-summary (completely redesigned)
2210+* pt-summary (completely redesigned)
2211+* pt-fingerprint (new tool)
2212+* pt-table-usage (new tool)
2213+
2214+There were also several bug fixes.
2215+
2216+The redesigned tools are meant to replace their 2.0 counterparts because
2217+the 2.1 versions have the same or more functionality and they are simpler
2218+and more reliable. pt-online-schema-change was particularly enhanced to
2219+be as safe as possible given that the tool is inherently risky.
2220+
2221+Percona Toolkit packages can be downloaded from
2222+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
2223+Repositories (http://www.percona.com/software/repositories/).
2224+
2225+Changelog
2226+---------
2227+
2228+* Completely redesigned pt-online-schema-change
2229+* Completely redesigned pt-mysql-summary
2230+* Completely redesigned pt-summary
2231+* Added new tool: pt-table-usage
2232+* Added new tool: pt-fingerprint
2233+* Fixed bug 955860: pt-stalk doesn't run vmstat, iostat, and mpstat for --run-time
2234+* Fixed bug 960513: SHOW TABLE STATUS is used needlessly
2235+* Fixed bug 969726: pt-online-schema-change loses foreign keys
2236+* Fixed bug 846028: pt-online-schema-change does not show progress until completed
2237+* Fixed bug 898695: pt-online-schema-change add useless ORDER BY
2238+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
2239+* Fixed bug 963225: pt-query-digest fails to set history columns for disk tmp tables and disk filesort
2240+* Fixed bug 967451: Char chunking doesn't quote column name
2241+* Fixed bug 972399: pt-table-checksum docs are not rendered right
2242+* Fixed bug 896553: Various documentation spelling fixes
2243+* Fixed bug 949154: pt-variable-advisor advice for relay-log-space-limit
2244+* Fixed bug 953461: pt-upgrade manual broken 'output' section
2245+* Fixed bug 949653: pt-table-checksum docs don't mention risks posed by inconsistent schemas
2246+
2247+v2.0.4 released 2012-03-07
2248+==========================
2249+
2250+Percona Toolkit 2.0.4 has been released. 23 bugs were fixed in this release,
2251+and three new features were implemented. First, --filter was added to pt-kill
2252+which allows for arbitrary --group-by. Second, pt-online-schema-change now
2253+requires that its new --execute option be given, else the tool will just check
2254+the tables and exit. This is a safeguard to encourage users to read the
2255+documentation, particularly when replication is involved. Third, pt-stalk
2256+also received a new option: --[no]stalk. To collect immediately without
2257+stalking, specify --no-stalk and the tool will collect once and exit.
2258+
2259+This release is completely backwards compatible with previous 2.0 releases.
2260+Given the number of bug fixes, it's worth upgrading to 2.0.4.
2261+
2262+Changelog
2263+---------
2264+
2265+* Added --filter to pt-kill to allow arbitrary --group-by
2266+* Added --[no]stalk to pt-stalk (bug 932331)
2267+* Added --execute to pt-online-schema-change (bug 933232)
2268+* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
2269+* Fixed bug 928966: pt-pmp still uses insecure /tmp
2270+* Fixed bug 933232: pt-online-schema-change can break replication
2271+* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
2272+* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
2273+* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
2274+* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
2275+* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
2276+* Fixed bug 928226: pt-diskstats illegal division by zero
2277+* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
2278+* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
2279+* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
2280+* Fixed bug 932331: pt-stalk cannot collect without stalking
2281+* Fixed bug 932442: pt-table-checksum error when column name has two spaces
2282+* Fixed bug 932883: File Debian bug after each release
2283+* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
2284+* Fixed bug 944420: --daemonize doesn't always close STDIN
2285+* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
2286+* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
2287+* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
2288+* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
2289+* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
2290+* Fixed bug 940440: Bad grammar in pt-kill docs
2291+
2292+v2.0.3 released 2012-02-03
2293+==========================
2294+
2295+Percona Toolkit 2.0.3 has been released. The development team was very
2296+busy last month making this release significant: two completely
2297+redesigned and improved tools, pt-diskstats and pt-stalk, and 20 bug fixes.
2298+
2299+Both pt-diskstats and pt-stalk were redesigned and rewritten from the ground
2300+up. This allowed us to greatly improve these tools' functionality and
2301+increase testing for them. The accuracy and output of pt-diskstats was
2302+enhanced, and the tool was rewritten in Perl. pt-collect was removed and
2303+its functionality was put into a new, enhanced pt-stalk. pt-stalk is now
2304+designed to be a stable, long-running daemon on a variety of common platforms.
2305+It is worth re-reading the documentation for each of these tools.
2306+
2307+The 20 bug fixes cover a wide range of problems. The most important are
2308+fixes to pt-table-checksum, pt-iostats, and pt-kill. Apart from pt-diskstats,
2309+pt-stalk, and pt-collect (which was removed), no other tools were changed
2310+in backwards-incompatible ways, so it is worth reviewing the full changelog
2311+for this release and upgrading if you use any tools which had bug fixes.
2312+
2313+Thank you to the many people who reported bugs and submitted patches.
2314+
2315+Download the latest release of Percona Toolkit 2.0 from
2316+http://www.percona.com/software/percona-toolkit/
2317+or the Percona Software Repositories
2318+(http://www.percona.com/docs/wiki/repositories:start).
2319+
2320+Changelog
2321+---------
2322+
2323+* Completely redesigned pt-diskstats
2324+* Completely redesigned pt-stalk
2325+* Removed pt-collect and put its functionality in pt-stalk
2326+* Fixed bug 871438: Bash tools are insecure
2327+* Fixed bug 897758: Failed to prepare TableSyncChunk plugin: Use of uninitialized value $args{"chunk_range"} in lc at pt-table-sync line 3055
2328+* Fixed bug 919819: pt-kill --execute-command creates zombies
2329+* Fixed bug 925778: pt-ioprofile doesn't run without a file
2330+* Fixed bug 925477: pt-ioprofile docs refer to pt-iostats
2331+* Fixed bug 857091: pt-sift downloads http://percona.com/get/pt-pmp, which does not work
2332+* Fixed bug 857104: pt-sift tries to invoke mext, should be pt-mext
2333+* Fixed bug 872699: pt-diskstats: rd_avkb & wr_avkb derived incorrectly
2334+* Fixed bug 897029: pt-diskstats computes wrong values for md0
2335+* Fixed bug 882918: pt-stalk spams warning if oprofile isn't installed
2336+* Fixed bug 884504: pt-stalk doesn't check pt-collect
2337+* Fixed bug 897483: pt-online-schema-change "uninitialized value" due to update-foreign-keys-method
2338+* Fixed bug 925007: pt-online-schema-change Use of uninitialized value $tables{"old_table"} in concatenation (.) or string at line 4330
2339+* Fixed bug 915598: pt-config-diff ignores --ask-pass option
2340+* Fixed bug 919352: pt-table-checksum changes binlog_format even if already set to statement
2341+* Fixed bug 921700: pt-table-checksum doesn't add --where to chunk size test on replicas
2342+* Fixed bug 921802: pt-table-checksum does not recognize --recursion-method=processlist
2343+* Fixed bug 925855: pt-table-checksum index check is case-sensitive
2344+* Fixed bug 821709: pt-show-grants --revoke and --separate don't work together
2345+* Fixed bug 918247: Some tools use VALUE instead of VALUES
2346+
2347+v2.0.2 released 2012-01-05
2348+==========================
2349+
2350+Percona Toolkit 2.0.2 fixes one critical bug: pt-table-sync --replicate
2351+did not work with character values, causing an "Unknown column" error.
2352+If using Percona Toolkit 2.0.1, you should upgrade to 2.0.2.
2353+
2354+Download the latest release of Percona Toolkit 2.0 from
2355+http://www.percona.com/software/percona-toolkit/
2356+or the Percona Software Repositories
2357+(http://www.percona.com/docs/wiki/repositories:start).
2358+
2359+Changelog
2360+---------
2361+
2362+* Fixed bug 911996: pt-table-sync --replicate causes "Unknown column" error
2363+
2364+v2.0.1 released 2011-12-30
2365+==========================
2366+
2367+The Percona Toolkit development team is proud to announce a new major version:
2368+2.0. Beginning with Percona Toolkit 2.0, we are overhauling, redesigning, and
2369+improving the major tools. 2.0 tools are therefore not backwards compatible
2370+with 1.0 tools, which we still support but will not continue to develop.
2371+
2372+New in Percona Toolkit 2.0.1 is a completely redesigned pt-table-checksum.
2373+The original pt-table-checksum 1.0 was rather complex, but it worked well
2374+for many years. By contrast, the new pt-table-checksum 2.0 is much simpler but
2375+also much more efficient and reliable. We spent months rethinking, redesigning,
2376+and testing every aspect of the tool. The three most significant changes:
2377+pt-table-checksum 2.0 does only --replicate, it has only one chunking algorithm,
2378+and its memory usage is stable even with hundreds of thousands of tables and
2379+trillions of rows. The tool is now dedicated to verifying MySQL replication
2380+integrity, nothing else, which it does extremely well.
2381+
2382+In Percona Toolkit 2.0.1 we also fixed various small bugs and forked ioprofile
2383+and align (as pt-ioprofile and pt-align) from Aspersa.
2384+
2385+If you still need functionalities in the original pt-table-checksum,
2386+the latest Percona Toolkit 1.0 release remains available for download.
2387+Otherwise, all new development in Percona Toolkit will happen in 2.0.
2388+
2389+Download the latest release of Percona Toolkit 2.0 from
2390+http://www.percona.com/software/percona-toolkit/
2391+or the Percona Software Repositories
2392+(http://www.percona.com/docs/wiki/repositories:start).
2393+
2394+Changelog
2395+---------
2396+
2397+* Completely redesigned pt-table-checksum
2398+* Fixed bug 856065: pt-trend does not work
2399+* Fixed bug 887688: Prepared statements crash pt-query-digest
2400+* Fixed bug 888286: align not part of percona-toolkit
2401+* Fixed bug 897961: ptc 2.0 replicate-check error does not include hostname
2402+* Fixed bug 898318: ptc 2.0 --resume with --tables does not always work
2403+* Fixed bug 903513: MKDEBUG should be PTDEBUG
2404+* Fixed bug 908256: Percona Toolkit should include pt-ioprofile
2405+* Fixed bug 821717: pt-tcp-model --type=requests crashes
2406+* Fixed bug 844038: pt-online-schema-change documentation example w/drop-tmp-table does not work
2407+* Fixed bug 864205: Remove the query to reset @crc from pt-table-checksum
2408+* Fixed bug 898663: Typo in pt-log-player documentation
2409+
2410+v1.0.1 released 2011-09-01
2411+==========================
2412+
2413+Percona Toolkit 1.0.1 has been released. In July, Baron announced planned
2414+changes to Maatkit and Aspersa development;[1] Percona Toolkit is the
2415+result. In brief, Percona Toolkit is the combined fork of Maatkit and
2416+Aspersa, so although the toolkit is new, the programs are not. That means
2417+Percona Toolkit 1.0.1 is mature, stable, and production-ready. In fact,
2418+it's even a little more stable because we fixed a few bugs in this release.
2419+
2420+Percona Toolkit packages can be downloaded from
2421+http://www.percona.com/downloads/percona-toolkit/
2422+or the Percona Software Repositories
2423+(http://www.percona.com/docs/wiki/repositories:start).
2424+
2425+Although Maatkit and Aspersa development use Google Code, Percona Toolkit
2426+uses Launchpad: https://launchpad.net/percona-toolkit
2427+
2428+[1] http://www.xaprb.com/blog/2011/07/06/planned-change-in-maatkit-aspersa-development/
2429+
2430+Changelog
2431+---------
2432+
2433+* Fixed bug 819421: MasterSlave::is_replication_thread() doesn't match all
2434+* Fixed bug 821673: pt-table-checksum doesn't include --where in min max queries
2435+* Fixed bug 821688: pt-table-checksum SELECT MIN MAX for char chunking is wrong
2436+* Fixed bug 838211: pt-collect: line 24: [: : integer expression expected
2437+* Fixed bug 838248: pt-collect creates a "5.1" file
2438+
2439+v0.9.5 released 2011-08-04
2440+==========================
2441+
2442+Percona 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.
2443+
2444+Changelog
2445+---------
2446+
2447+* Forked, combined, and rebranded Maatkit and Aspersa as Percona Toolkit.
2448+
2449+Changelog
2450+---------
2451+
2452+* Fixed bug 1279502: --version-check behaves like spyware
2453+* Fixed bug 1199589: pt-archiver deletes data despite --dry-run
2454
2455 v2.1.10 released 2013-07-18
2456 ===========================

Subscribers

People subscribed via source and target branches