[phplib] connection pools for MySQL From: Donncha O Caoimh (donncha.ocaoimh <email protected>)
Date: 05/25/00

I'm working on a streaming data server using a combination of Apache,
MySQL, PHP4 and phplib 7.2b (for database abstraction) but I notice that
there are 3 connections open by each Apache process (perfectly alright..
each process has to connect to 3 databases for logically seperate data).
Although the http connection is kept open all the time, there's a delay
using sleep() of between 1 and 5 seconds between bursts of data and I'd
really like to return the MySQL connections back to the "pool of
connections" or close them while the process sleeps. (as "mysqladmin
extended-status" shows that only up to 1/4 of connections are actually
doing anything..)
Is there any way of doing this in phplib or will I have to use the PHP4
db interface and explicitly close down connections while sleeping?

Donncha.

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>