How to check the number of applications connected to MySQL DB

[sandeepspatil]

Hi,

Is there some way to check the number of applications connected to an instance of mysql database?

I have two different Java applications that will be using the same instance of MySQL.
My requirement is that, I want to close the MySQL instance while closing the Java application.
But before doing so, I want to make sure the other application is not connected to it.
Is there some way I can check that?

Your suggestions will be of great help.

Thanks,
Sandeep

[goldhouse]

Are you refering to the Mysqlconnection ? I think you need to explain little more Is this different from the regular stuff ?

[sandeepspatil]

Hi,

I got the answer from another forum.
You can use "Show Processlist" to get the list of connections to the DB

Thanks,
Sandeep