diff options
| author | Jim Winstead <jimw@mysql.com> | 2009-05-07 10:40:00 -0700 |
|---|---|---|
| committer | Jim Winstead <jimw@mysql.com> | 2009-05-07 10:40:00 -0700 |
| commit | b78f9a8659adf3be4ecbad3db59a97deff4f2193 (patch) | |
| tree | e1517e24f6d1d4daba7ee7556f0df48935039265 /scripts/mysqldumpslow.sh | |
| parent | 84c5ba6ece069ec8874c0efec44cd2bd425bc534 (diff) | |
| download | mariadb-git-b78f9a8659adf3be4ecbad3db59a97deff4f2193.tar.gz | |
Add explanation of the possible -s values for mysqldumpslow. (Bug #35663,
based on a contribution by Ask Bjørn Hansen)
Diffstat (limited to 'scripts/mysqldumpslow.sh')
| -rw-r--r-- | scripts/mysqldumpslow.sh | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/scripts/mysqldumpslow.sh b/scripts/mysqldumpslow.sh index 1e942b035cb..8580b8e6203 100644 --- a/scripts/mysqldumpslow.sh +++ b/scripts/mysqldumpslow.sh @@ -163,7 +163,14 @@ Parse and summarize the MySQL slow query log. Options are -v verbose -d debug - -s ORDER what to sort by (al, at, ar, c, t, l, r), 'at' is default + -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' |