文档平台 API 中心 云数据库 MySQL 参数相关接口 查询实例的可设置参数列表

查询实例的可设置参数列表

最近更新时间:2018-10-26 15:05:02

1. 接口描述

接口请求域名: cdb.tencentcloudapi.com 。

该接口(DescribeInstanceParams)用于查询实例的参数列表。

默认接口请求频率限制:20次/秒。

注意:本接口支持金融区地域。由于金融区和非金融区是隔离不互通的,因此当公共参数 Region 为金融区地域(例如 ap-shanghai-fsi)时,需要同时指定带金融区地域的域名,最好和 Region 的地域保持一致,例如:cdb.ap-shanghai-fsi.tencentcloudapi.com 。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数,完整公共参数列表见公共请求参数

参数名称 必选 类型 描述
Action String 公共参数,本接口取值:DescribeInstanceParams
Version String 公共参数,本接口取值:2017-03-20
Region String 公共参数,详见产品支持的地域列表
InstanceId String 实例ID,格式如:cdb-c1nl9rpv,与云数据库控制台页面中显示的实例ID相同,可使用查询实例列表 接口获取,其值为输出参数中字段 InstanceId 的值

3. 输出参数

参数名称 类型 描述
TotalCount Integer 实例的参数总数
Items Array of ParameterDetail 参数详情
RequestId String 唯一请求 ID,每次请求都会返回。定位问题时需要提供该次请求的 RequestId。

4. 示例

示例1 查询实例的可设置参数列表

输入示例

https://cdb.tencentcloudapi.com/?Action=DescribeInstanceParams
&InstanceId=cdb-ezq1vzem
&<公共请求参数>

输出示例

