Mantis Bugtracker

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
Reporter koreth View Status public  
Assigned To ferg
Priority normal Resolution fixed  
Status closed   Product Version 3.0.19
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.
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