Re: [MonetDB-users] max concurrent limit?

On 28-02-2012 06:27:26 -0600, Allen Zhang wrote:

Hi Stefan,

We dug through source code, found out in mal_client.h, you have #define MAX_MALCLIENTS 64, can we increase that number and compile to get a boost in Aug version? Any impact will be? We have about 20 CPU core and 150GB memory for a monetdb install with 300GB data.

Basically, that's it, yes. It may or may not work, though. It's in any case not what monetdb is best at, so you preferably funnel down your connections. Regards, Fabian

On 2/28/12 12:19 AM, "Stefan Manegold" wrote:

...

Hi Allen,

in case you indeed require more than 64 clients connected to the server conrurrently, please consider upgrading to Dec2011. This allows you to set the maximal number of concurrent client connections via monetdb set nclients=<num>

or when starting mserver5 by hand

mserver5 --set max_clients=<num>

Cf., http://www.monetdb.org/Downloads/ReleaseNotes

Unfortunately, neither the mserver5 man page nor the monetdb man page seem to list this feature, yet.

Kind regards, Stefan

On Mon, Feb 27, 2012 at 07:53:04PM -0600, Allen Zhang wrote:

...

Hi,

When connecting to monetdb Aug 2011 SP2 version, we encountered error states : Maximum concurrent client connection (64) reached, any solutions?

Best Regards Allen