tomcat, how to check the usage of the connection pool?

龙不笑

For example, how many connections, idle, maximum connections, etc.?
ps: Of course, it is not the configuration file of the connection pool settings. The configuration file cannot see the real-time connection.

money80100

Go to the database

wh_family

In the ORACLE data, you can use commands to see the number of connections currently used by each IP, etc.!

龙不笑

sqlserver
What do you think? Can you elaborate

wh_family

I found sqlserver on the Internet, let me try it:
select * from sysprocesses where dbid in
(select dbid from sysdatabases where name='iChaoShi1')

Find all the connection records connected to the iChaoShi1 database.

The sysprocesses table records all connections to the SQL SERVER database.

龙不笑

I tried it, but it doesn’t seem to work. Different clients have opened several windows. After querying it, a connection

龙不笑

Query after closing tomcat, it indeed returns empty

sinbad

Pay attention. . ! !

wh_family

That is to query the current number of connections to the database.Your multiple windows can only indicate that there are several connections to the WEB server at the same time.
Pay attention to distinguish them

kaka309

It is recommended to use proxool as a connection pool