Merge lp:~abychko/percona-toolkit/release-2.2.7 into lp:percona-toolkit/2.2

Proposed by Alexey Bychko
Status: Merged
Merged at revision: 597
Proposed branch: lp:~abychko/percona-toolkit/release-2.2.7
Merge into: lp:percona-toolkit/2.2
Diff against target: 2004 lines (+1275/-75)
40 files modified
Changelog (+2/-0)
Makefile.PL (+1/-1)
bin/pt-agent (+2/-2)
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-mext (+2/-2)
bin/pt-mysql-summary (+2/-2)
bin/pt-online-schema-change (+2/-2)
bin/pt-pmp (+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-upgrade (+2/-2)
bin/pt-variable-advisor (+2/-2)
bin/pt-visual-explain (+2/-2)
config/deb/changelog (+6/-0)
config/sphinx-build/conf.py (+1/-1)
config/sphinx-build/percona-theme/layout.html (+7/-5)
docs/percona-toolkit.pod (+2/-2)
docs/release_notes.rst (+1190/-0)
To merge this branch: bzr merge lp:~abychko/percona-toolkit/release-2.2.7
Reviewer Review Type Date Requested Status
Daniel Nichter Approve
Review via email: mp+207363@code.launchpad.net

Description of the change

release 2.2.7

To post a comment you must log in.
597. By Alexey Bychko

Percona Toolkit release 2.2.7

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

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'Changelog'
2--- Changelog 2014-02-20 03:47:43 +0000
3+++ Changelog 2014-02-20 08:12:46 +0000
4@@ -1,5 +1,7 @@
5 Changelog for Percona Toolkit
6
7+v2.2.7 released 2014-02-20
8+
9 * Fixed bug 1279502: --version-check behaves like spyware
10
11 v2.2.6 released 2013-12-18
12
13=== modified file 'Makefile.PL'
14--- Makefile.PL 2013-12-18 23:53:01 +0000
15+++ Makefile.PL 2014-02-20 08:12:46 +0000
16@@ -2,7 +2,7 @@
17
18 WriteMakefile(
19 NAME => 'percona-toolkit',
20- VERSION => '2.2.6',
21+ VERSION => '2.2.7',
22 EXE_FILES => [ <bin/*> ],
23 MAN1PODS => {
24 'docs/percona-toolkit.pod' => 'blib/man1/percona-toolkit.1p',
25
26=== modified file 'bin/pt-agent'
27--- bin/pt-agent 2014-02-20 03:47:43 +0000
28+++ bin/pt-agent 2014-02-20 08:12:46 +0000
29@@ -9779,7 +9779,7 @@
30
31 =head1 COPYRIGHT, LICENSE, AND WARRANTY
32
33-This program is copyright 2013 Percona LLC and/or its affiliates.
34+This program is copyright 2013-2014 Percona LLC and/or its affiliates.
35
36 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
37 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
38@@ -9797,6 +9797,6 @@
39
40 =head1 VERSION
41
42-pt-agent 2.2.6
43+pt-agent 2.2.7
44
45 =cut
46
47=== modified file 'bin/pt-align'
48--- bin/pt-align 2013-12-18 23:53:01 +0000
49+++ bin/pt-align 2014-02-20 08:12:46 +0000
50@@ -1304,7 +1304,7 @@
51
52 =head1 COPYRIGHT, LICENSE, AND WARRANTY
53
54-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
55+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
56 2010-2011 Baron Schwartz.
57
58 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
59@@ -1323,6 +1323,6 @@
60
61 =head1 VERSION
62
63-pt-align 2.2.6
64+pt-align 2.2.7
65
66 =cut
67
68=== modified file 'bin/pt-archiver'
69--- bin/pt-archiver 2014-02-20 03:47:43 +0000
70+++ bin/pt-archiver 2014-02-20 08:12:46 +0000
71@@ -7873,7 +7873,7 @@
72
73 =head1 COPYRIGHT, LICENSE, AND WARRANTY
74
75-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
76+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
77 2007-2011 Baron Schwartz.
78
79 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
80@@ -7892,6 +7892,6 @@
81
82 =head1 VERSION
83
84-pt-archiver 2.2.6
85+pt-archiver 2.2.7
86
87 =cut
88
89=== modified file 'bin/pt-config-diff'
90--- bin/pt-config-diff 2014-02-20 03:47:43 +0000
91+++ bin/pt-config-diff 2014-02-20 08:12:46 +0000
92@@ -5715,7 +5715,7 @@
93
94 =head1 COPYRIGHT, LICENSE, AND WARRANTY
95
96-This program is copyright 2011-2013 Percona LLC and/or its affiliates.
97+This program is copyright 2011-2014 Percona LLC and/or its affiliates.
98
99 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
100 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
101@@ -5733,6 +5733,6 @@
102
103 =head1 VERSION
104
105-pt-config-diff 2.2.6
106+pt-config-diff 2.2.7
107
108 =cut
109
110=== modified file 'bin/pt-deadlock-logger'
111--- bin/pt-deadlock-logger 2014-02-20 03:47:43 +0000
112+++ bin/pt-deadlock-logger 2014-02-20 08:12:46 +0000
113@@ -5488,7 +5488,7 @@
114
115 =head1 COPYRIGHT, LICENSE, AND WARRANTY
116
117-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
118+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
119 2007-2011 Baron Schwartz.
120
121 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
122@@ -5507,6 +5507,6 @@
123
124 =head1 VERSION
125
126-pt-deadlock-logger 2.2.6
127+pt-deadlock-logger 2.2.7
128
129 =cut
130
131=== modified file 'bin/pt-diskstats'
132--- bin/pt-diskstats 2014-02-20 03:47:43 +0000
133+++ bin/pt-diskstats 2014-02-20 08:12:46 +0000
134@@ -5560,7 +5560,7 @@
135
136 =head1 COPYRIGHT, LICENSE, AND WARRANTY
137
138-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
139+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
140 2010-2011 Baron Schwartz.
141
142 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
143@@ -5579,6 +5579,6 @@
144
145 =head1 VERSION
146
147-pt-diskstats 2.2.6
148+pt-diskstats 2.2.7
149
150 =cut
151
152=== modified file 'bin/pt-duplicate-key-checker'
153--- bin/pt-duplicate-key-checker 2014-02-20 03:47:43 +0000
154+++ bin/pt-duplicate-key-checker 2014-02-20 08:12:46 +0000
155@@ -5582,7 +5582,7 @@
156
157 =head1 COPYRIGHT, LICENSE, AND WARRANTY
158
159-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
160+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
161 2007-2011 Baron Schwartz.
162
163 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
164@@ -5601,6 +5601,6 @@
165
166 =head1 VERSION
167
168-pt-duplicate-key-checker 2.2.6
169+pt-duplicate-key-checker 2.2.7
170
171 =cut
172
173=== modified file 'bin/pt-fifo-split'
174--- bin/pt-fifo-split 2013-12-18 23:53:01 +0000
175+++ bin/pt-fifo-split 2014-02-20 08:12:46 +0000
176@@ -1593,7 +1593,7 @@
177
178 =head1 COPYRIGHT, LICENSE, AND WARRANTY
179
180-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
181+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
182 2007-2011 Baron Schwartz.
183
184 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
185@@ -1612,6 +1612,6 @@
186
187 =head1 VERSION
188
189-pt-fifo-split 2.2.6
190+pt-fifo-split 2.2.7
191
192 =cut
193
194=== modified file 'bin/pt-find'
195--- bin/pt-find 2014-02-20 03:47:43 +0000
196+++ bin/pt-find 2014-02-20 08:12:46 +0000
197@@ -4965,7 +4965,7 @@
198
199 =head1 COPYRIGHT, LICENSE, AND WARRANTY
200
201-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
202+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
203 2007-2011 Baron Schwartz.
204
205 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
206@@ -4984,6 +4984,6 @@
207
208 =head1 VERSION
209
210-pt-find 2.2.6
211+pt-find 2.2.7
212
213 =cut
214
215=== modified file 'bin/pt-fingerprint'
216--- bin/pt-fingerprint 2013-12-18 23:53:01 +0000
217+++ bin/pt-fingerprint 2014-02-20 08:12:46 +0000
218@@ -2185,7 +2185,7 @@
219
220 =head1 COPYRIGHT, LICENSE, AND WARRANTY
221
222-This program is copyright 2011-2013 Percona LLC and/or its affiliates.
223+This program is copyright 2011-2014 Percona LLC and/or its affiliates.
224
225 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
226 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
227@@ -2203,6 +2203,6 @@
228
229 =head1 VERSION
230
231-pt-fingerprint 2.2.6
232+pt-fingerprint 2.2.7
233
234 =cut
235
236=== modified file 'bin/pt-fk-error-logger'
237--- bin/pt-fk-error-logger 2014-02-20 03:47:43 +0000
238+++ bin/pt-fk-error-logger 2014-02-20 08:12:46 +0000
239@@ -4491,7 +4491,7 @@
240
241 =head1 COPYRIGHT, LICENSE, AND WARRANTY
242
243-This program is copyright 2011-2013 Percona LLC and/or its affiliates.
244+This program is copyright 2011-2014 Percona LLC and/or its affiliates.
245
246 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
247 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
248@@ -4509,6 +4509,6 @@
249
250 =head1 VERSION
251
252-pt-fk-error-logger 2.2.6
253+pt-fk-error-logger 2.2.7
254
255 =cut
256
257=== modified file 'bin/pt-heartbeat'
258--- bin/pt-heartbeat 2014-02-20 03:47:43 +0000
259+++ bin/pt-heartbeat 2014-02-20 08:12:46 +0000
260@@ -6171,7 +6171,7 @@
261
262 =head1 COPYRIGHT, LICENSE, AND WARRANTY
263
264-This program is copyright 2007-2013 Percona LLC and/or its affiliates,
265+This program is copyright 2007-2014 Percona LLC and/or its affiliates,
266 2006 Proven Scaling LLC and Six Apart Ltd.
267
268 Feedback and improvements are welcome.
269@@ -6192,6 +6192,6 @@
270
271 =head1 VERSION
272
273-pt-heartbeat 2.2.6
274+pt-heartbeat 2.2.7
275
276 =cut
277
278=== modified file 'bin/pt-index-usage'
279--- bin/pt-index-usage 2014-02-20 03:47:43 +0000
280+++ bin/pt-index-usage 2014-02-20 08:12:46 +0000
281@@ -7500,7 +7500,7 @@
282
283 =head1 COPYRIGHT, LICENSE, AND WARRANTY
284
285-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
286+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
287 2010-2011 Baron Schwartz.
288
289 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
290@@ -7519,6 +7519,6 @@
291
292 =head1 VERSION
293
294-pt-index-usage 2.2.6
295+pt-index-usage 2.2.7
296
297 =cut
298
299=== modified file 'bin/pt-ioprofile'
300--- bin/pt-ioprofile 2013-12-18 23:53:01 +0000
301+++ bin/pt-ioprofile 2014-02-20 08:12:46 +0000
302@@ -1100,7 +1100,7 @@
303
304 =head1 COPYRIGHT, LICENSE, AND WARRANTY
305
306-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
307+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
308 2010-2011 Baron Schwartz.
309
310 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
311@@ -1119,7 +1119,7 @@
312
313 =head1 VERSION
314
315-pt-ioprofile 2.2.6
316+pt-ioprofile 2.2.7
317
318 =cut
319
320
321=== modified file 'bin/pt-kill'
322--- bin/pt-kill 2014-02-20 03:47:43 +0000
323+++ bin/pt-kill 2014-02-20 08:12:46 +0000
324@@ -8150,7 +8150,7 @@
325
326 =head1 COPYRIGHT, LICENSE, AND WARRANTY
327
328-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
329+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
330 2009-2011 Baron Schwartz.
331
332 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
333@@ -8169,6 +8169,6 @@
334
335 =head1 VERSION
336
337-pt-kill 2.2.6
338+pt-kill 2.2.7
339
340 =cut
341
342=== modified file 'bin/pt-mext'
343--- bin/pt-mext 2013-12-18 23:53:01 +0000
344+++ bin/pt-mext 2014-02-20 08:12:46 +0000
345@@ -772,7 +772,7 @@
346
347 =head1 COPYRIGHT, LICENSE, AND WARRANTY
348
349-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
350+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
351 2010 Baron Schwartz.
352
353 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
354@@ -791,7 +791,7 @@
355
356 =head1 VERSION
357
358-pt-mext 2.2.6
359+pt-mext 2.2.7
360
361 =cut
362
363
364=== modified file 'bin/pt-mysql-summary'
365--- bin/pt-mysql-summary 2013-12-18 23:53:01 +0000
366+++ bin/pt-mysql-summary 2014-02-20 08:12:46 +0000
367@@ -3070,7 +3070,7 @@
368
369 =head1 COPYRIGHT, LICENSE, AND WARRANTY
370
371-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
372+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
373 2010-2011 Baron Schwartz.
374
375 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
376@@ -3089,7 +3089,7 @@
377
378 =head1 VERSION
379
380-pt-mysql-summary 2.2.6
381+pt-mysql-summary 2.2.7
382
383 =cut
384
385
386=== modified file 'bin/pt-online-schema-change'
387--- bin/pt-online-schema-change 2014-02-20 03:47:43 +0000
388+++ bin/pt-online-schema-change 2014-02-20 08:12:46 +0000
389@@ -11514,7 +11514,7 @@
390
391 =head1 COPYRIGHT, LICENSE, AND WARRANTY
392
393-This program is copyright 2011-2013 Percona LLC and/or its affiliates.
394+This program is copyright 2011-2014 Percona LLC and/or its affiliates.
395
396 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
397 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
398@@ -11532,6 +11532,6 @@
399
400 =head1 VERSION
401
402-pt-online-schema-change 2.2.6
403+pt-online-schema-change 2.2.7
404
405 =cut
406
407=== modified file 'bin/pt-pmp'
408--- bin/pt-pmp 2013-12-18 23:53:01 +0000
409+++ bin/pt-pmp 2014-02-20 08:12:46 +0000
410@@ -870,7 +870,7 @@
411
412 =head1 COPYRIGHT, LICENSE, AND WARRANTY
413
414-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
415+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
416 2010-2011 Baron Schwartz.
417
418 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
419@@ -889,7 +889,7 @@
420
421 =head1 VERSION
422
423-pt-pmp 2.2.6
424+pt-pmp 2.2.7
425
426 =cut
427
428
429=== modified file 'bin/pt-query-digest'
430--- bin/pt-query-digest 2014-02-20 03:47:43 +0000
431+++ bin/pt-query-digest 2014-02-20 08:12:46 +0000
432@@ -16567,7 +16567,7 @@
433
434 =head1 COPYRIGHT, LICENSE, AND WARRANTY
435
436-This program is copyright 2008-2013 Percona LLC and/or its affiliates.
437+This program is copyright 2008-2014 Percona LLC and/or its affiliates.
438
439 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
440 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
441@@ -16585,6 +16585,6 @@
442
443 =head1 VERSION
444
445-pt-query-digest 2.2.6
446+pt-query-digest 2.2.7
447
448 =cut
449
450=== modified file 'bin/pt-show-grants'
451--- bin/pt-show-grants 2013-12-18 23:53:01 +0000
452+++ bin/pt-show-grants 2014-02-20 08:12:46 +0000
453@@ -2387,7 +2387,7 @@
454
455 =head1 COPYRIGHT, LICENSE, AND WARRANTY
456
457-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
458+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
459 2007-2011 Baron Schwartz.
460
461 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
462@@ -2406,6 +2406,6 @@
463
464 =head1 VERSION
465
466-pt-show-grants 2.2.6
467+pt-show-grants 2.2.7
468
469 =cut
470
471=== modified file 'bin/pt-sift'
472--- bin/pt-sift 2013-12-18 23:53:01 +0000
473+++ bin/pt-sift 2014-02-20 08:12:46 +0000
474@@ -1218,7 +1218,7 @@
475
476 =head1 COPYRIGHT, LICENSE, AND WARRANTY
477
478-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
479+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
480 2010-2011 Baron Schwartz.
481
482 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
483@@ -1237,7 +1237,7 @@
484
485 =head1 VERSION
486
487-pt-sift 2.2.6
488+pt-sift 2.2.7
489
490 =cut
491
492
493=== modified file 'bin/pt-slave-delay'
494--- bin/pt-slave-delay 2014-02-20 03:47:43 +0000
495+++ bin/pt-slave-delay 2014-02-20 08:12:46 +0000
496@@ -4850,7 +4850,7 @@
497
498 =head1 COPYRIGHT, LICENSE, AND WARRANTY
499
500-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
501+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
502 2007-2011 Sergey Zhuravle and Baron Schwartz.
503
504 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
505@@ -4869,6 +4869,6 @@
506
507 =head1 VERSION
508
509-pt-slave-delay 2.2.6
510+pt-slave-delay 2.2.7
511
512 =cut
513
514=== modified file 'bin/pt-slave-find'
515--- bin/pt-slave-find 2013-12-18 23:53:01 +0000
516+++ bin/pt-slave-find 2014-02-20 08:12:46 +0000
517@@ -4315,7 +4315,7 @@
518
519 =head1 COPYRIGHT, LICENSE, AND WARRANTY
520
521-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
522+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
523 2007-2011 Baron Schwartz.
524
525 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
526@@ -4334,6 +4334,6 @@
527
528 =head1 VERSION
529
530-pt-slave-find 2.2.6
531+pt-slave-find 2.2.7
532
533 =cut
534
535=== modified file 'bin/pt-slave-restart'
536--- bin/pt-slave-restart 2014-02-20 03:47:43 +0000
537+++ bin/pt-slave-restart 2014-02-20 08:12:46 +0000
538@@ -5792,7 +5792,7 @@
539
540 =head1 COPYRIGHT, LICENSE, AND WARRANTY
541
542-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
543+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
544 2007-2011 Baron Schwartz.
545
546 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
547@@ -5811,6 +5811,6 @@
548
549 =head1 VERSION
550
551-pt-slave-restart 2.2.6
552+pt-slave-restart 2.2.7
553
554 =cut
555
556=== modified file 'bin/pt-stalk'
557--- bin/pt-stalk 2013-12-18 23:53:01 +0000
558+++ bin/pt-stalk 2014-02-20 08:12:46 +0000
559@@ -2193,7 +2193,7 @@
560
561 =head1 COPYRIGHT, LICENSE, AND WARRANTY
562
563-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
564+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
565 2010-2011 Baron Schwartz.
566
567 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
568@@ -2212,7 +2212,7 @@
569
570 =head1 VERSION
571
572-pt-stalk 2.2.6
573+pt-stalk 2.2.7
574
575 =cut
576
577
578=== modified file 'bin/pt-summary'
579--- bin/pt-summary 2013-12-18 23:53:01 +0000
580+++ bin/pt-summary 2014-02-20 08:12:46 +0000
581@@ -2671,7 +2671,7 @@
582
583 =head1 COPYRIGHT, LICENSE, AND WARRANTY
584
585-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
586+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
587 2010-2011 Baron Schwartz.
588
589 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
590@@ -2690,7 +2690,7 @@
591
592 =head1 VERSION
593
594-pt-summary 2.2.6
595+pt-summary 2.2.7
596
597 =cut
598
599
600=== modified file 'bin/pt-table-checksum'
601--- bin/pt-table-checksum 2014-02-20 03:47:43 +0000
602+++ bin/pt-table-checksum 2014-02-20 08:12:46 +0000
603@@ -12545,7 +12545,7 @@
604
605 =head1 COPYRIGHT, LICENSE, AND WARRANTY
606
607-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
608+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
609 2007-2011 Baron Schwartz.
610
611 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
612@@ -12564,6 +12564,6 @@
613
614 =head1 VERSION
615
616-pt-table-checksum 2.2.6
617+pt-table-checksum 2.2.7
618
619 =cut
620
621=== modified file 'bin/pt-table-sync'
622--- bin/pt-table-sync 2014-02-20 03:47:43 +0000
623+++ bin/pt-table-sync 2014-02-20 08:12:46 +0000
624@@ -12750,7 +12750,7 @@
625
626 =head1 COPYRIGHT, LICENSE, AND WARRANTY
627
628-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
629+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
630 2007-2011 Baron Schwartz.
631
632 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
633@@ -12769,6 +12769,6 @@
634
635 =head1 VERSION
636
637-pt-table-sync 2.2.6
638+pt-table-sync 2.2.7
639
640 =cut
641
642=== modified file 'bin/pt-table-usage'
643--- bin/pt-table-usage 2013-12-18 23:53:01 +0000
644+++ bin/pt-table-usage 2014-02-20 08:12:46 +0000
645@@ -7504,7 +7504,7 @@
646
647 =head1 COPYRIGHT, LICENSE, AND WARRANTY
648
649-This program is copyright 2012-2013 Percona LLC and/or its affiliates.
650+This program is copyright 2012-2014 Percona LLC and/or its affiliates.
651
652 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
653 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
654@@ -7522,6 +7522,6 @@
655
656 =head1 VERSION
657
658-pt-table-usage 2.2.6
659+pt-table-usage 2.2.7
660
661 =cut
662
663=== modified file 'bin/pt-upgrade'
664--- bin/pt-upgrade 2014-02-20 03:47:43 +0000
665+++ bin/pt-upgrade 2014-02-20 08:12:46 +0000
666@@ -11191,7 +11191,7 @@
667
668 =head1 COPYRIGHT, LICENSE, AND WARRANTY
669
670-This program is copyright 2009-2013 Percona LLC and/or its affiliates.
671+This program is copyright 2009-2014 Percona LLC and/or its affiliates.
672 Feedback and improvements are welcome.
673
674 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
675@@ -11210,6 +11210,6 @@
676
677 =head1 VERSION
678
679-pt-upgrade 2.2.6
680+pt-upgrade 2.2.7
681
682 =cut
683
684=== modified file 'bin/pt-variable-advisor'
685--- bin/pt-variable-advisor 2014-02-20 03:47:43 +0000
686+++ bin/pt-variable-advisor 2014-02-20 08:12:46 +0000
687@@ -6120,7 +6120,7 @@
688
689 =head1 COPYRIGHT, LICENSE, AND WARRANTY
690
691-This program is copyright 2010-2013 Percona LLC and/or its affiliates.
692+This program is copyright 2010-2014 Percona LLC and/or its affiliates.
693
694 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
695 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
696@@ -6138,6 +6138,6 @@
697
698 =head1 VERSION
699
700-pt-variable-advisor 2.2.6
701+pt-variable-advisor 2.2.7
702
703 =cut
704
705=== modified file 'bin/pt-visual-explain'
706--- bin/pt-visual-explain 2013-12-18 23:53:01 +0000
707+++ bin/pt-visual-explain 2014-02-20 08:12:46 +0000
708@@ -3224,7 +3224,7 @@
709
710 =head1 COPYRIGHT, LICENSE, AND WARRANTY
711
712-This program is copyright 2011-2013 Percona LLC and/or its affiliates,
713+This program is copyright 2011-2014 Percona LLC and/or its affiliates,
714 2007-2011 Baron Schwartz.
715
716 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
717@@ -3243,6 +3243,6 @@
718
719 =head1 VERSION
720
721-pt-visual-explain 2.2.6
722+pt-visual-explain 2.2.7
723
724 =cut
725
726=== modified file 'config/deb/changelog'
727--- config/deb/changelog 2013-12-18 23:53:01 +0000
728+++ config/deb/changelog 2014-02-20 08:12:46 +0000
729@@ -1,3 +1,9 @@
730+percona-toolkit (2.2.7) unstable; urgency=low
731+
732+ * Fixed bug 1279502: --version-check behaves like spyware
733+
734+ -- Percona Toolkit Developers <toolkit-dev@percona.com> Thu, 20 Feb 2014 08:09:53 +0000
735+
736 percona-toolkit (2.2.6) unstable; urgency=low
737
738 * Added pt-query-digest support for Percona Server slow log rate limiting
739
740=== modified file 'config/sphinx-build/conf.py'
741--- config/sphinx-build/conf.py 2013-12-18 23:53:01 +0000
742+++ config/sphinx-build/conf.py 2014-02-20 08:12:46 +0000
743@@ -50,7 +50,7 @@
744 # The short X.Y version.
745 version = '2.2'
746 # The full version, including alpha/beta/rc tags.
747-release = '2.2.6'
748+release = '2.2.7'
749
750 # The language for content autogenerated by Sphinx. Refer to documentation
751 # for a list of supported languages.
752
753=== modified file 'config/sphinx-build/percona-theme/layout.html'
754--- config/sphinx-build/percona-theme/layout.html 2013-12-18 23:53:01 +0000
755+++ config/sphinx-build/percona-theme/layout.html 2014-02-20 08:12:46 +0000
756@@ -302,12 +302,14 @@
757
758 {%- block footer %}
759
760- {@ footer_documentation_bugs @}
761+
762 <div class="file-bugs">
763- This documentation is developed in Launchpad as part of the <a rel="nofollow" href="https://code.launchpad.net/percona-toolkit">Percona Toolkit source code</a>.<br/>
764- For all document-related issues (typos, errors, confusion, etc.), please <a rel="nofollow" href="https://bugs.launchpad.net/percona-toolkit/+filebug?field.tags=docs&amp;field.comment=[In:Percona Toolkit Documentation]&amp;?field.tags=docs&amp;field.title=[DOC] ">file a bug</a>.
765+ This documentation is developed in Launchpad as part of the <a rel="nofollow" href="https://code.launchpad.net/percona-toolkit">Percona Toolkit source code</a>.<br/>
766+ If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please <a rel="nofollow" href="https://bugs.launchpad.net/percona-toolkit/+filebug?field.tags=doc&amp;field.comment=[In:Percona Toolkit Documentation]&amp;?field.tags=doc&amp;field.title=[DOC] ">file a bug</a>.
767+
768 </div>
769- {@ /footer_documentation_bugs @}
770+
771+
772
773 <div id="footer">
774
775@@ -320,7 +322,7 @@
776 Call us: 1-888-316-9775 • <a href="http://www.percona.com/contact">Contact Us</a><br>
777 MySQL and InnoDB are trademarks of Oracle Corp.<br>
778 Proudly running <a href="http://www.percona.com/software/percona-server/">Percona Server<span id="recentServerVersion"></span></a><br>
779- Copyright &copy; 2006-2013 Percona LLC and/or its affiliates<br>
780+ Copyright &copy; 2013 Percona<br>
781 <a href="http://www.percona.com/about-us/policies/">Copyright, Trademark, and Privacy Policy</a> • <a href="http://www.percona.com/site_map/">Sitemap</a>
782 <span class="inv"><!--[CDATA[</noindex-->]]&gt;</span>
783 </div>
784
785=== modified file 'docs/percona-toolkit.pod'
786--- docs/percona-toolkit.pod 2013-12-18 23:53:01 +0000
787+++ docs/percona-toolkit.pod 2014-02-20 08:12:46 +0000
788@@ -543,7 +543,7 @@
789
790 =head1 COPYRIGHT, LICENSE, AND WARRANTY
791
792-Percona Toolkit is copyright 2011-2013 Percona LLC and/or its affiliates, et al.
793+Percona Toolkit is copyright 2011-2014 Percona LLC and/or its affiliates, et al.
794 See each program's documentation for complete copyright notices.
795
796 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
797@@ -562,6 +562,6 @@
798
799 =head1 VERSION
800
801-Percona Toolkit v2.2.6 released 2013-12-18
802+Percona Toolkit v2.2.7 released 2014-02-20
803
804 =cut
805
806=== modified file 'docs/release_notes.rst'
807--- docs/release_notes.rst 2013-12-18 23:53:01 +0000
808+++ docs/release_notes.rst 2014-02-20 08:12:46 +0000
809@@ -1,6 +1,1196 @@
810 Release Notes
811 *************
812
813+v2.2.7 released 2014-02-20
814+==========================
815+
816+Release Notes
817+*************
818+
819+v2.2.7 released 2014-02-20
820+==========================
821+
822+Percona Toolkit 2.2.7 has been released. This release has only one bug fixed.
823+
824+* Fixed bug 1279502: --version-check behaves like spyware
825+
826+ The configuration for what information PT tools should collect was not hardcoded in the scripts. Instead, every time it's downloaded from http://v.percona.com/. One of the possible parameters was a binary file name to be executed. This was fixed by removing the remote execution.
827+
828+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/).
829+
830+v2.2.6 released 2013-12-18
831+==========================
832+
833+Percona Toolkit 2.2.6 has been released. This release has 16 bug fixes and a few new features. One bug fix is very important, so 2.2 users are strongly encouraged to upgrade:
834+
835+* Fixed bug 1223458: pt-table-sync deletes child table rows
836+
837+Buried in the pt-table-sync docs is this warning:
838+
839+ Also be careful with tables that have foreign key constraints with C<ON DELETE>
840+ or C<ON UPDATE> definitions because these might cause unintended changes on the
841+ child tables.
842+
843+Until recently, either no one had this problem, or no one reported it, or no one realized that pt-table-sync caused it. In the worst case, pt-table-sync could delete all rows in child tables, which is quite surprising and bad. As of 2.2.6, pt-table-sync has option --[no]check-child-tables which is on by default. In cases were this "bug" can happen, pt-table-sync prints a warning and skips the table. Read the option's docs to learn more.
844+
845+Another good bug fix is:
846+
847+* Fixed bug 1217013: pt-duplicate-key-checker misses exact duplicate unique indexes
848+
849+After saying "pt-duplicate-key-checker hasn't had a bug in years" at enough conferences, users proved us wrong--thanks! The tool is better now.
850+
851+* Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table
852+
853+This was poor feedback from the tool more than a bug. There was a point in the tool where it waited forever for slaves to catch up, but it did this silently. Now the tool reports --progress while it's waiting and it reports which slaves, if any, it found and intends to check. In short: its feedback delivers a better user experience.
854+
855+Finally, this bug (more like a feature request/change) might be a backwards-incompatible change:
856+
857+* Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled
858+
859+The change is that pt-mysql-summary no longer prompts to dump and summarize schemas. To do this, you must specify --databases or, a new option, --all-databases. Several users said this behavior was better, so we made the change even though some might consider it a backwards-incompatible change.
860+
861+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/).
862+
863+Changelog
864+---------
865+
866+* Added pt-query-digest support for Percona Server slow log rate limiting
867+* Added pt-agent --ping
868+* Added pt-mysql-summary --all-databases
869+* Added pt-stalk --sleep-collect
870+* Added pt-table-sync --[no]check-child-tables
871+* Fixed bug 1249150: PTDEBUG prints some info to STDOUT
872+* Fixed bug 1248363: pt-agent requires restart after changing MySQL options
873+* Fixed bug 1248778: pt-agent --install on PXC is not documented
874+* Fixed bug 1250973: pt-agent --install doesn't check for previous install
875+* Fixed bug 1250968: pt-agent --install suggest MySQL user isn't quoted
876+* Fixed bug 1251004: pt-agent --install error about slave is confusing
877+* Fixed bug 1251726: pt-agent --uninstall fails if agent is running
878+* Fixed bug 1248785: pt-agent docs don't list privs required for its MySQL user
879+* Fixed bug 1215016: pt-deadlock-logger docs use pt-fk-error-logger
880+* Fixed bug 1201443: pt-duplicate-key-checker error when EXPLAIN key_len=0
881+* Fixed bug 1217013: pt-duplicate-key-checker misses exact duplicate unique indexes
882+* Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled
883+* Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table
884+* Fixed bug 1249149: pt-query-digest stats prints to STDOUT instead of STDERR
885+* Fixed bug 1071979: pt-stak error parsing df with NFS
886+* Fixed bug 1223458: pt-table-sync deletes child table rows
887+
888+v2.2.5 released 2013-10-16
889+==========================
890+
891+Percona Toolkit 2.2.5 has been released. This release has four new features and a number of bugfixes.
892+
893+Query_time histogram has been added to the pt-query-digest JSON output, not the actual chart but the values necessary to render the chart later, so the values for each bucket.
894+
895+As of pt-table-checksum 2.2.5, skipped chunks cause a non-zero exit status. An exit status of zero or 32 is equivalent to a zero exit status with skipped chunks in previous versions of the tool.
896+
897+New --no-drop-triggers option has been implemented for pt-online-schema-change in case users want to rename the tables manually, when the load is low.
898+
899+New --new-table-name option has been added to pt-online-schema-change which can be used to specify the temporary table name.
900+
901+* Fixed bug #1199589: pt-archiver would delete the data even with the --dry-run option.
902+
903+* Fixed bug #821692: pt-query-digest didn't distill LOAD DATA correctly.
904+
905+* Fixed bug #984053: pt-query-digest didn't distill INSERT/REPLACE without INTO correctly.
906+
907+* Fixed bug #1206677: pt-agent docs were referencing wrong web address.
908+
909+* Fixed bug #1210537: pt-table-checksum --recursion-method=cluster would crash if no nodes were found.
910+
911+Percona Toolkit packages can be downloaded from
912+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
913+Repositories (http://www.percona.com/software/repositories
914+
915+Changelog
916+---------
917+
918+* Added Query_time histogram bucket counts to pt-query-digest JSON output
919+* Added pt-online-schema-change --[no]drop-triggers option
920+* Fixed bug #1199589: pt-archiver deletes data despite --dry-run
921+* Fixed bug #944051: pt-table-checksum has ambiguous exit status
922+* Fixed bug #1209436: pt-kill --log-dsn may not work on Perl 5.8
923+* Fixed bug #1210537: pt-table-checksum --recursion-method=cluster crashes if no nodes are found
924+* Fixed bug #1215608: pt-online-schema-change new table suffix is hard-coded
925+* Fixed bug #1229861: pt-table-sync quotes float values, can't sync
926+* Fixed bug #821692: pt-query-digest doesn't distill LOAD DATA correctly
927+* Fixed bug #984053: pt-query-digest doesn't distill INSERT/REPLACE without INTO correctly
928+* Fixed bug #1206728: pt-deadlock-logger 2.2 requires DSN on command line
929+* Fixed bug #1226721: pt-agent on CentOS 5 fails to send data
930+* Fixed bug #821690: pt-query-digest doesn't distill IF EXISTS correctly
931+* Fixed bug #1206677: pt-agent docs reference clodu.percona.com
932+
933+v2.2.4 released 2013-07-18
934+==========================
935+
936+Percona Toolkit 2.2.4 has been released. This release two new features and a number of bugfixes.
937+
938+pt-query-digest --output json includes query examples as of v2.2.3. Some people might not want this because it exposes real data. New option, --output json-anon, has been implemented. This option will provide the same data without query examples. It's "anonymous" in the sense that there's no identifying data; nothing more than schema and table structs can be inferred from fingerprints.
939+
940+When using drop swap with pt-online-schema-change there is some production impact. This impact can be measured because tool outputs the current timestamp on lines for operations that may take awhile.
941+
942+* Fixed bug #1163735: pt-table-checksum fails if explicit_defaults_for_timestamp is enabled in 5.6
943+pt-table-checksum would fail if variable explicit_defaults_for_timestamp was enabled in MySQL 5.6.
944+
945+* Fixed bug #1182856: Zero values causes "Invalid --set-vars value: var=0"
946+Trying to assign 0 to any variable by using --set-vars option would cause “Invalid --set-vars value” message.
947+
948+* Fixed bug #1188264: pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get
949+Fixed the typo in the pt-online-schema-change code that could lead to a tool crash when copying the rows.
950+
951+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
952+pt-table-checksum was using the first non-unique index instead of the one with the highest cardinality due to a sorting bug.
953+
954+Percona Toolkit packages can be downloaded from
955+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
956+Repositories (http://www.percona.com/software/repositories
957+
958+Changelog
959+---------
960+
961+* Added pt-query-digest anonymous JSON output
962+* Added pt-online-schema-change timestamp output
963+* Fixed bug #1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
964+* Fixed bug #1163735: pt-table-checksum fails if explicit_defaults_for_timestamp is enabled in 5.6
965+* Fixed bug #1182856: Zero values causes "Invalid --set-vars value: var=0"
966+* Fixed bug #1188264: pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get
967+* Fixed bug #1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
968+* Fixed bug #1199591: pt-table-checksum doesn't use non-unique index with highest cardinality
969+* Fixed bug #1168434: pt-upgrade reports differences on NULL
970+* Fixed bug #1172317: pt-sift does not work if pt-stalk did not collect due to a full disk
971+* Fixed bug #1176010: pt-query-digest doesn't group db and `db` together
972+* Fixed bug #1137556: pt-heartbeat docs don't account for --utc
973+* Fixed bug #1168106: pt-variable-advisor has the wrong default value for innodb_max_dirty_pages_pct in 5.5 and 5.6
974+* Fixed bug #1168110: pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is)
975+* Fixed bug #1171968: pt-query-digest docs don't mention --type=rawlog
976+* Fixed bug #1174956: pt-query-digest and pt-fingerprint don't strip some multi-line comments
977+
978+
979+v2.2.3 released 2013-06-17
980+==========================
981+
982+Percona Toolkit 2.2.3 has been released which has only two changes: pt-agent
983+and a bug fix for pt-online-schema-change. pt-agent is not a command line
984+tool but a client-side agent for Percona Cloud Tools. Visit
985+https://cloud.percona.com for more information. The pt-online-schema-change
986+bug fix is bug 1188002: pt-online-schema-change causes "ERROR 1146 (42S02):
987+"Table 'db._t_new' doesn't exist". This happens when the tool's triggers
988+cannot be dropped.
989+
990+Percona Toolkit packages can be downloaded from
991+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
992+Repositories (http://www.percona.com/software/repositories/).
993+
994+Changelog
995+---------
996+
997+* Added new tool: pt-agent
998+* Fixed bug 1188002: pt-online-schema-change causes "ERROR 1146 (42S02): Table 'db._t_new' doesn't exist"
999+
1000+v2.2.2 released 2013-04-24
1001+==========================
1002+
1003+Percona Toolkit 2.2.2 has been released. This is the second release of
1004+the 2.2 series and aims to fix bugs in the previous release and provide
1005+usability enhacements to the toolkit.
1006+
1007+Users may note the revival of the --show-all option in pt-query-digest.
1008+This had been removed in 2.2.1, but resulted in too much output in
1009+certain cases.
1010+
1011+A new --recursion-method was added to pt-table-checksum: cluster. This
1012+method attempts to auto-discover cluster nodes, alleviating the need to
1013+specify cluster node DSNs in a DSN table (--recursion-method=dsn).
1014+
1015+The following highlights some of the more interesting and "hot" bugs in
1016+this release:
1017+
1018+* Bug #1127450: pt-archiver --bulk-insert may corrupt data
1019+
1020+pt-archiver --bulk-insert didn't work with --charset UTF-8. This revealed
1021+a case where the tool could corrupt data by double-encoding. This is now
1022+fixed, but remains relatively dangerous if using DBD::mysql 3.0007 which
1023+does not handle UTF-8 properly.
1024+
1025+* Bug #1163372: pt-heartbeat --utc --check always returns 0
1026+
1027+Unfortunately, the relatively new --utc option for pt-heart was still
1028+broken because "[MySQL] interprets date as a value in the current time zone
1029+and converts it to an internal value in UTC." Now the tool works correctly
1030+with --utc by specifying "SET time_zone='+0:00'", and older versions of
1031+the tool can be made to work by specifying --set-vars "time_zone='+0:00'".
1032+
1033+* Bug #821502: Some tools don't have --help or --version
1034+
1035+pt-align, pt-mext, pt-pmp and pt-sift now have both options.
1036+
1037+This is another solid bug fix release, and all users are encouraged to upgrade.
1038+
1039+Percona Toolkit packages can be downloaded from
1040+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1041+Repositories (http://www.percona.com/software/repositories/).
1042+
1043+Changelog
1044+---------
1045+
1046+* Added --show-all to pt-query-digest
1047+* Added --recursion-method=cluster to pt-table-checksum
1048+* Fixed bug 1127450: pt-archiver --bulk-insert may corrupt data
1049+* Fixed bug 1163372: pt-heartbeat --utc --check always returns 0
1050+* Fixed bug 1156901: pt-query-digest --processlist reports duplicate queries for replication thread
1051+* Fixed bug 1160338: pt-query-digest 2.2 prints unwanted debug info on tcpdump parsing errors
1052+* Fixed bug 1160918: pt-query-digest 2.2 prints too many string values
1053+* Fixed bug 1156867: pt-stalk prints the wrong variable name in verbose mode when --function is used
1054+* Fixed bug 1081733: pt-stalk plugins can't access the real --prefix
1055+* Fixed bug 1099845: pt-table-checksum pxc same_node function incorrectly uses wsrep_sst_receive_address
1056+* Fixed bug 821502: Some tools don't have --help or --version
1057+* Fixed bug 947893: Some tools use @@hostname without /*!50038*/
1058+* Fixed bug 1082406: An explicitly set wsrep_node_incoming_address may make SHOW STATUS LIKE 'wsrep_incoming_addresses' return a portless address
1059+
1060+v2.2.1 released 2013-03-14
1061+==========================
1062+
1063+Percona Toolkit 2.2.1 has been released. This is the first release in
1064+the new 2.2 series which supersedes the 2.1 series and renders the 2.0
1065+series obsolete. We plan to do one more bug fix release for 2.1 (2.1.10),
1066+but otherwise all new development and fixes and will now focus on 2.2.
1067+
1068+Percona Toolkit 2.2 has been several months in the making, and it turned
1069+out very well, with many more new features, changes, and improvements than
1070+originally anticipated. Here are the highlights:
1071+
1072+----
1073+
1074+* Official support for MySQL 5.6
1075+
1076+We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta.
1077+Now that 5.6 is GA, so is our support for it. Check out the Percona Toolkit
1078+supported platforms and versions:
1079+http://www.percona.com/mysql-support/policies/percona-toolkit-supported-platforms-and-versions
1080+
1081+When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too.
1082+
1083+* Official support for Percona XtraDB Cluster (PXC)
1084+
1085+We also started beta support for Percona XtraDB Cluster in 2.1.8, but
1086+now that support is official in 2.2 because we have had many months to
1087+work with PXC and figure out which tools work with it and how. There's
1088+still one noticeable omission: pt-table-sync. It's still unclear if
1089+or how one would sync a cluster that, in theory, doesn't become out-of-sync.
1090+As Percona XtraDB Cluster develops, Percona Toolkit will continue to
1091+evolve to support it.
1092+
1093+* pt-online-schema-change (pt-osc) is much more resilient
1094+
1095+pt-online-schema-change 2.1 has been a great success, and people have been
1096+using it for evermore difficult and challenging tasks. Consequently, we
1097+needed to make it "try harder", even though it already tried pretty hard
1098+to keep working despite recoverable errors and such. Whereas pt-osc 2.1
1099+only retries certain operations, pt-osc 2.2 retries every critical operation,
1100+and its tries and wait time between tries for all operations are configurable.
1101+Also, we removed --lock-wait-timeout which set innodb_lock_wait_timeout
1102+because that now conflicts, or is at least confused with, lock_wait_timeout
1103+(introduced in MySQL 5.5) for metadata locks. Now --set-vars is used to
1104+set both of these (or any) system variables. For a quick intro to metadata
1105+locks and how they may affect you, see Ovais's article:
1106+http://www.mysqlperformanceblog.com/2013/02/01/implications-of-metadata-locking-changes-in-mysql-5-5/
1107+
1108+What does this all mean? In short: pt-online-schema-change 2.2 is far more
1109+resilient out of the box. It's also aware of metadata locks now, whereas
1110+2.1 was not really aware of them. And it's highly configurable, so you can
1111+make the tool try _very_ hard to keep working.
1112+
1113+* pt-upgrade is brand-new
1114+
1115+pt-upgrade was written once long ago, thrown into the world, and then never
1116+heard from again... until now. Now that we have four base versions of
1117+MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona
1118+Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster),
1119+upgrades are fashionable, so to speak. Problem is: "original" pt-upgrade
1120+was too noisy and too complex. pt-upgrade 2.2 is far simpler and far
1121+easier to use. It's basically what you expect from such a tool.
1122+
1123+Moreover, it has a really helpful new feature: "reference results", i.e.
1124+saved results from running queries on a server. Granted, this can take
1125+_a lot_ of disk space, but it allows you to "run now, compare later."
1126+
1127+If you're thinking about upgrading, give pt-upgrade a try. It also reads
1128+every type of log now (slow, general, binary, and tcpdump), so you shouldn't
1129+have a problem finding queries to run and compare.
1130+
1131+* pt-query-digest is simpler
1132+
1133+pt-query-digest 2.2 has fewer options now. Basically, we re-focused it
1134+on its primary objective: analyzing MySQL query logs. So the ability
1135+to parse memcached, Postgres, Apache, and other logs was removed. We
1136+also removed several options that probably nobody ever used, and
1137+changed/renamed other options to be more logical. The result is a simpler,
1138+more focused tool, i.e. less overwhelming.
1139+
1140+Also, pt-query-digest 2.2 can save results in JSON format (--output=json).
1141+This feature is still in development while we determine the optimal
1142+JSON structure.
1143+
1144+* Version check is on by default
1145+
1146+Way back in 2.1.4, released September/October 2012, we introduced a feature
1147+called "version check" into most tools: http://percona.com/version-check
1148+It's like a lot of software that automatically checks for updates, but
1149+it's also more: it's a free service from Percona that advises when certain
1150+programs (Percona Toolkit tools, MySQL, Perl, etc.) are either out of date
1151+or are known bad versions. For example, there are two versions of the
1152+DBD::mysql Perl module that have problems. And there are certain versions
1153+of MySQL that have critical bugs. Version check will warn you about these
1154+if your system is running them.
1155+
1156+What's new in 2.2 is that, whereas this feature (specifically, the option
1157+in tools: --version-check) was off by default, now it's on by default.
1158+If the IO::Socket::SSL Perl module is installed (easily available through
1159+your package manager), it will use a secure (https) connection over the web,
1160+else it will use a standard (http) connection.
1161+
1162+Check out http://percona.com/version-check for more information.
1163+
1164+* pt-query-advisor, pt-tcp-model, pt-trend, and pt-log-player are gone
1165+
1166+We removed pt-query-advisor, pt-tcp-model, pt-trend, and pt-log-player.
1167+Granted, no tool is ever really gone: if you need one of these tools,
1168+get it from 2.1. pt-log-player is now superseded by Percona Playback
1169+(http://www.percona.com/doc/percona-playback/). pt-query-advisor was
1170+removed so that we can focus our efforts on its online counterpart instead:
1171+https://tools.percona.com/query-advisor. The other tools were special
1172+projects that were not widely used.
1173+
1174+* pt-stalk and pt-mysql-summary have built-in MySQL options
1175+
1176+No more "pt-stalk -- -h db1 -u me". pt-stalk 2.2 and pt-mysql-summary 2.2
1177+have all the standard MySQL options built-in, like other tools: --user,
1178+--host, --port, --password, --socket, --defaults-file. So now the command
1179+line is what you expect: pt-stalk -h dhb1 -u me.
1180+
1181+* pt-stalk --no-stalk is no longer magical
1182+
1183+Originally, pt-stalk --no-stalk was meant to simulate pt-collect, i.e.
1184+collect once and exit. To do that, the tool magically set some options
1185+and clobbered others, resulting in no way to do repeated collections
1186+at intervals. Now --no-stalk means only that: don't stalk, just collect,
1187+respecting --interval and --iterations as usual. So to collect once
1188+and exit: pt-stalk --no-stalk --iterations 1.
1189+
1190+* pt-fk-error-logger and pt-deadlock-logger are standardized
1191+
1192+Similar to the pt-stalk --no-stalk changes, pt-fk-error-logger and
1193+pt-deadlock-logger received mini overhauls in 2.2 to make their
1194+run-related options (--run-time, --interval, --iterations) standard.
1195+If you hadn't noticed, one tool would run forever by default, while
1196+the other would run once and exit. And each treated their run-related
1197+options a little differently. This magic is gone now: both tools run
1198+forever by default, so specify --iterations or --run-time to limit how
1199+long they run.
1200+
1201+----
1202+
1203+There were other miscellaneous bug fixes, too. See
1204+https://launchpad.net/percona-toolkit/+milestone/2.2.1 for the full list.
1205+
1206+As the first release in a new series, 2.2 features are not yet finalized.
1207+In other words, we may change things like the pt-query-digest --output json
1208+format in future releases after receiving real-world feedback.
1209+
1210+Percona Toolkit 2.2 is an exciting release with many helpful new
1211+features. Users are encouraged to begin upgrading, particularly given
1212+that, except for the forthcoming 2.1.10 release, no more work will be
1213+done on 2.1 (unless you're a Percona customer with a support contract or
1214+other agreement).
1215+
1216+If you upgrade from 2.1 to 2.2, be sure to re-read tools' documentation
1217+to see what has changed because much as changed for certain tools.
1218+
1219+Percona Toolkit packages can be downloaded from
1220+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1221+Repositories (http://www.percona.com/software/repositories/).
1222+
1223+Changelog
1224+---------
1225+
1226+* Official support for MySQL 5.6
1227+* Official support for Percona XtraDB Cluster
1228+* Redesigned pt-query-digest
1229+* Redesigned pt-upgrade
1230+* Redesigned pt-fk-error-logger
1231+* Redesigned pt-deadlock-logger
1232+* Changed --set-vars in all tools
1233+* Renamed --retries to --tries in pt-online-schema-change
1234+* Added --check-read-only to pt-heartbeat
1235+* Added MySQL options to pt-mysql-summary
1236+* Added MySQL options to pt-stalk
1237+* Removed --lock-wait-timeout from pt-online-schema-change (use --set-vars)
1238+* Removed --lock-wait-timeout from pt-table-checksum (use --set-vars)
1239+* Removed pt-query-advisor
1240+* Removed pt-tcp-model
1241+* Removed pt-trend
1242+* Removed pt-log-player
1243+* Enabled --version-check by default in all tools
1244+* Fixed bug 1008796: Several tools don't have --database
1245+* Fixed bug 1087319: Quoter::serialize_list() doesn't handle multiple NULL values
1246+* Fixed bug 1086018: pt-config-diff needs to parse wsrep_provider_options
1247+* Fixed bug 1056838: pt-fk-error-logger --run-time works differently than pt-deadlock-logger --run-time
1248+* Fixed bug 1093016: pt-online-schema-change doesn't retry RENAME TABLE
1249+* Fixed bug 1113301: pt-online-schema-change blocks on metadata locks
1250+* Fixed bug 1125665: pt-stalk --no-stalk silently clobbers other options, acts magically
1251+* Fixed bug 1019648: pt-stalk truncates InnoDB status if there are too many transactions
1252+* Fixed bug 1087804: pt-table-checksum doesn't warn if no slaves are found
1253+
1254+v2.1.9 released 2013-02-14
1255+==========================
1256+
1257+Percona Toolkit 2.1.9 has been released. This release primarily aims to
1258+restore backwards-compatibility with pt-heartbeat 2.1.7 and older, but it
1259+also has important bug fixes for other tools.
1260+
1261+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
1262+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
1263+
1264+The previous release switched the time authority from Perl to MySQL, and from
1265+local time to UTC. Unfortunately, these changes caused a loss of precision and,
1266+if mixing versions of pt-heartbeat, made the tool report a huge amount of
1267+replication lag. This release makes the tool compatible with pt-heartbeat
1268+2.1.7 and older again, but the UTC behavior introduced in 2.1.8 is now only
1269+available by specifying the new --utc option.
1270+
1271+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
1272+
1273+This is an important bug fix for pt-table-sync: certain chunks from
1274+pt-table-checksum resulted in an impossible WHERE, causing the false-positive
1275+"Cannot nibble" error, if those chunks had diffs.
1276+
1277+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
1278+
1279+MariaDB 5.5.28 (https://kb.askmonty.org/en/mariadb-5528-changelog/) fixed
1280+a bug: "Added warnings for duplicate key errors when using INSERT IGNORE".
1281+However, standard MySQL does not warn in this case, despite the docs saying
1282+that it should. Since pt-online-schema-change has always intended to ignore
1283+duplicate entry errors by using "INSERT IGNORE", it now handles the MariaDB
1284+case by also ignoring duplicate entry errors in the code.
1285+
1286+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
1287+
1288+pt-online-schema-change 2.1.9 handles another case of changing the primary key.
1289+However, since changing the primary key is tricky, the tool stops if --alter
1290+contains "DROP PRIMARY KEY", and you have to specify --no-check-alter to
1291+acknowledge this case.
1292+
1293+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
1294+
1295+Previously, pt-stalk printed a line for every check. Since the tool is
1296+designed to be a long-running daemon, this could result in huge log files
1297+with "matched=no" lines. The tool has a new --verbose option which makes it
1298+quieter by default.
1299+
1300+All users should upgrade, but in particular, users of versions 2.1.7 and
1301+older are strongly recommended to skip 2.1.8 and go directly to 2.1.9.
1302+
1303+Users of pt-heartbeat in 2.1.8 who prefer the UTC behavior should keep in
1304+mind that they will have to use the --utc option after upgrading.
1305+
1306+Percona Toolkit packages can be downloaded from
1307+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1308+Repositories (http://www.percona.com/software/repositories/).
1309+
1310+Changelog
1311+---------
1312+
1313+* Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
1314+* Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
1315+* Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB
1316+* Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
1317+* Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function
1318+* Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump
1319+* Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors
1320+* Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
1321+* Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index"
1322+* Fixed bug 1099933: pt-stalk is too verbose, fills up log
1323+
1324+v2.1.8 released 2012-12-21
1325+==========================
1326+
1327+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:
1328+
1329+* pt-table-chcecksum
1330+* pt-online-schema-change
1331+* pt-archive
1332+* pt-mysql-summary
1333+* pt-heartbeat
1334+* pt-variable-advisor
1335+* pt-config-diff
1336+* pt-deadlock-logger
1337+
1338+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.
1339+
1340+The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:
1341+
1342+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
1343+
1344+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 */``.
1345+
1346+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1347+
1348+The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.
1349+
1350+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1351+
1352+Some renamed variables had caused the Percona Server section to work unreliably.
1353+
1354+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1355+
1356+When using --replicate-check-only, filter options like --databases and --tables were not applied.
1357+
1358+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1359+
1360+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.
1361+
1362+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1363+
1364+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.
1365+
1366+2.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.
1367+
1368+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/).
1369+
1370+Changelog
1371+---------
1372+
1373+* Beta support for MySQL 5.6
1374+* Beta support for Percona XtraDB Cluster
1375+* pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1376+* pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer
1377+* pt-upgrade: Added --[no]disable-query-cache
1378+* Fixed bug 927955: Bad pod2rst transformation
1379+* Fixed bug 898665: Bad online docs formatting for --[no]vars
1380+* Fixed bug 1022622: pt-config-diff is case-sensitive
1381+* Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments
1382+* Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
1383+* Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes
1384+* Fixed bug 886059: pt-heartbeat handles timezones inconsistently
1385+* Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong
1386+* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
1387+* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables
1388+* Fixed bug 823431: pt-query-advisor hangs on big queries
1389+* Fixed bug 996069: pt-query-advisor RES.001 is incorrect
1390+* Fixed bug 933465: pt-query-advisor false positive on RES.001
1391+* Fixed bug 937234: pt-query-advisor issues wrong RES.001
1392+* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query
1393+* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"
1394+* Fixed bug 957442: pt-query-digest with custom --group-by throws error
1395+* Fixed bug 887638: pt-query-digest prints negative byte offset
1396+* Fixed bug 831525: pt-query-digest help output mangled
1397+* Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error
1398+* Fixed bug 1046440: pt-stalk purge_samples slows down checks
1399+* Fixed bug 986847: pt-stalk does not report NFS iostat
1400+* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only
1401+* Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used
1402+* Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef
1403+* Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950
1404+* Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611
1405+* Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
1406+
1407+v2.1.7 released 2012-11-19
1408+==========================
1409+
1410+Percona Toolkit 2.1.7 has been released which is a hotfix for two bugs when using pt-table-checksum with Percona XtraDB Cluster:
1411+
1412+* Bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1413+* Bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1414+
1415+If you're using pt-table-checksum with a Percona XtraDB Cluster, you should upgrade. Otherwise, users can wait until the next full release.
1416+
1417+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/).
1418+
1419+Changelog
1420+---------
1421+
1422+* Fixed bug 1080384: pt-table-checksum 2.1.6 crashes using PTDEBUG
1423+* Fixed bug 1080385: pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
1424+
1425+v2.1.6 released 2012-11-13
1426+==========================
1427+
1428+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:
1429+
1430+* Bug 978133: pt-query-digest review table privilege checks don't work
1431+
1432+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.
1433+
1434+* Bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1435+
1436+A particularly important fix, as it may stop pt-table-checksum from breaking replication in these setups.
1437+
1438+* Bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1439+
1440+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.
1441+
1442+* Bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1443+
1444+Fixed by choosing a key on the new table for the DELETE trigger.
1445+
1446+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1447+
1448+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.
1449+
1450+* Bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1451+
1452+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.
1453+
1454+* Bug 866075: pt-show-grant doesn't support column-level grants
1455+
1456+This was actually the 'hottest' bug in the tracker.
1457+
1458+This is another solid bug fix release, and all 2.1 users are encouraged to upgrade.
1459+
1460+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/).
1461+
1462+Changelog
1463+---------
1464+
1465+* pt-online-schema-change: Columns can now be renamed without data loss
1466+* pt-online-schema-change: New --default-engine option
1467+* pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality
1468+* Fixed bug 1069951: --version-check default should be explicitly "off"
1469+* Fixed bug 821715: LOAD DATA LOCAL INFILE broken in some platforms
1470+* Fixed bug 995896: Useless use of cat in Daemon.pm
1471+* Fixed bug 1039074: Tools exit 0 on error parsing options, should exit non-zero
1472+* Fixed bug 938068: pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
1473+* Fixed bug 1009510: pt-table-checksum breaks replication if a slave table is missing or different
1474+* Fixed bug 1043438: pt-table-checksum doesn't honor --run-time while checking replication lag
1475+* Fixed bug 1073532: pt-table-checksum error: Use of uninitialized value in int at line 2778
1476+* Fixed bug 1016131: pt-table-checksum can crash with --columns if none match
1477+* Fixed bug 1039569: pt-table-checksum dies if creating the --replicate table fails
1478+* Fixed bug 1059732: pt-table-checksum doesn't test all hash functions
1479+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1480+* Fixed bug 1043528: pt-deadlock-logger can't parse db/tbl/index on partitioned tables
1481+* Fixed bug 1062324: pt-online-schema-change DELETE trigger fails when altering primary key
1482+* Fixed bug 1058285: pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
1483+* Fixed bug 1073996: pt-online-schema-change fails with "I need a max_rows argument"
1484+* Fixed bug 1039541: pt-online-schema-change --quiet doesn't disable --progress
1485+* Fixed bug 1045317: pt-online-schema-change doesn't report how many warnings it suppressed
1486+* Fixed bug 1060774: pt-upgrade fails if select column > 64 chars
1487+* Fixed bug 1070916: pt-mysql-summary may report the wrong cnf file
1488+* Fixed bug 903229: pt-mysql-summary incorrectly categorizes databases
1489+* Fixed bug 866075: pt-show-grant doesn't support column-level grants
1490+* Fixed bug 978133: pt-query-digest review table privilege checks don't work
1491+* Fixed bug 956981: pt-query-digest docs for event attributes link to defunct Maatkit wiki
1492+* Fixed bug 1047335: pt-duplicate-key-checker fails when it encounters a crashed table
1493+* Fixed bug 1047701: pt-stalk deletes non-empty files
1494+* Fixed bug 1070434: pt-stalk --no-stalk and --iterations 1 don't wait for the collect
1495+* Fixed bug 1052722: pt-fifo-split is processing n-1 rows initially
1496+* Fixed bug 1013407: pt-find documentation error with mtime and InnoDB
1497+* Fixed bug 1059757: pt-trend output has no header
1498+* Fixed bug 1063933: pt-visual-explain docs link to missing pdf
1499+* Fixed bug 1075773: pt-fk-error-logger crashes if there's no foreign key error
1500+* Fixed bug 1075775: pt-fk-error-logger --dest table example doesn't work
1501+
1502+v2.1.5 released 2012-10-08
1503+==========================
1504+
1505+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:
1506+
1507+* Bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1508+
1509+* Bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1510+
1511+* Bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1512+
1513+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.
1514+
1515+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.
1516+
1517+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.
1518+
1519+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/).
1520+
1521+Changelog
1522+---------
1523+
1524+* Fixed bug 1062563: pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
1525+* Fixed bug 1063912: pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes
1526+* Fixed bug 1064016: pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
1527+* Fixed bug 1060423: Missing version-check page
1528+
1529+v2.1.4 released 2012-09-20
1530+==========================
1531+
1532+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:
1533+
1534+* Fixed bug 1017626: pt-table-checksum doesn't work with Percona XtraDB Cluster
1535+
1536+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.
1537+
1538+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1539+
1540+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.
1541+
1542+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1543+
1544+Which were stopping pt-upgrade from working on a MySQL 4.1 host.
1545+
1546+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1547+
1548+The same checks were removed in the previous release from pt-table-checksum, so this continues the trend.
1549+
1550+* Fixed bug 1038995: pt-stalk --notify-by-email fails
1551+
1552+This was a bug in our shell option parsing library, and would potentially affect any option starting with 'no'.
1553+
1554+Like 2.1.3, this is another solid bug fix release, and 2.1 users are encouraged to upgrade.
1555+
1556+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/).
1557+
1558+Changelog
1559+---------
1560+
1561+* pt-table-checksum: Percona XtraDB Cluster support
1562+* pt-table-checksum: Implemented the standard --run-time option
1563+* Implemented the version-check feature in several tools, enabled with the --version-check option
1564+* Fixed bug 856060: Document gdb dependency
1565+* Fixed bug 1041394: Unquoted arguments to tr break the bash tools
1566+* Fixed bug 1035311: pt-diskstats shows wrong device names
1567+* Fixed bug 1036804: pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
1568+* Fixed bug 1022658: pt-online-schema-change dropping FK limitation isn't documented
1569+* Fixed bug 1041372: pt-online-schema-changes fails if db+tbl name exceeds 64 characters
1570+* Fixed bug 1029178: pt-query-digest --type tcpdump memory usage keeps increasing
1571+* Fixed bug 1037211: pt-query-digest won't distill LOCK TABLES in lowercase
1572+* Fixed bug 942114: pt-stalk warns about bad "find" usage
1573+* Fixed bug 1035319: pt-stalk df -h throws away needed details
1574+* Fixed bug 1038995: pt-stalk --notify-by-email fails
1575+* Fixed bug 1038995: pt-stalk does not get all InnoDB lock data
1576+* Fixed bug 952722: pt-summary should show information about Fusion-io cards
1577+* Fixed bug 899415: pt-table-checksum doesn't work if slaves use RBR
1578+* Fixed bug 954588: pt-table-checksum --check-slave-lag docs aren't clear
1579+* Fixed bug 1034170: pt-table-checksum --defaults-file isn't used for slaves
1580+* Fixed bug 930693: pt-table-sync and text columns with just whitespace
1581+* Fixed bug 1028710: pt-table-sync base_count fails on n = 1000, base = 10
1582+* Fixed bug 1034717: pt-table-sync division by zero error with varchar primary key
1583+* Fixed bug 1036747: pt-table-sync priv checks need to be removed
1584+* Fixed bug 1039184: pt-upgrade error "I need a right_sth argument"
1585+* Fixed bug 1035260: sh warnings in pt-summary and pt-mysql-summary
1586+* Fixed bug 1038276: ChangeHandler doesn't quote varchar columns with hex-looking values
1587+* Fixed bug 916925: CentOS 5 yum dependency resolution for perl module is wrong
1588+* Fixed bug 1035950: Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
1589+
1590+v2.1.3 released 2012-08-03
1591+==========================
1592+
1593+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:
1594+
1595+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1596+
1597+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.
1598+
1599+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1600+
1601+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.
1602+
1603+* Fixed bug 821703: pt-query-digest --processlist may crash
1604+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1605+
1606+Certain distributions of MySQL add extra columns to SHOW PROCESSLIST which caused pt-query-digest --processlist to crash at times.
1607+
1608+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1609+
1610+pt-kill is meant to be a long-running daemon, so naturally it's important that it stays connected to MySQL.
1611+
1612+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1613+
1614+The combination of these pt-heartbeat options could cause replication to break due to a duplicate key error.
1615+
1616+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1617+
1618+This bug was related to how --quiet was handled, and it could happen even if --quiet wasn't given on the command line.
1619+
1620+All in all, this is solid bug fix release, and 2.1 users are encouraged to upgrade.
1621+
1622+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/).
1623+
1624+Changelog
1625+---------
1626+
1627+* pt-kill: Implemented --log-dsn to log info about killed queries to a table
1628+* Fixed bug 1016127: Install hint for DBD::mysql is wrong
1629+* Fixed bug 984915: DSNParser does not check success of --set-vars
1630+* Fixed bug 889739: pt-config-diff doesn't diff quoted strings properly
1631+* Fixed bug 969669: pt-duplicate-key-checker --key-types=k doesn't work
1632+* Fixed bug 1004567: pt-heartbeat --update --replace causes duplicate key error
1633+* Fixed bug 1028614: pt-index-usage ignores --database
1634+* Fixed bug 940733: pt-ioprofile leaves behind temp directory
1635+* Fixed bug 941469: pt-kill doesn't reconnect if its connection is lost
1636+* Fixed bug 1016114: pt-online-schema-change docs don't mention default values
1637+* Fixed bug 1020997: pt-online-schema-change fails when table is empty
1638+* Fixed bug 1022628: pt-online-schema-change error: Use of uninitialized value in numeric lt (<) at line 6519
1639+* Fixed bug 937225: pt-query-advisor OUTER JOIN advice in JOI.003 is confusing
1640+* Fixed bug 821703: pt-query-digest --processlist may crash
1641+* Fixed bug 883098: pt-query-digest crashes if processlist has extra columns
1642+* Fixed bug 924950: pt-query-digest --group-by db may crash profile report
1643+* Fixed bug 1022851: pt-sift error: PREFIX: unbound variable
1644+* Fixed bug 969703: pt-sift defaults to '.' instead of '/var/lib/pt-talk'
1645+* Fixed bug 962330: pt-slave-delay incorrectly computes lag if started when slave is already lagging
1646+* Fixed bug 954990: pt-stalk --nostalk does not work
1647+* Fixed bug 977226: pt-summary doesn't detect LSI RAID control
1648+* Fixed bug 1030031: pt-table-checksum reports wrong number of DIFFS
1649+* Fixed bug 916168: pt-table-checksum privilege check fails on MySQL 5.5
1650+* Fixed bug 950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS
1651+* Fixed bug 953141: pt-table-checksum ignores its default and explicit --recursion-method
1652+* Fixed bug 1030975: pt-table-sync crashes if sql_mode includes ANSI_QUOTES
1653+* Fixed bug 869005: pt-table-sync should always set REPEATABLE READ
1654+* Fixed bug 903510: pt-tcp-model crashes in --type=requests mode on empty file
1655+* Fixed bug 934310: pt-tcp-model --quantile docs wrong
1656+* Fixed bug 980318: pt-upgrade results truncated if hostnames are long
1657+* Fixed bug 821696: pt-variable-advisor shows too long of a snippet
1658+* Fixed bug 844880: pt-variable-advisor shows binary logging as both enabled and disabled
1659+
1660+v2.1.2 released 2012-06-12
1661+==========================
1662+
1663+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.
1664+
1665+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.
1666+
1667+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.
1668+
1669+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.
1670+
1671+Two pt-archiver bugs were fixed: bug 979092, --sleep conflicts with bulk operations; and bug 903379, --file doesn't create a file.
1672+
1673+--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.
1674+
1675+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.
1676+
1677+Percona Toolkit 2.1.2 should be backwards-compatible with 2.1.1, so users are strongly encouraged to upgrade.
1678+
1679+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/).
1680+
1681+Changelog
1682+---------
1683+
1684+* pt-heartbeat: Implemented --recursion-method=none
1685+* pt-index-usage: MySQL 5.5 compatibility fixes
1686+* pt-log-player: MySQL 5.5 compatibility fixes
1687+* pt-online-schema-change: Added --chunk-index-columns
1688+* pt-online-schema-change: Added --[no]check-plan
1689+* pt-online-schema-change: Added --[no]drop-new-table
1690+* pt-online-schema-change: Implemented --recursion-method=none
1691+* pt-query-advisor: Added --report-type for JSON output
1692+* pt-query-digest: Removed --[no]zero-bool
1693+* pt-slave-delay: Added --database
1694+* pt-slave-find: Implemented --recursion-method=none
1695+* pt-slave-restart: Implemented --recursion-method=none
1696+* pt-table-checksum: Added --chunk-index-columns
1697+* pt-table-checksum: Added --[no]check-plan
1698+* pt-table-checksum: Implemented --recursion-method=none
1699+* pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer
1700+* pt-table-sync: Implemented --recursion-method=none
1701+* Fixed bug 945079: Shell tools TMPDIR may break
1702+* Fixed bug 912902: Some shell tools still use basename
1703+* Fixed bug 987694: There is no --recursion-method=none option
1704+* Fixed bug 886077: Passwords with commas don't work, expose part of password
1705+* Fixed bug 856024: Lintian warnings when building percona-toolkit Debian package
1706+* Fixed bug 903379: pt-archiver --file doesn't create a file
1707+* Fixed bug 979092: pt-archiver --sleep conflicts with bulk operations
1708+* Fixed bug 903443: pt-deadlock-logger crashes on MySQL 5.5
1709+* Fixed bug 941064: pt-deadlock-logger can't clear deadlocks on 5.5
1710+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1711+* Fixed bug 994176: pt-diskstats --group-by=all --headers=scroll prints a header for every sample
1712+* Fixed bug 894140: pt-duplicate-key-checker sometimes recreates a key it shouldn't
1713+* Fixed bug 923896: pt-kill: uninitialized value causes script to exit
1714+* Fixed bug 1003003: pt-online-schema-change uses different keys for chunking and triggers
1715+* Fixed bug 1003315: pt-online-schema-change --dry-run always fails on table with foreign keys
1716+* Fixed bug 1004551: pt-online-schema-change --no-swap-tables causes error
1717+* Fixed bug 976108: pt-online-schema-change doesn't allow to disable foreign key checks
1718+* Fixed bug 976109: pt-online-schema-change doesn't handle column renames
1719+* Fixed bug 988036: pt-online-schema-change causes deadlocks under heavy write load
1720+* Fixed bug 989227: pt-online-schema-change crashes with PTDEBUG
1721+* Fixed bug 994002: pt-online-schema-change 2.1.1 doesn't choose the PRIMARY KEY
1722+* Fixed bug 994010: pt-online-schema-change 2.1.1 crashes without InnoDB
1723+* Fixed bug 996915: pt-online-schema-change crashes with invalid --max-load and --critical-load
1724+* Fixed bug 998831: pt-online-schema-change -- Should have an option to NOT drop tables on failure
1725+* Fixed bug 1002448: pt-online-schema-change: typo for finding usable indexes
1726+* Fixed bug 885382: pt-query-digest --embedded-attributes doesn't check cardinality
1727+* Fixed bug 888114: pt-query-digest report crashes with infinite loop
1728+* Fixed bug 949630: pt-query-digest mentions a Subversion repository
1729+* Fixed bug 844034: pt-show-grants --separate fails with proxy user
1730+* Fixed bug 946707: pt-sift loses STDIN after pt-diskstats
1731+* Fixed bug 994947: pt-stalk doesn't reset cycles_true after collection
1732+* Fixed bug 986151: pt-stalk-has mktemp error
1733+* Fixed bug 993436: pt-summary Memory: Total reports M instead of G
1734+* Fixed bug 1008778: pt-table-checksum doesn't wait for checksum table to replicate
1735+* Fixed bug 1010232: pt-table-checksum doesn't check the size of checksum chunks
1736+* Fixed bug 1011738: pt-table-checksum SKIPPED is zero but chunks were skipped
1737+* Fixed bug 919499: pt-table-checksum fails with binary log error in mysql >= 5.5.18
1738+* Fixed bug 972399: pt-table-checksum docs are not rendered right
1739+* Fixed bug 978432: pt-table-checksum ignoring primary key
1740+* Fixed bug 995274: pt-table-checksum can't use an undefined value as an ARRAY reference at line 2206
1741+* Fixed bug 996110: pt-table-checksum crashes if InnoDB is disabled
1742+* Fixed bug 987393: pt-table-checksum: Empy tables cause "undefined value as an ARRAY" errors
1743+* Fixed bug 1002365: pt-table-sync --ignore-* options don't work with --replicate
1744+* Fixed bug 1003014: pt-table-sync --replicate and --sync-to-master error "index does not exist"
1745+* Fixed bug 823403: pt-table-sync --lock-and-rename doesn't work on 5.1
1746+* Fixed bug 898138: pt-variable-advisor doesn't recognize 5.5.3+ concurrent_insert values
1747+
1748+v2.1.1 released 2012-04-03
1749+==========================
1750+
1751+Percona Toolkit 2.1.1 has been released. This is the first release in the
1752+new 2.1 series which supersedes the 2.0 series. We will continue to fix bugs
1753+in 2.0, but 2.1 is now the focus of development.
1754+
1755+2.1 introduces a lot of new code for:
1756+
1757+* pt-online-schema-change (completely redesigned)
1758+* pt-mysql-summary (completely redesigned)
1759+* pt-summary (completely redesigned)
1760+* pt-fingerprint (new tool)
1761+* pt-table-usage (new tool)
1762+
1763+There were also several bug fixes.
1764+
1765+The redesigned tools are meant to replace their 2.0 counterparts because
1766+the 2.1 versions have the same or more functionality and they are simpler
1767+and more reliable. pt-online-schema-change was particularly enhanced to
1768+be as safe as possible given that the tool is inherently risky.
1769+
1770+Percona Toolkit packages can be downloaded from
1771+http://www.percona.com/downloads/percona-toolkit/ or the Percona Software
1772+Repositories (http://www.percona.com/software/repositories/).
1773+
1774+Changelog
1775+---------
1776+
1777+* Completely redesigned pt-online-schema-change
1778+* Completely redesigned pt-mysql-summary
1779+* Completely redesigned pt-summary
1780+* Added new tool: pt-table-usage
1781+* Added new tool: pt-fingerprint
1782+* Fixed bug 955860: pt-stalk doesn't run vmstat, iostat, and mpstat for --run-time
1783+* Fixed bug 960513: SHOW TABLE STATUS is used needlessly
1784+* Fixed bug 969726: pt-online-schema-change loses foreign keys
1785+* Fixed bug 846028: pt-online-schema-change does not show progress until completed
1786+* Fixed bug 898695: pt-online-schema-change add useless ORDER BY
1787+* Fixed bug 952727: pt-diskstats shows incorrect wr_mb_s
1788+* Fixed bug 963225: pt-query-digest fails to set history columns for disk tmp tables and disk filesort
1789+* Fixed bug 967451: Char chunking doesn't quote column name
1790+* Fixed bug 972399: pt-table-checksum docs are not rendered right
1791+* Fixed bug 896553: Various documentation spelling fixes
1792+* Fixed bug 949154: pt-variable-advisor advice for relay-log-space-limit
1793+* Fixed bug 953461: pt-upgrade manual broken 'output' section
1794+* Fixed bug 949653: pt-table-checksum docs don't mention risks posed by inconsistent schemas
1795+
1796+v2.0.4 released 2012-03-07
1797+==========================
1798+
1799+Percona Toolkit 2.0.4 has been released. 23 bugs were fixed in this release,
1800+and three new features were implemented. First, --filter was added to pt-kill
1801+which allows for arbitrary --group-by. Second, pt-online-schema-change now
1802+requires that its new --execute option be given, else the tool will just check
1803+the tables and exit. This is a safeguard to encourage users to read the
1804+documentation, particularly when replication is involved. Third, pt-stalk
1805+also received a new option: --[no]stalk. To collect immediately without
1806+stalking, specify --no-stalk and the tool will collect once and exit.
1807+
1808+This release is completely backwards compatible with previous 2.0 releases.
1809+Given the number of bug fixes, it's worth upgrading to 2.0.4.
1810+
1811+Changelog
1812+---------
1813+
1814+* Added --filter to pt-kill to allow arbitrary --group-by
1815+* Added --[no]stalk to pt-stalk (bug 932331)
1816+* Added --execute to pt-online-schema-change (bug 933232)
1817+* Fixed bug 873598: pt-online-schema-change doesn't like reserved words in column names
1818+* Fixed bug 928966: pt-pmp still uses insecure /tmp
1819+* Fixed bug 933232: pt-online-schema-change can break replication
1820+* Fixed bug 941225: Use of qw(...) as parentheses is deprecated at pt-kill line 3511
1821+* Fixed bug 821694: pt-query-digest doesn't recognize hex InnoDB txn IDs
1822+* Fixed bug 894255: pt-kill shouldn't check if STDIN is a tty when --daemonize is given
1823+* Fixed bug 916999: pt-table-checksum error: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed
1824+* Fixed bug 926598: DBD::mysql bug causes pt-upgrade to use wrong precision (M) and scale (D)
1825+* Fixed bug 928226: pt-diskstats illegal division by zero
1826+* Fixed bug 928415: Typo in pt-stalk doc: --trigger should be --function
1827+* Fixed bug 930317: pt-archiver doc refers to nonexistent pt-query-profiler
1828+* Fixed bug 930533: pt-sift looking for *-processlist1; broken compatibility with pt-stalk
1829+* Fixed bug 932331: pt-stalk cannot collect without stalking
1830+* Fixed bug 932442: pt-table-checksum error when column name has two spaces
1831+* Fixed bug 932883: File Debian bug after each release
1832+* Fixed bug 940503: pt-stalk disk space checks wrong on 32bit platforms
1833+* Fixed bug 944420: --daemonize doesn't always close STDIN
1834+* Fixed bug 945834: pt-sift invokes pt-diskstats with deprecated argument
1835+* Fixed bug 945836: pt-sift prints awk error if there are no stack traces to aggregate
1836+* Fixed bug 945842: pt-sift generates wrong state sum during processlist analysis
1837+* Fixed bug 946438: pt-query-digest should print a better message when an unsupported log format is specified
1838+* Fixed bug 946776: pt-table-checksum ignores --lock-wait-timeout
1839+* Fixed bug 940440: Bad grammar in pt-kill docs
1840+
1841+v2.0.3 released 2012-02-03
1842+==========================
1843+
1844+Percona Toolkit 2.0.3 has been released. The development team was very
1845+busy last month making this release significant: two completely
1846+redesigned and improved tools, pt-diskstats and pt-stalk, and 20 bug fixes.
1847+
1848+Both pt-diskstats and pt-stalk were redesigned and rewritten from the ground
1849+up. This allowed us to greatly improve these tools' functionality and
1850+increase testing for them. The accuracy and output of pt-diskstats was
1851+enhanced, and the tool was rewritten in Perl. pt-collect was removed and
1852+its functionality was put into a new, enhanced pt-stalk. pt-stalk is now
1853+designed to be a stable, long-running daemon on a variety of common platforms.
1854+It is worth re-reading the documentation for each of these tools.
1855+
1856+The 20 bug fixes cover a wide range of problems. The most important are
1857+fixes to pt-table-checksum, pt-iostats, and pt-kill. Apart from pt-diskstats,
1858+pt-stalk, and pt-collect (which was removed), no other tools were changed
1859+in backwards-incompatible ways, so it is worth reviewing the full changelog
1860+for this release and upgrading if you use any tools which had bug fixes.
1861+
1862+Thank you to the many people who reported bugs and submitted patches.
1863+
1864+Download the latest release of Percona Toolkit 2.0 from
1865+http://www.percona.com/software/percona-toolkit/
1866+or the Percona Software Repositories
1867+(http://www.percona.com/docs/wiki/repositories:start).
1868+
1869+Changelog
1870+---------
1871+
1872+* Completely redesigned pt-diskstats
1873+* Completely redesigned pt-stalk
1874+* Removed pt-collect and put its functionality in pt-stalk
1875+* Fixed bug 871438: Bash tools are insecure
1876+* Fixed bug 897758: Failed to prepare TableSyncChunk plugin: Use of uninitialized value $args{"chunk_range"} in lc at pt-table-sync line 3055
1877+* Fixed bug 919819: pt-kill --execute-command creates zombies
1878+* Fixed bug 925778: pt-ioprofile doesn't run without a file
1879+* Fixed bug 925477: pt-ioprofile docs refer to pt-iostats
1880+* Fixed bug 857091: pt-sift downloads http://percona.com/get/pt-pmp, which does not work
1881+* Fixed bug 857104: pt-sift tries to invoke mext, should be pt-mext
1882+* Fixed bug 872699: pt-diskstats: rd_avkb & wr_avkb derived incorrectly
1883+* Fixed bug 897029: pt-diskstats computes wrong values for md0
1884+* Fixed bug 882918: pt-stalk spams warning if oprofile isn't installed
1885+* Fixed bug 884504: pt-stalk doesn't check pt-collect
1886+* Fixed bug 897483: pt-online-schema-change "uninitialized value" due to update-foreign-keys-method
1887+* Fixed bug 925007: pt-online-schema-change Use of uninitialized value $tables{"old_table"} in concatenation (.) or string at line 4330
1888+* Fixed bug 915598: pt-config-diff ignores --ask-pass option
1889+* Fixed bug 919352: pt-table-checksum changes binlog_format even if already set to statement
1890+* Fixed bug 921700: pt-table-checksum doesn't add --where to chunk size test on replicas
1891+* Fixed bug 921802: pt-table-checksum does not recognize --recursion-method=processlist
1892+* Fixed bug 925855: pt-table-checksum index check is case-sensitive
1893+* Fixed bug 821709: pt-show-grants --revoke and --separate don't work together
1894+* Fixed bug 918247: Some tools use VALUE instead of VALUES
1895+
1896+v2.0.2 released 2012-01-05
1897+==========================
1898+
1899+Percona Toolkit 2.0.2 fixes one critical bug: pt-table-sync --replicate
1900+did not work with character values, causing an "Unknown column" error.
1901+If using Percona Toolkit 2.0.1, you should upgrade to 2.0.2.
1902+
1903+Download the latest release of Percona Toolkit 2.0 from
1904+http://www.percona.com/software/percona-toolkit/
1905+or the Percona Software Repositories
1906+(http://www.percona.com/docs/wiki/repositories:start).
1907+
1908+Changelog
1909+---------
1910+
1911+* Fixed bug 911996: pt-table-sync --replicate causes "Unknown column" error
1912+
1913+v2.0.1 released 2011-12-30
1914+==========================
1915+
1916+The Percona Toolkit development team is proud to announce a new major version:
1917+2.0. Beginning with Percona Toolkit 2.0, we are overhauling, redesigning, and
1918+improving the major tools. 2.0 tools are therefore not backwards compatible
1919+with 1.0 tools, which we still support but will not continue to develop.
1920+
1921+New in Percona Toolkit 2.0.1 is a completely redesigned pt-table-checksum.
1922+The original pt-table-checksum 1.0 was rather complex, but it worked well
1923+for many years. By contrast, the new pt-table-checksum 2.0 is much simpler but
1924+also much more efficient and reliable. We spent months rethinking, redesigning,
1925+and testing every aspect of the tool. The three most significant changes:
1926+pt-table-checksum 2.0 does only --replicate, it has only one chunking algorithm,
1927+and its memory usage is stable even with hundreds of thousands of tables and
1928+trillions of rows. The tool is now dedicated to verifying MySQL replication
1929+integrity, nothing else, which it does extremely well.
1930+
1931+In Percona Toolkit 2.0.1 we also fixed various small bugs and forked ioprofile
1932+and align (as pt-ioprofile and pt-align) from Aspersa.
1933+
1934+If you still need functionalities in the original pt-table-checksum,
1935+the latest Percona Toolkit 1.0 release remains available for download.
1936+Otherwise, all new development in Percona Toolkit will happen in 2.0.
1937+
1938+Download the latest release of Percona Toolkit 2.0 from
1939+http://www.percona.com/software/percona-toolkit/
1940+or the Percona Software Repositories
1941+(http://www.percona.com/docs/wiki/repositories:start).
1942+
1943+Changelog
1944+---------
1945+
1946+* Completely redesigned pt-table-checksum
1947+* Fixed bug 856065: pt-trend does not work
1948+* Fixed bug 887688: Prepared statements crash pt-query-digest
1949+* Fixed bug 888286: align not part of percona-toolkit
1950+* Fixed bug 897961: ptc 2.0 replicate-check error does not include hostname
1951+* Fixed bug 898318: ptc 2.0 --resume with --tables does not always work
1952+* Fixed bug 903513: MKDEBUG should be PTDEBUG
1953+* Fixed bug 908256: Percona Toolkit should include pt-ioprofile
1954+* Fixed bug 821717: pt-tcp-model --type=requests crashes
1955+* Fixed bug 844038: pt-online-schema-change documentation example w/drop-tmp-table does not work
1956+* Fixed bug 864205: Remove the query to reset @crc from pt-table-checksum
1957+* Fixed bug 898663: Typo in pt-log-player documentation
1958+
1959+v1.0.1 released 2011-09-01
1960+==========================
1961+
1962+Percona Toolkit 1.0.1 has been released. In July, Baron announced planned
1963+changes to Maatkit and Aspersa development;[1] Percona Toolkit is the
1964+result. In brief, Percona Toolkit is the combined fork of Maatkit and
1965+Aspersa, so although the toolkit is new, the programs are not. That means
1966+Percona Toolkit 1.0.1 is mature, stable, and production-ready. In fact,
1967+it's even a little more stable because we fixed a few bugs in this release.
1968+
1969+Percona Toolkit packages can be downloaded from
1970+http://www.percona.com/downloads/percona-toolkit/
1971+or the Percona Software Repositories
1972+(http://www.percona.com/docs/wiki/repositories:start).
1973+
1974+Although Maatkit and Aspersa development use Google Code, Percona Toolkit
1975+uses Launchpad: https://launchpad.net/percona-toolkit
1976+
1977+[1] http://www.xaprb.com/blog/2011/07/06/planned-change-in-maatkit-aspersa-development/
1978+
1979+Changelog
1980+---------
1981+
1982+* Fixed bug 819421: MasterSlave::is_replication_thread() doesn't match all
1983+* Fixed bug 821673: pt-table-checksum doesn't include --where in min max queries
1984+* Fixed bug 821688: pt-table-checksum SELECT MIN MAX for char chunking is wrong
1985+* Fixed bug 838211: pt-collect: line 24: [: : integer expression expected
1986+* Fixed bug 838248: pt-collect creates a "5.1" file
1987+
1988+v0.9.5 released 2011-08-04
1989+==========================
1990+
1991+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.
1992+
1993+Changelog
1994+---------
1995+
1996+* Forked, combined, and rebranded Maatkit and Aspersa as Percona Toolkit.
1997+
1998+Changelog
1999+---------
2000+
2001+* Fixed bug 1279502: --version-check behaves like spyware
2002+
2003 v2.2.6 released 2013-12-18
2004 ==========================
2005

Subscribers

People subscribed via source and target branches