MySQL – limiting the result returned by Show Processlist


Use /P (pager) to limit the result you wish to see.

For example, if you wish to see all processes except the ones sleeping then do the following:


mysql> \P grep -v Sleep
mysql> show processlist;

  1. No comments yet.
(will not be published)
*