Percona Toolkit 3.0.4 is Now Available

Percona announces the release of Percona Toolkit 3.0.4 on August 2, 2017.

Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

You download Percona Toolkit packages from the web site or install from official repositories.

This release includes the following changes:

New Features

• PT-90: Added collection of information about prepared statements by pt-stalk when Performance Schema is enabled. For more information, see #1642750.
• PT-91: Added the --preserve-triggers option for pt-online-schema-change to support AFTER triggers.
• PT-138: Added --output-format option for pt-mongodb-summary to choose between JSON format and the default plain text.
• PT-141: Added the --output-format=csv parameter for pt-archiver to archive rows in CSV format.
• PT-142: Added the --only-same-schema-fks option for pt-online-schema-change to check foreigns keys only on tables with the same schema as the original table. This should speed up the tool’s execution, but keep in mind that if you have foreign keys referencing tables in other schemas, they won’t be detected. For more information, see #1690122.
• PT-153: Added the --check-unique-key-change option for pt-online-schema-change to abort if the specified statement for --alter is trying to add a unique index. This is supposed to avoid adding duplicate keys that might lead to silently losing data.
• PT-173: Added the --truncate-replicate-table option for pt-table-checksum to ensure stale data is removed.

Bug fixes

• PT-136: Fixed pt-table-checksum to support tables that have columns with different collations or charsets. For more information, see #1674266.
• PT-143: Fixed primary key handling by pt-archiver. For more information, see #1691630.
• PT-144: Limited constraint name in the new table when running pt-online-schema-change. For more information, see #1491674.
• PT-146: Fixed the --no-check-binlog-format option for pt-table-checksum to work as expected.
• PT-148: Fixed the use of uninitialized value in printf() for pt-online-schema-change. For more information, see #1693614.
• PT-151: Fixed pt-table-sync to prevent field type point to be taken as decimal.
• PT-154: Reverted PT-116 to remove the --use-insert-ignore option from pt-online-schema-change.
• PT-161: Fixed the --skip-check-slave-lag feature for pt-table-checksum to safely check for undefined values.
• PT-178: Fixed regression in --check-slave-lag option for pt-online-schema-change.
• PT-180: Fixed regression in --skip-check-slave-lag option for pt-online-schema-change.
• PT-181: Fixed syntax error in pt-online-schema-change.

Other Improvements

• PT-162: Updated list of tables ignored by pt-table-checksum.

You can find release details in the release notes. Report bugs in Toolkit’s 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.