[MonetDB-users] max concurrent limit? - users-list - monetdb.org

newer
[MonetDB-users] Announcement: New...

[MonetDB-users] max concurrent limit?

older
[MonetDB-users] MonetDB JDBC 1.9...

Allen Zhang

28 Feb 2012 28 Feb '12

1:53 a.m.

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

Attachments:

attachment.html (text/html — 1.2 KB)

Reply

Sign in to reply online Use email software

Show replies by date

Stefan Manegold

28 Feb 28 Feb

6:19 a.m.

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

------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

Reply

Sign in to reply online Use email software

Allen Zhang

12:27 p.m.

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. Best Regards Allen 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

...
------------------------------------------------------------------------- ----- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d

...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

-------------------------------------------------------------------------- ---- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply

Sign in to reply online Use email software

Fabian Groffen

12:33 p.m.

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

Reply

Sign in to reply online Use email software

Martin Kersten

12:35 p.m.

Hi, You can increase the defined MAX, but there is no expected boost. For, the more clients there are, the more resource competition arises. What the optimum is depends on the workload. regards, Martin On 2/28/12 1:27 PM, 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.

Best Regards Allen

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

...
------------------------------------------------------------------------- ----- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d

...
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

-------------------------------------------------------------------------- ---- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply

Sign in to reply online Use email software

4758

Age (days ago)

4758

Last active (days ago)

Download

4 comments

4 participants

tags

participants (4)

Allen Zhang
Fabian Groffen
Martin Kersten
Stefan Manegold