Percona Toolkit 2.2.6

Milestone information

Project:
Percona Toolkit
Series:
2.2
Version:
2.2.6
Released:
2013-12-20  
Registrant:
Daniel Nichter
Release registered:
2013-12-20
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
18 Daniel Nichter
Blueprints:
2 Implemented
Bugs:
16 Fix Released

Download files for this release

File Description Downloads

Release notes 

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:

* Fixed bug 1223458: pt-table-sync deletes child table rows

Buried in the pt-table-sync docs is this warning:

  Also be careful with tables that have foreign key constraints with C<ON DELETE>
  or C<ON UPDATE> definitions because these might cause unintended changes on the
  child tables.

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.

Another good bug fix is:

* Fixed bug 1217013: pt-duplicate-key-checker misses exact duplicate unique indexes

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.

* Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table

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.

Finally, this bug (more like a feature request/change) might be a backwards-incompatible change:

* Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled

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.

Finally, this bug (more like a feature request/change) might be a backwards-incompatible change:

* Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled

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.

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/).

Changelog 

View the full changelog

* Added pt-query-digest support for Percona Server slow log rate limiting
* Added pt-agent --ping
* Added pt-mysql-summary --all-databases
* Added pt-stalk --sleep-collect
* Added pt-table-sync --[no]check-child-tables
* Fixed bug 1249150: PTDEBUG prints some info to STDOUT
* Fixed bug 1248363: pt-agent requires restart after changing MySQL options
* Fixed bug 1248778: pt-agent --install on PXC is not documented
* Fixed bug 1250973: pt-agent --install doesn't check for previous install
* Fixed bug 1250968: pt-agent --install suggest MySQL user isn't quoted
* Fixed bug 1251004: pt-agent --install error about slave is confusing
* Fixed bug 1251726: pt-agent --uninstall fails if agent is running
* Fixed bug 1248785: pt-agent docs don't list privs required for its MySQL user
* Fixed bug 1215016: pt-deadlock-logger docs use pt-fk-error-logger
* Fixed bug 1201443: pt-duplicate-key-checker error when EXPLAIN key_len=0
* Fixed bug 1217013: pt-duplicate-key-checker misses exact duplicate unique indexes
* Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled
* Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table
* Fixed bug 1249149: pt-query-digest stats prints to STDOUT instead of STDERR
* Fixed bug 1071979: pt-stak error parsing df with NFS
* Fixed bug 1223458: pt-table-sync deletes child table rows

2 blueprints and 16 bugs targeted

Blueprint Priority Assignee Delivery
pt-query-digest support for Percona Server slow log rate limiting 3 Medium Daniel Nichter  11 Implemented
pt-stalk --sleep-collect 3 Medium Daniel Nichter  11 Implemented
Bug report Importance Assignee Status
1223458 #1223458 pt-table-sync deletes child table rows 2 Critical Daniel Nichter  10 Fix Released
1071979 #1071979 pt-stak error parsing df with NFS 3 High Daniel Nichter  10 Fix Released
1195628 #1195628 pt-online-schema-change gets stuck looking for its own _new table 3 High Daniel Nichter  10 Fix Released
1214685 #1214685 pt-mysql-summary schema dump prompt can't be disabled 3 High Daniel Nichter  10 Fix Released
1248363 #1248363 pt-agent requires restart after changing MySQL options 3 High Daniel Nichter  10 Fix Released
1250973 #1250973 pt-agent --install doesn't check for previous install 3 High Daniel Nichter  10 Fix Released
1251004 #1251004 pt-agent --install error about slave is confusing 3 High Daniel Nichter  10 Fix Released
1201443 #1201443 pt-duplicate-key-checker error when EXPLAIN key_len=0 4 Medium Daniel Nichter  10 Fix Released
1217013 #1217013 pt-duplicate-key-checker misses exact duplicate unique indexes 4 Medium Daniel Nichter  10 Fix Released
1248778 #1248778 pt-agent --install on PXC is not documented 4 Medium Daniel Nichter  10 Fix Released
1248785 #1248785 pt-agent docs don't list privs required for its MySQL user 4 Medium Daniel Nichter  10 Fix Released
1249149 #1249149 pt-query-digest stats prints to STDOUT instead of STDERR 4 Medium Daniel Nichter  10 Fix Released
1249150 #1249150 PTDEBUG prints some info to STDOUT 4 Medium Daniel Nichter  10 Fix Released
1250968 #1250968 pt-agent --install suggest MySQL user isn't quoted 4 Medium Daniel Nichter  10 Fix Released
1251726 #1251726 pt-agent --uninstall fails if agent is running 4 Medium Daniel Nichter  10 Fix Released
1215016 #1215016 pt-deadlock-logger docs use pt-fk-error-logger 5 Low Daniel Nichter  10 Fix Released
This milestone contains Public information
Everyone can see this information.