RE: Practical connection limits MySQL 5.1/5.5
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? > > >
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? signature.asc Description: OpenPGP digital signature
Practical connection limits MySQL 5.1/5.5
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. 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. 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. I have started looking at doing connection concentration using MySQL Proxy Funnel but it doesn't look like it's been updated in a while so I'm not sure how far I'll get. Thanks