Percona Toolkit 3.0.11 Is Now Available

percona toolkitPercona 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 in pt-online-schema-change
  • PT-242: (pt-stalk) Include SHOW 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-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)

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_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.

Share this post

Comments (6)

  • Matt

    Why is there only an i386 version available to be downloaded for Ubuntu 16.04 Xenial?

    August 30, 2018 at 11:46 am
    • Matt

      Thanks for fixing the xenial version, Ubuntu 14.04 Trusty also only contains an i386 version

      August 31, 2018 at 2:23 pm
      • Michael Coburn

        Hi @matt
        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!

        August 31, 2018 at 3:49 pm
      • Michael Coburn

        We’re tracking this work under so feel free to add yourself as Watcher

        August 31, 2018 at 4:19 pm
      • Michael Coburn

        Hi @Matt

        Should be working again, let us know though if you continue to see issues. Thanks!

        August 31, 2018 at 4:40 pm
        • Matt

          Thanks for fixing it!

          September 4, 2018 at 11:29 am

Comments are closed.

Use Percona's Technical Forum to ask any follow-up questions on this blog topic.