e- postpone-cap int query server message postpone cap is the maximum number of messages that can be postponed at any given time. Set this number to substantially lower than transaction cap, so that the 0 (default) then the overall query timeout is used instead. -queryserver-config-query-pool- waiter-cap int query server query pool waiter limit, this is the maximum number of queries that can be queued transaction-cap int query server transaction cap is the maximum number of transactions allowed to happen at any given point of a time for a single vttablet. E.g. by setting transaction cap to 100, there

queryserver -config-pool-prefill -parallelism maxWaiters: 50000 # queryserver -config-query-pool-waiter-cap olapReadPool: size: 200 # queryserver -config-stream-pool-size timeoutSeconds: 0 # queryserver -config-stream-pool-prefill -parallelism maxWaiters: 0 64 txPool: size: 20 # queryserver -config-transaction -cap timeoutSeconds: 1 # queryserver -config-txpool-timeout idleTimeoutSeconds: 1800 # queryserver -config-idle-timeout queryserver -config-transaction -prefill -parallelism maxWaiters: 50000 # queryserver -config-txpool-waiter-cap oltp: queryTimeoutSeconds: 30 # queryserver -config-query-timeout txTimeoutSeconds: 30 # queryserver

e- postpone-cap int query server message postpone cap is the maximum number of messages that can be postponed at any given time. Set this number to substantially lower than transaction cap, so that the 0 (default) then the overall query timeout is used instead. -queryserver-config-query-pool- waiter-cap int query server query pool waiter limit, this is the maximum number of queries that can be queued ransaction- cap int query server transaction cap is the maximum number of transactions allowed to happen at any given point of a time for a single vttablet. E.g. by setting transaction cap to 100, there

queryserver -config-pool-prefill -parallelism maxWaiters: 50000 # queryserver -config-query-pool-waiter-cap olapReadPool: size: 200 # queryserver -config-stream-pool-size timeoutSeconds: 0 # queryserver -config-stream-pool-prefill -parallelism maxWaiters: 0 72 txPool: size: 20 # queryserver -config-transaction -cap timeoutSeconds: 1 # queryserver -config-txpool-timeout idleTimeoutSeconds: 1800 # queryserver -config-idle-timeout queryserver -config-transaction -prefill -parallelism maxWaiters: 50000 # queryserver -config-txpool-waiter-cap oltp: queryTimeoutSeconds: 30 # queryserver -config-query-timeout txTimeoutSeconds: 30 # queryserver

queryserver -config-pool-prefill -parallelism maxWaiters: 50000 # queryserver -config-query-pool-waiter-cap olapReadPool: size: 200 # queryserver -config-stream-pool-size timeoutSeconds: 0 # queryserver -config-stream-pool-prefill -parallelism maxWaiters: 0 txPool: size: 20 # queryserver -config-transaction -cap timeoutSeconds: 1 # queryserver -config-txpool-timeout idleTimeoutSeconds: 1800 # queryserver -config-idle-timeout queryserver -config-transaction -prefill -parallelism maxWaiters: 50000 # queryserver -config-txpool-waiter-cap oltp: queryTimeoutSeconds: 30 # queryserver -config-query-timeout txTimeoutSeconds: 30 # queryserver

queryserver -config-pool-prefill -parallelism maxWaiters: 50000 # queryserver -config-query-pool-waiter-cap olapReadPool: size: 200 # queryserver -config-stream-pool-size timeoutSeconds: 0 # queryserver -config-stream-pool-prefill -parallelism maxWaiters: 0 txPool: size: 20 # queryserver -config-transaction -cap timeoutSeconds: 1 # queryserver -config-txpool-timeout idleTimeoutSeconds: 1800 # queryserver -config-idle-timeout queryserver -config-transaction -prefill -parallelism maxWaiters: 50000 # queryserver -config-txpool-waiter-cap oltp: queryTimeoutSeconds: 30 # queryserver -config-query-timeout txTimeoutSeconds: 30 # queryserver

-config -pool-size 24 -queryserver -config -stream-pool-size 24 -queryserver -config -transaction -cap 300 More tuning flags are available, but the above overrides are definitely needed for serving reasonable streaming queries you plan to run. Typical values are in the low 100s. • queryserver-config-transaction-cap: This value should be set to how many concurrent transactions you wish to allow. This should be a function

-config -pool-size 24 -queryserver -config -stream-pool-size 24 -queryserver -config -transaction -cap 300 More tuning flags are available, but the above overrides are definitely needed for serving reasonable streaming queries you plan to run. Typical values are in the low 100s. • queryserver-config-transaction-cap: This value should be set to how many concurrent transactions you wish to allow. This should be a function