云数据库 TAURUSDB-获取参数模板详情:响应示例

时间:2024-12-11 17:00:03

响应示例

状态码: 200

Success.

{
  "configurations" : {
    "id" : "43570e0de32e40c5a15f831aa5ce4176pr07",
    "name" : "myparameter",
    "description" : "parameter1",
    "datastore" : {
      "type" : "gaussdb-mysql",
      "version" : "8.0"
    },
    "created" : "2022-05-15T11:53:34+0000",
    "updated" : "2022-05-15T11:53:34+0000"
  },
  "parameter_values" : {
    "auto_increment_increment" : "1",
    "auto_increment_offset" : 1,
    "binlog_checksum" : "CRC32",
    "character_set_server" : "utf8",
    "connect_timeout" : 10,
    "default_authentication_plugin" : "mysql_native_password",
    "default_week_format" : 0,
    "div_precision_increment" : 4,
    "end_markers_in_json" : "OFF",
    "innodb_autoextend_increment" : 64,
    "innodb_autoinc_lock_mode" : 2,
    "innodb_concurrency_tickets" : 5000,
    "innodb_default_row_format" : "DYNAMIC",
    "innodb_flush_log_at_timeout" : 1,
    "innodb_flush_log_at_trx_commit" : 1,
    "innodb_flush_neighbors" : 0,
    "innodb_max_undo_log_size" : 1073741824,
    "innodb_optimize_fulltext_only" : "OFF",
    "innodb_purge_batch_size" : 300,
    "innodb_purge_threads" : 4,
    "innodb_sort_buffer_size" : 1048576,
    "innodb_spin_wait_delay" : 6,
    "innodb_status_output" : "OFF",
    "innodb_status_output_locks" : "OFF",
    "innodb_strict_mode" : "OFF",
    "innodb_sync_array_size" : 1,
    "innodb_sync_spin_loops" : 30,
    "innodb_thread_concurrency" : 0,
    "innodb_thread_sleep_delay" : 10000,
    "interactive_timeout" : 28800,
    "local_infile" : "OFF",
    "lock_wait_timeout" : 31536000,
    "log_queries_not_using_indexes" : "OFF",
    "log_throttle_queries_not_using_indexes" : 0,
    "long_query_time" : 10,
    "low_priority_updates" : "OFF",
    "max_connect_errors" : 100,
    "max_error_count" : 1024,
    "max_prepared_stmt_count" : 16382,
    "max_sp_recursion_depth" : 0,
    "max_user_connections" : 0,
    "max_write_lock_count" : 102400,
    "net_buffer_length" : 16384,
    "net_read_timeout" : 30,
    "net_retry_count" : 10,
    "net_write_timeout" : 60,
    "password_history" : 0,
    "password_require_current" : "OFF",
    "password_reuse_interval" : 0,
    "performance_schema" : "OFF",
    "profiling_history_size" : 15,
    "query_prealloc_size" : 8192,
    "read_buffer_size" : 131072,
    "read_rnd_buffer_size" : 262144,
    "show_old_temporals" : "OFF",
    "skip_name_resolve" : "ON",
    "slow_launch_time" : 2,
    "sql_mode" : null,
    "table_open_cache" : 8192,
    "table_open_cache_instances" : 16,
    "thread_cache_size" : 1024,
    "thread_stack" : 286720,
    "transaction_isolation" : "REPEATABLE-READ",
    "updatable_views_with_limit" : "YES",
    "wait_timeout" : 28800,
    "temptable_max_mmap" : 1073741824,
    "default_password_lifetime" : 0,
    "max_allowed_packet" : 1073741824,
    "binlog_expire_logs_seconds" : 3600,
    "max_binlog_cache_size" : 18446744073709547520,
    "binlog_cache_size" : 32768,
    "group_concat_max_len" : 1024,
    "max_binlog_size" : 67108864,
    "log_bin_trust_function_creators" : "ON",
    "explicit_defaults_for_timestamp" : "ON",
    "threadpool_stall_limit" : 50,
    "time_zone" : "SYSTEM",
    "rds_warn_max_binlog_cache_size" : 18446744073709547520,
    "default_collation_for_utf8mb4" : "utf8mb4_0900_ai_ci",
    "idle_transaction_timeout" : 0,
    "idle_readonly_transaction_timeout" : 0,
    "idle_write_transaction_timeout" : 0,
    "block_encryption_mode" : "aes-256-cbc",
    "innodb_lock_wait_timeout" : 50,
    "collation_server" : "utf8_general_ci",
    "innodb_read_ahead_threshold" : 56,
    "innodb_random_read_ahead" : "OFF",
    "eq_range_index_dive_limit" : 10,
    "sort_buffer_size" : 1048576,
    "join_buffer_size" : 524288,
    "range_optimizer_max_mem_size" : 16777216,
    "strict_status_check_RTO_time" : 30,
    "long_trx_decision_time" : 300,
    "mount_vip_when_failover" : "ON",
    "force_parallel_execute" : "OFF",
    "parallel_cost_threshold" : 1000,
    "parallel_default_dop" : 4,
    "parallel_max_threads" : 64,
    "parallel_memory_limit" : 104857600,
    "parallel_queue_timeout" : 0,
    "threadpool_oversubscribe" : 3,
    "binlog_gtid_simple_recovery" : "ON",
    "log_slave_updates" : "ON",
    "binlog_rows_query_log_events" : "OFF",
    "log-bin" : "ON",
    "gtid_mode" : "ON",
    "enforce_gtid_consistency" : "ON",
    "innodb_online_alter_log_max_size" : 134217728,
    "rds_sql_tracer_max_record_size" : 4096,
    "innodb_parallel_select_count" : "ON",
    "max_execution_time" : 0,
    "rds_sqlfilter_case_sensitive" : "OFF",
    "strict_status_check" : "ON",
    "rds_ddl_lock_wait_timeout" : 31536000
  }
}
support.huaweicloud.com/api-gaussdbformysql/ShowGaussMySqlConfiguration.html