Percona Toolkit 2.2.13 发布,MySQL 管理工具包

发布于 2015年01月27日
收藏 25

Percona Toolkit 2.2.13 发布了,Percona Toolkit 是一组高级的命令行工具,用来管理 MySQL 和系统任务,主要包括:

  • 验证主节点和复制数据的一致性

  • 有效的对记录行进行归档

  • 找出重复的索引

  • 总结 MySQL 服务器

  • 从日志和 tcpdump 中分析查询

  • 问题发生时收集重要的系统信息


New Features:

  • pt-kill now supports new --query-id option. This option can be used to print a query fingerprint hash after killing a query to enable the cross-referencing with the pt-query-digest output. This option can be used along with --print option as well.

Bugs Fixed:

  • Fixed bug 1408375: Percona Toolkit was vulnerable to MITM attack which could allow exfiltration of MySQL configuration information via --version-check option. This vulnerability was logged as CVE 2015-1027

  • Fixed bug 1019479: pt-table-checksum now works with ONLY_FULL_GROUP_BY SQL mode.

  • Fixed bug 1394934: running pt-table-checksum in debug mode would cause an error.

  • Fixed bug 1396868: regression introduced in Percona Toolkit 2.2.12 caused pt-online-schema-change not to honor --ask-pass option.

  • Fixed bug 1399789: pt-table-checksum would fail to find Percona XtraDB Cluster nodes when variable wsrep_node_incoming_address was set to AUTO.

  • Fixed bug 1321297: pt-table-checksum was reporting differences on timestamp columns with replication from 5.5 to 5.6 server version, although the data was identical.

  • Fixed bug 1388870: pt-table-checksum was showing differences if the master and slave were in different time zone.

  • Fixed bug 1402668: pt-mysql-summary would exit if Percona XtraDB Cluster was in Donor/Desynced state.

  • Fixed bug 1266869: pt-stalk would fail to start if $HOME environment variable was not set.

转载请注明:文章转载自 开源中国社区 []
本文标题:Percona Toolkit 2.2.13 发布,MySQL 管理工具包


Linux MySQL DBA 必备工具 Percona Toolkit (一些Perl和Shell脚本)
./pt-summary > summary.txt

pt-query-digest /var/log/mysql/slow.sql > ./slow.sql