show processlist does not show SELECT with JOIN

[Simon Chan]

Greetings,

I am using community version 5.6.12. Recently I noticed that "show full processlist" does not list long running queries that use LEFT JOIN. But if I get rid of the LEFT JOIN then "show full processlist" will list them.

Anyone seen this before? Know what's happening?

Just today we had a runaway query that I very much like to get hold of the process id so that I could kill it. But no help from "show full processlist".
It only listed the INSERT/UPDATE statements that were blocked by the SELECT.

The runaway query looked like this:
SELECT SQL_CALC_FOUND_ROWS time, skuid, quantity, companyname FROM ordertable LEFT JOIN customertable ON ordertable.customerid = customertable.customerid WHERE time >= 20140501000000 AND time <= 20140601000000 AND skuid IN (458, 477, 478, 479) ORDER BY companyname LIMIT 0,500;

Regards,
Simon