'\" t
.\" Title: \fBmysqlprocgrep\fR
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
.\" Generator: DocBook XSL Stylesheets v1.79.1
.\" Date: 08/01/2016
.\" Manual: MySQL Utilities
.\" Source: MySQL 1.6.3
.\" Language: English
.\"
.TH "\FBMYSQLPROCGREP\FR" "1" "08/01/2016" "MySQL 1\&.6\&.3" "MySQL Utilities"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
mysqlprocgrep \- Search Server Process Lists
.SH "SYNOPSIS"
.HP \w'\fBmysqlprocgrep\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
\fBmysqlprocgrep [\fR\fB\fIoptions\fR\fR\fB]\fR
.SH "DESCRIPTION"
.PP
This utility scans the process lists for the servers specified using instances of the
\fB\-\-server\fR
option and selects those that match the conditions specified using the
\fB\-\-age\fR
and
\-\-match\-xxx
options\&. For a process to match, all conditions given must match\&. The utility then either prints the selected processes (the default) or executes certain actions on them\&.
.PP
If no
\fB\-\-age\fR
or
\-\-match\-xxx
options are given, the utility selects all processes\&.
.PP
The
\-\-match\-xxx
options correspond to the columns in the
\fBINFORMATION_SCHEMA\&.PROCESSLIST\fR
table\&. For example,
\fB\-\-match\-command\fR
specifies a matching condition for
\fBPROCESSLIST\&.COMMAND\fR
column values\&. There is no
\-\-match\-time
option\&. To specify a condition based on process time, use
\fB\-\-age\fR\&.
.PP
Processes that can be seen and killed are subject to whether the account used to connect to the server has the
\fBPROCESS\fR
and
\fBSUPER\fR
privileges\&. Without
\fBPROCESS\fR, the account cannot see processes belonging to other accounts Without
\fBSUPER\fR, the account cannot kill processes belonging to other accounts\&.
.PP
When the
\fB\-\-kill\-query\fR
or
\fB\-\-kill\-connection\fR
option is used, the utility will display those rows from the
SHOW PROCESSLIST
that match the query and are killed\&. This behavior exists as of MySQL Utilities 1\&.6\&.0\&.
.PP
To specify how to display output, use one of the following values with the
\fB\-\-format\fR
option:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fBgrid\fR
(default)
.sp
Display output in grid or table format like that of the
\fBmysql\fR
client command\-line tool\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fBcsv\fR
.sp
Display output in comma\-separated values format\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fBtab\fR
.sp
Display output in tab\-separated format\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\fBvertical\fR
.sp
Display output in single\-column format like that of the
\eG
command for the
\fBmysql\fR
client command\-line tool\&.
.RE
Options.PP
\fBmysqlprocgrep\fR
accepts the following command\-line options:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-help
.sp
Display a help message and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-license
.sp
Display license information and exit\&.
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
\-\-age=