[MonetDB-users] max concurrent limit?
Hi,
When connecting to monetdb Aug 2011 SP2 version, we encountered error states : Maximum concurrent client connection (64) reached, any solutions?
Best Regards Allen
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> <your_db_name>
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
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" Stefan.Manegold@cwi.nl 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> <your_db_name>
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
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" Stefan.Manegold@cwi.nl 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> <your_db_name>
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
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"Stefan.Manegold@cwi.nl 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> <your_db_name>
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
participants (4)
-
Allen Zhang -
Fabian Groffen -
Martin Kersten -
Stefan Manegold