Re: Connection Pooling
| From: | Steven Roussey | Date: | Fri, 21 Jul 2000 21:36:49 +0000 |
| Subject: | Re: Connection Pooling | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-7630@lists.php.net to get a copy of this message | ||
> I'd be interested to hear why you need connection pooling for a MySQL
> environment though. Connection pooling is always going to be slower than
> having dedicated connections, and MySQL connections are very
> lightweight.
In that case, why use persistent connections at all? If they are not shared
per server, then they can keep more connections open, and therefore more
threads running on the MySQL server, unnecessarily.
Multiply persistent connections * number of apache processes per server *
number of web servers in the farm. Only a fraction of the corresponding
threads on the MySQL server will actually be needed and doing anything. In
the mean time they do take up resources.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e