Bug #21092 Constrain SHOW PROCESSLIST with LIKE
Submitted: 17 Jul 2006 9:54 Modified: 30 Sep 2008 15:13
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: CPU Architecture:Any
Tags: PROCESSLIST

[17 Jul 2006 9:54] Oli Sennhauser
Description:
SHOW PROCESSLIST lists to many lines when you have 250 or even 1000 users connect to you system.

How to repeat:
n.a.

Suggested fix:
It would be nice having something like

SHOW PROCESSLIST LIKE 'user|host|...'

to reduce the output to the relevant informations.

Much more nice would be having something like:

SELECT user, host, time, command, time
  FROM [mysql|information_schema].processlist
 WHERE user = 'me' and state IS NOT NULL;

...
[17 Jul 2006 12:06] Valeriy Kravchuk
Thank you for a reasonable feature request. As far as I remember, this feature is under development and will be implemented in MySQL 5.2 (or, maybe, even 5.1).
[30 Sep 2008 15:13] Konstantin Osipov
You can use INFORMATION_SCHEMA.PROCESSLIST with  WHERE clause starting from 5.1