Percona Toolkit 3.1.0 Is Now Available

September 13, 2019

Author

Dmitriy Kostiuk

MariaDB

MongoDB

MySQL

Share this Post:

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:

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

1

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