Re: Re: Connection Pooling

> > 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. Each httpd process only has a single persistent connection. -Rasmus