Show running queries if MySQl is stuck

Sometimes we want to know which query causes the DB to be so slow. Here is the magic MySQL queries which can do it:

show processlist;

Look into "info" column listed in the output table to see what queries are working now.