Percona Toolkit 2.2.5 发布了,Percona Toolkit 是一组高级的命令行工具,用来管理 MySQL 和系统任务,主要包括:
验证主节点和复制数据的一致性
有效的对记录行进行归档
找出重复的索引
总结 MySQL 服务器
从日志和 tcpdump 中分析查询
问题发生时收集重要的系统信息
改进内容包括:
New Features:
Query_time histogram has been added to the pt-query-digest JSON output, not the actual chart but the values necessary to render the chart later, so the values for each bucket.
As of pt-table-checksum 2.2.5, skipped chunks cause a non-zero exit status. An exit status of zero or 32 is equivalent to a zero exit status with skipped chunks in previous versions of the tool.
New --no-drop-triggers option has been implemented for pt-online-schema-change in case users want to rename the tables manually, when the load is low.
New --new-table-name option has been added to pt-online-schema-change which can be used to specify the temporary table name.
Bugs Fixed:
pt-archiver would delete the data even with the --dry-run option. Bug fixed #1199589
pt-query-digest didn’t distill LOAD DATA correctly. Bug fixed #821692
pt-query-digest didn’t distill INSERT/REPLACE without INTO correctly. Bug fixed #984053
pt-agent docs were referencing wrong web address. Bug fixed #1206677
pt-table-checksum --recursion-method=cluster option would crash if no nodes were found. Bug fixed #1210537
官方首页:http://www.percona.com/software/percona-toolkit
免费下载:http://www.percona.com/downloads/percona-toolkit/
来自:开源中国社区

