使用方法shell> mysqldumpslow [options] [log_file ...]Table 4.12. mysqldumpslow Option ReferenceFormat Config File Description Introduction Deprecated -a Do not abstract all numbers to N and strings to S --debug debug Write debugging information -g pattern Only consider statements that match the pattern --help Display help message and exit -h name Host name of the server in the log file name -i name Name of the server instance -l Do not subtract lock time from total time -n num Abstract numbers with at least the specified digits -r Reverse the sort order -s value How to sort output -t num Display only first num queries --verbose verbose Verbose mode mysqldumpslow supports the following options: --help Display a help message and exit. -a Do not abstract all numbers to N and strings to 'S'. --debug, -d Run in debug mode. -g pattern Consider only queries that match the (grep-style) pattern. -h host_name Host name of MySQL server for *-slow.log file name. The value can contain a wildcare. The default is * (match all). -i name Name of server instance (if using mysql.server startup script). -l Do not subtract lock time from total time. -n N Abstract numbers with at least N digits within names. -r Reverse the sort order. -s sort_type How to sort the output. The value of sort_type should be chosen from the following list: t, at: Sort by query time or average query time l, al: Sort by lock time or average lock time s, as: Sort by rows sent or average rows went c: Sort by count -t N Display only the first N queries in the output. --verbose, -v Verbose mode. Print more information about what the program does. Example of usage: shell> mysqldumpslowReading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 limit NCount: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t1 select * from t1
是MYSQL提供的一个工具,用来分析MYSQL的慢查询日志linux 下的安装会有
-a Do not abstract all numbers to N and strings to S
--debug debug Write debugging information
-g pattern Only consider statements that match the pattern
--help Display help message and exit
-h name Host name of the server in the log file name
-i name Name of the server instance
-l Do not subtract lock time from total time
-n num Abstract numbers with at least the specified digits
-r Reverse the sort order
-s value How to sort output
-t num Display only first num queries
--verbose verbose Verbose mode mysqldumpslow supports the following options: --help Display a help message and exit. -a Do not abstract all numbers to N and strings to 'S'. --debug, -d Run in debug mode. -g pattern Consider only queries that match the (grep-style) pattern. -h host_name Host name of MySQL server for *-slow.log file name. The value can contain a wildcare. The default is * (match all). -i name Name of server instance (if using mysql.server startup script). -l Do not subtract lock time from total time. -n N Abstract numbers with at least N digits within names. -r Reverse the sort order. -s sort_type How to sort the output. The value of sort_type should be chosen from the following list: t, at: Sort by query time or average query time l, al: Sort by lock time or average lock time s, as: Sort by rows sent or average rows went c: Sort by count -t N Display only the first N queries in the output. --verbose, -v Verbose mode. Print more information about what the program does. Example of usage: shell> mysqldumpslowReading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log
Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t2 select * from t1 limit NCount: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
insert into t1 select * from t1
可以通过mysqlshow --help来查看帮助信息。