i agree with harald
if you're using Java you should consider pooling your database connections with
DBCP
http://commons.apache.org/dbcp/
feel free to ping me for implementation details
takk,
Martin
______________________________________________
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Wed, 13 Apr 2011 23:59:43 +0200
> From: h.rei...@thelounge.net
> To: mysql@lists.mysql.com
> Subject: Re: Practical connection limits MySQL 5.1/5.5
>
>
> 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
> > connections
>
> 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,
> query-cache, key-buffers?
>
>
>
