How to count open db connections?

Question

I'm developing a web app using Java servlet to access Mysql db, how can I get the number of connections to my DB that is currently open ?

Edit :

I tried "show processlist", it showed me : 2695159, but that's not right, I'm just developing this new project, I'm the only user, couldn't have that many processes running, what I want is the number of users accessing my project's DB, not the number of all db users, but just the ones logged in to my database which has only one table.

Answer 1

Depending on your MySQL version, you can perform a select on

SELECT COUNT(*) FROM information_schema.PROCESSLIST;

and you can do a where between the user, database, and host IP.

For example:

USE information_schema;
SELECT COUNT(*) FROM PROCESSLIST WHERE db ="mycase" AND HOST LIKE "192.168.11.174%"