Spec-Zone .ru
спецификации, руководства, описания, API

20.16. The INFORMATION_SCHEMA PROCESSLIST Table

The PROCESSLIST table provides information about which threads are running.

INFORMATION_SCHEMA Name SHOW Name Remarks
ID Id MySQL extension
USER User MySQL extension
HOST Host MySQL extension
DB db MySQL extension
COMMAND Command MySQL extension
TIME Time MySQL extension
STATE State MySQL extension
INFO Info MySQL extension

For an extensive description of the table columns, see Section 13.7.5.30, "SHOW PROCESSLIST Syntax".

Notes:

The following statements are equivalent:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLISTSHOW FULL PROCESSLIST