It’s not a query waiting for connection; it’s a connection pointer waiting for the timeout to terminate. It doesn’t have an impact on performance. The only thing it’s using is a few bytes as every connection does. The really worst case: It’s using one connection of your pool; If you would connect multiple times via … Read more
Newer versions of SQL support the process list in information_schema: SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST You can ORDER BY in any way you like. The INFORMATION_SCHEMA.PROCESSLIST table was added in MySQL 5.1.7. You can find out which version you’re using with: SELECT VERSION()
mysql> show processlist; +—-+——+———–+—–+———+——+———————+——————————+———-+ | Id | User | Host | db | Command | Time | State | Info | Progress | +—-+——+———–+—–+———+——+———————+——————————+———-+ | 14 | usr1 | localhost | db1 | Query | 0 | starting | show processlist | 0.000 | | 16 | usr1 | localhost | db1 | Query | … Read more
SHOW FULL PROCESSLIST If you don’t use FULL, “only the first 100 characters of each statement are shown in the Info field”. When using phpMyAdmin, you should also click on the “Full texts” option (“← T →” on top left corner of a results table) to see untruncated results.