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

oschina
 oschina
发布于 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.

本站文章除注明转载外,均为本站原创或编译。欢迎任何形式的转载,但请务必注明出处,尊重他人劳动共创开源社区。
转载请注明:文章转载自 开源中国社区 [http://www.oschina.net]
本文标题:Percona Toolkit 2.2.13 发布,MySQL 管理工具包
加载中

最新评论(1

eechen
eechen
Linux MySQL DBA 必备工具 Percona Toolkit (一些Perl和Shell脚本)
http://www.percona.com/software/percona-toolkit
http://www.percona.com/doc/percona-toolkit/2.2/pt-summary.html
wget http://percona.com/get/pt-summary
./pt-summary > summary.txt

把long_query_time设置成0s,然后用pt-query-digest输出分析报告,看下占用时长最久的那些语句.
http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html
pt-query-digest /var/log/mysql/slow.sql > ./slow.sql
返回顶部
顶部