On Sep 5, 1:39 am, Axel Schwenke <axel.schwe...@gmx.de> wrote:
> Hi Sonny,
>
> Sonny <smani...@gmail.com> wrote:
> > On 3 Set, 20:46, Axel Schwenke <axel.schwe...@gmx.de> wrote:
>
> <cut>
>
> > Thanks for the responses sirs,
>
> No need for pluralis majestatis <g>
>
> > how many open database connections can MySQL have concurrently?
>
> There are only practical limits. Each open connection eats at least
> one file descriptor for the TCP socket and some memory (~ 2MB with
> defaults). So if you have big hardware and push operating system
> limits, you can have several thousand open connections. But there's
> not much use of that. I've seen at most ~1500 concurrent connections
> being used on live systems. Normally you stay well below 1000.
>
> XL
> --
> Axel Schwenke, Support Engineer, MySQL AB
>
> Online User Manual:http://dev.mysql.com/doc/refman/5.0/en/
> MySQL User Forums: http://forums.mysql.com/

I see, thanks a lot for the info