Bug #39491 mysqldumpslow
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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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.