Description:
mysqldumpslow documentation suggests check mysqldumpslow --help, however, the command shows this output:
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 (t, at, l, al, r, ar etc), 'at' is default
-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
Unfortunately, parts of this help requires a secret decoder ring. For example, what are t, at, l, al, r, ar etc? What is "at" short for? Examples of the results of each of these would also be helpful.
I believe a lot more admins would use mysqldumpslow if it were better documented. This is one case where I don't want to have to "use the source, luke."
How to repeat:
See description.
Suggested fix:
See description.
Description: mysqldumpslow documentation suggests check mysqldumpslow --help, however, the command shows this output: 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 (t, at, l, al, r, ar etc), 'at' is default -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 Unfortunately, parts of this help requires a secret decoder ring. For example, what are t, at, l, al, r, ar etc? What is "at" short for? Examples of the results of each of these would also be helpful. I believe a lot more admins would use mysqldumpslow if it were better documented. This is one case where I don't want to have to "use the source, luke." How to repeat: See description. Suggested fix: See description.