MySQL/MariaDB: Hide all sleeping processes in processlist
If you have many connections to your MySQL or MariaDB (as we have) you might want to filter the list you see when running a
SHOW PROCESSLIST. To hide all sleeping processes, you can simply use
grep as your pager:
\P grep -v "| Sleep"
There is an more advanced way by querying the
information_schema database: Show MySQL process list without sleeping connections