Percona Toolkit 2.2.14 发布,修复了多个PT-表校验(pt-table-checksum)错误,能够更好的支持 XtraDB 集群 , 同时此版本继续为兼容 MySQL 5.7 做准备。 完整改进记录: New Features: pt-slave-find can now resolve the IP address and show the slave’s hostname. This can be done with the new --resolve-address option. pt-table-sync can now ignore the tables whose names match a specific Perl regex with the new --ignore-tables-regex option. Bugs Fixed: Fixed bug 925781: Inserting non-BMP characters into a column with utf8 charset would cause the Incorrect string value error when running the pt-table-checksum. Fixed bug 1368244: pt-online-schema-change --alter-foreign-keys-method=drop-swap` was not atomic and thus it could be interrupted. Fixed by disabling common interrupt signals during the critical drop-rename phase. Fixed bug 1381280: pt-table-checksum was failing on BINARY field in Primary Key. Fixed by implementing new --binary-index flag to optionally create checksum table using BLOB data type. Fixed bug 1421405: Running pt-upgrade against a log with many identical (or similar) queries was producing repeated sections with the same fingerprint. Fixed bug 1402730: pt-duplicate-key-checker was not checking for duplicate keys when --verbose option was set. Fixed bug 1406390: A race condition was causing pt-heartbeat to crash with sleep argument error. Fixed bug 1417558: pt-stalk when used along with --collect-strace didn’t write the strace output to the expected destination file. Fixed bug 1421025: Missing dependency for perl-TermReadKey RPM package was causing toolkit commands to fail when they were run with --ask-pass option. Fixed bug 1421781: pt-upgrade would fail when log contained SELECT...INTO queries. Fixed by ignoring/skipping those queries. Fixed bug 1425478: pt-stalk was removing non-empty files that were starting with an empty line. Fixed bug 1419098: Fixed bad formatting in the pt-table-checksum documentation. Percona Toolkit 是一组高级的命令行工具,用来管理 MySQL 和系统任务,主要包括: 验证主节点和复制数据的一致性 有效的对记录行进行归档 找出重复的索引 总结 MySQL 服务器 从日志和 tcpdump 中分析查询 问题发生时收集重要的系统信息 Percona Toolkit 2.2.14 发布,MySQL 管理工具包下载地址