resource pools chain

Moderator: NorbertKrupa

Post Reply
vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

resource pools chain

Post by vcarusi » Thu May 26, 2016 3:34 pm

Hi,

I need the confirmation that I understood correctly how a query is executing, passing from a resource pool to another.
I imagine the query starts in 1_pool. After runtimecap corresponding to 1_pool it falls in 2_pool if
runtimecap 2_pool > runtimecap 1_pool .


1_pool
|---------runtimecap------------------|
|--high priority--|
                  |
     runtime      |
     priority     |
     threshold    |
                  |--runtimepriority--|
                                      |cascadeto
                                      |
                                      |
                                      |
                                      |
                                      |2_pool
                                      |---------runtimecap--------------------------|
                                      |--high priority--|
                                          runtime       |
                                          priority      |
                                          threshold     |------runtimepriority------|
                                                                                    |cascadeto
                                                                                    |
                                                                                    |                                                                                    
                                                                                    |3_pool



Until now is correct ?
Thank you,
Veronica

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1804
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: resource pools chain

Post by JimKnicely » Thu May 26, 2016 5:52 pm

Hi,

To the best of my knowledge, your diagram is correct, and really cool, btw.

Note: You can't create a resource pool that starts with a number :)

Code: Select all

dbadmin=> create resource pool 1_pool;
ERROR 3709:  Invalid number at or near "1_p" at character 22
LINE 1: create resource pool 1_pool;
                             ^
dbadmin=> create resource pool pool_1;
CREATE RESOURCE POOL
Unless you surround it in double quotes, which would be a terrible idea.

Code: Select all

dbadmin=> create resource pool "1_pool";
CREATE RESOURCE POOL
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.


vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Re: resource pools chain

Post by vcarusi » Fri May 27, 2016 1:39 pm

Thank you, Jim for your time!
Let's continue!
There are 2 parameters:
RUNTIMECAP - Sets the maximum amount of time any query on the pool has to execute.
QUEUETIMEOUT - Integer value, in seconds, indicating the maximum time the request can wait for resources to become available before rejection.
Both accept NULL = unlimited

Which is the difference between them ?
RUNTIMECAP - is related to execution ?
QUEUETIMEOUT - is the waiting time before execution ?
Is QUEUETIMEOUT included in RUNTIMECAP ?

pool_1
|--queuetimeout|---------runtimecap------------------|
               |--high priority--|
                                 |
                    runtime      |
                    priority     |
                   threshold     |
                                 |--runtimepriority--|
                                                     |cascadeto
                                                     |
Thank you,
Veronica

vcarusi
Beginner
Beginner
Posts: 29
Joined: Mon Apr 20, 2015 11:03 am

Re: resource pools chain

Post by vcarusi » Wed Jun 01, 2016 3:33 pm

I obtained the following error when QUEUETIMEOUT has been exhaused (after 303 sec) :

Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 2733342, Free = 0 (Limit = 17831818, Used = 18251444) (queueing threshold)]

pool_1 QUEUETIMEOUT = 120 sec
pool_2 QUEUETIMEOUT = 300 sec

Post Reply

Return to “Vertica Database Administration”