mysqlsla

mysqlsla parses, filters, analyzes and sorts MySQL slow, general, binary and microslow patched logs in order to create a customizable report of the queries and their meta-property values.

Since these reports are customizable, they can be used for human consumption or be fed into other scripts to further analyze the queries. For example, to profile with mk-query-profiler (a script from Baron Schwartz's Maatkit) every unique SELECT statement using database foo from a slow log:

         mysqlsla -lt slow slow.log -R print-unique -mf "db=foo" -sf "+SELECT" | \
         mk-query-profiler -separate -database foo

 

本日志由 flyinweb 于 2010-05-25 15:05:22 发表到 数据库技术 中,目前已经被浏览 4273 次,评论 0 次;

作者添加了以下标签: mysqlsla

首页只显示了部分日志内容,要查看日志的全部内容请阅读全文