Mysql - Show Current Active Connections

 

 

mysql> SHOW STATUS WHERE `variable_name` = 'Threads_connected';

  

mysql> show processlist;  (or)    SHOW FULL PROCESSLIST\G;

 

 

mysql> KILL 'ID';　　// Kill the connection