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

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

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
(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.