On 31 May 2012, at 00:49, Christopher Schultz <ch...@christopherschultz.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > André, > > On 5/30/12 6:18 PM, André Warnier wrote: >> Taking the same hypothetical case and figures : >> >> Assuming that you need a total of (10000 * 4 connections) = 40000 >> connections. Assuming that it takes 10ms to set up one such >> connection, and that once it is there, you don't do anything with >> it and just let it be for now. Assuming we ignore such things like >> bandwidth, other things happening on that host etc.. It then takes >> a total of (10 ms * 40000) = 400000 ms = 400s = ~ 6.5 minutes just >> to set up these connections. >> >> Is that acceptable ? >> >> What I mean is that once you start playing with such numbers, you >> may want to look at other aspects than just required memory.. > > There's also the issue of open filehandles, etc. My development > environment is limited to 10240 filehandles per process (though of > course that can be changed). Opening 10,000 connections would use most > of those, leaving very few left to accept incoming requests from > clients, etc. Ah, beat me to it. p > It would be easier if all databases were hosted by a single instance > of MySQL -- then you could use Tomcat-pool's feature of being able to > provide credentials when obtaining connections from the pool -- and > get the right database. That way, a much smaller number of connections > could be maintained with roughly the same semantics. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.17 (Darwin) > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAk/GsecACgkQ9CaO5/Lv0PC7HACeNXMp5KZpAHGfhK73/MPFcGOn > eIwAoJ7g4P/Nz2DBgNHBhwkq0jO3HMCu > �CE > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org