Percona Toolkit 3.1.0 Is Now Available

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:
    • • Shell

        ##### --- Database Port and Data_Directory --- #### +----------------------+----------------------------------------------------+ | Name | Setting | +----------------------+----------------------------------------------------+ | data_directory | /var/lib/postgresql/9.5/main | +----------------------+----------------------------------------------------+ ##### --- List of Tablespaces ---- ###### +----------------------+----------------------+----------------------------------------------------+ | Name | Owner | Location | +----------------------+----------------------+----------------------------------------------------+ | pg_default | postgres | | | pg_global | postgres | | +----------------------+----------------------+----------------------------------------------------+ ##### --- Cluster Information --- #### +------------------------------------------------------------------------------------------------------+ Usename : postgres Time : 2019-09-13 08:30:42.272582 -0400 EDT Client Address : ::1 Client Hostname: Version : PostgreSQL 9.5.18 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1 Started : 2019-09-13 08:29:43.175138 -0400 EDT Is Slave : false +------------------------------------------------------------------------------------------------------+ ##### --- Databases --- #### +----------------------+------------+ | Dat Name | Size | +----------------------+------------+ | template1 | 6841 kB |

        1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

        ##### --- Database Port and Data_Directory --- #### +----------------------+----------------------------------------------------+ |         Name         |                      Setting                       | +----------------------+----------------------------------------------------+ | data_directory       | /var/lib/postgresql/9.5/main                       | +----------------------+----------------------------------------------------+   ##### --- List of Tablespaces ---- ###### +----------------------+----------------------+----------------------------------------------------+ |         Name         |         Owner        |               Location                             | +----------------------+----------------------+----------------------------------------------------+ | pg_default           | postgres             |                                                    | | pg_global            | postgres             |                                                    | +----------------------+----------------------+----------------------------------------------------+     ##### --- Cluster Information --- #### +------------------------------------------------------------------------------------------------------+                                                                                 Usename        : postgres                                                           Time           : 2019-09-13 08:30:42.272582 -0400 EDT                                     Client Address : ::1                                             Client Hostname:                         Version        : PostgreSQL 9.5.18 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1                                       Started        : 2019-09-13 08:29:43.175138 -0400 EDT                                   Is Slave       : false                                               +------------------------------------------------------------------------------------------------------+   ##### --- Databases --- #### +----------------------+------------+ |       Dat Name       |    Size    | +----------------------+------------+ | template1            |    6841 kB |

• • PT-1663: pt-stalk has two new options limiting the amount of disk space it can consume: --retention-size option makes pt-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 (here pt-stalk just collects the information and exits):
    Shell

    pt-stalk --no-stalk --retention-count=3 --retention-size=100M -- --defaults-file=./my.default.cnf

    1	pt-stalk --no-stalk --retention-count=3 --retention-size=100M -- --defaults-file=./my.default.cnf

• • 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 for pt-online-schema-change is to rename the tables to swap the old and new ones, we have added a check that prevents running pt-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.