cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <>
Subject Re: Closing Cayennes' DataContext
Date Sat, 03 Jan 2015 22:21:31 GMT
10,000 is a pretty high number. The default is about 150. It may be that mysql isn't able to
cope with that many settings.

Also, you should always have more connections available in your database than you configure
in your connection pool, otherwise you are going to run into problems when you connect to
your database for admin purposes, backups, or other things.


On 4/01/2015 1:37am, jonathan_ms2006 wrote:
> Hi Michael,
>     In my cayenne NodeDriver.xml file, I have configured a connection pool
> that goes like this:
> <connectionPool min="1" max="10000"/>. Obviously I allowed 10000 maximum
> number or simultaneous connections.
>     On MySQL server installation directory (my.ini), I have configured
> max_connections attribute to 10000 same with my connection pool defined in
> cayennes' dataNodeDriver.xml while the rest of my.ini file attributes are
> not modified upon installation.
>     Are there other things I missed.? Many thanks.. :))
> Best Regards,
> Jonathan
> --
> View this message in context:
> Sent from the Cayenne - User mailing list archive at

Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

View raw message