Personal blog of Yzmir Ramirez

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.

Percona announces the release of Percona Toolkit 3.0.3 on May 19, 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

• Added the --skip-check-slave-lag option for pt-table-checksum, pt-online-schema-change, and pt-archiverdp.This option can be used to specify a list of servers where to skip checking for slave lag.
• 1642754: Added support for collecting replication slave information in pt-stalk.
• PT-111: Added support for collecting information about variables from Performance Schema in pt-stalk. For more information, see 1642753.
• PT-116: Added the --[no]use-insert-ignore option for pt-online-schema-change to force or prevent using IGNORE on INSERT statements. For more information, see 1545129.

Bug Fixes

• PT-115: Fixed OptionParser to accept repeatable DSNs.
• PT-126: Fixed pt-online-schema-change to correctly parse comments. For more information, see 1592072.
• PT-128: Fixed pt-stalk to include memory usage information. For more information, see 1510809.
• PT-130: Fixed pt-mext to work with non-empty RSA public key. For more information, see 1587404.
• PT-132: Fixed pt-online-schema-change to enable --no-drop-new-table when --no-swap-tables and --no-drop-triggers are used.

You can find release details in the release notes. Report bugs in Toolkit’s launchpad bug tracker.

Percona announces the availability of Percona Toolkit 3.0.2 on March 27, 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.

This release includes the following changes:

You can find release details in the release notes. Bugs can be reported on Toolkit’s launchpad bug tracker.

Percona announces the availability of Percona Toolkit 3.0.1 on February 20, 2017. This is the first general availability (GA) release in the 3.0 series with a focus on padding MongoDB tools:

• pt-mongodb-summary
• pt-mongodb-query-digest

Downloads are available from the Percona Software Repositories.

NOTE: If you are upgrading using Percona’s yum repositories, make sure that the you enable the basearch repo, because Percona Toolkit 3.0 is not available in the noarch repo.

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.

This release includes changes from the previous 3.0.0 RC and the following additional changes:

• Added requirement to run pt-mongodb-summary as a user with the clusterAdmin or root built-in roles.

You can find release details in the release notes. Bugs can be reported on Toolkit’s launchpad bug tracker.