Configuring Auto Throttling for a Standard HTAP Instance

Scenarios

If auto throttling is enabled, to prevent overloads, queries are automatically queued when the number of concurrent queries or the BE node resource usage reaches a certain threshold. Queries in the queue will not be executed until there are enough compute resources.

Configuring Auto Throttling

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, locate a TaurusDB instance and click its name to access the Basic Information page.
5. In the navigation pane, choose HTAP Analysis.
6. Click the name of an HTAP instance to access the Basic Information page.
7. In the navigation pane, choose DBA Assistant > Historical Diagnosis.
8. Click SQL Explorer and then Auto Throttling.
9. Click under Auto Throttling and set required parameters. Auto throttling is triggered when one or more of the thresholds are reached. For details about the parameters, see Table 1.
   Figure 1 Configuring auto throttling
   

   Table 1 Parameter description

   Parameter	Description
   Max. Queuing Queries	When system resources are insufficient, queries are queued. Once the threshold is reached, subsequent queries will be rejected.
   Max. Queuing Time (s)	Maximum timeout interval of a single query in the queue, in seconds. Once the threshold is reached, the query will be rejected.
   Max. Concurrent Queries on BE Node	Maximum number of concurrent queries on a single BE node. Once the threshold is reached, subsequent queries will be queued. This parameter is only valid when it is set to a value greater than 0. The value 0 indicates there is no restriction.
   Max. CPU Usage on BE Node (%)	Maximum CPU usage of a single BE node. Once the threshold is reached, subsequent queries will be queued. This parameter is only valid when it is set to a value greater than 0. The value 0 indicates there is no restriction.
   Max. Memory Usage on BE Node (%)	Maximum memory usage of a single BE node. Once the threshold is reached, subsequent queries will be queued. This parameter is only valid when it is set to a value greater than 0. The value 0 indicates there is no restriction.

10. Click Apply.
11. Return to the Auto Throttling page. Check that auto throttling is enabled. Review the conditions you have set for triggering auto throttling.