Emergency

Process List

This page describes Percona changes to both the standard MySQL SHOW PROCESSLIST command and the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.

The changes that have been made as of version 5.5 of the server are:

  • SHOW PROCESSLIST command:
    • added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ
  • PROCESSLIST table:
    • added columns TIME_MS, ROWS_EXAMINED, ROWS_SENT, and ROWS_READ

Version Specific Information

  • 5.5.10-20.1:
    • Added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ to SHOW PROCESSLIST command.
    • Added columns ROWS_EXAMINED, ROWS_SENT, and ROWS_READ to PROCESSLIST table.

INFORMATION_SCHEMA Tables

table INFORMATION_SCHEMA.PROCESSLIST

This table implements modifications to the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.

Columns:
  • ID – The connection identifier.
  • USER – The MySQL user who issued the statement.
  • HOST – The host name of the client issuing the statement.
  • DB – The default database, if one is selected, otherwise NULL.
  • COMMAND – The type of command the thread is executing.
  • TIME – The time in seconds that the thread has been in its current state.
  • STATE – An action, event, or state that indicates what the thread is doing.
  • INFO – The statement that the thread is executing, or NULL if it is not executing any statement.
  • TIME_MS – The time in milliseconds that the thread has been in its current state.
  • ROWS_EXAMINED – The number of rows examined by the statement being executed.
  • ROWS_SENT – The number of rows sent by the statement being executed.
  • ROWS_READ – The number of rows read by the statement being executed.

Example Output

SHOW PROCESSLIST Command:

mysql> show processlist;
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+
| Id   | User      | Host      | db     | Command | Time | State      | Info                                         | ROWS_SENT | ROWS_EXAMINED | ROWS_READ |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+
|    2 | root      | localhost | test   | Query   |    0 | NULL       | SHOW PROCESSLIST                             |         0 |             0 |         1 |
|   14 | root      | localhost | test   | Query   |    0 | User lock  | SELECT GET_LOCK(``t``,1000)                    |         0 |             0 |         1 |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+

Table PROCESSLIST:

mysql> select * from information_schema.PROCESSLIST;
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
| ID   | USER      | HOST      | DB     | COMMAND | TIME | STATE      | INFO                                         | TIME_MS  | ROWS_EXAMINED | ROWS_SENT | ROWS_READ |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
|   14 | root      | localhost | test   | Query   |    0 | User lock  | SELECT GET_LOCK(``t``,1000)                    |        1 |             0 |         0   |         1 |
|    2 | root      | localhost | test   | Query   |    0 | executing  | SELECT * from INFORMATION_SCHEMA.PROCESSLIST |        0 |             0 |         0 |         1 |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+

Table Of Contents

Previous topic

Show Lock Names

Next topic

Misc. INFORMATION_SCHEMA Tables