0001108: Need a way to set connection pool parameters on implicitly created connections

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

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

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
(0002347) ferg 10-16-07 10:22	php/1431

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[^]

29 total queries executed.
26 unique queries executed.