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 PROCESSLISTcommand:
- added columns
ROWS_EXAMINED,ROWS_SENT, andROWS_READPROCESSLISTtable:
- added columns
TIME_MS,ROWS_EXAMINED,ROWS_SENT, andROWS_READ
5.5.10-20.1:
- Added columns
ROWS_EXAMINED,ROWS_SENT, andROWS_READtoSHOW PROCESSLISTcommand.- Added columns
ROWS_EXAMINED,ROWS_SENT, andROWS_READtoPROCESSLISTtable.
INFORMATION_SCHEMA.PROCESSLIST¶This table implements modifications to the standard MySQL INFORMATION_SCHEMA table PROCESSLIST.
| Columns: |
|
|---|
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 |
+------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.
