mysql日志分析工具-mysqldumpslow

最新推荐文章于 2024-09-04 18:00:11 发布

互联网俱乐部

最新推荐文章于 2024-09-04 18:00:11 发布

阅读量698

点赞数

分类专栏： mysql 文章标签： mysql 日志分析工具 mysqldu

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

日志分析工具mysqldumpslow

在生产环境中，如果要手工分析日志，查找、分析SQL，显然是个体力活，MySQL提供了日志分析工具mysqldumpslow

查看mysqldumpslow的帮助信息：

 
  [root@DB-Server ~]# mysqldumpslow --help 
  Usage: mysqldumpslow [ OPTS... ] [ LOGS... ] 
    
  Parse and summarize the MySQL slow query log. Options are 
    
    --verbose    verbose 
    --debug      debug 
    --help       write this text to standard output 
    
    -v           verbose 
    -d           debug 
    -s ORDER     what to sort by (al, at, ar, c, l, r, t), 'at' is default 
                  al: average lock time 
                  ar: average rows sent 
                  at: average query time 
                   c: count 
                   l: lock time 
                   r: rows sent 
                   t: query time   
    -r           reverse the sort order (largest last instead of first) 
    -t NUM       just show the top n queries 
    -a           don't abstract all numbers to N and strings to 'S' 
    -n NUM       abstract numbers with at least n digits within names 
    -g PATTERN   grep: only consider stmts that include this string 
    -h HOSTNAME  hostname of db server for *-slow.log filename (can be wildcard), 
                 default is '*', i.e. match all 
    -i NAME      name of server instance (if using mysql.server startup script) 
    -l           don't subtract lock time from total time 
 