grid (default)

Display output in grid or table format like that of the mysql monitor.

csv

Display output in comma-separated values format.

tab

Display output in tab-separated format.

vertical

Display output in single-column format like that of the \G command for the mysql monitor.

--help

Display a help message and exit.

--age=<time>

Select only processes that have been in the current state more than a given time. The time value can be specified in two formats: either using the hh:mm:ss format, with hours and minutes optional, or as a sequence of numbers with a suffix giving the period size.

The permitted suffixes are s (second), m (minute), h (hour), d (day), and w (week). For example, 4h15m mean 4 hours and 15 minutes.

For both formats, the specification can optionally be preceded by + or -, where + means older than the given time, and - means younger than the given time.

--format=<format>, -f<format>

Specify the output display format. Permitted format values are grid, csv, tab, and vertical. The default is grid.

--kill-connection

Kill the connection for all matching processes (like the KILL CONNECTION statement).

--kill-query

Kill the query for all matching processes (like the KILL QUERY statement).

--match-command=<pattern>

Match all processes where the Command field matches the pattern.

--match-db=<pattern>

Match all processes where the Db field matches the pattern.

--match-host=<pattern>

Match all processes where the Host field matches the pattern.

--match-info=<pattern>

Match all processes where the Info field matches the pattern.

--match-state=<pattern>

Match all processes where the State field matches the pattern.

--match-user=<pattern>

Match all processes where the User field matches the pattern.

--print

Print information about the matching processes. This is the default if no --kill-connection or --kill-query option is given. If a kill option is given, --print prints information about the processes before killing them.

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

Perform pattern matches using the REGEXP operator. The default is to use LIKE for matching. This affects the --match-xxx options.

--server=<source>

Connection information for a server to search in the format: <user>[:<passwd>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>]. Use this option multiple times to search multiple servers.

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

Instead of displaying the selected processes, emit the SELECT statement that retrieves information about them. If the --kill-connection or --kill-query option is given, the utility generates a stored procedure named kill_processes() for killing the queries rather than a SELECT statement.

--sql-body

Like --sql, but produces the output as the body of a stored procedure without the CREATE PROCEDURE part of the definition. This could be used, for example, to generate an event for the server Event Manager.

When used with a kill option, code for killing the matching queries is generated. Note that it is not possible to execute the emitted code unless it is put in a stored routine, event, or trigger. For example, the following code could be generated to kill all idle connections for user www-data:

$ mysqlprocgrep --kill-connection --sql-body \
>   --match-user=www-data --match-state=sleep
DECLARE kill_done INT;
DECLARE kill_cursor CURSOR FOR
  SELECT
        Id, User, Host, Db, Command, Time, State, Info
      FROM
        INFORMATION_SCHEMA.PROCESSLIST
      WHERE
          user LIKE 'www-data'
        AND
          State LIKE 'sleep'
OPEN kill_cursor;
BEGIN
   DECLARE id BIGINT;
   DECLARE EXIT HANDLER FOR NOT FOUND SET kill_done = 1;
   kill_loop: LOOP
      FETCH kill_cursor INTO id;
      KILL CONNECTION id;
   END LOOP kill_loop;
END;
CLOSE kill_cursor;

--verbose, -v

Specify how much information to display. Use this option multiple times to increase the amount of information. For example, -v = verbose, -vv = more verbose, -vvv = debug.

--version

Display version information and exit.