Am 13.04.2011 23:50, schrieb Jeff Lee:
> Hey All,
> Can anyone provide some guidance as to what the practical connection limits
> to MySQL 5.1/5.5 are under linux?
> We're running a ruby on rails application that establishes 50 to 100
> connections to our database upon startup resulting in around 1,000
> persistent db connections.
depends on how much RAM the box has
remind that every connection needs some MB for buffers
> I've been told to expect anywhere from 5 - 10x
> our current transaction volume and I'm trying to predict where we're going
> to top out.
i can not image why 1000 connections are needed in a real world application
throw away the aüülication if it does not support connection-pooling in 2011
> The servers are pretty beefy so I don't have a problem
> reserving memory for connections if that's what it takes but was more
> concerned about other problems that might be caused by having so many
even if you have enough memory why will you throw it away for a
unusual connection count instead use the RAm for innodb-buffer-pool,
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc