/mysqlprocslow

save and monitor MySQL slow-query information with the output of SHOW PROCESSLIST.

Primary LanguagePerl

NAME

mysqlprocslow - save and monitor slow-query information with the output of SHOW PROCESSLIST.

SYNOPSIS

mysqlprocslow [OPTIONS] 

Examples:

mysqlprocslow -u dbuser -h dbhost -p

mysqlprocslow -u dbuser -h dbhost -p -o slowquery.log

DESCRIPTION

save and monitor slow-query information with the output of SHOW PROCESSLIST.

OPTIONS

--help

Display helpscreen and exit

-u, --user=#

user for database login if not current user. Give a user who has sufficient privileges PROCESS.

-p, --password=#

password to use when connecting to server. If password is not given it's asked from the tty

-h, --host=#

host to connect to

-P, --port=#

port to use when connecting to server

-S, --socket=#

UNIX domain socket to use when connecting to server

-o=#

write the slow queries to the file filename

-q, --quiet

no print slow queris on STDOUT

-d, --delay

output query once finished on STDOUT

-l=#, --long=#, --long-query-time=#

output or save queries that took more than long-query-time seconds on PROCESSLIST;

WARRANTY

This software is free and comes without warranty of any kind.

AUTHOR

2010-09-27 Junichiro Abe (abejunichiro@gmail.com)