Read more

MySQL/MariaDB: Hide all sleeping processes in processlist

Thomas Eisenbarth
December 23, 2015Software engineer at makandra GmbH

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"
Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

There is an more advanced way by querying the information_schema database: Show MySQL process list without sleeping connections

Posted by Thomas Eisenbarth to makandra dev (2015-12-23 10:18)