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.
Percona Toolkit, like all Percona software, is free and open source. You can download packages from the website or install from official repositories.
This release includes the following changes:
New Features:
- PT-1571: Improved hostname recognition in
pt-secure-collect
- PT-1569: Disabled
--alter-foreign-keys-method=drop_swap
inpt-online-schema-change
- PT-242: (
pt-stalk
) IncludeSHOW SLAVE STATUS
on MySQL 5.7 (Thanks Marcelo Altmann)
Fixed bugs:
- PT-1570:
pt-archiver
fails to detect columns with the word *GENERATED* as part of the comment - PT-1563:
pt-show-grants
fails 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)
Breaking changes:
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.
Why is there only an i386 version available to be downloaded for Ubuntu 16.04 Xenial?
Thanks for fixing the xenial version, Ubuntu 14.04 Trusty also only contains an i386 version
Hi @Matt Yonkovit
We’re looking into this, it’s a problem with our build process. Should be a quick fix like the last one (i.e. renaming a directory), however it is the weekend already for the Dev team so we’ll fix this on Monday. Thanks for catching this!
We’re tracking this work under https://jira.percona.com/browse/BLD-1121 so feel free to add yourself as Watcher
Hi @Matt Yonkovit
Should be working again, let us know though if you continue to see issues. Thanks!
Thanks for fixing it!