A summary of incoming MySQL Connections

connection_breakdown.sql

SELECT /* Host connections */ SUBSTRING_INDEX(host, ':', 1) AS host, user, COUNT(*) AS host_connections
FROM information_schema.processlist
GROUP BY SUBSTRING_INDEX(host, ':', 1), user;

SELECT /* Running connections per source/user/schema */ host,user,db,command,COUNT(*) AS running
FROM information_schema.processlist
WHERE command NOT IN ('Sleep','Daemon','Binlog Dump')
GROUP BY host, user;

SELECT /* thread counts */ variable_name, variable_value
FROM performance_schema.global_status
WHERE variable_name LIKE 'thread_%';