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.
This release includes the following changes:
New features and improvements:
- PT-1696: the new
pt-pg-summarytool 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-stalkhas two new options limiting the amount of disk space it can consume: --retention-size option makes
pt-stalkto 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 (here
pt-stalkjust collects the information and exits):
- PT-1741: Migration to a new MongoDB driver was done.
pt-online-schema-changewill 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 for
pt-online-schema-changeis to rename the tables to swap the old and new ones, we have added a check that prevents running
pt-online-schema-changeif the conditions for this error are met.
pt-table-checksumfailed when the table was empty
pt-online-schema-changefailed to detect hostnames with a specified port number
pt-mysql-summarydid not print the PXC section for PXC 5.6 and 5.7
pt-table-checksumhad a regression which prevented it from working with Galera cluster
pt-config-diffincorrectly parsed variables with numbers having K, M, G or T suffix (Thanks to Dieter Adriaenssens)
pt-upgradegenerated “Use of uninitialized value in concatenation (.) or string” error in case of invalid MySQL packets
pt-pmpexited with an error in case of any unknown option in a common PT configuration file
pt-table-checksumfailed to scan small tables that get wiped out often
pt-stalkdid non-strict matching for ‘log_error’, resulting in wider filtering
pt-diskstatsdidn’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.