MySQL utility mysqlprocgrep cheatsheet
mysqlprocgrep search or grep for process information/list
mysqlprocgrep --version
mysqlprocgrep --help
Usage: mysqlprocgrep --server=user:pass@host:port:socket [options]
mysqlprocgrep utility scans the process lists for servers specified using instances of the --server option and selects those that match the conditions specified.
mysqlprocgrep --server=root:secret@localhost
mysqlprocgrep --server=root@localhost --match-user=procgrep --age=1m --kill-query
mysqlprocgrep --server=dba --match-command=sleep --age=1h --kill
mysqlprocgrep --kill-connection --sql-body --match-user=data --match-state=sleep
mysqlprocgrep --server=root@localhost --match-user=satya --kill-connection --format=CSV
mysqlprocgrep --server=root@localhost --match-command=sleep --age=1h --kill-connection --verbose
mysqlprocgrep --server=mysql_dba --match-db=sakila --kill-connection --format=TAB -v
mysqlprocgrep Options:
--version show program's version number and exit
--help display a help message and exit
--license display program's license and exit
--server=SERVER connection information for the server in the form: user[:password]@host[:port][:socket] or login-path[:port][:socket] or config- path[[group]].
--ssl-ca=SSL_CA path to a file that contains a list of trusted SSL CAs.
--ssl-cert=SSL_CERT name of the SSL certificate file to use for establishing a secure connection.
--ssl-key=SSL_KEY name of the SSL key file to use for establishing a secure connection.
--ssl=SSL specifies if the server connection requires use of SSL. If an encrypted connection cannot be established, the connection attempt fails. By default 0 (SSL not required).
--character-set=CHARSET sets the client character set. The default is retrieved from the server variable 'character_set_client'.
-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-id=PATTERN match the 'ID' column of the PROCESSLIST table.
--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.
Related MySQL Articles: mysqlrplms utility in MySQL
