Well, usually you would see a marked performance dropoff somewhere after a
certain number of connections are open. I didn't realize until checking that
MySQL defaults to 151(!), see:
http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html
which seems like a heck of a lot to me, but depends on what you are doing
with it I guess. I'll probably limit Senda to 50 to start...
Thanks for the testing and explanations ivan!
Best,
Mark
On Fri, Feb 13, 2009 at 11:33 AM, Ivan Shcheklein <[email protected]>wrote:
> Mark,
>
> OK, thanks!
>> I haven't checked the docs on this, not sure if its in there or not, but
>> while we are on the subject - whats the recommended number of connections
>> for typical usage (say medium load) when using a connection pool?
>>
>
>
> I don't know actually if there are any known recommendations. It seems to
> me that it's an application dependent thing.
>
> Ivan
>
>
>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
