that's not new and many people may already know it. but it's really very helpful when some SQL locked.
tip 1. use -A to start faster
if mysql somedatabase command didn't return mysql> for you. you really can try it with -A. that loads faster.
tip 2: set pager for large result.
mysql> pager less;
so that if you do 'SHOW FULL PROCESSLIST' that you can find the exact one you want without scrolling back or missing anything.
for sure it can be configured into ~/.my.cnf like
Thanks for Alex who sharing it.