Percona announces the release of Percona Toolkit 3.1.0 on September 13, 2019.
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®, PostgreSQL® 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, PostgreSQL, 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 and improvements:
- PT-1696: the new
pt-pg-summary
tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces: - PT-1663:
pt-stalk
has two new options limiting the amount of disk space it can consume: --retention-size option makespt-stalk
to store less than the specified amount of megabytes, while --retention-count option limits the number of runs for which data are kept. Following simple example illustrates how these two parameters can be passed to the tool (herept-stalk
just collects the information and exits):
- PT-1741: Migration to a new MongoDB driver was done.
- PT-1761:
pt-online-schema-change
will not run under MySQL 8.0.14 .. 8.0.17 if the table has foreign keys
Important note: There is an error in MySQL from versions 8.0.14 up to the current 8.0.17 that makes MySQL die under certain conditions when trying to rename a table. Since the last step forpt-online-schema-change
is to rename the tables to swap the old and new ones, we have added a check that prevents runningpt-online-schema-change
if the conditions for this error are met.
Bug fixes:
- PT-1114:
pt-table-checksum
failed when the table was empty - PT-1344:
pt-online-schema-change
failed to detect hostnames with a specified port number - PT-1575:
pt-mysql-summary
did not print the PXC section for PXC 5.6 and 5.7 - PT-1630:
pt-table-checksum
had a regression which prevented it from working with Galera cluster - PT-1633:
pt-config-diff
incorrectly parsed variables with numbers having K, M, G or T suffix (Thanks to Dieter Adriaenssens) - PT-1709:
pt-upgrade
generated “Use of uninitialized value in concatenation (.) or string” error in case of invalid MySQL packets - PT-1720:
pt-pmp
exited with an error in case of any unknown option in a common PT configuration file - PT-1728:
pt-table-checksum
failed to scan small tables that get wiped out often - PT-1734:
pt-stalk
did non-strict matching for ‘log_error’, resulting in wider filtering - PT-1746:
pt-diskstats
didn’t work for newer Linux kernels starting from 4.18
Help us improve our software quality by reporting any bugs you encounter using our bug tracking system.
Great! The link to PT-1696 is not available to public.