Filtering 'show processlist'

By Aaron Macks on June 12, 2013 10:08 AM

| No Comments | No TrackBacks

Neat little MySQL trick:

mysql> \P grep -v Sleep
PAGER set to 'grep -v Sleep'

filters out the idle connections from the output of 'show processlist'

No TrackBacks

TrackBack URL: http://mt.wiglaf.org/cgi-bin/mt-tb.cgi/725

Name

Email Address

URL

Remember personal info?

Comments (You may use HTML tags for style)