Mantis Bugtracker

Viewing Issue Advanced Details Jump to Notes ] View Simple ] 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
Reporter koreth View Status public  
Assigned To ferg
Priority normal Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 3.1.4 Product Version 3.0.19
  Product Build
Summary 0001108: Need a way to set connection pool parameters on implicitly created connections
Description 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.
Steps To Reproduce
Additional Information
Attached Files

- Relationships

- Notes
10-16-07 10:22



- Issue History
Date Modified Username Field Change
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.
Powered by Mantis Bugtracker