Rachel’s Blog

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

gives the same info (in recent MySqls) and can be filtered;

if for example, you want to apply a unique index, but you can’t because there’s duplicates in the table.

SELECT name FROM mytable GROUP BY name HAVING COUNT(*) > 1;