|Anonymous | Login | Signup for a new account||09-22-2023 00:43 PDT|
|Main | My View | View Issues | Change Log | Docs|
|Viewing Issue Simple Details [ Jump to Notes ]||[ View Advanced ] [ Issue History ] [ Print ]|
|ID||Category||Severity||Reproducibility||Date Submitted||Last Update|
|0001108||[Quercus]||minor||always||05-13-06 15:03||10-16-07 10:22|
|Summary||0001108: Need a way to set connection pool parameters on implicitly created connections|
We have a zillion MySQL databases, and our code typically needs to talk to several databases over the course of generating a page. Since we also have tons of web servers, we need to aggressively expire idle MySQL connections.
Quercus/Resin is happy to create a MySQL connection on demand based on the host/port info supplied by the PHP code, but when the PHP code calls mysql_close(), the connection is returned to a Resin connection pool that's implicitly created. I don't see any way to set the pool parameters, e.g. the max idle time for a pooled connection.
It's not practical to add a <database> config item for each one of our MySQL databases; there are way too many of them and we add new ones all the time. Instead I need a way to configure default settings for the connection pools that get created by Quercus.
|05-13-06 15:03||koreth||New Issue|
|10-16-07 10:22||ferg||Note Added: 0002347|
|10-16-07 10:22||ferg||Assigned To||=> ferg|
|10-16-07 10:22||ferg||Status||new => closed|
|10-16-07 10:22||ferg||Resolution||open => fixed|
|10-16-07 10:22||ferg||Fixed in Version||=> 3.1.4|
| Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.|
26 unique queries executed.