发布于 2016-12-10 00:21:20 | 180 次阅读 | 评论: 0 | 来源: 网友投递
Percona Toolkit 管理 MySQL的命令行工具
Percona Toolkit 是一组高级的命令行工具,用来管理 MySQL 和系统任务,
Percona Toolkit 2.2.20 发布了,主要包括:
验证主节点和复制数据的一致性
有效的对记录行进行归档
找出重复的索引
总结 MySQL 服务器
从日志和 tcpdump 中分析查询
问题发生时收集重要的系统信息
更新内容:
新功能
New --pause-file
option has been implemented for pt-online-schema-change
. When used pt-online-schema-change
will pause while the specified file exists.
pt-online-schema-change
now supports adding and removing the DATA DIRECTORY
to a new table with the --data-dir
and --remove-data-dir
options.
Following schemas/tables have been added to the default ignore list: mysql.gtid_execution
, sys.sys_config
, mysql.proc
, mysql.inventory
, mysql.plugin
, percona.*
(including checksums, DSNs table), test.*
, and percona_schema.*
pt-summary
now provides information about Transparent huge pages.
New --preserve-embedded-numbers
option was implemented for pt-query-digest
which can be used to preserve numbers in database/table names when fingerprinting queries.
更多 Bug 修复请查看完整 更新日志
下载地址:
https://www.percona.com/downloads/percona-toolkit/