Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018.
Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL®, MariaDB®, Percona Server for MongoDB and MongoDB.
This release includes the following changes:
PT-1571: Improved hostname recognition in pt-secure-collect
PT-1569: Disabled --alter-foreign-keys-method=drop_swap in pt-online-schema-change
PT-242: (pt-stalk) Include SHOW SLAVE STATUS on MySQL 5.7 (Thanks Marcelo Altmann)
PT-1570: pt-archiver fails to detect columns with the word GENERATED as part of the comment
PT-1563: pt-show-grantsfails for MySQL 5.6 producing an error which reports that an unknown column account_locked has been detected.
PT-1551: pt-table-checksum fails on MySQL 8.0.11
[*]PT-241: (pt-stalk) Slave queries don’t run on MySQL 5.7 because the FQDN was missing (Thanks Marcelo Altmann)
Starting with this version, the queries checksum in pt-query-digest will use the full MD5 field as a CHAR(32) field instead of storing just the least significant bytes of the checksum as a BIGINT field. The reason for this change is that storing only the least significant bytes as a BIGINT was producing inconsistent results in MySQL 8 compared to MySQL 5.6+. pt-online-schema-change in MySQL 8:
Due to a bug in MySQL 8.0+, it is not possible to use the drop_swap method to rebuild constraints because renaming a table will result in losing the foreign keys. You must specify a different method explicitly.
Help us improve our software quality by reporting any bugs you encounter using our bug tracking system.