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.

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=csvparameter for pt-archiver to archive rows in CSV format.

PT-142: Added the --only-same-schema-fksoption 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-changeoption 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-formatoption 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-lagfeature for pt-table-checksum to safely check for undefined values.

Related

Author

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.