You can translate the question and the replies:

What happens when thread count goes above limit

Hello, The [Denodo documentation for Thread Pools](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/threads_pool/threads_pool) says "Maximum number of threads the pool can support simultaneously (default value is 300)". 1. Could you provide a general explanation of what happens when the thread count goes above the limit? 2. Will we see anything in the vdp logs associated to this? 3. What happens to new queries when the thread count is already above the limit? 4. In the monitor query logs, there's a column called "waiting time". When a new query arrives and the server is already at the maximum thread count, will we see that query have a "waiting time" in the logs? 5. Could you provide an example of the error message for "checkout time" ? Thanks
thread pools threads count limit
user
14-11-2023 10:24:06 -0500
code

1 Answer

Hi, 300 is indeed the default value for the maximum number of threads the pool can support simultaneously. Find below answers to above questions : 1. When that value is reached, Denodo will stop spinning up new execution threads. 2. The Denodo Monitor log accounts for all threads running in the JVM. 3. New queries that arrive won't be executed unless there is room for them. Hope this helps
Denodo Team
16-11-2023 12:26:13 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here