mysqlprocgrep(1) - Linux man page

Name

Synopsis

Description

Options

--version

show program's version number and exit

--help

display a help message and exit

--server=SERVER

connection information for the server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>].

-G, --basic-regexp, --regexp

use 'REGEXP' operator to match pattern. Default is to use 'LIKE'.

-Q, --print-sql, --sql

print the statement instead of sending it to the server. If a kill option is submitted, a procedure will be generated containing the code for executing the kill.

--sql-body

only print the body of the procedure.

--kill-connection

kill all matching connections.

--kill-query

kill query for all matching processes.

--print

print all matching processes.

-f FORMAT, --format=FORMAT

display the output in either grid (default), tab, csv, or vertical format

-v, --verbose

control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug

--match-user=PATTERN

match the 'USER' column of the PROCESSLIST table

--match-host=PATTERN

match the 'HOST' column of the PROCESSLIST table

--match-db=PATTERN

match the 'DB' column of the PROCESSLIST table

--match-command=PATTERN

match the 'COMMAND' column of the PROCESSLIST table

--match-info=PATTERN

match the 'INFO' column of the PROCESSLIST table

--match-state=PATTERN

match the 'STATE' column of the PROCESSLIST table

--age=AGE

show only processes that have been in the current state more than a given time

Copyright