Tag Info

New answers tagged


What you need is a breakdown by user and hostname along with a total SELECT IFNULL(usr,'All Users') user,IFNULL(hst,'All Hosts') host,COUNT(1) Connections FROM ( SELECT user usr,LEFT(host,LOCATE(':',host) - 1) hst FROM information_schema.processlist WHERE user NOT IN ('system user','root') ) A GROUP BY usr,hst WITH ROLLUP; This will handle ...


There was a discussion in detail for this: http://dba.stackexchange.com/a/47160/385 In short, the queries you need are SELECT max_user_connections FROM mysql.user WHERE user='db_user' AND host='localhost'; and SHOW VARIABLES LIKE 'max_user_connections'; UPDATE Maybe this is not direct answer to your question, but according to ...

Top 50 recent answers are included