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 forpt-online-schema-change
to supportAFTER
triggers. - PT-138: Added
--output-format
option forpt-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-
. For more information, see #1491674.change - 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()
forpt-online-
. For more information, see #1693614.schema-change - PT-151: Fixed
pt-table-sync
to prevent field typepoint
to be taken as decimal. - PT-154: Reverted PT-116 to remove the
--use-insert-ignore
option frompt-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 forpt-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.