v2.2.11 released 2014-09-25 Percona Toolkit 2.2.11 has been released. This release contains seven bug fixes. Bugs Fixed: Fixed bug 1262456: pt-query-digest didn’t report host details when host was using skip-name-resolve option. Fixed by using the IP of the host instead of it’s name, when the hostname is missing. Fixed bug 1264580: pt-mysql-summary was incorrectly parsing key/value pairs in the wsrep_provider_options option, which resulted in incomplete my.cnf information. Fixed bug 1318985: pt-stalk is now using SQL_NO_CACHE when executing queries for locks and transactions. Previously this could lead to situations where most of the queries that were waiting on query cache mutex were the pt-stalk queries (INNODB_TRX). Fixed bug 1348679: When using -- -p option to enter the password for pt-stalk it would ask user to re-enter the password every time tool connects to the server to retrieve the information. New option --ask-pass has been introduced that can be used to specify the password only once. Fixed bug 1368379: A parsing error caused pt-summary ( specifically the report_system_info module) to choke on the “Memory Device” parameter named “Configured Clock Speed” when using dmidecode to report memory slot information. Changelog Fixed bug 1262456: pt-query-digest doesn’t report host details Fixed bug 1264580: pt-mysql-summary incorrectly tries to parse key/value pairs in wsrep_provider_options resulting in incomplete my.cnf information Fixed bug 1318985: pt-stalk should use SQL_NO_CACHE Fixed bug 1348679: pt-stalk handles mysql user password in awkward way Fixed bug 1365085: Various issues with tests Fixed bug 1368379: pt-summary problem parsing dmidecode output on some machines Fixed bug 1303388: Typo in pt-variable-advisor v2.2.10 released 2014-08-06 Percona Toolkit 2.2.10 has been released. This release contains six bug fixes. Bugs Fixed: Fixed bug 1287253: pt-table-checksum would exit with error if it would encounter deadlock when doing checksum. This was fixed by retrying the command in case of deadlock error. Fixed bug 1311654: When used with Percona XtraDB Cluster, pt-table-checksum could show incorrect result if –resume option was used. This was fixed by adding a new --replicate-check-retries command line parameter. If you are having resume problems you can now set --replicate-check-retries N , where N is the number of times to retry a discrepant checksum (default = 1 , no retries). Setting a value of 3 is enough to completely eliminate spurious differences. Fixed bug 1299387: pt-query-digest didn’t work correctly do to a changed logging format when field Thread_id has been renamed to Id. Fixed by implementing support for the new format. Fixed bug 1340728: in some cases, where the index was of type “hash” , pt-online-schema-change would refuse to run because MySQL reported it would not use an index for the select. This check should have been able to be skipped using –nocheck-plan option, but it wasn’t. --nocheck-plan now ignores the chosen index correctly. Fixed bug 1253872: When running pt-table-checksum or pt-online-schema on a server that is unused, setting the 20% max load would fail due to tools rounding the value down. This has been fixed by rounding the value up. Fixed bug 1340364: Due to incompatibility of dash and bash syntax some shell tools were showing error when queried for version. Changelog Fixed bug 1287253: pt-table-checksum deadlock Fixed bug 1299387: 5.6 slow query log Thead_id becomes Id Fixed bug 1311654: pt-table-checksum + PXC inconsistent results upon –resume Fixed bug 1340728: pt-online-schema-change doesn’t work with HASH indexes Fixed bug 1253872: pt-table-checksum max load 20% rounds down Fixed bug 1340364: some shell tools output error when queried for –version v2.2.9 released 2014-07-08 Percona Toolkit 2.2.9 has been released. This release contains five bug fixes. Bugs Fixed: Fixed bug 1335960: pt-query-digest could not parse the binlogs from MySQL 5.6 because the binlog format was changed. Fixed bug 1315130: pt-online-schema-change did not find child tables as expected. It could incorrectly locate tables which reference a table with the same name in a different schema and could miss tables referencing the altered table if they were in a different schema. Fixed bug 1335322: pt-stalk would fail when variable or threshold was non-integer. Fixed bug 1258135: pt-deadlock-logger was inserting older deadlocks into the deadlock table even if it was already there creating unnecessary noise. For example, if the deadlock happened 1 year ago, and MySQL keeps it in the memory and pt-deadlock-logger would INSERT it into percona.deadlocks table every minute all the time until server was restarted. This was fixed by comparing with the last deadlock fingerprint before issuing the INSERT query. Fixed bug 1329422: pt-online-schema-change foreign-keys-method=none can break FK constraints in a way that is hard to recover from. Allthough this method of handling foreign key constraints is provided so that the database administrator can disable the tool’s built-in functionality if desired, a warning and confirmation request when using alter-foreign-keys-method “none” has been added to warn users when using this option. Changelog Fixed bug 1258135: pt-deadlock-logger introduces a noise to MySQL Fixed bug 1329422: pt-online-schema-change foreign-keys-method=none breaks constraints Fixed bug 1315130: pt-online-schema-change not properly detecting foreign keys Fixed bug 1335960: pt-query-digest cannot parse binlogs from 5.6 Fixed bug 1335322: pt-stalk fails when variable or threshold is non-integer v2.2.8 released 2014-06-04 Percona Toolkit 2.2.8 has been released. This release has two new features and six bug fixes. New Features: pt-agent has been replaced by percona-agent. More information on percona-agent can be found in the Introducing the 3-Minute MySQL Monitor blogpost. pt-slave-restart now supports MySQL 5.6 global transaction IDs. pt-table-checkum now has new –plugin option which is similar to pt-online-schema-change –plugin Bugs Fixed: Fixed bug 1254233: pt-mysql-summary was showing blank InnoDB section for 5.6 because it was using have_innodb variable which was removed in MySQL 5.6. Fixed bug 965553: pt-query-digest didn’t fingerprint true/false literals correctly. Fixed bug 1286250: pt-online-schema-change was requesting password twice. Fixed bug 1295667: pt-deadlock-logger was logging incorrect timestamp because tool wasn’t aware of the time-zones. Fixed bug 1304062: when multiple tables were specified with pt-table-checksum –ignore-tables, only one of them would be ignored. Fixed bug : pt-show-grant –ask-pass option was asking for password in STDOUT instead of STDERR where it could be seen. 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 Removed pt-agent Added pt-slave-restart GTID support Added pt-table-checksum –plugin Fixed bug 1304062: –ignore-tables does not work correctly Fixed bug 1295667: pt-deadlock-logger logs incorrect ts Fixed bug 1254233: pt-mysql-summary blank InnoDB section for 5.6 Fixed bug 1286250: pt-online-schema-change requests password twice Fixed bug 965553: pt-query-digest dosn’t fingerprint true/false literals correctly Fixed bug 290911: pt-show-grant –ask-pass prints “Enter password” to STDOUT
Ebuild for 2.2.7 seems to work on amd64. It still needs the "spyware" removal patch.
Bumped. Thanks!
