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-1569: Disabled
- PT-242: (
SHOW SLAVE STATUSon MySQL 5.7 (Thanks Marcelo Altmann)
pt-archiverfails to detect columns with the word *GENERATED* as part of the comment
pt-show-grantsfails for MySQL 5.6 producing an error which reports that an unknown column account_locked has been detected.
pt-table-checksumfails 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_swapmethod 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.