<p style="text-align: center;"><img alt="" src="https://simg.open-open.com/show/a1518b4e4fed222c1d043bf5ef84ad1d.jpg" /></p> <p>Percona Toolkit 是一组高级命令行工具的集合,用来执行各种通过手工执行非常复 杂和麻烦的 MySQL任务和系统任务,这些任务包括: </p> <ul> <li>检查 master 和 slave 数据的一致性</li> <li>有效地对记录进行归档 </li> <li>查找重复的索引</li> <li>对服务器信息进行汇总</li> <li>分析来自日志和 tcpdump 的查询</li> <li>当系统出问题的时候收集重要的系统信息</li> </ul> <p>Percona Toolkit 源自 Maatkit 和 Aspersa 工具,这两个工具是管理 MySQL的最有名的 工具,现在 Maatkit 工具已经不维护了,Percona Toolkit 工具主要包括开发、性能、配置、监控、复制、系统、实用六大类,作为一个优秀 的 DBA,里面有的工具非常有用,如果能掌握并加以灵活应用,将能极大的提高工 作效率。</p> <h2>更新日志</h2> <p><strong>新特性:</strong></p> <ul> <li><a href="/misc/goto?guid=4958991698716129272" rel="nofollow">1537416</a>: <code>pt-stalk</code> now sorts the output of transactions by id</li> <li><a href="/misc/goto?guid=4958991698830689349" rel="nofollow">1553340</a>: Added “Shared” memory info to <code>pt-summary</code></li> <li><a href="/misc/goto?guid=4958991698932519615" rel="nofollow">PT-24</a>: Added the <code>--no-vertical-format</code> option for <code>pt-query-digest</code>, allowing compatibility with non-standard MySQL clients that don’t support the <code>G</code> directive at the end of a statement</li> </ul> <p><strong>Bug修复:</strong></p> <ul> <li><a href="/misc/goto?guid=4958991699033064674" rel="nofollow">1402776</a>: Fixed error when parsing <code>tcpdump</code> capture with <code>pt-query-digest</code></li> <li><a href="/misc/goto?guid=4958991699136551919" rel="nofollow">1521880</a>: Improved <code>pt-online-schema-change</code> plugin documentation</li> <li><a href="/misc/goto?guid=4958991699235479686" rel="nofollow">1547225</a>: Clarified the description of the <code>--attribute-value-limit</code> option for <code>pt-query-digest</code></li> <li><a href="/misc/goto?guid=4958991699337835192" rel="nofollow">1569564</a>: Fixed all PERL-based tools to return a zero exit status when run with the <code>--version</code> option</li> <li><a href="/misc/goto?guid=4958991699438867653" rel="nofollow">1576036</a>: Fixed error that sometimes prevented to choose the primary key as index, when using the <code>--where</code>option for <code>pt-table-checksum</code></li> <li><a href="/misc/goto?guid=4958991699549566902" rel="nofollow">1585412</a>: Fixed the inability of <code>pt-query-digest</code> to parse the general log generated by MySQL (and Percona Server) 5.7 instance</li> <li><a href="/misc/goto?guid=4958991699652100784" rel="nofollow">PT-36</a>: Clarified the description of the <code>--verbose</code> option for <code>pt-slave-restart</code></li> </ul> <h2>下载</h2> <ul> <li><a href="/misc/goto?guid=4958991699757778696" rel="nofollow"><strong>Source code</strong> (zip)</a></li> <li><a href="/misc/goto?guid=4958991699849181105" rel="nofollow"><strong>Source code</strong> (tar.gz)</a></li> <li><a href="/misc/goto?guid=4958991699956364012">官方下载</a></li> </ul>