Percona Toolkit 2.1.8

Bug fixes and beta support for Percona XtraDB Cluster and MySQL 5.6

Milestone information

Project:
Percona Toolkit
Series:
2.1
Version:
2.1.8
Released:
2013-01-09  
Registrant:
Daniel Nichter
Release registered:
2013-01-07
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:
27 Brian Fraser, 5 Daniel Nichter
Blueprints:
2 Implemented
Bugs:
30 Fix Released

Download files for this release

File Description Downloads

Release notes 

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:

* pt-table-chcecksum
* pt-online-schema-change
* pt-archive
* pt-mysql-summary
* pt-heartbeat
* pt-variable-advisor
* pt-config-diff
* pt-deadlock-logger

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.

The bug fixes are widely assorted. The following highlights some of the more interesting and "hot" bugs:

* Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query

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 */``.

* Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user"

The "as" was misparsed and the following word would end up reported as the database; pt-query-digest now handles this correctly.

* Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5

Some renamed variables had caused the Percona Server section to work unreliably.

* Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only

When using --replicate-check-only, filter options like --databases and --tables were not applied.

* Fixed bug 886059: pt-heartbeat handles timezones inconsistently

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.

* Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables

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.

2.1.8 continues the trend of solid bug fix releases, and all 2.1 users are encouraged to upgrade.

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 

This release does not have a changelog.

2 blueprints and 30 bugs targeted

Blueprint Priority Assignee Delivery
Beta support for MySQL 5.6 5 Essential Daniel Nichter  11 Implemented
Beta support for Percona XtraDB Cluster 5 Essential Daniel Nichter  11 Implemented
Bug report Importance Assignee Status
1074179 #1074179 pt-table-checksum doesn't ignore tables for --replicate-check-only 3 High Brian Fraser  10 Fix Released
1078838 #1078838 pt-query-digest doesn't parse general log with "Connect user as user" 3 High Daniel Nichter  10 Fix Released
1082599 #1082599 pt-query-digest fails to parse timestamp with no query 3 High Daniel Nichter  10 Fix Released
823431 #823431 pt-query-advisor hangs on big queries 4 Medium Brian Fraser  10 Fix Released
886059 #886059 pt-heartbeat handles timezones inconsistently 4 Medium Brian Fraser  10 Fix Released
911385 #911385 pt-table-checksum v2 fails when --resume + --ignore-database is used 4 Medium Brian Fraser  10 Fix Released
911385 #911385 pt-table-checksum v2 fails when --resume + --ignore-database is used 4 Medium Brian Fraser  10 Fix Released
917770 #917770 pt-config-diff Use of uninitialized value in substitution (s///) at line 1996 4 Medium Brian Fraser  10 Fix Released
927955 #927955 Bad pod2rst transformation 4 Medium Brian Fraser  10 Fix Released
932614 #932614 pt-slave-restart CHANGE MASTER query causes error 4 Medium Daniel Nichter  10 Fix Released
937234 #937234 pt-query-advisor issues wrong RES.001 4 Medium Brian Fraser  10 Fix Released
957442 #957442 pt-query-digest with custom --group-by throws error 4 Medium Brian Fraser  10 Fix Released
986847 #986847 pt-stalk does not report NFS iostat 4 Medium Brian Fraser  10 Fix Released
986847 #986847 pt-stalk does not report NFS iostat 4 Medium Brian Fraser  10 Fix Released
1015590 #1015590 pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5 4 Medium Brian Fraser  10 Fix Released
1022622 #1022622 pt-config-diff is case-sensitive 4 Medium Brian Fraser  10 Fix Released
1046440 #1046440 pt-stalk purge_samples slows down checks 4 Medium Brian Fraser  10 Fix Released
1052475 #1052475 pt-table-checksum uninitialized value in numeric lt (<) at line 8611 4 Medium Brian Fraser  10 Fix Released
1075638 #1075638 pt-table-checksum Illegal division by zero at line 7950 4 Medium Brian Fraser  10 Fix Released
1078887 #1078887 Tools let --set-vars clobber the required SQL mode 4 Medium Brian Fraser  10 Fix Released
1086259 #1086259 pt-kill --log-dsn timestamp is wrong 4 Medium Brian Fraser  10 Fix Released
831525 #831525 pt-query-digest help output mangled 5 Low Brian Fraser  10 Fix Released
887638 #887638 pt-query-digest prints negative byte offset 5 Low Brian Fraser  10 Fix Released
898665 #898665 Bad online docs formatting for --[no]vars 5 Low Brian Fraser  10 Fix Released
933465 #933465 pt-query-advisor false positive on RES.001 5 Low Brian Fraser  10 Fix Released
996069 #996069 pt-query-advisor RES.001 is incorrect 5 Low Brian Fraser  10 Fix Released
1007938 #1007938 pt-config-diff doesn't handle end-of-line comments 5 Low Brian Fraser  10 Fix Released
1041391 #1041391 pt-table-checksum debug statement for "Chosen hash func" prints undef 5 Low Brian Fraser  10 Fix Released
1079341 #1079341 pt-online-schema-change checks for foreign keys on MyISAM tables 5 Low Brian Fraser  10 Fix Released
1082104 #1082104 pt-deadlock-logger doesn't handle usernames with dashes 5 Low Brian Fraser  10 Fix Released
This milestone contains Public information
Everyone can see this information.