Percona Toolkit 2.2.11 发布,此版本包括 pt-query-digest,pt-mysql-summary,
pt-stalk 和其他工具的 bug 修复,此版本是个 GA 版本。此版本现已提供 下载。
Bugs 修复:
Fixed bug #1262456: pt-query-digest didn’t report host details when host was using skip-name-resolve option. Fixed by using the IP of the host instead of its name, when the hostname is missing.
Fixed bug #1264580: pt-mysql-summary was incorrectly parsing key/value pairs in the wsrep_provider_options option, which resulted in incomplete my.cnf
information.
Fixed bug #1318985: pt-stalk is now using SQL_NO_CACHE
when executing queries for locks and transactions. Previously this
could lead to situations where most of the queries that were waiting on
query cache mutex were the pt-stalk queries (INNODB_TRX
).
Fixed bug #1348679: When using -- -p
option to enter the password for pt-stalk it would ask user to re-enter the password every time tool connects to the server to retrieve the information. New option --ask-pass
has been introduced that can be used to specify the password only once.
Fixed bug #1368379: A parsing error caused pt-summary ( specifically the report_system_info
module) to choke on the “Memory Device” parameter named “Configured Clock Speed” when using dmidecode to report memory slot information.
更多更新内容请看发行说明和 2.2.11 milestone at Launchpad。
Percona Toolkit 是一组高级的命令行工具,用来管理 MySQL 和系统任务,主要包括:
验证主节点和复制数据的一致性
有效的对记录行进行归档
找出重复的索引
总结 MySQL 服务器
从日志和 tcpdump 中分析查询
问题发生时收集重要的系统信息