{
  "Response": {
    "Items": [
      {
        "CurrentValue": "800",
        "Default": "151",
        "Description": "The maximum permitted number of simultaneous client connections.",
        "EnumValue": [],
        "Max": 10240,
        "Min": 1,
        "Name": "max_connections",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "utf8",
        "Default": "utf8",
        "Description": "Specify default server character set.",
        "EnumValue": [
          "utf8",
          "utf8mb4",
          "gbk",
          "latin1"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "character_set_server",
        "NeedReboot": 1,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "0",
        "Default": "0",
        "Description": "If set to 0, table names are stored as specified and comparisons are case sensitive. If set to 1, they are stored in lowercase on disk and comparisons are not case sensitive.",
        "EnumValue": [],
        "Max": 1,
        "Min": 0,
        "Name": "lower_case_table_names",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "3600",
        "Default": "7200",
        "Description": "The number of seconds the server waits for activity on a noninteractive connection before closing it.",
        "EnumValue": [],
        "Max": 7200,
        "Min": 1,
        "Name": "wait_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH",
        "Default": "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",
        "Description": "The current server SQL mode.",
        "EnumValue": [
          "",
          "ALLOW_INVALID_DATES",
          "ANSI_QUOTES",
          "ERROR_FOR_DIVISION_BY_ZERO",
          "HIGH_NOT_PRECEDENCE",
          "IGNORE_SPACE",
          "NO_AUTO_CREATE_USER",
          "NO_AUTO_VALUE_ON_ZERO",
          "NO_BACKSLASH_ESCAPES",
          "NO_DIR_IN_CREATE",
          "NO_ENGINE_SUBSTITUTION",
          "NO_FIELD_OPTIONS",
          "NO_KEY_OPTIONS",
          "NO_TABLE_OPTIONS",
          "NO_UNSIGNED_SUBTRACTION",
          "NO_ZERO_DATE",
          "NO_ZERO_IN_DATE",
          "ONLY_FULL_GROUP_BY",
          "PAD_CHAR_TO_FULL_LENGTH",
          "PIPES_AS_CONCAT",
          "REAL_AS_FLOAT",
          "STRICT_ALL_TABLES",
          "STRICT_TRANS_TABLES"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "sql_mode",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "MINIMAL",
        "Default": "FULL",
        "Description": "Controls what formats that rows should be logged in.",
        "EnumValue": [
          "FULL",
          "MINIMAL"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "binlog_row_image",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "512",
        "Default": "2000",
        "Description": "The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.",
        "EnumValue": [],
        "Max": 524288,
        "Min": 1,
        "Name": "table_open_cache",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "8192",
        "Default": "1024",
        "Description": "It specifies the maximum number of .ibd files that MySQL can keep open at one time.",
        "EnumValue": [],
        "Max": 8192,
        "Min": 10,
        "Name": "innodb_open_files",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "OFF",
        "Default": "OFF",
        "Description": "Whether queries that do not use indexes are logged to the slow query log.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "log_queries_not_using_indexes",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "4048",
        "Default": "768",
        "Description": "The number of table definitions (from .frm files) that can be stored in the definition cache.",
        "EnumValue": [],
        "Max": 4048,
        "Min": 400,
        "Name": "table_definition_cache",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "This variable indicates the status of the Event Scheduler.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "event_scheduler",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "READ-COMMITTED",
        "Default": "REPEATABLE-READ",
        "Description": "Default transaction isolation level.",
        "EnumValue": [
          "READ-COMMITTED",
          "REPEATABLE-READ"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "tx_isolation",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "0",
        "Default": "1",
        "Description": "The lock mode to use for generating auto-increment values.",
        "EnumValue": [],
        "Max": 2,
        "Min": 0,
        "Name": "innodb_autoinc_lock_mode",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "2",
        "Default": "1",
        "Description": "Controls the balance between strict ACID compliance for commit operations, and higher performance that is possible when commit-related I/O operations are rearranged and done in batches.",
        "EnumValue": [],
        "Max": 2,
        "Min": 0,
        "Name": "innodb_flush_log_at_trx_commit",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "1",
        "Default": "1",
        "Description": "Controls the number of binary log commit groups to collect before synchronizing the binary log to disk.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 0,
        "Name": "sync_binlog",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4194304",
        "Default": "16777216",
        "Description": "The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.",
        "EnumValue": [],
        "Max": 1073741824,
        "Min": 1024,
        "Name": "tmp_table_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "31536000",
        "Default": "30",
        "Description": "The number of seconds to wait for more data from a connection before aborting the read.",
        "EnumValue": [],
        "Max": 31536000,
        "Min": 1,
        "Name": "net_read_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "1073741824",
        "Default": "7200",
        "Description": "The length of time in seconds an InnoDB transaction waits for a row lock before giving up",
        "EnumValue": [],
        "Max": 1073741824,
        "Min": 1,
        "Name": "innodb_lock_wait_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "If set to true, all INSERT, UPDATE, DELETE, and LOCK TABLE WRITE statements wait until there is no pending SELECT or LOCK TABLE READ on the affected table",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "low_priority_updates",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "64",
        "Default": "84",
        "Description": "Maximum character length of words that are stored in an InnoDB FULLTEXT index.",
        "EnumValue": [],
        "Max": 84,
        "Min": 10,
        "Name": "innodb_ft_max_token_size",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4294967295",
        "Default": "1000",
        "Description": "What size queue (in rows) should be allocated for handling INSERT DELAYED. If the queue becomes full, any client that does INSERT DELAYED will wait until there is room in the queue again.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 1,
        "Name": "delayed_queue_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "16",
        "Default": "3",
        "Description": "Minimum length of words that are stored in an InnoDB FULLTEXT index.",
        "EnumValue": [],
        "Max": 16,
        "Min": 0,
        "Name": "innodb_ft_min_token_size",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "2147483647",
        "Default": "1000",
        "Description": "Specifies the approximate percentage of the InnoDB buffer pool used for the old block sublist",
        "EnumValue": [],
        "Max": 2147483647,
        "Min": 0,
        "Name": "innodb_old_blocks_time",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "524288",
        "Default": "8388608",
        "Description": "The size of the buffer that is allocated when sorting MyISAM indexes during a REPAIR TABLE or when creating indexes with CREATE INDEX or ALTER TABLE",
        "EnumValue": [],
        "Max": 16777216,
        "Min": 262144,
        "Name": "myisam_sort_buffer_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4294967295",
        "Default": "10",
        "Description": "If a read or write on a communication port is interrupted, retry this many times before giving up.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 1,
        "Name": "net_retry_count",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "10240",
        "Default": "0",
        "Description": "The maximum permitted number of simultaneous client connections per user.",
        "EnumValue": [],
        "Max": 10240,
        "Min": 0,
        "Name": "max_user_connections",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "8388608",
        "Default": "1024",
        "Description": "The cutoff on the size of index values that determines which filesort algorithm to use.",
        "EnumValue": [],
        "Max": 8388608,
        "Min": 4,
        "Name": "max_length_for_sort_data",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "64",
        "Default": "4",
        "Description": "The number of I/O threads for write operations in InnoDB.",
        "EnumValue": [],
        "Max": 64,
        "Min": 1,
        "Name": "innodb_write_io_threads",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ALL",
        "Default": "ON",
        "Description": "This option applies only to MyISAM tables. It can have one of the following values to affect handling of the DELAY_KEY_WRITE table option that can be used in CREATE TABLE statements.",
        "EnumValue": [
          "ON",
          "OFF",
          "ALL"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "delay_key_write",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "1048576",
        "Default": "8192",
        "Description": "The size of the persistent buffer used for statement parsing and execution. This buffer is not freed between statements.",
        "EnumValue": [],
        "Max": 1048576,
        "Min": 8192,
        "Name": "query_prealloc_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "When innodb_strict_mode is ON, InnoDB returns errors rather than warnings for certain conditions",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_strict_mode",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "999999999",
        "Default": "100",
        "Description": "If more than this many successive connection requests from a host are interrupted without a successful connection, the server blocks that host from further connections.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 1,
        "Name": "max_connect_errors",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "NEVER",
        "Default": "AUTO",
        "Description": "If AUTO (the default), MySQL permits INSERT and SELECT statements to run concurrently for MyISAM tables that have no free blocks in the middle of the data file.",
        "EnumValue": [
          "NEVER",
          "AUTO",
          "ALWAYS"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "concurrent_insert",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "95",
        "Default": "37",
        "Description": "Specifies the approximate percentage of the InnoDB buffer pool used for the old block sublist",
        "EnumValue": [],
        "Max": 95,
        "Min": 5,
        "Name": "innodb_old_blocks_pct",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "65535",
        "Default": "1",
        "Description": "Determines the starting point for the AUTO_INCREMENT column value.",
        "EnumValue": [],
        "Max": 65535,
        "Min": 1,
        "Name": "auto_increment_offset",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "64",
        "Default": "4",
        "Description": "The number of I/O threads for read operations in InnoDB.",
        "EnumValue": [],
        "Max": 64,
        "Min": 1,
        "Name": "innodb_read_io_threads",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "128",
        "Default": "512",
        "Description": "How many threads we should keep in a cache for reuse",
        "EnumValue": [],
        "Max": 1000,
        "Min": 1,
        "Name": "thread_cache_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "7",
        "Default": "0",
        "Description": "The default mode value to use for the WEEK() function",
        "EnumValue": [],
        "Max": 7,
        "Min": 0,
        "Name": "default_week_format",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "1000",
        "Default": "20",
        "Description": "Number of best matches to use for query expansion",
        "EnumValue": [],
        "Max": 1000,
        "Min": 0,
        "Name": "ft_query_expansion_limit",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4294967295",
        "Default": "100",
        "Description": "After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 1,
        "Name": "delayed_insert_limit",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4294967295",
        "Default": "1024",
        "Description": "The maximum permitted result length in bytes for the GROUP_CONCAT() function",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 4,
        "Name": "group_concat_max_len",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "10000",
        "Default": "0",
        "Description": "How long InnoDB threads sleep before joining the InnoDB queue, in microseconds. ",
        "EnumValue": [],
        "Max": 1000000,
        "Min": 0,
        "Name": "innodb_thread_sleep_delay",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "300",
        "Default": "300",
        "Description": "This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in key cache.",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 100,
        "Name": "key_cache_age_threshold",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "5000",
        "Default": "5000",
        "Description": "Determines the number of threads that can enter InnoDB concurrently",
        "EnumValue": [],
        "Max": 4294967295,
        "Min": 1,
        "Name": "innodb_concurrency_tickets",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "56",
        "Default": "56",
        "Description": "Controls the sensitivity of linear read-ahead that InnoDB uses to prefetch pages into the buffer pool",
        "EnumValue": [],
        "Max": 64,
        "Min": 0,
        "Name": "innodb_read_ahead_threshold",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "75.000000",
        "Default": "75",
        "Description": "InnoDB tries to flush data from the buffer pool so that the percentage of dirty pages does not exceed this value",
        "EnumValue": [],
        "Max": 99,
        "Min": 0,
        "Name": "innodb_max_dirty_pages_pct",
        "NeedReboot": 0,
        "ParamType": "float"
      },
      {
        "CurrentValue": "1800",
        "Default": "10",
        "Description": "The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake",
        "EnumValue": [],
        "Max": 1800,
        "Min": 2,
        "Name": "connect_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "SYSTEM",
        "Default": "UTC",
        "Description": "This variable controls the time zone of timestamps in messages written to the error log, and in general query log and slow query log messages written to files.",
        "EnumValue": [
          "UTC",
          "SYSTEM"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "log_timestamps",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "84",
        "Default": "4",
        "Description": "The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable.",
        "EnumValue": [],
        "Max": 84,
        "Min": 1,
        "Name": "ft_min_word_len",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "1",
        "Default": "2",
        "Description": "ngram_token_size is set to the size of the largest token that you want to search for.",
        "EnumValue": [],
        "Max": 10,
        "Min": 1,
        "Name": "ngram_token_size",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "65535",
        "Default": "1",
        "Description": "Controls the interval between successive column values.",
        "EnumValue": [],
        "Max": 65535,
        "Min": 1,
        "Name": "auto_increment_increment",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "100",
        "Default": "100",
        "Description": "The minimum percentage of warm blocks in key cache",
        "EnumValue": [],
        "Max": 100,
        "Min": 1,
        "Name": "key_cache_division_limit",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "4",
        "Default": "4",
        "Description": "This variable indicates the number of digits by which to increase the scale of the result of division operations performed with the operator",
        "EnumValue": [],
        "Max": 30,
        "Min": 0,
        "Name": "div_precision_increment",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "OFF",
        "Default": "ON",
        "Description": "If autocommit = 0, InnoDB honors LOCK TABLES; MySQL does not return from LOCK TABLES ... WRITE until all other threads have released all their locks to the table. The default value of innodb_table_locks is 1, which means that LOCK TABLES causes InnoDB to lock a table internally if autocommit = 0.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_table_locks",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "31536000",
        "Default": "31536000",
        "Description": "his variable specifies the timeout in seconds for attempts to acquire metadata locks.",
        "EnumValue": [],
        "Max": 31536000,
        "Min": 1,
        "Name": "lock_wait_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "ON",
        "Description": "Create FTS index with stopword.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_ft_enable_stopword",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "60",
        "Default": "60",
        "Description": "The number of seconds to wait for a block to be written to a connection before aborting the write.",
        "EnumValue": [],
        "Max": 31536000,
        "Min": 1,
        "Name": "net_write_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "When this option is enabled, information about all deadlocks in InnoDB user transactions is recorded in the mysqld error log.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_print_all_deadlocks",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "2048",
        "Default": "8192",
        "Description": "The allocation size of memory blocks that are allocated for objects created during statement parsing and execution.",
        "EnumValue": [],
        "Max": 16384,
        "Min": 1024,
        "Name": "query_alloc_block_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "Invalidate queries in query cache on LOCK for write",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "query_cache_wlock_invalidate",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "OFF",
        "Default": "ON",
        "Description": "Whether the InnoDB adaptive hash index is enabled or disabled.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_adaptive_hash_index",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "Whether enable the performance schema.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "performance_schema",
        "NeedReboot": 1,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "3600",
        "Default": "300",
        "Description": "How long a INSERT DELAYED thread should wait for INSERT statements before terminating.",
        "EnumValue": [],
        "Max": 3600,
        "Min": 1,
        "Name": "delayed_insert_timeout",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "5000",
        "Default": "300",
        "Description": "The granularity of changes, expressed in units of redo log records, that trigger a purge operation, flushing the changed buffer pool blocks to disk.",
        "EnumValue": [],
        "Max": 5000,
        "Min": 1,
        "Name": "innodb_purge_batch_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "10",
        "Default": "2",
        "Description": "If creating a thread takes longer than this many seconds, the server increments the Slow_launch_threads status variable",
        "EnumValue": [],
        "Max": 10,
        "Min": 1,
        "Name": "slow_launch_time",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "16",
        "Default": "1",
        "Description": "The number of background threads devoted to the InnoDB purge operation.",
        "EnumValue": [],
        "Max": 32,
        "Min": 1,
        "Name": "innodb_purge_threads",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "Enable this option to allow index key prefixes longer than 767 bytes (up to 3072 bytes) for InnoDB tables that use the DYNAMIC and COMPRESSED row formats.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_large_prefix",
        "NeedReboot": 0,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "64",
        "Default": "16",
        "Description": "The number of table cache instances",
        "EnumValue": [],
        "Max": 64,
        "Min": 1,
        "Name": "table_open_cache_instances",
        "NeedReboot": 1,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "2147483647",
        "Default": "134217728",
        "Description": "Maximum modification log file size for online index creation",
        "EnumValue": [],
        "Max": 2147483647,
        "Min": 134217728,
        "Name": "innodb_online_alter_log_max_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "ON",
        "Default": "OFF",
        "Description": "InnoDB rolls back only the last statement on a transaction timeout by default. If innodb_rollback_on_timeout is specified, a transaction timeout causes InnoDB to abort and roll back the entire transaction.",
        "EnumValue": [
          "ON",
          "OFF"
        ],
        "Max": 0,
        "Min": 0,
        "Name": "innodb_rollback_on_timeout",
        "NeedReboot": 1,
        "ParamType": "enum"
      },
      {
        "CurrentValue": "4096",
        "Default": "1024",
        "Description": "The default size of key cache blocks",
        "EnumValue": [],
        "Max": 16384,
        "Min": 512,
        "Name": "key_cache_block_size",
        "NeedReboot": 0,
        "ParamType": "integer"
      },
      {
        "CurrentValue": "1",
        "Default": "10",
        "Description": "The optimizer will use existing index statistics instead of doing index dives for equality ranges if the number of equality ranges for the index is larger than or equal to this number. If set to 0, index dives are always used.",
        "EnumValue": [],
        "Max": 200,
        "Min": 1,
        "Name": "eq_range_index_dive_limit",
        "NeedReboot": 0,
        "ParamType": "integer"
      }
    ],
    "RequestId": "92131c95-aa65-44db-8c3c-e8cd67883b58",
    "TotalCount": 72
  }
}

5. 开发者资源

API Explorer

该工具提供了在线调用、签名验证、SDK 代码生成和快速检索接口等能力,能显著降低使用云 API 的难度,推荐使用。

SDK

云 API 3.0 提供了配套的开发工具集(SDK),支持多种编程语言,能更方便的调用 API。

命令行工具

6. 错误码

以下仅列出了接口业务逻辑相关的错误码,其他错误码详见公共错误码

错误码 描述
CdbError 后端错误或者流程错误。
InternalError.DatabaseAccessError 数据库内部错误。
InvalidParameter 参数错误。
InvalidParameter.InstanceNotFound 实例不存在。