Flashnux

GNU/Linux man pages

Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :

ISBN : 978-2-7460-9712-4
EAN : 9782746097124
(Editions ENI)

GNU/Linux

Debian 4.0

(Etch)

mysqldumpslow(1)


mysql

mysql

NAME
SYNOPSIS
DESCRIPTION
SEE ALSO
AUTHOR

NAME

mysqldumpslow − Parse and summarize the MySQL slow query log.

SYNOPSIS

mysqldumpslow [options]

DESCRIPTION

This program parses and summarizes a ’slow query log’.

−v

verbose

−d

debug

−s=WORD

what to sort by (t, at, l, al, r, ar etc)

−r

reverse the sort order (largest last instead of first)

−t=NUMBER

just show the top n queries

−a

don’t abstract all numbers to N and strings to ’S’

−n=NUMBER

abstract numbers with at least n digits within names

−g=WORD

grep: only consider stmts that include this string

−h=WORD

hostname of db server for *-slow.log filename (can be wildcard)

−i=WORD

name of server instance (if using mysql.server startup script)

−l

don’t subtract lock time from total time

SEE ALSO

mysql (1), mysqld (1)

AUTHOR

This manpage was written by Christian Hammers <ch@debian.org> based on the commends in the code.

MySQL is available at http://www.mysql.com/.



mysqldumpslow(1)