Percona Toolkit moved to https://jira.percona.com/projects/PT 2.2.2

Percona Toolkit 2.2.2 has been released. This is the second release of the 2.2 series and aims to fix bugs in the previous release and provide usability enhacements to the toolkit.

Users may note the revival of the --show-all option in pt-query-digest. This had been removed in 2.2.1, but resulted in too much output in certain cases.

A new --recursion-method was added to pt-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node DSNs in a DSN table (--recursion-method=dsn).

The following highlights some of the more interesting and "hot" bugs in this release:

* Bug #1127450: pt-archiver --bulk-insert may corrupt data

pt-archiver --bulk-insert didn't work with --charset UTF-8. This revealed a case where the tool could corrupt data by double-encoding. This is now fixed, but remains relatively dangerous if using DBD::mysql 3.0007 which does not handle UTF-8 properly.

* Bug #1163372: pt-heartbeat --utc --check always returns 0

Unfortunately, the relatively new --utc option for pt-heart was still broken because "[MySQL] interprets date as a value in the current time zone and converts it to an internal value in UTC." Now the tool works correctly with --utc by specifying "SET time_zone='+0:00'", and older versions of the tool can be made to work by specifying --set-vars "time_zone='+0:00'".

* Bug #821502: Some tools don't have --help or --version

pt-align, pt-mext, pt-pmp and pt-sift now have both options.

This is another solid bug fix release, and all 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/).