0

open connections to a given database

How to see all open connections to a given database?

Database Add a comment
stalin
asked Sep 24 2018

Answer

0

To see the host details database user and database details they accessed use the below command

show processlist;

Or if you simply wanted to see the threads connected alone run the following command

 SHOW STATUS WHERE `variable_name` = 'Threads_connected';
Add a comment
gokulravichandran2
asked Sep 28 2018
edited Oct 30 2018
Post your Answer