On 10/12/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > On Oct 12, 2008, at 3:01 PM, Roy Lyseng wrote: > > Yes, but I guess there is usually a 1-1 connection between thread and >> session. Thus, most operations on the session can be done without >> synchronization. With more threads, this will change. >> > > > Nope, not in our world. There are many, and I mean many, groups who have > 1K+ open sessions at a time.
Agreed. I've actually had to recompile the Linux kernel to allow more than 10,240 connections because we were hitting MySQL with all we could muster. (first we thought we were running into a limitation of MySQL cluster and switched to a regular MyISAM architecture, and then we got the same issues occurring and realized it was the 10,240 connection limit on Linux). -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
