tencentcloud.MariadbParameters
Explore with Pulumi AI
Provides a resource to create a mariadb parameters
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";
const parameters = new tencentcloud.MariadbParameters("parameters", {
instanceId: "tdsql-4pzs5b67",
params: [
{
param: "auto_increment_increment",
value: "1",
},
{
param: "auto_increment_offset",
value: "1",
},
{
param: "autocommit",
value: "ON",
},
{
param: "character_set_server",
value: "utf8mb4",
},
{
param: "collation_connection",
value: "utf8mb4_general_ci",
},
{
param: "collation_database",
value: "utf8mb4_general_ci",
},
{
param: "collation_server",
value: "utf8mb4_general_ci",
},
{
param: "connect_timeout",
value: "10",
},
{
param: "default_collation_for_utf8mb4",
value: "utf8mb4_general_ci",
},
{
param: "default_week_format",
value: "0",
},
{
param: "delay_key_write",
value: "ON",
},
{
param: "delayed_insert_limit",
value: "100",
},
{
param: "delayed_insert_timeout",
value: "300",
},
{
param: "delayed_queue_size",
value: "1000",
},
{
param: "div_precision_increment",
value: "4",
},
{
param: "event_scheduler",
value: "ON",
},
{
param: "group_concat_max_len",
value: "1024",
},
{
param: "innodb_concurrency_tickets",
value: "5000",
},
{
param: "innodb_flush_log_at_trx_commit",
value: "1",
},
{
param: "innodb_lock_wait_timeout",
value: "20",
},
{
param: "innodb_max_dirty_pages_pct",
value: "70.000000",
},
{
param: "innodb_old_blocks_pct",
value: "37",
},
{
param: "innodb_old_blocks_time",
value: "1000",
},
{
param: "innodb_purge_batch_size",
value: "1000",
},
{
param: "innodb_read_ahead_threshold",
value: "56",
},
{
param: "innodb_stats_method",
value: "nulls_equal",
},
{
param: "innodb_stats_on_metadata",
value: "OFF",
},
{
param: "innodb_strict_mode",
value: "OFF",
},
{
param: "innodb_table_locks",
value: "ON",
},
{
param: "innodb_thread_concurrency",
value: "0",
},
{
param: "interactive_timeout",
value: "28800",
},
{
param: "key_cache_age_threshold",
value: "300",
},
{
param: "key_cache_block_size",
value: "1024",
},
{
param: "key_cache_division_limit",
value: "100",
},
{
param: "local_infile",
value: "OFF",
},
{
param: "lock_wait_timeout",
value: "5",
},
{
param: "log_queries_not_using_indexes",
value: "OFF",
},
{
param: "long_query_time",
value: "1.000000",
},
{
param: "low_priority_updates",
value: "OFF",
},
{
param: "max_allowed_packet",
value: "1073741824",
},
{
param: "max_binlog_size",
value: "536870912",
},
{
param: "max_connect_errors",
value: "2000",
},
{
param: "max_connections",
value: "10000",
},
{
param: "max_execution_time",
value: "0",
},
{
param: "max_prepared_stmt_count",
value: "200000",
},
{
param: "myisam_sort_buffer_size",
value: "4194304",
},
{
param: "net_buffer_length",
value: "16384",
},
{
param: "net_read_timeout",
value: "150",
},
{
param: "net_retry_count",
value: "10",
},
{
param: "net_write_timeout",
value: "300",
},
{
param: "query_alloc_block_size",
value: "16384",
},
{
param: "query_prealloc_size",
value: "24576",
},
{
param: "slow_launch_time",
value: "2",
},
{
param: "sort_buffer_size",
value: "2097152",
},
{
param: "sql_mode",
value: "NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES",
},
{
param: "sql_require_primary_key",
value: "ON",
},
{
param: "sql_safe_updates",
value: "OFF",
},
{
param: "sqlasyntimeout",
value: "30",
},
{
param: "sync_binlog",
value: "1",
},
{
param: "table_definition_cache",
value: "10240",
},
{
param: "table_open_cache",
value: "20480",
},
{
param: "time_zone",
value: "+08:00",
},
{
param: "tmp_table_size",
value: "33554432",
},
{
param: "tx_isolation",
value: "READ-COMMITTED",
},
{
param: "wait_timeout",
value: "28800",
},
],
});
import pulumi
import pulumi_tencentcloud as tencentcloud
parameters = tencentcloud.MariadbParameters("parameters",
instance_id="tdsql-4pzs5b67",
params=[
{
"param": "auto_increment_increment",
"value": "1",
},
{
"param": "auto_increment_offset",
"value": "1",
},
{
"param": "autocommit",
"value": "ON",
},
{
"param": "character_set_server",
"value": "utf8mb4",
},
{
"param": "collation_connection",
"value": "utf8mb4_general_ci",
},
{
"param": "collation_database",
"value": "utf8mb4_general_ci",
},
{
"param": "collation_server",
"value": "utf8mb4_general_ci",
},
{
"param": "connect_timeout",
"value": "10",
},
{
"param": "default_collation_for_utf8mb4",
"value": "utf8mb4_general_ci",
},
{
"param": "default_week_format",
"value": "0",
},
{
"param": "delay_key_write",
"value": "ON",
},
{
"param": "delayed_insert_limit",
"value": "100",
},
{
"param": "delayed_insert_timeout",
"value": "300",
},
{
"param": "delayed_queue_size",
"value": "1000",
},
{
"param": "div_precision_increment",
"value": "4",
},
{
"param": "event_scheduler",
"value": "ON",
},
{
"param": "group_concat_max_len",
"value": "1024",
},
{
"param": "innodb_concurrency_tickets",
"value": "5000",
},
{
"param": "innodb_flush_log_at_trx_commit",
"value": "1",
},
{
"param": "innodb_lock_wait_timeout",
"value": "20",
},
{
"param": "innodb_max_dirty_pages_pct",
"value": "70.000000",
},
{
"param": "innodb_old_blocks_pct",
"value": "37",
},
{
"param": "innodb_old_blocks_time",
"value": "1000",
},
{
"param": "innodb_purge_batch_size",
"value": "1000",
},
{
"param": "innodb_read_ahead_threshold",
"value": "56",
},
{
"param": "innodb_stats_method",
"value": "nulls_equal",
},
{
"param": "innodb_stats_on_metadata",
"value": "OFF",
},
{
"param": "innodb_strict_mode",
"value": "OFF",
},
{
"param": "innodb_table_locks",
"value": "ON",
},
{
"param": "innodb_thread_concurrency",
"value": "0",
},
{
"param": "interactive_timeout",
"value": "28800",
},
{
"param": "key_cache_age_threshold",
"value": "300",
},
{
"param": "key_cache_block_size",
"value": "1024",
},
{
"param": "key_cache_division_limit",
"value": "100",
},
{
"param": "local_infile",
"value": "OFF",
},
{
"param": "lock_wait_timeout",
"value": "5",
},
{
"param": "log_queries_not_using_indexes",
"value": "OFF",
},
{
"param": "long_query_time",
"value": "1.000000",
},
{
"param": "low_priority_updates",
"value": "OFF",
},
{
"param": "max_allowed_packet",
"value": "1073741824",
},
{
"param": "max_binlog_size",
"value": "536870912",
},
{
"param": "max_connect_errors",
"value": "2000",
},
{
"param": "max_connections",
"value": "10000",
},
{
"param": "max_execution_time",
"value": "0",
},
{
"param": "max_prepared_stmt_count",
"value": "200000",
},
{
"param": "myisam_sort_buffer_size",
"value": "4194304",
},
{
"param": "net_buffer_length",
"value": "16384",
},
{
"param": "net_read_timeout",
"value": "150",
},
{
"param": "net_retry_count",
"value": "10",
},
{
"param": "net_write_timeout",
"value": "300",
},
{
"param": "query_alloc_block_size",
"value": "16384",
},
{
"param": "query_prealloc_size",
"value": "24576",
},
{
"param": "slow_launch_time",
"value": "2",
},
{
"param": "sort_buffer_size",
"value": "2097152",
},
{
"param": "sql_mode",
"value": "NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES",
},
{
"param": "sql_require_primary_key",
"value": "ON",
},
{
"param": "sql_safe_updates",
"value": "OFF",
},
{
"param": "sqlasyntimeout",
"value": "30",
},
{
"param": "sync_binlog",
"value": "1",
},
{
"param": "table_definition_cache",
"value": "10240",
},
{
"param": "table_open_cache",
"value": "20480",
},
{
"param": "time_zone",
"value": "+08:00",
},
{
"param": "tmp_table_size",
"value": "33554432",
},
{
"param": "tx_isolation",
"value": "READ-COMMITTED",
},
{
"param": "wait_timeout",
"value": "28800",
},
])
package main
import (
"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := tencentcloud.NewMariadbParameters(ctx, "parameters", &tencentcloud.MariadbParametersArgs{
InstanceId: pulumi.String("tdsql-4pzs5b67"),
Params: tencentcloud.MariadbParametersParamArray{
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("auto_increment_increment"),
Value: pulumi.String("1"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("auto_increment_offset"),
Value: pulumi.String("1"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("autocommit"),
Value: pulumi.String("ON"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("character_set_server"),
Value: pulumi.String("utf8mb4"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("collation_connection"),
Value: pulumi.String("utf8mb4_general_ci"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("collation_database"),
Value: pulumi.String("utf8mb4_general_ci"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("collation_server"),
Value: pulumi.String("utf8mb4_general_ci"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("connect_timeout"),
Value: pulumi.String("10"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("default_collation_for_utf8mb4"),
Value: pulumi.String("utf8mb4_general_ci"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("default_week_format"),
Value: pulumi.String("0"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("delay_key_write"),
Value: pulumi.String("ON"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("delayed_insert_limit"),
Value: pulumi.String("100"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("delayed_insert_timeout"),
Value: pulumi.String("300"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("delayed_queue_size"),
Value: pulumi.String("1000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("div_precision_increment"),
Value: pulumi.String("4"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("event_scheduler"),
Value: pulumi.String("ON"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("group_concat_max_len"),
Value: pulumi.String("1024"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_concurrency_tickets"),
Value: pulumi.String("5000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_flush_log_at_trx_commit"),
Value: pulumi.String("1"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_lock_wait_timeout"),
Value: pulumi.String("20"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_max_dirty_pages_pct"),
Value: pulumi.String("70.000000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_old_blocks_pct"),
Value: pulumi.String("37"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_old_blocks_time"),
Value: pulumi.String("1000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_purge_batch_size"),
Value: pulumi.String("1000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_read_ahead_threshold"),
Value: pulumi.String("56"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_stats_method"),
Value: pulumi.String("nulls_equal"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_stats_on_metadata"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_strict_mode"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_table_locks"),
Value: pulumi.String("ON"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("innodb_thread_concurrency"),
Value: pulumi.String("0"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("interactive_timeout"),
Value: pulumi.String("28800"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("key_cache_age_threshold"),
Value: pulumi.String("300"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("key_cache_block_size"),
Value: pulumi.String("1024"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("key_cache_division_limit"),
Value: pulumi.String("100"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("local_infile"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("lock_wait_timeout"),
Value: pulumi.String("5"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("log_queries_not_using_indexes"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("long_query_time"),
Value: pulumi.String("1.000000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("low_priority_updates"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_allowed_packet"),
Value: pulumi.String("1073741824"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_binlog_size"),
Value: pulumi.String("536870912"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_connect_errors"),
Value: pulumi.String("2000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_connections"),
Value: pulumi.String("10000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_execution_time"),
Value: pulumi.String("0"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("max_prepared_stmt_count"),
Value: pulumi.String("200000"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("myisam_sort_buffer_size"),
Value: pulumi.String("4194304"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("net_buffer_length"),
Value: pulumi.String("16384"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("net_read_timeout"),
Value: pulumi.String("150"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("net_retry_count"),
Value: pulumi.String("10"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("net_write_timeout"),
Value: pulumi.String("300"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("query_alloc_block_size"),
Value: pulumi.String("16384"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("query_prealloc_size"),
Value: pulumi.String("24576"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("slow_launch_time"),
Value: pulumi.String("2"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sort_buffer_size"),
Value: pulumi.String("2097152"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sql_mode"),
Value: pulumi.String("NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sql_require_primary_key"),
Value: pulumi.String("ON"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sql_safe_updates"),
Value: pulumi.String("OFF"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sqlasyntimeout"),
Value: pulumi.String("30"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("sync_binlog"),
Value: pulumi.String("1"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("table_definition_cache"),
Value: pulumi.String("10240"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("table_open_cache"),
Value: pulumi.String("20480"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("time_zone"),
Value: pulumi.String("+08:00"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("tmp_table_size"),
Value: pulumi.String("33554432"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("tx_isolation"),
Value: pulumi.String("READ-COMMITTED"),
},
&tencentcloud.MariadbParametersParamArgs{
Param: pulumi.String("wait_timeout"),
Value: pulumi.String("28800"),
},
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;
return await Deployment.RunAsync(() =>
{
var parameters = new Tencentcloud.MariadbParameters("parameters", new()
{
InstanceId = "tdsql-4pzs5b67",
Params = new[]
{
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "auto_increment_increment",
Value = "1",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "auto_increment_offset",
Value = "1",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "autocommit",
Value = "ON",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "character_set_server",
Value = "utf8mb4",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "collation_connection",
Value = "utf8mb4_general_ci",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "collation_database",
Value = "utf8mb4_general_ci",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "collation_server",
Value = "utf8mb4_general_ci",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "connect_timeout",
Value = "10",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "default_collation_for_utf8mb4",
Value = "utf8mb4_general_ci",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "default_week_format",
Value = "0",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "delay_key_write",
Value = "ON",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "delayed_insert_limit",
Value = "100",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "delayed_insert_timeout",
Value = "300",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "delayed_queue_size",
Value = "1000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "div_precision_increment",
Value = "4",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "event_scheduler",
Value = "ON",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "group_concat_max_len",
Value = "1024",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_concurrency_tickets",
Value = "5000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_flush_log_at_trx_commit",
Value = "1",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_lock_wait_timeout",
Value = "20",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_max_dirty_pages_pct",
Value = "70.000000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_old_blocks_pct",
Value = "37",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_old_blocks_time",
Value = "1000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_purge_batch_size",
Value = "1000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_read_ahead_threshold",
Value = "56",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_stats_method",
Value = "nulls_equal",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_stats_on_metadata",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_strict_mode",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_table_locks",
Value = "ON",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "innodb_thread_concurrency",
Value = "0",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "interactive_timeout",
Value = "28800",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "key_cache_age_threshold",
Value = "300",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "key_cache_block_size",
Value = "1024",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "key_cache_division_limit",
Value = "100",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "local_infile",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "lock_wait_timeout",
Value = "5",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "log_queries_not_using_indexes",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "long_query_time",
Value = "1.000000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "low_priority_updates",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_allowed_packet",
Value = "1073741824",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_binlog_size",
Value = "536870912",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_connect_errors",
Value = "2000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_connections",
Value = "10000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_execution_time",
Value = "0",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "max_prepared_stmt_count",
Value = "200000",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "myisam_sort_buffer_size",
Value = "4194304",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "net_buffer_length",
Value = "16384",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "net_read_timeout",
Value = "150",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "net_retry_count",
Value = "10",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "net_write_timeout",
Value = "300",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "query_alloc_block_size",
Value = "16384",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "query_prealloc_size",
Value = "24576",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "slow_launch_time",
Value = "2",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sort_buffer_size",
Value = "2097152",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sql_mode",
Value = "NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sql_require_primary_key",
Value = "ON",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sql_safe_updates",
Value = "OFF",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sqlasyntimeout",
Value = "30",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "sync_binlog",
Value = "1",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "table_definition_cache",
Value = "10240",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "table_open_cache",
Value = "20480",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "time_zone",
Value = "+08:00",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "tmp_table_size",
Value = "33554432",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "tx_isolation",
Value = "READ-COMMITTED",
},
new Tencentcloud.Inputs.MariadbParametersParamArgs
{
Param = "wait_timeout",
Value = "28800",
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.MariadbParameters;
import com.pulumi.tencentcloud.MariadbParametersArgs;
import com.pulumi.tencentcloud.inputs.MariadbParametersParamArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var parameters = new MariadbParameters("parameters", MariadbParametersArgs.builder()
.instanceId("tdsql-4pzs5b67")
.params(
MariadbParametersParamArgs.builder()
.param("auto_increment_increment")
.value("1")
.build(),
MariadbParametersParamArgs.builder()
.param("auto_increment_offset")
.value("1")
.build(),
MariadbParametersParamArgs.builder()
.param("autocommit")
.value("ON")
.build(),
MariadbParametersParamArgs.builder()
.param("character_set_server")
.value("utf8mb4")
.build(),
MariadbParametersParamArgs.builder()
.param("collation_connection")
.value("utf8mb4_general_ci")
.build(),
MariadbParametersParamArgs.builder()
.param("collation_database")
.value("utf8mb4_general_ci")
.build(),
MariadbParametersParamArgs.builder()
.param("collation_server")
.value("utf8mb4_general_ci")
.build(),
MariadbParametersParamArgs.builder()
.param("connect_timeout")
.value("10")
.build(),
MariadbParametersParamArgs.builder()
.param("default_collation_for_utf8mb4")
.value("utf8mb4_general_ci")
.build(),
MariadbParametersParamArgs.builder()
.param("default_week_format")
.value("0")
.build(),
MariadbParametersParamArgs.builder()
.param("delay_key_write")
.value("ON")
.build(),
MariadbParametersParamArgs.builder()
.param("delayed_insert_limit")
.value("100")
.build(),
MariadbParametersParamArgs.builder()
.param("delayed_insert_timeout")
.value("300")
.build(),
MariadbParametersParamArgs.builder()
.param("delayed_queue_size")
.value("1000")
.build(),
MariadbParametersParamArgs.builder()
.param("div_precision_increment")
.value("4")
.build(),
MariadbParametersParamArgs.builder()
.param("event_scheduler")
.value("ON")
.build(),
MariadbParametersParamArgs.builder()
.param("group_concat_max_len")
.value("1024")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_concurrency_tickets")
.value("5000")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_flush_log_at_trx_commit")
.value("1")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_lock_wait_timeout")
.value("20")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_max_dirty_pages_pct")
.value("70.000000")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_old_blocks_pct")
.value("37")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_old_blocks_time")
.value("1000")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_purge_batch_size")
.value("1000")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_read_ahead_threshold")
.value("56")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_stats_method")
.value("nulls_equal")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_stats_on_metadata")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_strict_mode")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_table_locks")
.value("ON")
.build(),
MariadbParametersParamArgs.builder()
.param("innodb_thread_concurrency")
.value("0")
.build(),
MariadbParametersParamArgs.builder()
.param("interactive_timeout")
.value("28800")
.build(),
MariadbParametersParamArgs.builder()
.param("key_cache_age_threshold")
.value("300")
.build(),
MariadbParametersParamArgs.builder()
.param("key_cache_block_size")
.value("1024")
.build(),
MariadbParametersParamArgs.builder()
.param("key_cache_division_limit")
.value("100")
.build(),
MariadbParametersParamArgs.builder()
.param("local_infile")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("lock_wait_timeout")
.value("5")
.build(),
MariadbParametersParamArgs.builder()
.param("log_queries_not_using_indexes")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("long_query_time")
.value("1.000000")
.build(),
MariadbParametersParamArgs.builder()
.param("low_priority_updates")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("max_allowed_packet")
.value("1073741824")
.build(),
MariadbParametersParamArgs.builder()
.param("max_binlog_size")
.value("536870912")
.build(),
MariadbParametersParamArgs.builder()
.param("max_connect_errors")
.value("2000")
.build(),
MariadbParametersParamArgs.builder()
.param("max_connections")
.value("10000")
.build(),
MariadbParametersParamArgs.builder()
.param("max_execution_time")
.value("0")
.build(),
MariadbParametersParamArgs.builder()
.param("max_prepared_stmt_count")
.value("200000")
.build(),
MariadbParametersParamArgs.builder()
.param("myisam_sort_buffer_size")
.value("4194304")
.build(),
MariadbParametersParamArgs.builder()
.param("net_buffer_length")
.value("16384")
.build(),
MariadbParametersParamArgs.builder()
.param("net_read_timeout")
.value("150")
.build(),
MariadbParametersParamArgs.builder()
.param("net_retry_count")
.value("10")
.build(),
MariadbParametersParamArgs.builder()
.param("net_write_timeout")
.value("300")
.build(),
MariadbParametersParamArgs.builder()
.param("query_alloc_block_size")
.value("16384")
.build(),
MariadbParametersParamArgs.builder()
.param("query_prealloc_size")
.value("24576")
.build(),
MariadbParametersParamArgs.builder()
.param("slow_launch_time")
.value("2")
.build(),
MariadbParametersParamArgs.builder()
.param("sort_buffer_size")
.value("2097152")
.build(),
MariadbParametersParamArgs.builder()
.param("sql_mode")
.value("NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES")
.build(),
MariadbParametersParamArgs.builder()
.param("sql_require_primary_key")
.value("ON")
.build(),
MariadbParametersParamArgs.builder()
.param("sql_safe_updates")
.value("OFF")
.build(),
MariadbParametersParamArgs.builder()
.param("sqlasyntimeout")
.value("30")
.build(),
MariadbParametersParamArgs.builder()
.param("sync_binlog")
.value("1")
.build(),
MariadbParametersParamArgs.builder()
.param("table_definition_cache")
.value("10240")
.build(),
MariadbParametersParamArgs.builder()
.param("table_open_cache")
.value("20480")
.build(),
MariadbParametersParamArgs.builder()
.param("time_zone")
.value("+08:00")
.build(),
MariadbParametersParamArgs.builder()
.param("tmp_table_size")
.value("33554432")
.build(),
MariadbParametersParamArgs.builder()
.param("tx_isolation")
.value("READ-COMMITTED")
.build(),
MariadbParametersParamArgs.builder()
.param("wait_timeout")
.value("28800")
.build())
.build());
}
}
resources:
parameters:
type: tencentcloud:MariadbParameters
properties:
instanceId: tdsql-4pzs5b67
params:
- param: auto_increment_increment
value: '1'
- param: auto_increment_offset
value: '1'
- param: autocommit
value: ON
- param: character_set_server
value: utf8mb4
- param: collation_connection
value: utf8mb4_general_ci
- param: collation_database
value: utf8mb4_general_ci
- param: collation_server
value: utf8mb4_general_ci
- param: connect_timeout
value: '10'
- param: default_collation_for_utf8mb4
value: utf8mb4_general_ci
- param: default_week_format
value: '0'
- param: delay_key_write
value: ON
- param: delayed_insert_limit
value: '100'
- param: delayed_insert_timeout
value: '300'
- param: delayed_queue_size
value: '1000'
- param: div_precision_increment
value: '4'
- param: event_scheduler
value: ON
- param: group_concat_max_len
value: '1024'
- param: innodb_concurrency_tickets
value: '5000'
- param: innodb_flush_log_at_trx_commit
value: '1'
- param: innodb_lock_wait_timeout
value: '20'
- param: innodb_max_dirty_pages_pct
value: '70.000000'
- param: innodb_old_blocks_pct
value: '37'
- param: innodb_old_blocks_time
value: '1000'
- param: innodb_purge_batch_size
value: '1000'
- param: innodb_read_ahead_threshold
value: '56'
- param: innodb_stats_method
value: nulls_equal
- param: innodb_stats_on_metadata
value: OFF
- param: innodb_strict_mode
value: OFF
- param: innodb_table_locks
value: ON
- param: innodb_thread_concurrency
value: '0'
- param: interactive_timeout
value: '28800'
- param: key_cache_age_threshold
value: '300'
- param: key_cache_block_size
value: '1024'
- param: key_cache_division_limit
value: '100'
- param: local_infile
value: OFF
- param: lock_wait_timeout
value: '5'
- param: log_queries_not_using_indexes
value: OFF
- param: long_query_time
value: '1.000000'
- param: low_priority_updates
value: OFF
- param: max_allowed_packet
value: '1073741824'
- param: max_binlog_size
value: '536870912'
- param: max_connect_errors
value: '2000'
- param: max_connections
value: '10000'
- param: max_execution_time
value: '0'
- param: max_prepared_stmt_count
value: '200000'
- param: myisam_sort_buffer_size
value: '4194304'
- param: net_buffer_length
value: '16384'
- param: net_read_timeout
value: '150'
- param: net_retry_count
value: '10'
- param: net_write_timeout
value: '300'
- param: query_alloc_block_size
value: '16384'
- param: query_prealloc_size
value: '24576'
- param: slow_launch_time
value: '2'
- param: sort_buffer_size
value: '2097152'
- param: sql_mode
value: NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
- param: sql_require_primary_key
value: ON
- param: sql_safe_updates
value: OFF
- param: sqlasyntimeout
value: '30'
- param: sync_binlog
value: '1'
- param: table_definition_cache
value: '10240'
- param: table_open_cache
value: '20480'
- param: time_zone
value: +08:00
- param: tmp_table_size
value: '33554432'
- param: tx_isolation
value: READ-COMMITTED
- param: wait_timeout
value: '28800'
Create MariadbParameters Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MariadbParameters(name: string, args: MariadbParametersArgs, opts?: CustomResourceOptions);
@overload
def MariadbParameters(resource_name: str,
args: MariadbParametersArgs,
opts: Optional[ResourceOptions] = None)
@overload
def MariadbParameters(resource_name: str,
opts: Optional[ResourceOptions] = None,
instance_id: Optional[str] = None,
params: Optional[Sequence[MariadbParametersParamArgs]] = None,
mariadb_parameters_id: Optional[str] = None)
func NewMariadbParameters(ctx *Context, name string, args MariadbParametersArgs, opts ...ResourceOption) (*MariadbParameters, error)
public MariadbParameters(string name, MariadbParametersArgs args, CustomResourceOptions? opts = null)
public MariadbParameters(String name, MariadbParametersArgs args)
public MariadbParameters(String name, MariadbParametersArgs args, CustomResourceOptions options)
type: tencentcloud:MariadbParameters
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args MariadbParametersArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args MariadbParametersArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args MariadbParametersArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MariadbParametersArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MariadbParametersArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
MariadbParameters Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The MariadbParameters resource accepts the following input properties:
- Instance
Id string - instance id.
- Params
List<Mariadb
Parameters Param> - Number of days to keep, no more than 30.
- Mariadb
Parameters stringId - ID of the resource.
- Instance
Id string - instance id.
- Params
[]Mariadb
Parameters Param Args - Number of days to keep, no more than 30.
- Mariadb
Parameters stringId - ID of the resource.
- instance
Id String - instance id.
- params
List<Mariadb
Parameters Param> - Number of days to keep, no more than 30.
- mariadb
Parameters StringId - ID of the resource.
- instance
Id string - instance id.
- params
Mariadb
Parameters Param[] - Number of days to keep, no more than 30.
- mariadb
Parameters stringId - ID of the resource.
- instance_
id str - instance id.
- params
Sequence[Mariadb
Parameters Param Args] - Number of days to keep, no more than 30.
- mariadb_
parameters_ strid - ID of the resource.
- instance
Id String - instance id.
- params List<Property Map>
- Number of days to keep, no more than 30.
- mariadb
Parameters StringId - ID of the resource.
Outputs
All input properties are implicitly available as output properties. Additionally, the MariadbParameters resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
- id string
- The provider-assigned unique ID for this managed resource.
- id str
- The provider-assigned unique ID for this managed resource.
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing MariadbParameters Resource
Get an existing MariadbParameters resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: MariadbParametersState, opts?: CustomResourceOptions): MariadbParameters
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
instance_id: Optional[str] = None,
mariadb_parameters_id: Optional[str] = None,
params: Optional[Sequence[MariadbParametersParamArgs]] = None) -> MariadbParameters
func GetMariadbParameters(ctx *Context, name string, id IDInput, state *MariadbParametersState, opts ...ResourceOption) (*MariadbParameters, error)
public static MariadbParameters Get(string name, Input<string> id, MariadbParametersState? state, CustomResourceOptions? opts = null)
public static MariadbParameters get(String name, Output<String> id, MariadbParametersState state, CustomResourceOptions options)
resources: _: type: tencentcloud:MariadbParameters get: id: ${id}
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Instance
Id string - instance id.
- Mariadb
Parameters stringId - ID of the resource.
- Params
List<Mariadb
Parameters Param> - Number of days to keep, no more than 30.
- Instance
Id string - instance id.
- Mariadb
Parameters stringId - ID of the resource.
- Params
[]Mariadb
Parameters Param Args - Number of days to keep, no more than 30.
- instance
Id String - instance id.
- mariadb
Parameters StringId - ID of the resource.
- params
List<Mariadb
Parameters Param> - Number of days to keep, no more than 30.
- instance
Id string - instance id.
- mariadb
Parameters stringId - ID of the resource.
- params
Mariadb
Parameters Param[] - Number of days to keep, no more than 30.
- instance_
id str - instance id.
- mariadb_
parameters_ strid - ID of the resource.
- params
Sequence[Mariadb
Parameters Param Args] - Number of days to keep, no more than 30.
- instance
Id String - instance id.
- mariadb
Parameters StringId - ID of the resource.
- params List<Property Map>
- Number of days to keep, no more than 30.
Supporting Types
MariadbParametersParam, MariadbParametersParamArgs
Import
mariadb parameters can be imported using the id, e.g.
$ pulumi import tencentcloud:index/mariadbParameters:MariadbParameters parameters tdsql-4pzs5b67
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- tencentcloud tencentcloudstack/terraform-provider-tencentcloud
- License
- Notes
- This Pulumi package is based on the
tencentcloud
Terraform Provider.