Percona is pleased to announce the availability of Percona Toolkit 2.2.16, released on November 9, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.
This release is the current GA (Generally Available) stable release in the 2.2 series. It includes new features and bug fixes as well as continued preparation for MySQL 5.7 compatibility. Full details are below. Downloads are available here and from the Percona Software Repositories.
- 1491261: When using MySQL 5.6 or later, and
innodb_stats_persistentoption is enabled (by default, it is enabled), then
pt-online-schema-changewill now run with the
--analyze-before-swapoption. This ensures that queries continue to use correct execution path, instead of switching to full table scan, which could cause possible downtime. If you do not want
ANALYZEon new tables before the swap, you can disable this behavior using the
pt-online-schema-changewill now wait forever for slaves to be available and not be lagging. This ensures that the tool does not abort during faults and connection problems on slaves.
pt-archivernow issues ‘keepalive’ queries during and after bulk insert/delete process that takes a long time. This keeps the connection alive even if the
innodb_kill_idle_transactionvariable is set to a low value.
- 1488685: The
pt-killnow works correctly.
- 1494082: The
pt-stalktool no longer uses the
-warnoption when running
find, because the option is not supported on FreeBSD.