Using the command line tool
cd quickstart/wildfly-10.1.0.Final/
./bin/jboss-cli.sh
-->You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands.
connect
To see the current state of the datasource you need to enable statistics (you may be able to reenter from the history)
/subsystem=datasources/data-source=CalendarDS/statistics=pool:write-attribute(name=statistics-enabled,value=true
To see the current state:
/subsystem=datasources/data-source=CalendarDS/statistics=pool/:read-resource(recursive=false,proxies=false,include-runtime=true,include-defaults=true
The most important fields are AvailableCount and MaxUsedCount. We hope to see a large proportion of the pool available. Some of the otehr statistics may indicate we are runnign out of pool entries.
Checking the database
If using mysql, run the mysql client on your db system and enter
show processlist;
The Time column should contain small values only. There may be some hung connections with large time values. Teh AutoKill process is supposed to clean these up. Ifyou are seeing lot of these with high values try setting the autoKill time in bwengine/system.xml to a lower value (or hight if it's set to 0). A 3 minuet interval will mean a connection may hang for 3 minutes up to just under 6 minutes..