...
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
...
a MySQL database
If using mysql, run Run the mysql client on your db system and enter
...
The Time column should contain small values only. There may be some hung connections with large time values. Teh The AutoKill process is supposed to clean these up. Ifyou If you are seeing lot of these with high values try setting the autoKill time in bwengine/system.xml to a lower value (or hight higher if it's set to 0). A 3 minuet minute interval will mean a connection may hang for 3 minutes up to just under 6 minutes. Typically bedework does not run long queries. A minute may be sufficient.
Killing the query on the db side may help resolve issues. Try this
SELECT GROUP_CONCAT(CONCAT('KILL QUERY ',id,';') SEPARATOR ' ') KillQuery FROM information_schema.processlist WHERE user<>'system user' AND time >= 60\G
to get a bunch of kill commands. See this question and answers for the above approach and how to automate it.
Clearly this approach only attacks the symptoms but sometimes that's all we want.