Page Comparison

...

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..