Is there a way to limit worker threads on Windows
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thank you, I had tried the --set "nthreads=2" without success. Is there a complete list of what can be provided using the --set syntax anywhere?
-----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, January 06, 2015 11:29 AM To: Communication channel for MonetDB users Subject: Re: Is there a way to limit worker threads on Windows
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi Bryan,
You can find more info in the man pages or monetdb.org website: https://www.monetdb.org/Documentation/mserver5-man-page
Best regards, Dimitar
On 2015-Jan-06, at 17:53 , Bryan Senseman monetdb@openbi.com wrote:
Thank you, I had tried the --set "nthreads=2" without success. Is there a complete list of what can be provided using the --set syntax anywhere?
-----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, January 06, 2015 11:29 AM To: Communication channel for MonetDB users Subject: Re: Is there a way to limit worker threads on Windows
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Dimitar,
Thank you, I have read every documentation page I could find. You'll notice, that the gdk_nr_threads is absent from your referenced page; well technically I guess it is covered by " −−set option=value". However it is the that list of options that is elusive. (atleast for Windows and/or me)
Bryan
-----Original Message----- From: Dimitar Nedev [mailto:dimitar.nedev@monetdbsolutions.com] Sent: Tuesday, January 06, 2015 12:07 PM To: Bryan Senseman Cc: MonetDB Users Subject: Re: Is there a way to limit worker threads on Windows
Hi Bryan,
You can find more info in the man pages or monetdb.org website: https://www.monetdb.org/Documentation/mserver5-man-page
Best regards, Dimitar
On 2015-Jan-06, at 17:53 , Bryan Senseman monetdb@openbi.com wrote:
Thank you, I had tried the --set "nthreads=2" without success. Is there a complete list of what can be provided using the --set syntax anywhere?
-----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, January 06, 2015 11:29 AM To: Communication channel for MonetDB users Subject: Re: Is there a way to limit worker threads on Windows
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
yes, indeed, our documentation does not mention "mserver5 --set gdk_nr_threads=..."; it only mentions "monetdb set nthreads=..." (Unix only)
----- Original Message -----
Dimitar,
Thank you, I have read every documentation page I could find. You'll notice, that the gdk_nr_threads is absent from your referenced page; well technically I guess it is covered by " −−set option=value". However it is the that list of options that is elusive. (atleast for Windows and/or me)
Bryan
-----Original Message----- From: Dimitar Nedev [mailto:dimitar.nedev@monetdbsolutions.com] Sent: Tuesday, January 06, 2015 12:07 PM To: Bryan Senseman Cc: MonetDB Users Subject: Re: Is there a way to limit worker threads on Windows
Hi Bryan,
You can find more info in the man pages or monetdb.org website: https://www.monetdb.org/Documentation/mserver5-man-page
Best regards, Dimitar
On 2015-Jan-06, at 17:53 , Bryan Senseman monetdb@openbi.com wrote:
Thank you, I had tried the --set "nthreads=2" without success. Is there a complete list of what can be provided using the --set syntax anywhere?
-----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, January 06, 2015 11:29 AM To: Communication channel for MonetDB users Subject: Re: Is there a way to limit worker threads on Windows
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
FWIW there are other omissions from the Windows documentation: In particular I had to grep the source tree to find the port option ...
HTH
Jerry
Note that it's "mserver5 --set gdk_nr_threads=2"
----- Original Message -----
Thank you, I had tried the --set "nthreads=2" without success. Is there a complete list of what can be provided using the --set syntax anywhere?
-----Original Message----- From: users-list [mailto:users-list-bounces+monetdb=openbi.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, January 06, 2015 11:29 AM To: Communication channel for MonetDB users Subject: Re: Is there a way to limit worker threads on Windows
Hi,
the number of worker threads can be controlled with the following command line option for mserver5:
--set gdk_nr_threads=<N>
On Windows, you'd need to modify the batch script that start the server (mserver5) accordingly; possibly, you can also call that batch script with the above option.
On Unix's, you can use the monetdb tool:
monetdb set nthreads=<N>
Best, Stefan
----- Original Message -----
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
--
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
The number of threads to use can be controlled using a commandline argument --set gdk_nr_threads=<yournumber>
regards, Martin
On 06/01/15 17:08, Bryan Senseman wrote:
All,
I have tried various approaches, but nothing changes the ‘using 8 threads’ message displayed at server startup. I have a client (with a client) that is running MonetDB on a 2cpu windows box and getting various errors, I’m trying to duplicate them but cannot and am concerned it might be that my hardware (read laptop) is too “powerful” to create the error condition. I really do not want to light up a virtual machine just to reduce threads.
Thanx,
Bryan
This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (5)
-
Bryan Senseman -
Dimitar Nedev -
g4＠novadsp.com -
Martin Kersten -
Stefan Manegold