MYSQL slow-log分析工具

最新推荐文章于 2024-06-26 17:47:05 发布

孙海龙_1982

最新推荐文章于 2024-06-26 17:47:05 发布

阅读量416

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/card_2005/article/details/8713253

本文详细介绍了mysqldumpslow命令的用法，包括其选项、参数及如何利用它解析MySQL慢查询日志，从而优化数据库性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysqldumpslow

-bash-3.2$ 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