Percona Toolkit 2.2.15 is now available

Percona is pleased to announce the availability of Percona Toolkit 2.2.15.  Released August 28, 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 multiple 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.

New Features:

• Added --max-flow-ctl option to pt-online-schema-change and pt-archiver with a value set in percent. When a Percona XtraDB Cluster node is very loaded, it sends flow control signals to the other nodes to stop sending transactions in order to catch up. When the average value of time spent in this state (in percent) exceeds the maximum provided in the option, the tool pauses until it falls below again.Default is no flow control checking.
• Added the --sleep option for pt-online-schema-change to avoid performance problems. The option accepts float values in seconds.
• Implemented ability to specify --check-slave-lag multiple times for pt-archiver. The following example enables lag checks for two slaves:
  
  Shell

  pt-archiver --no-delete --where '1=1' --source h=oltp_server,D=test,t=tbl --dest h=olap_server --check-slave-lag h=slave1 --check-slave-lag h=slave2 --limit 1000 --commit-each

  1	pt-archiver --no-delete --where '1=1' --source h=oltp_server,D=test,t=tbl --dest h=olap_server --check-slave-lag h=slave1 --check-slave-lag h=slave2 --limit 1000 --commit-each

• Added the --rds option to pt-kill, which makes the tool use Amazon RDS procedure calls instead of the standard MySQL kill command.

Bugs Fixed:

• Fixed bug 1042727: pt-table-checksum doesn’t reconnect the slave $dbh
  Before, the tool would die if any slave connection was lost. Now the tool waits forever for slaves.
• Fixed bug 1056507: pt-archiver --check-slave-lag agressiveness
  The tool now checks replication lag every 100 rows instead of every row, which significantly improves efficiency.
• Fixed bug 1215587: Adding underscores to constraints when using pt-online-schema-change can create issues with constraint name length
  Before, multiple schema changes lead to underscores stacking up on the name of the constraint until it reached the 64 character limit. Now there is a limit of two underscores in the prefix, then the tool alternately removes or adds one underscore, attempting to make the name unique.
• Fixed bug 1277049: pt-online-schema-change can’t connect with comma in password
  For all tools, documented that commas in passwords provided on the command line must be escaped.
• Fixed bug 1441928: Unlimited chunk size when using pt-online-schema-change with --chunk-size-limit=0 inhibits checksumming of single-nibble tables
  When comparing table size with the slave table, the tool now ignores --chunk-size-limit if it is set to zero to avoid multiplying by zero.
• Fixed bug 1443763: Update documentation and/or implentation of pt-archiver --check-interval
  Fixed the documentation for --check-interval to reflect its correct behavior.
• Fixed bug 1449226: pt-archiver dies with “MySQL server has gone away” when --innodb_kill_idle_transaction is set to a low value and --check-slave-lag is enabled
  The tool now sends a dummy SQL query to avoid timing out.
• Fixed bug 1446928: pt-online-schema-change not reporting meaningful errors
  The tool now produces meaningful errors based on text from MySQL errors.
• Fixed bug 1450499: ReadKeyMini causes pt-online-schema-change session to lock under some circumstances
  Removed ReadKeyMini, because it is no longer necessary.
• Fixed bug 1452914: --purge and --no-delete are mutually exclusive, but still allowed to be specified together by pt-archiver
  The tool now issues an error when --purge and --no-delete are specified together.
• Fixed bug 1455486: pt-mysql-summary is missing the --ask-pass option
  Added the --ask-pass option to the tool.
• Fixed bug 1457573: pt-mysql-summary fails to download pt-diskstats pt-pmp pt-mext pt-align
  Added the -L option to curl and changed download address to use HTTPS.
• Fixed bug 1462904: pt-duplicate-key-checker doesn’t support triple quote in column name
  Updated TableParser module to handle literal backticks.
• Fixed bug 1488600: pt-stalk doesn’t check TokuDB status
  Implemented status collection similar to how it is performed for InnoDB.
• Fixed bug 1488611: various testing bugs related to newer Perl versions

Details of the release can be found in the release notes and the 2.2.15 milestone on Launchpad. Bugs can be reported on the Percona Toolkit launchpad bug tracker.

About the Author

Alexey Zhebel
Alexey works for Percona as a Technical Writer responsible for open source software documentation. He joined the company in March 2015 with almost 8 years of prior experience in writing and managing technical documentation. Before joining Percona, Alexey worked for Oracle on Java SE and Java ME documentation. And before that his writing experience revolved around virtualization and information security software. Alexey has a degree in Electrical Engineering and a supplementary qualification in translation theory (Russian-English). He lives in Saint Petersburg, Russia with his wife and son. He spends his free time practicing and playing ultimate frisbee in a local team.