Is there a way to limit worker threads on Windows

Bryan Senseman

6 Jan 2015 6 Jan '15

4:08 p.m.

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.

Attachments:

attachment.html (text/html — 2.2 KB)

Show replies by date

Stefan Manegold

6 Jan 6 Jan

4:29 p.m.

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

Bryan Senseman

4:53 p.m.

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.

Dimitar Nedev

5:07 p.m.

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 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

Bryan Senseman

5:22 p.m.

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 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.

Stefan Manegold

5:41 p.m.

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 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

g4＠novadsp.com

6:20 p.m.

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

Stefan Manegold

5:40 p.m.

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

Martin Kersten

4:37 p.m.

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

3645

Age (days ago)

3645

Last active (days ago)

List overview

Download

8 comments

5 participants

participants (5)

Bryan Senseman
Dimitar Nedev
g4＠novadsp.com
Martin Kersten
Stefan Manegold