mysqlprocslow - save and monitor slow-query information with the output of SHOW PROCESSLIST.
mysqlprocslow [OPTIONS]
Examples:
mysqlprocslow -u dbuser -h dbhost -p
mysqlprocslow -u dbuser -h dbhost -p -o slowquery.log
save and monitor slow-query information with the output of SHOW PROCESSLIST.
- --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;
This software is free and comes without warranty of any kind.
2010-09-27 Junichiro Abe (abejunichiro@gmail.com)