云数据库 GAUSSDB-修改SQL限流任务:请求示例

时间:2024-11-05 09:15:23

请求示例

  • 修改限流类型是SQL_ID的限流任务。
    https://gaussdb-opengauss.cn-north-1.myhuaweicloud.com/v3/0611f1bd8b00d5d32f17c017f15b599f/instances/3d39c18788b54a919bab633874c159dfin14/limit-task/96854ba7-8d50-4a3c-8fd8-210a7390e9d1
    {
      "start_time" : "2024-08-20T06:54:42+0800",
      "end_time" : "2024-08-20T07:54:42+0800",
      "task_name" : "SOLIdLimit",
      "parallel_size" : 10
    }
  • 修改限流类型是SQL_TYPE的限流任务。
    https://gaussdb-opengauss.cn-north-1.myhuaweicloud.com/v3/0611f1bd8b00d5d32f17c017f15b599f/instances/3d39c18788b54a919bab633874c159dfin14/limit-task/96854ba7-8d50-4a3c-8fd8-210a7390e9d1
    {
      "start_time" : "2024-08-20T06:54:42+0800",
      "end_time" : "2024-08-20T07:54:42+0800",
      "key_words" : "version,type",
      "task_name" : "KeywordLimit",
      "parallel_size" : 10,
      "databases" : "gaussdb_test3"
    }
  • 修改限流类型是SESSION_ACTIVE_MAX_COUNT的限流任务。
    https://gaussdb-opengauss.cn-north-1.myhuaweicloud.com/v3/0611f1bd8b00d5d32f17c017f15b599f/instances/3d39c18788b54a919bab633874c159dfin14/limit-task/96854ba7-8d50-4a3c-8fd8-210a7390e9d1
    {
      "task_name": "ThresholdLimit",
      "parallel_size": 10,
      "cpu_utilization": 20,
      "memory_utilization": 20
    }
support.huaweicloud.com/api-gaussdb/gaussdb_api_386.html