mysqlsla

太过爱你忘了你带给我的痛 2022-09-21 01:27 45阅读 0赞

本文转载自：http://hackmysql.com/mysqlsla

# 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

In brief, mysqlsla is a liaison allowing other scripts easy access to queries from a MySQL log. For a quick introduction to what mysqlsla is capable of doing, take a glance at the [guide][].

## The mysqlsla Library ##

» [Guide][guide]: Covers installation, basic usage, reports, special topics and advancing  
  
» [Documentation][]: Complete list of command line options, limitations, future features and bugs  
  
» [Filters][]: Overview of mysqlsla v2 log filters  
  
» [Reports][]: Creating and customizing mysqlsla v2 standard reports  
  
» [Replays][]: Working with mysqlsla v2 log replays  
  
» [User-Defined Logs (UDL)][User-Defined Logs _UDL]: Creating mysqlsla v2 and MySQL::Log::ParseFilter user-defined logs

## Download mysqlsla ##

Current version: mysqlsla-2.03 ( [Changes][])

*  Installer + man page: [mysqlsla-2.03.tar.gz][]
 *  Script only: wget http://hackmysql.com/scripts/mysqlsla

## v1.x Retired ##

Looking for mysqlsla v1.7a or 1.8-DEBUG? The v1 branch has been retired and is no longer supported. The older versions can still be accessed at http://hackmysql.com/archive/.

注：近期参加MySQL运维学习，老师推荐该文章作为学习和技术提高的扩展阅读，先记录到自己的博客中，随后慢慢消化、学习、提高。本文章与“日志系统”主题相关。

[slow]: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
[general]: http://dev.mysql.com/doc/refman/5.0/en/query-log.html
[binary]: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
[microslow patched]: http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/
[mk-query-profiler]: http://maatkit.sourceforge.net/doc/mk-query-profiler.html
[Maatkit]: http://www.maatkit.org/
[guide]: http://hackmysql.com/mysqlsla_guide
[Documentation]: http://hackmysql.com/mysqlsla_documentation
[Filters]: http://hackmysql.com/mysqlsla_filters
[Reports]: http://hackmysql.com/mysqlsla_reports
[Replays]: http://hackmysql.com/mysqlsla_replays
[User-Defined Logs _UDL]: http://hackmysql.com/udl
[Changes]: http://hackmysql.com/mysqlsla_changes.txt
[mysqlsla-2.03.tar.gz]: http://hackmysql.com/scripts/mysqlsla-2.03.tar.gz