Docs Home
oci.Mysql.MysqlConfiguration
Explore with Pulumi AI
This resource provides the Mysql Configuration resource in Oracle Cloud Infrastructure MySQL Database service.
Creates a new Configuration.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testMysqlConfiguration = new oci.mysql.MysqlConfiguration("test_mysql_configuration", {
compartmentId: compartmentId,
shapeName: testShape.name,
definedTags: {
"foo-namespace.bar-key": "value",
},
description: mysqlConfigurationDescription,
displayName: mysqlConfigurationDisplayName,
freeformTags: {
"bar-key": "value",
},
initVariables: {
lowerCaseTableNames: mysqlConfigurationInitVariablesLowerCaseTableNames,
},
parentConfigurationId: testConfiguration.id,
variables: {
autocommit: mysqlConfigurationVariablesAutocommit,
bigTables: mysqlConfigurationVariablesBigTables,
binlogExpireLogsSeconds: mysqlConfigurationVariablesBinlogExpireLogsSeconds,
binlogRowMetadata: mysqlConfigurationVariablesBinlogRowMetadata,
binlogRowValueOptions: mysqlConfigurationVariablesBinlogRowValueOptions,
binlogTransactionCompression: mysqlConfigurationVariablesBinlogTransactionCompression,
completionType: mysqlConfigurationVariablesCompletionType,
connectTimeout: mysqlConfigurationVariablesConnectTimeout,
connectionMemoryChunkSize: mysqlConfigurationVariablesConnectionMemoryChunkSize,
connectionMemoryLimit: mysqlConfigurationVariablesConnectionMemoryLimit,
cteMaxRecursionDepth: mysqlConfigurationVariablesCteMaxRecursionDepth,
defaultAuthenticationPlugin: mysqlConfigurationVariablesDefaultAuthenticationPlugin,
foreignKeyChecks: mysqlConfigurationVariablesForeignKeyChecks,
generatedRandomPasswordLength: mysqlConfigurationVariablesGeneratedRandomPasswordLength,
globalConnectionMemoryLimit: mysqlConfigurationVariablesGlobalConnectionMemoryLimit,
globalConnectionMemoryTracking: mysqlConfigurationVariablesGlobalConnectionMemoryTracking,
groupReplicationConsistency: mysqlConfigurationVariablesGroupReplicationConsistency,
informationSchemaStatsExpiry: mysqlConfigurationVariablesInformationSchemaStatsExpiry,
innodbBufferPoolDumpPct: mysqlConfigurationVariablesInnodbBufferPoolDumpPct,
innodbBufferPoolInstances: mysqlConfigurationVariablesInnodbBufferPoolInstances,
innodbBufferPoolSize: mysqlConfigurationVariablesInnodbBufferPoolSize,
innodbDdlBufferSize: mysqlConfigurationVariablesInnodbDdlBufferSize,
innodbDdlThreads: mysqlConfigurationVariablesInnodbDdlThreads,
innodbFtEnableStopword: mysqlConfigurationVariablesInnodbFtEnableStopword,
innodbFtMaxTokenSize: mysqlConfigurationVariablesInnodbFtMaxTokenSize,
innodbFtMinTokenSize: mysqlConfigurationVariablesInnodbFtMinTokenSize,
innodbFtNumWordOptimize: mysqlConfigurationVariablesInnodbFtNumWordOptimize,
innodbFtResultCacheLimit: mysqlConfigurationVariablesInnodbFtResultCacheLimit,
innodbFtServerStopwordTable: mysqlConfigurationVariablesInnodbFtServerStopwordTable,
innodbLockWaitTimeout: mysqlConfigurationVariablesInnodbLockWaitTimeout,
innodbLogWriterThreads: mysqlConfigurationVariablesInnodbLogWriterThreads,
innodbMaxPurgeLag: mysqlConfigurationVariablesInnodbMaxPurgeLag,
innodbMaxPurgeLagDelay: mysqlConfigurationVariablesInnodbMaxPurgeLagDelay,
innodbStatsPersistentSamplePages: mysqlConfigurationVariablesInnodbStatsPersistentSamplePages,
innodbStatsTransientSamplePages: mysqlConfigurationVariablesInnodbStatsTransientSamplePages,
interactiveTimeout: mysqlConfigurationVariablesInteractiveTimeout,
localInfile: mysqlConfigurationVariablesLocalInfile,
mandatoryRoles: mysqlConfigurationVariablesMandatoryRoles,
maxAllowedPacket: mysqlConfigurationVariablesMaxAllowedPacket,
maxBinlogCacheSize: mysqlConfigurationVariablesMaxBinlogCacheSize,
maxConnectErrors: mysqlConfigurationVariablesMaxConnectErrors,
maxConnections: mysqlConfigurationVariablesMaxConnections,
maxExecutionTime: mysqlConfigurationVariablesMaxExecutionTime,
maxHeapTableSize: mysqlConfigurationVariablesMaxHeapTableSize,
maxPreparedStmtCount: mysqlConfigurationVariablesMaxPreparedStmtCount,
mysqlFirewallMode: mysqlConfigurationVariablesMysqlFirewallMode,
mysqlZstdDefaultCompressionLevel: mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel,
mysqlxConnectTimeout: mysqlConfigurationVariablesMysqlxConnectTimeout,
mysqlxDeflateDefaultCompressionLevel: mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel,
mysqlxDeflateMaxClientCompressionLevel: mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel,
mysqlxDocumentIdUniquePrefix: mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix,
mysqlxEnableHelloNotice: mysqlConfigurationVariablesMysqlxEnableHelloNotice,
mysqlxIdleWorkerThreadTimeout: mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout,
mysqlxInteractiveTimeout: mysqlConfigurationVariablesMysqlxInteractiveTimeout,
mysqlxLz4defaultCompressionLevel: mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel,
mysqlxLz4maxClientCompressionLevel: mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel,
mysqlxMaxAllowedPacket: mysqlConfigurationVariablesMysqlxMaxAllowedPacket,
mysqlxMinWorkerThreads: mysqlConfigurationVariablesMysqlxMinWorkerThreads,
mysqlxReadTimeout: mysqlConfigurationVariablesMysqlxReadTimeout,
mysqlxWaitTimeout: mysqlConfigurationVariablesMysqlxWaitTimeout,
mysqlxWriteTimeout: mysqlConfigurationVariablesMysqlxWriteTimeout,
mysqlxZstdDefaultCompressionLevel: mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel,
mysqlxZstdMaxClientCompressionLevel: mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel,
netReadTimeout: mysqlConfigurationVariablesNetReadTimeout,
netWriteTimeout: mysqlConfigurationVariablesNetWriteTimeout,
parserMaxMemSize: mysqlConfigurationVariablesParserMaxMemSize,
queryAllocBlockSize: mysqlConfigurationVariablesQueryAllocBlockSize,
queryPreallocSize: mysqlConfigurationVariablesQueryPreallocSize,
regexpTimeLimit: mysqlConfigurationVariablesRegexpTimeLimit,
sortBufferSize: mysqlConfigurationVariablesSortBufferSize,
sqlMode: mysqlConfigurationVariablesSqlMode,
sqlRequirePrimaryKey: mysqlConfigurationVariablesSqlRequirePrimaryKey,
sqlWarnings: mysqlConfigurationVariablesSqlWarnings,
threadPoolDedicatedListeners: mysqlConfigurationVariablesThreadPoolDedicatedListeners,
threadPoolMaxTransactionsLimit: mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit,
timeZone: mysqlConfigurationVariablesTimeZone,
tmpTableSize: mysqlConfigurationVariablesTmpTableSize,
transactionIsolation: mysqlConfigurationVariablesTransactionIsolation,
waitTimeout: mysqlConfigurationVariablesWaitTimeout,
},
});
import pulumi
import pulumi_oci as oci
test_mysql_configuration = oci.mysql.MysqlConfiguration("test_mysql_configuration",
compartment_id=compartment_id,
shape_name=test_shape["name"],
defined_tags={
"foo-namespace.bar-key": "value",
},
description=mysql_configuration_description,
display_name=mysql_configuration_display_name,
freeform_tags={
"bar-key": "value",
},
init_variables={
"lower_case_table_names": mysql_configuration_init_variables_lower_case_table_names,
},
parent_configuration_id=test_configuration["id"],
variables={
"autocommit": mysql_configuration_variables_autocommit,
"big_tables": mysql_configuration_variables_big_tables,
"binlog_expire_logs_seconds": mysql_configuration_variables_binlog_expire_logs_seconds,
"binlog_row_metadata": mysql_configuration_variables_binlog_row_metadata,
"binlog_row_value_options": mysql_configuration_variables_binlog_row_value_options,
"binlog_transaction_compression": mysql_configuration_variables_binlog_transaction_compression,
"completion_type": mysql_configuration_variables_completion_type,
"connect_timeout": mysql_configuration_variables_connect_timeout,
"connection_memory_chunk_size": mysql_configuration_variables_connection_memory_chunk_size,
"connection_memory_limit": mysql_configuration_variables_connection_memory_limit,
"cte_max_recursion_depth": mysql_configuration_variables_cte_max_recursion_depth,
"default_authentication_plugin": mysql_configuration_variables_default_authentication_plugin,
"foreign_key_checks": mysql_configuration_variables_foreign_key_checks,
"generated_random_password_length": mysql_configuration_variables_generated_random_password_length,
"global_connection_memory_limit": mysql_configuration_variables_global_connection_memory_limit,
"global_connection_memory_tracking": mysql_configuration_variables_global_connection_memory_tracking,
"group_replication_consistency": mysql_configuration_variables_group_replication_consistency,
"information_schema_stats_expiry": mysql_configuration_variables_information_schema_stats_expiry,
"innodb_buffer_pool_dump_pct": mysql_configuration_variables_innodb_buffer_pool_dump_pct,
"innodb_buffer_pool_instances": mysql_configuration_variables_innodb_buffer_pool_instances,
"innodb_buffer_pool_size": mysql_configuration_variables_innodb_buffer_pool_size,
"innodb_ddl_buffer_size": mysql_configuration_variables_innodb_ddl_buffer_size,
"innodb_ddl_threads": mysql_configuration_variables_innodb_ddl_threads,
"innodb_ft_enable_stopword": mysql_configuration_variables_innodb_ft_enable_stopword,
"innodb_ft_max_token_size": mysql_configuration_variables_innodb_ft_max_token_size,
"innodb_ft_min_token_size": mysql_configuration_variables_innodb_ft_min_token_size,
"innodb_ft_num_word_optimize": mysql_configuration_variables_innodb_ft_num_word_optimize,
"innodb_ft_result_cache_limit": mysql_configuration_variables_innodb_ft_result_cache_limit,
"innodb_ft_server_stopword_table": mysql_configuration_variables_innodb_ft_server_stopword_table,
"innodb_lock_wait_timeout": mysql_configuration_variables_innodb_lock_wait_timeout,
"innodb_log_writer_threads": mysql_configuration_variables_innodb_log_writer_threads,
"innodb_max_purge_lag": mysql_configuration_variables_innodb_max_purge_lag,
"innodb_max_purge_lag_delay": mysql_configuration_variables_innodb_max_purge_lag_delay,
"innodb_stats_persistent_sample_pages": mysql_configuration_variables_innodb_stats_persistent_sample_pages,
"innodb_stats_transient_sample_pages": mysql_configuration_variables_innodb_stats_transient_sample_pages,
"interactive_timeout": mysql_configuration_variables_interactive_timeout,
"local_infile": mysql_configuration_variables_local_infile,
"mandatory_roles": mysql_configuration_variables_mandatory_roles,
"max_allowed_packet": mysql_configuration_variables_max_allowed_packet,
"max_binlog_cache_size": mysql_configuration_variables_max_binlog_cache_size,
"max_connect_errors": mysql_configuration_variables_max_connect_errors,
"max_connections": mysql_configuration_variables_max_connections,
"max_execution_time": mysql_configuration_variables_max_execution_time,
"max_heap_table_size": mysql_configuration_variables_max_heap_table_size,
"max_prepared_stmt_count": mysql_configuration_variables_max_prepared_stmt_count,
"mysql_firewall_mode": mysql_configuration_variables_mysql_firewall_mode,
"mysql_zstd_default_compression_level": mysql_configuration_variables_mysql_zstd_default_compression_level,
"mysqlx_connect_timeout": mysql_configuration_variables_mysqlx_connect_timeout,
"mysqlx_deflate_default_compression_level": mysql_configuration_variables_mysqlx_deflate_default_compression_level,
"mysqlx_deflate_max_client_compression_level": mysql_configuration_variables_mysqlx_deflate_max_client_compression_level,
"mysqlx_document_id_unique_prefix": mysql_configuration_variables_mysqlx_document_id_unique_prefix,
"mysqlx_enable_hello_notice": mysql_configuration_variables_mysqlx_enable_hello_notice,
"mysqlx_idle_worker_thread_timeout": mysql_configuration_variables_mysqlx_idle_worker_thread_timeout,
"mysqlx_interactive_timeout": mysql_configuration_variables_mysqlx_interactive_timeout,
"mysqlx_lz4default_compression_level": mysql_configuration_variables_mysqlx_lz4default_compression_level,
"mysqlx_lz4max_client_compression_level": mysql_configuration_variables_mysqlx_lz4max_client_compression_level,
"mysqlx_max_allowed_packet": mysql_configuration_variables_mysqlx_max_allowed_packet,
"mysqlx_min_worker_threads": mysql_configuration_variables_mysqlx_min_worker_threads,
"mysqlx_read_timeout": mysql_configuration_variables_mysqlx_read_timeout,
"mysqlx_wait_timeout": mysql_configuration_variables_mysqlx_wait_timeout,
"mysqlx_write_timeout": mysql_configuration_variables_mysqlx_write_timeout,
"mysqlx_zstd_default_compression_level": mysql_configuration_variables_mysqlx_zstd_default_compression_level,
"mysqlx_zstd_max_client_compression_level": mysql_configuration_variables_mysqlx_zstd_max_client_compression_level,
"net_read_timeout": mysql_configuration_variables_net_read_timeout,
"net_write_timeout": mysql_configuration_variables_net_write_timeout,
"parser_max_mem_size": mysql_configuration_variables_parser_max_mem_size,
"query_alloc_block_size": mysql_configuration_variables_query_alloc_block_size,
"query_prealloc_size": mysql_configuration_variables_query_prealloc_size,
"regexp_time_limit": mysql_configuration_variables_regexp_time_limit,
"sort_buffer_size": mysql_configuration_variables_sort_buffer_size,
"sql_mode": mysql_configuration_variables_sql_mode,
"sql_require_primary_key": mysql_configuration_variables_sql_require_primary_key,
"sql_warnings": mysql_configuration_variables_sql_warnings,
"thread_pool_dedicated_listeners": mysql_configuration_variables_thread_pool_dedicated_listeners,
"thread_pool_max_transactions_limit": mysql_configuration_variables_thread_pool_max_transactions_limit,
"time_zone": mysql_configuration_variables_time_zone,
"tmp_table_size": mysql_configuration_variables_tmp_table_size,
"transaction_isolation": mysql_configuration_variables_transaction_isolation,
"wait_timeout": mysql_configuration_variables_wait_timeout,
})
package main
import (
"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/Mysql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := Mysql.NewMysqlConfiguration(ctx, "test_mysql_configuration", &Mysql.MysqlConfigurationArgs{
CompartmentId: pulumi.Any(compartmentId),
ShapeName: pulumi.Any(testShape.Name),
DefinedTags: pulumi.StringMap{
"foo-namespace.bar-key": pulumi.String("value"),
},
Description: pulumi.Any(mysqlConfigurationDescription),
DisplayName: pulumi.Any(mysqlConfigurationDisplayName),
FreeformTags: pulumi.StringMap{
"bar-key": pulumi.String("value"),
},
InitVariables: &mysql.MysqlConfigurationInitVariablesArgs{
LowerCaseTableNames: pulumi.Any(mysqlConfigurationInitVariablesLowerCaseTableNames),
},
ParentConfigurationId: pulumi.Any(testConfiguration.Id),
Variables: &mysql.MysqlConfigurationVariablesArgs{
Autocommit: pulumi.Any(mysqlConfigurationVariablesAutocommit),
BigTables: pulumi.Any(mysqlConfigurationVariablesBigTables),
BinlogExpireLogsSeconds: pulumi.Any(mysqlConfigurationVariablesBinlogExpireLogsSeconds),
BinlogRowMetadata: pulumi.Any(mysqlConfigurationVariablesBinlogRowMetadata),
BinlogRowValueOptions: pulumi.Any(mysqlConfigurationVariablesBinlogRowValueOptions),
BinlogTransactionCompression: pulumi.Any(mysqlConfigurationVariablesBinlogTransactionCompression),
CompletionType: pulumi.Any(mysqlConfigurationVariablesCompletionType),
ConnectTimeout: pulumi.Any(mysqlConfigurationVariablesConnectTimeout),
ConnectionMemoryChunkSize: pulumi.Any(mysqlConfigurationVariablesConnectionMemoryChunkSize),
ConnectionMemoryLimit: pulumi.Any(mysqlConfigurationVariablesConnectionMemoryLimit),
CteMaxRecursionDepth: pulumi.Any(mysqlConfigurationVariablesCteMaxRecursionDepth),
DefaultAuthenticationPlugin: pulumi.Any(mysqlConfigurationVariablesDefaultAuthenticationPlugin),
ForeignKeyChecks: pulumi.Any(mysqlConfigurationVariablesForeignKeyChecks),
GeneratedRandomPasswordLength: pulumi.Any(mysqlConfigurationVariablesGeneratedRandomPasswordLength),
GlobalConnectionMemoryLimit: pulumi.Any(mysqlConfigurationVariablesGlobalConnectionMemoryLimit),
GlobalConnectionMemoryTracking: pulumi.Any(mysqlConfigurationVariablesGlobalConnectionMemoryTracking),
GroupReplicationConsistency: pulumi.Any(mysqlConfigurationVariablesGroupReplicationConsistency),
InformationSchemaStatsExpiry: pulumi.Any(mysqlConfigurationVariablesInformationSchemaStatsExpiry),
InnodbBufferPoolDumpPct: pulumi.Any(mysqlConfigurationVariablesInnodbBufferPoolDumpPct),
InnodbBufferPoolInstances: pulumi.Any(mysqlConfigurationVariablesInnodbBufferPoolInstances),
InnodbBufferPoolSize: pulumi.Any(mysqlConfigurationVariablesInnodbBufferPoolSize),
InnodbDdlBufferSize: pulumi.Any(mysqlConfigurationVariablesInnodbDdlBufferSize),
InnodbDdlThreads: pulumi.Any(mysqlConfigurationVariablesInnodbDdlThreads),
InnodbFtEnableStopword: pulumi.Any(mysqlConfigurationVariablesInnodbFtEnableStopword),
InnodbFtMaxTokenSize: pulumi.Any(mysqlConfigurationVariablesInnodbFtMaxTokenSize),
InnodbFtMinTokenSize: pulumi.Any(mysqlConfigurationVariablesInnodbFtMinTokenSize),
InnodbFtNumWordOptimize: pulumi.Any(mysqlConfigurationVariablesInnodbFtNumWordOptimize),
InnodbFtResultCacheLimit: pulumi.Any(mysqlConfigurationVariablesInnodbFtResultCacheLimit),
InnodbFtServerStopwordTable: pulumi.Any(mysqlConfigurationVariablesInnodbFtServerStopwordTable),
InnodbLockWaitTimeout: pulumi.Any(mysqlConfigurationVariablesInnodbLockWaitTimeout),
InnodbLogWriterThreads: pulumi.Any(mysqlConfigurationVariablesInnodbLogWriterThreads),
InnodbMaxPurgeLag: pulumi.Any(mysqlConfigurationVariablesInnodbMaxPurgeLag),
InnodbMaxPurgeLagDelay: pulumi.Any(mysqlConfigurationVariablesInnodbMaxPurgeLagDelay),
InnodbStatsPersistentSamplePages: pulumi.Any(mysqlConfigurationVariablesInnodbStatsPersistentSamplePages),
InnodbStatsTransientSamplePages: pulumi.Any(mysqlConfigurationVariablesInnodbStatsTransientSamplePages),
InteractiveTimeout: pulumi.Any(mysqlConfigurationVariablesInteractiveTimeout),
LocalInfile: pulumi.Any(mysqlConfigurationVariablesLocalInfile),
MandatoryRoles: pulumi.Any(mysqlConfigurationVariablesMandatoryRoles),
MaxAllowedPacket: pulumi.Any(mysqlConfigurationVariablesMaxAllowedPacket),
MaxBinlogCacheSize: pulumi.Any(mysqlConfigurationVariablesMaxBinlogCacheSize),
MaxConnectErrors: pulumi.Any(mysqlConfigurationVariablesMaxConnectErrors),
MaxConnections: pulumi.Any(mysqlConfigurationVariablesMaxConnections),
MaxExecutionTime: pulumi.Any(mysqlConfigurationVariablesMaxExecutionTime),
MaxHeapTableSize: pulumi.Any(mysqlConfigurationVariablesMaxHeapTableSize),
MaxPreparedStmtCount: pulumi.Any(mysqlConfigurationVariablesMaxPreparedStmtCount),
MysqlFirewallMode: pulumi.Any(mysqlConfigurationVariablesMysqlFirewallMode),
MysqlZstdDefaultCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel),
MysqlxConnectTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxConnectTimeout),
MysqlxDeflateDefaultCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel),
MysqlxDeflateMaxClientCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel),
MysqlxDocumentIdUniquePrefix: pulumi.Any(mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix),
MysqlxEnableHelloNotice: pulumi.Any(mysqlConfigurationVariablesMysqlxEnableHelloNotice),
MysqlxIdleWorkerThreadTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout),
MysqlxInteractiveTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxInteractiveTimeout),
MysqlxLz4defaultCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel),
MysqlxLz4maxClientCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel),
MysqlxMaxAllowedPacket: pulumi.Any(mysqlConfigurationVariablesMysqlxMaxAllowedPacket),
MysqlxMinWorkerThreads: pulumi.Any(mysqlConfigurationVariablesMysqlxMinWorkerThreads),
MysqlxReadTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxReadTimeout),
MysqlxWaitTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxWaitTimeout),
MysqlxWriteTimeout: pulumi.Any(mysqlConfigurationVariablesMysqlxWriteTimeout),
MysqlxZstdDefaultCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel),
MysqlxZstdMaxClientCompressionLevel: pulumi.Any(mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel),
NetReadTimeout: pulumi.Any(mysqlConfigurationVariablesNetReadTimeout),
NetWriteTimeout: pulumi.Any(mysqlConfigurationVariablesNetWriteTimeout),
ParserMaxMemSize: pulumi.Any(mysqlConfigurationVariablesParserMaxMemSize),
QueryAllocBlockSize: pulumi.Any(mysqlConfigurationVariablesQueryAllocBlockSize),
QueryPreallocSize: pulumi.Any(mysqlConfigurationVariablesQueryPreallocSize),
RegexpTimeLimit: pulumi.Any(mysqlConfigurationVariablesRegexpTimeLimit),
SortBufferSize: pulumi.Any(mysqlConfigurationVariablesSortBufferSize),
SqlMode: pulumi.Any(mysqlConfigurationVariablesSqlMode),
SqlRequirePrimaryKey: pulumi.Any(mysqlConfigurationVariablesSqlRequirePrimaryKey),
SqlWarnings: pulumi.Any(mysqlConfigurationVariablesSqlWarnings),
ThreadPoolDedicatedListeners: pulumi.Any(mysqlConfigurationVariablesThreadPoolDedicatedListeners),
ThreadPoolMaxTransactionsLimit: pulumi.Any(mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit),
TimeZone: pulumi.Any(mysqlConfigurationVariablesTimeZone),
TmpTableSize: pulumi.Any(mysqlConfigurationVariablesTmpTableSize),
TransactionIsolation: pulumi.Any(mysqlConfigurationVariablesTransactionIsolation),
WaitTimeout: pulumi.Any(mysqlConfigurationVariablesWaitTimeout),
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testMysqlConfiguration = new Oci.Mysql.MysqlConfiguration("test_mysql_configuration", new()
{
CompartmentId = compartmentId,
ShapeName = testShape.Name,
DefinedTags =
{
{ "foo-namespace.bar-key", "value" },
},
Description = mysqlConfigurationDescription,
DisplayName = mysqlConfigurationDisplayName,
FreeformTags =
{
{ "bar-key", "value" },
},
InitVariables = new Oci.Mysql.Inputs.MysqlConfigurationInitVariablesArgs
{
LowerCaseTableNames = mysqlConfigurationInitVariablesLowerCaseTableNames,
},
ParentConfigurationId = testConfiguration.Id,
Variables = new Oci.Mysql.Inputs.MysqlConfigurationVariablesArgs
{
Autocommit = mysqlConfigurationVariablesAutocommit,
BigTables = mysqlConfigurationVariablesBigTables,
BinlogExpireLogsSeconds = mysqlConfigurationVariablesBinlogExpireLogsSeconds,
BinlogRowMetadata = mysqlConfigurationVariablesBinlogRowMetadata,
BinlogRowValueOptions = mysqlConfigurationVariablesBinlogRowValueOptions,
BinlogTransactionCompression = mysqlConfigurationVariablesBinlogTransactionCompression,
CompletionType = mysqlConfigurationVariablesCompletionType,
ConnectTimeout = mysqlConfigurationVariablesConnectTimeout,
ConnectionMemoryChunkSize = mysqlConfigurationVariablesConnectionMemoryChunkSize,
ConnectionMemoryLimit = mysqlConfigurationVariablesConnectionMemoryLimit,
CteMaxRecursionDepth = mysqlConfigurationVariablesCteMaxRecursionDepth,
DefaultAuthenticationPlugin = mysqlConfigurationVariablesDefaultAuthenticationPlugin,
ForeignKeyChecks = mysqlConfigurationVariablesForeignKeyChecks,
GeneratedRandomPasswordLength = mysqlConfigurationVariablesGeneratedRandomPasswordLength,
GlobalConnectionMemoryLimit = mysqlConfigurationVariablesGlobalConnectionMemoryLimit,
GlobalConnectionMemoryTracking = mysqlConfigurationVariablesGlobalConnectionMemoryTracking,
GroupReplicationConsistency = mysqlConfigurationVariablesGroupReplicationConsistency,
InformationSchemaStatsExpiry = mysqlConfigurationVariablesInformationSchemaStatsExpiry,
InnodbBufferPoolDumpPct = mysqlConfigurationVariablesInnodbBufferPoolDumpPct,
InnodbBufferPoolInstances = mysqlConfigurationVariablesInnodbBufferPoolInstances,
InnodbBufferPoolSize = mysqlConfigurationVariablesInnodbBufferPoolSize,
InnodbDdlBufferSize = mysqlConfigurationVariablesInnodbDdlBufferSize,
InnodbDdlThreads = mysqlConfigurationVariablesInnodbDdlThreads,
InnodbFtEnableStopword = mysqlConfigurationVariablesInnodbFtEnableStopword,
InnodbFtMaxTokenSize = mysqlConfigurationVariablesInnodbFtMaxTokenSize,
InnodbFtMinTokenSize = mysqlConfigurationVariablesInnodbFtMinTokenSize,
InnodbFtNumWordOptimize = mysqlConfigurationVariablesInnodbFtNumWordOptimize,
InnodbFtResultCacheLimit = mysqlConfigurationVariablesInnodbFtResultCacheLimit,
InnodbFtServerStopwordTable = mysqlConfigurationVariablesInnodbFtServerStopwordTable,
InnodbLockWaitTimeout = mysqlConfigurationVariablesInnodbLockWaitTimeout,
InnodbLogWriterThreads = mysqlConfigurationVariablesInnodbLogWriterThreads,
InnodbMaxPurgeLag = mysqlConfigurationVariablesInnodbMaxPurgeLag,
InnodbMaxPurgeLagDelay = mysqlConfigurationVariablesInnodbMaxPurgeLagDelay,
InnodbStatsPersistentSamplePages = mysqlConfigurationVariablesInnodbStatsPersistentSamplePages,
InnodbStatsTransientSamplePages = mysqlConfigurationVariablesInnodbStatsTransientSamplePages,
InteractiveTimeout = mysqlConfigurationVariablesInteractiveTimeout,
LocalInfile = mysqlConfigurationVariablesLocalInfile,
MandatoryRoles = mysqlConfigurationVariablesMandatoryRoles,
MaxAllowedPacket = mysqlConfigurationVariablesMaxAllowedPacket,
MaxBinlogCacheSize = mysqlConfigurationVariablesMaxBinlogCacheSize,
MaxConnectErrors = mysqlConfigurationVariablesMaxConnectErrors,
MaxConnections = mysqlConfigurationVariablesMaxConnections,
MaxExecutionTime = mysqlConfigurationVariablesMaxExecutionTime,
MaxHeapTableSize = mysqlConfigurationVariablesMaxHeapTableSize,
MaxPreparedStmtCount = mysqlConfigurationVariablesMaxPreparedStmtCount,
MysqlFirewallMode = mysqlConfigurationVariablesMysqlFirewallMode,
MysqlZstdDefaultCompressionLevel = mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel,
MysqlxConnectTimeout = mysqlConfigurationVariablesMysqlxConnectTimeout,
MysqlxDeflateDefaultCompressionLevel = mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel,
MysqlxDeflateMaxClientCompressionLevel = mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel,
MysqlxDocumentIdUniquePrefix = mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix,
MysqlxEnableHelloNotice = mysqlConfigurationVariablesMysqlxEnableHelloNotice,
MysqlxIdleWorkerThreadTimeout = mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout,
MysqlxInteractiveTimeout = mysqlConfigurationVariablesMysqlxInteractiveTimeout,
MysqlxLz4defaultCompressionLevel = mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel,
MysqlxLz4maxClientCompressionLevel = mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel,
MysqlxMaxAllowedPacket = mysqlConfigurationVariablesMysqlxMaxAllowedPacket,
MysqlxMinWorkerThreads = mysqlConfigurationVariablesMysqlxMinWorkerThreads,
MysqlxReadTimeout = mysqlConfigurationVariablesMysqlxReadTimeout,
MysqlxWaitTimeout = mysqlConfigurationVariablesMysqlxWaitTimeout,
MysqlxWriteTimeout = mysqlConfigurationVariablesMysqlxWriteTimeout,
MysqlxZstdDefaultCompressionLevel = mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel,
MysqlxZstdMaxClientCompressionLevel = mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel,
NetReadTimeout = mysqlConfigurationVariablesNetReadTimeout,
NetWriteTimeout = mysqlConfigurationVariablesNetWriteTimeout,
ParserMaxMemSize = mysqlConfigurationVariablesParserMaxMemSize,
QueryAllocBlockSize = mysqlConfigurationVariablesQueryAllocBlockSize,
QueryPreallocSize = mysqlConfigurationVariablesQueryPreallocSize,
RegexpTimeLimit = mysqlConfigurationVariablesRegexpTimeLimit,
SortBufferSize = mysqlConfigurationVariablesSortBufferSize,
SqlMode = mysqlConfigurationVariablesSqlMode,
SqlRequirePrimaryKey = mysqlConfigurationVariablesSqlRequirePrimaryKey,
SqlWarnings = mysqlConfigurationVariablesSqlWarnings,
ThreadPoolDedicatedListeners = mysqlConfigurationVariablesThreadPoolDedicatedListeners,
ThreadPoolMaxTransactionsLimit = mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit,
TimeZone = mysqlConfigurationVariablesTimeZone,
TmpTableSize = mysqlConfigurationVariablesTmpTableSize,
TransactionIsolation = mysqlConfigurationVariablesTransactionIsolation,
WaitTimeout = mysqlConfigurationVariablesWaitTimeout,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Mysql.MysqlConfiguration;
import com.pulumi.oci.Mysql.MysqlConfigurationArgs;
import com.pulumi.oci.Mysql.inputs.MysqlConfigurationInitVariablesArgs;
import com.pulumi.oci.Mysql.inputs.MysqlConfigurationVariablesArgs;
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 testMysqlConfiguration = new MysqlConfiguration("testMysqlConfiguration", MysqlConfigurationArgs.builder()
.compartmentId(compartmentId)
.shapeName(testShape.name())
.definedTags(Map.of("foo-namespace.bar-key", "value"))
.description(mysqlConfigurationDescription)
.displayName(mysqlConfigurationDisplayName)
.freeformTags(Map.of("bar-key", "value"))
.initVariables(MysqlConfigurationInitVariablesArgs.builder()
.lowerCaseTableNames(mysqlConfigurationInitVariablesLowerCaseTableNames)
.build())
.parentConfigurationId(testConfiguration.id())
.variables(MysqlConfigurationVariablesArgs.builder()
.autocommit(mysqlConfigurationVariablesAutocommit)
.bigTables(mysqlConfigurationVariablesBigTables)
.binlogExpireLogsSeconds(mysqlConfigurationVariablesBinlogExpireLogsSeconds)
.binlogRowMetadata(mysqlConfigurationVariablesBinlogRowMetadata)
.binlogRowValueOptions(mysqlConfigurationVariablesBinlogRowValueOptions)
.binlogTransactionCompression(mysqlConfigurationVariablesBinlogTransactionCompression)
.completionType(mysqlConfigurationVariablesCompletionType)
.connectTimeout(mysqlConfigurationVariablesConnectTimeout)
.connectionMemoryChunkSize(mysqlConfigurationVariablesConnectionMemoryChunkSize)
.connectionMemoryLimit(mysqlConfigurationVariablesConnectionMemoryLimit)
.cteMaxRecursionDepth(mysqlConfigurationVariablesCteMaxRecursionDepth)
.defaultAuthenticationPlugin(mysqlConfigurationVariablesDefaultAuthenticationPlugin)
.foreignKeyChecks(mysqlConfigurationVariablesForeignKeyChecks)
.generatedRandomPasswordLength(mysqlConfigurationVariablesGeneratedRandomPasswordLength)
.globalConnectionMemoryLimit(mysqlConfigurationVariablesGlobalConnectionMemoryLimit)
.globalConnectionMemoryTracking(mysqlConfigurationVariablesGlobalConnectionMemoryTracking)
.groupReplicationConsistency(mysqlConfigurationVariablesGroupReplicationConsistency)
.informationSchemaStatsExpiry(mysqlConfigurationVariablesInformationSchemaStatsExpiry)
.innodbBufferPoolDumpPct(mysqlConfigurationVariablesInnodbBufferPoolDumpPct)
.innodbBufferPoolInstances(mysqlConfigurationVariablesInnodbBufferPoolInstances)
.innodbBufferPoolSize(mysqlConfigurationVariablesInnodbBufferPoolSize)
.innodbDdlBufferSize(mysqlConfigurationVariablesInnodbDdlBufferSize)
.innodbDdlThreads(mysqlConfigurationVariablesInnodbDdlThreads)
.innodbFtEnableStopword(mysqlConfigurationVariablesInnodbFtEnableStopword)
.innodbFtMaxTokenSize(mysqlConfigurationVariablesInnodbFtMaxTokenSize)
.innodbFtMinTokenSize(mysqlConfigurationVariablesInnodbFtMinTokenSize)
.innodbFtNumWordOptimize(mysqlConfigurationVariablesInnodbFtNumWordOptimize)
.innodbFtResultCacheLimit(mysqlConfigurationVariablesInnodbFtResultCacheLimit)
.innodbFtServerStopwordTable(mysqlConfigurationVariablesInnodbFtServerStopwordTable)
.innodbLockWaitTimeout(mysqlConfigurationVariablesInnodbLockWaitTimeout)
.innodbLogWriterThreads(mysqlConfigurationVariablesInnodbLogWriterThreads)
.innodbMaxPurgeLag(mysqlConfigurationVariablesInnodbMaxPurgeLag)
.innodbMaxPurgeLagDelay(mysqlConfigurationVariablesInnodbMaxPurgeLagDelay)
.innodbStatsPersistentSamplePages(mysqlConfigurationVariablesInnodbStatsPersistentSamplePages)
.innodbStatsTransientSamplePages(mysqlConfigurationVariablesInnodbStatsTransientSamplePages)
.interactiveTimeout(mysqlConfigurationVariablesInteractiveTimeout)
.localInfile(mysqlConfigurationVariablesLocalInfile)
.mandatoryRoles(mysqlConfigurationVariablesMandatoryRoles)
.maxAllowedPacket(mysqlConfigurationVariablesMaxAllowedPacket)
.maxBinlogCacheSize(mysqlConfigurationVariablesMaxBinlogCacheSize)
.maxConnectErrors(mysqlConfigurationVariablesMaxConnectErrors)
.maxConnections(mysqlConfigurationVariablesMaxConnections)
.maxExecutionTime(mysqlConfigurationVariablesMaxExecutionTime)
.maxHeapTableSize(mysqlConfigurationVariablesMaxHeapTableSize)
.maxPreparedStmtCount(mysqlConfigurationVariablesMaxPreparedStmtCount)
.mysqlFirewallMode(mysqlConfigurationVariablesMysqlFirewallMode)
.mysqlZstdDefaultCompressionLevel(mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel)
.mysqlxConnectTimeout(mysqlConfigurationVariablesMysqlxConnectTimeout)
.mysqlxDeflateDefaultCompressionLevel(mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel)
.mysqlxDeflateMaxClientCompressionLevel(mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel)
.mysqlxDocumentIdUniquePrefix(mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix)
.mysqlxEnableHelloNotice(mysqlConfigurationVariablesMysqlxEnableHelloNotice)
.mysqlxIdleWorkerThreadTimeout(mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout)
.mysqlxInteractiveTimeout(mysqlConfigurationVariablesMysqlxInteractiveTimeout)
.mysqlxLz4defaultCompressionLevel(mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel)
.mysqlxLz4maxClientCompressionLevel(mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel)
.mysqlxMaxAllowedPacket(mysqlConfigurationVariablesMysqlxMaxAllowedPacket)
.mysqlxMinWorkerThreads(mysqlConfigurationVariablesMysqlxMinWorkerThreads)
.mysqlxReadTimeout(mysqlConfigurationVariablesMysqlxReadTimeout)
.mysqlxWaitTimeout(mysqlConfigurationVariablesMysqlxWaitTimeout)
.mysqlxWriteTimeout(mysqlConfigurationVariablesMysqlxWriteTimeout)
.mysqlxZstdDefaultCompressionLevel(mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel)
.mysqlxZstdMaxClientCompressionLevel(mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel)
.netReadTimeout(mysqlConfigurationVariablesNetReadTimeout)
.netWriteTimeout(mysqlConfigurationVariablesNetWriteTimeout)
.parserMaxMemSize(mysqlConfigurationVariablesParserMaxMemSize)
.queryAllocBlockSize(mysqlConfigurationVariablesQueryAllocBlockSize)
.queryPreallocSize(mysqlConfigurationVariablesQueryPreallocSize)
.regexpTimeLimit(mysqlConfigurationVariablesRegexpTimeLimit)
.sortBufferSize(mysqlConfigurationVariablesSortBufferSize)
.sqlMode(mysqlConfigurationVariablesSqlMode)
.sqlRequirePrimaryKey(mysqlConfigurationVariablesSqlRequirePrimaryKey)
.sqlWarnings(mysqlConfigurationVariablesSqlWarnings)
.threadPoolDedicatedListeners(mysqlConfigurationVariablesThreadPoolDedicatedListeners)
.threadPoolMaxTransactionsLimit(mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit)
.timeZone(mysqlConfigurationVariablesTimeZone)
.tmpTableSize(mysqlConfigurationVariablesTmpTableSize)
.transactionIsolation(mysqlConfigurationVariablesTransactionIsolation)
.waitTimeout(mysqlConfigurationVariablesWaitTimeout)
.build())
.build());
}
}
resources:
testMysqlConfiguration:
type: oci:Mysql:MysqlConfiguration
name: test_mysql_configuration
properties:
compartmentId: ${compartmentId}
shapeName: ${testShape.name}
definedTags:
foo-namespace.bar-key: value
description: ${mysqlConfigurationDescription}
displayName: ${mysqlConfigurationDisplayName}
freeformTags:
bar-key: value
initVariables:
lowerCaseTableNames: ${mysqlConfigurationInitVariablesLowerCaseTableNames}
parentConfigurationId: ${testConfiguration.id}
variables:
autocommit: ${mysqlConfigurationVariablesAutocommit}
bigTables: ${mysqlConfigurationVariablesBigTables}
binlogExpireLogsSeconds: ${mysqlConfigurationVariablesBinlogExpireLogsSeconds}
binlogRowMetadata: ${mysqlConfigurationVariablesBinlogRowMetadata}
binlogRowValueOptions: ${mysqlConfigurationVariablesBinlogRowValueOptions}
binlogTransactionCompression: ${mysqlConfigurationVariablesBinlogTransactionCompression}
completionType: ${mysqlConfigurationVariablesCompletionType}
connectTimeout: ${mysqlConfigurationVariablesConnectTimeout}
connectionMemoryChunkSize: ${mysqlConfigurationVariablesConnectionMemoryChunkSize}
connectionMemoryLimit: ${mysqlConfigurationVariablesConnectionMemoryLimit}
cteMaxRecursionDepth: ${mysqlConfigurationVariablesCteMaxRecursionDepth}
defaultAuthenticationPlugin: ${mysqlConfigurationVariablesDefaultAuthenticationPlugin}
foreignKeyChecks: ${mysqlConfigurationVariablesForeignKeyChecks}
generatedRandomPasswordLength: ${mysqlConfigurationVariablesGeneratedRandomPasswordLength}
globalConnectionMemoryLimit: ${mysqlConfigurationVariablesGlobalConnectionMemoryLimit}
globalConnectionMemoryTracking: ${mysqlConfigurationVariablesGlobalConnectionMemoryTracking}
groupReplicationConsistency: ${mysqlConfigurationVariablesGroupReplicationConsistency}
informationSchemaStatsExpiry: ${mysqlConfigurationVariablesInformationSchemaStatsExpiry}
innodbBufferPoolDumpPct: ${mysqlConfigurationVariablesInnodbBufferPoolDumpPct}
innodbBufferPoolInstances: ${mysqlConfigurationVariablesInnodbBufferPoolInstances}
innodbBufferPoolSize: ${mysqlConfigurationVariablesInnodbBufferPoolSize}
innodbDdlBufferSize: ${mysqlConfigurationVariablesInnodbDdlBufferSize}
innodbDdlThreads: ${mysqlConfigurationVariablesInnodbDdlThreads}
innodbFtEnableStopword: ${mysqlConfigurationVariablesInnodbFtEnableStopword}
innodbFtMaxTokenSize: ${mysqlConfigurationVariablesInnodbFtMaxTokenSize}
innodbFtMinTokenSize: ${mysqlConfigurationVariablesInnodbFtMinTokenSize}
innodbFtNumWordOptimize: ${mysqlConfigurationVariablesInnodbFtNumWordOptimize}
innodbFtResultCacheLimit: ${mysqlConfigurationVariablesInnodbFtResultCacheLimit}
innodbFtServerStopwordTable: ${mysqlConfigurationVariablesInnodbFtServerStopwordTable}
innodbLockWaitTimeout: ${mysqlConfigurationVariablesInnodbLockWaitTimeout}
innodbLogWriterThreads: ${mysqlConfigurationVariablesInnodbLogWriterThreads}
innodbMaxPurgeLag: ${mysqlConfigurationVariablesInnodbMaxPurgeLag}
innodbMaxPurgeLagDelay: ${mysqlConfigurationVariablesInnodbMaxPurgeLagDelay}
innodbStatsPersistentSamplePages: ${mysqlConfigurationVariablesInnodbStatsPersistentSamplePages}
innodbStatsTransientSamplePages: ${mysqlConfigurationVariablesInnodbStatsTransientSamplePages}
interactiveTimeout: ${mysqlConfigurationVariablesInteractiveTimeout}
localInfile: ${mysqlConfigurationVariablesLocalInfile}
mandatoryRoles: ${mysqlConfigurationVariablesMandatoryRoles}
maxAllowedPacket: ${mysqlConfigurationVariablesMaxAllowedPacket}
maxBinlogCacheSize: ${mysqlConfigurationVariablesMaxBinlogCacheSize}
maxConnectErrors: ${mysqlConfigurationVariablesMaxConnectErrors}
maxConnections: ${mysqlConfigurationVariablesMaxConnections}
maxExecutionTime: ${mysqlConfigurationVariablesMaxExecutionTime}
maxHeapTableSize: ${mysqlConfigurationVariablesMaxHeapTableSize}
maxPreparedStmtCount: ${mysqlConfigurationVariablesMaxPreparedStmtCount}
mysqlFirewallMode: ${mysqlConfigurationVariablesMysqlFirewallMode}
mysqlZstdDefaultCompressionLevel: ${mysqlConfigurationVariablesMysqlZstdDefaultCompressionLevel}
mysqlxConnectTimeout: ${mysqlConfigurationVariablesMysqlxConnectTimeout}
mysqlxDeflateDefaultCompressionLevel: ${mysqlConfigurationVariablesMysqlxDeflateDefaultCompressionLevel}
mysqlxDeflateMaxClientCompressionLevel: ${mysqlConfigurationVariablesMysqlxDeflateMaxClientCompressionLevel}
mysqlxDocumentIdUniquePrefix: ${mysqlConfigurationVariablesMysqlxDocumentIdUniquePrefix}
mysqlxEnableHelloNotice: ${mysqlConfigurationVariablesMysqlxEnableHelloNotice}
mysqlxIdleWorkerThreadTimeout: ${mysqlConfigurationVariablesMysqlxIdleWorkerThreadTimeout}
mysqlxInteractiveTimeout: ${mysqlConfigurationVariablesMysqlxInteractiveTimeout}
mysqlxLz4defaultCompressionLevel: ${mysqlConfigurationVariablesMysqlxLz4defaultCompressionLevel}
mysqlxLz4maxClientCompressionLevel: ${mysqlConfigurationVariablesMysqlxLz4maxClientCompressionLevel}
mysqlxMaxAllowedPacket: ${mysqlConfigurationVariablesMysqlxMaxAllowedPacket}
mysqlxMinWorkerThreads: ${mysqlConfigurationVariablesMysqlxMinWorkerThreads}
mysqlxReadTimeout: ${mysqlConfigurationVariablesMysqlxReadTimeout}
mysqlxWaitTimeout: ${mysqlConfigurationVariablesMysqlxWaitTimeout}
mysqlxWriteTimeout: ${mysqlConfigurationVariablesMysqlxWriteTimeout}
mysqlxZstdDefaultCompressionLevel: ${mysqlConfigurationVariablesMysqlxZstdDefaultCompressionLevel}
mysqlxZstdMaxClientCompressionLevel: ${mysqlConfigurationVariablesMysqlxZstdMaxClientCompressionLevel}
netReadTimeout: ${mysqlConfigurationVariablesNetReadTimeout}
netWriteTimeout: ${mysqlConfigurationVariablesNetWriteTimeout}
parserMaxMemSize: ${mysqlConfigurationVariablesParserMaxMemSize}
queryAllocBlockSize: ${mysqlConfigurationVariablesQueryAllocBlockSize}
queryPreallocSize: ${mysqlConfigurationVariablesQueryPreallocSize}
regexpTimeLimit: ${mysqlConfigurationVariablesRegexpTimeLimit}
sortBufferSize: ${mysqlConfigurationVariablesSortBufferSize}
sqlMode: ${mysqlConfigurationVariablesSqlMode}
sqlRequirePrimaryKey: ${mysqlConfigurationVariablesSqlRequirePrimaryKey}
sqlWarnings: ${mysqlConfigurationVariablesSqlWarnings}
threadPoolDedicatedListeners: ${mysqlConfigurationVariablesThreadPoolDedicatedListeners}
threadPoolMaxTransactionsLimit: ${mysqlConfigurationVariablesThreadPoolMaxTransactionsLimit}
timeZone: ${mysqlConfigurationVariablesTimeZone}
tmpTableSize: ${mysqlConfigurationVariablesTmpTableSize}
transactionIsolation: ${mysqlConfigurationVariablesTransactionIsolation}
waitTimeout: ${mysqlConfigurationVariablesWaitTimeout}
Create MysqlConfiguration Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MysqlConfiguration(name: string, args: MysqlConfigurationArgs, opts?: CustomResourceOptions);@overload
def MysqlConfiguration(resource_name: str,
args: MysqlConfigurationArgs,
opts: Optional[ResourceOptions] = None)
@overload
def MysqlConfiguration(resource_name: str,
opts: Optional[ResourceOptions] = None,
compartment_id: Optional[str] = None,
shape_name: Optional[str] = None,
defined_tags: Optional[Mapping[str, str]] = None,
description: Optional[str] = None,
display_name: Optional[str] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
init_variables: Optional[_mysql.MysqlConfigurationInitVariablesArgs] = None,
parent_configuration_id: Optional[str] = None,
variables: Optional[_mysql.MysqlConfigurationVariablesArgs] = None)func NewMysqlConfiguration(ctx *Context, name string, args MysqlConfigurationArgs, opts ...ResourceOption) (*MysqlConfiguration, error)public MysqlConfiguration(string name, MysqlConfigurationArgs args, CustomResourceOptions? opts = null)
public MysqlConfiguration(String name, MysqlConfigurationArgs args)
public MysqlConfiguration(String name, MysqlConfigurationArgs args, CustomResourceOptions options)
type: oci:Mysql:MysqlConfiguration
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 MysqlConfigurationArgs
- 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 MysqlConfigurationArgs
- 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 MysqlConfigurationArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MysqlConfigurationArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MysqlConfigurationArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var mysqlConfigurationResource = new Oci.Mysql.MysqlConfiguration("mysqlConfigurationResource", new()
{
CompartmentId = "string",
ShapeName = "string",
DefinedTags =
{
{ "string", "string" },
},
Description = "string",
DisplayName = "string",
FreeformTags =
{
{ "string", "string" },
},
InitVariables = new Oci.Mysql.Inputs.MysqlConfigurationInitVariablesArgs
{
LowerCaseTableNames = "string",
},
ParentConfigurationId = "string",
Variables = new Oci.Mysql.Inputs.MysqlConfigurationVariablesArgs
{
Autocommit = false,
BigTables = false,
BinlogExpireLogsSeconds = 0,
BinlogRowMetadata = "string",
BinlogRowValueOptions = "string",
BinlogTransactionCompression = false,
CompletionType = "string",
ConnectTimeout = 0,
ConnectionMemoryChunkSize = 0,
ConnectionMemoryLimit = "string",
CteMaxRecursionDepth = "string",
DefaultAuthenticationPlugin = "string",
ForeignKeyChecks = false,
GlobalConnectionMemoryLimit = "string",
GlobalConnectionMemoryTracking = false,
GroupReplicationConsistency = "string",
InformationSchemaStatsExpiry = 0,
InnodbBufferPoolDumpPct = 0,
InnodbBufferPoolInstances = 0,
InnodbBufferPoolSize = "string",
InnodbDdlBufferSize = "string",
InnodbDdlThreads = 0,
InnodbFtEnableStopword = false,
InnodbFtMaxTokenSize = 0,
InnodbFtMinTokenSize = 0,
InnodbFtNumWordOptimize = 0,
InnodbFtResultCacheLimit = "string",
InnodbFtServerStopwordTable = "string",
InnodbLockWaitTimeout = 0,
InnodbLogWriterThreads = false,
InnodbMaxPurgeLag = "string",
InnodbMaxPurgeLagDelay = 0,
InnodbStatsPersistentSamplePages = "string",
InnodbStatsTransientSamplePages = "string",
InteractiveTimeout = 0,
LocalInfile = false,
MandatoryRoles = "string",
MaxAllowedPacket = 0,
MaxBinlogCacheSize = "string",
MaxConnectErrors = "string",
MaxConnections = 0,
MaxExecutionTime = "string",
MaxHeapTableSize = "string",
MaxPreparedStmtCount = 0,
MysqlFirewallMode = false,
MysqlxConnectTimeout = 0,
MysqlxDeflateDefaultCompressionLevel = 0,
MysqlxDeflateMaxClientCompressionLevel = 0,
MysqlxEnableHelloNotice = false,
MysqlxInteractiveTimeout = 0,
MysqlxLz4defaultCompressionLevel = 0,
MysqlxLz4maxClientCompressionLevel = 0,
MysqlxMaxAllowedPacket = 0,
MysqlxReadTimeout = 0,
MysqlxWaitTimeout = 0,
MysqlxWriteTimeout = 0,
MysqlxZstdDefaultCompressionLevel = 0,
MysqlxZstdMaxClientCompressionLevel = 0,
NetReadTimeout = 0,
NetWriteTimeout = 0,
ParserMaxMemSize = "string",
RegexpTimeLimit = 0,
SortBufferSize = "string",
SqlMode = "string",
SqlRequirePrimaryKey = false,
SqlWarnings = false,
ThreadPoolDedicatedListeners = false,
ThreadPoolMaxTransactionsLimit = 0,
TimeZone = "string",
TmpTableSize = "string",
TransactionIsolation = "string",
WaitTimeout = 0,
},
});
example, err := Mysql.NewMysqlConfiguration(ctx, "mysqlConfigurationResource", &Mysql.MysqlConfigurationArgs{
CompartmentId: pulumi.String("string"),
ShapeName: pulumi.String("string"),
DefinedTags: pulumi.StringMap{
"string": pulumi.String("string"),
},
Description: pulumi.String("string"),
DisplayName: pulumi.String("string"),
FreeformTags: pulumi.StringMap{
"string": pulumi.String("string"),
},
InitVariables: &mysql.MysqlConfigurationInitVariablesArgs{
LowerCaseTableNames: pulumi.String("string"),
},
ParentConfigurationId: pulumi.String("string"),
Variables: &mysql.MysqlConfigurationVariablesArgs{
Autocommit: pulumi.Bool(false),
BigTables: pulumi.Bool(false),
BinlogExpireLogsSeconds: pulumi.Int(0),
BinlogRowMetadata: pulumi.String("string"),
BinlogRowValueOptions: pulumi.String("string"),
BinlogTransactionCompression: pulumi.Bool(false),
CompletionType: pulumi.String("string"),
ConnectTimeout: pulumi.Int(0),
ConnectionMemoryChunkSize: pulumi.Int(0),
ConnectionMemoryLimit: pulumi.String("string"),
CteMaxRecursionDepth: pulumi.String("string"),
DefaultAuthenticationPlugin: pulumi.String("string"),
ForeignKeyChecks: pulumi.Bool(false),
GlobalConnectionMemoryLimit: pulumi.String("string"),
GlobalConnectionMemoryTracking: pulumi.Bool(false),
GroupReplicationConsistency: pulumi.String("string"),
InformationSchemaStatsExpiry: pulumi.Int(0),
InnodbBufferPoolDumpPct: pulumi.Int(0),
InnodbBufferPoolInstances: pulumi.Int(0),
InnodbBufferPoolSize: pulumi.String("string"),
InnodbDdlBufferSize: pulumi.String("string"),
InnodbDdlThreads: pulumi.Int(0),
InnodbFtEnableStopword: pulumi.Bool(false),
InnodbFtMaxTokenSize: pulumi.Int(0),
InnodbFtMinTokenSize: pulumi.Int(0),
InnodbFtNumWordOptimize: pulumi.Int(0),
InnodbFtResultCacheLimit: pulumi.String("string"),
InnodbFtServerStopwordTable: pulumi.String("string"),
InnodbLockWaitTimeout: pulumi.Int(0),
InnodbLogWriterThreads: pulumi.Bool(false),
InnodbMaxPurgeLag: pulumi.String("string"),
InnodbMaxPurgeLagDelay: pulumi.Int(0),
InnodbStatsPersistentSamplePages: pulumi.String("string"),
InnodbStatsTransientSamplePages: pulumi.String("string"),
InteractiveTimeout: pulumi.Int(0),
LocalInfile: pulumi.Bool(false),
MandatoryRoles: pulumi.String("string"),
MaxAllowedPacket: pulumi.Int(0),
MaxBinlogCacheSize: pulumi.String("string"),
MaxConnectErrors: pulumi.String("string"),
MaxConnections: pulumi.Int(0),
MaxExecutionTime: pulumi.String("string"),
MaxHeapTableSize: pulumi.String("string"),
MaxPreparedStmtCount: pulumi.Int(0),
MysqlFirewallMode: pulumi.Bool(false),
MysqlxConnectTimeout: pulumi.Int(0),
MysqlxDeflateDefaultCompressionLevel: pulumi.Int(0),
MysqlxDeflateMaxClientCompressionLevel: pulumi.Int(0),
MysqlxEnableHelloNotice: pulumi.Bool(false),
MysqlxInteractiveTimeout: pulumi.Int(0),
MysqlxLz4defaultCompressionLevel: pulumi.Int(0),
MysqlxLz4maxClientCompressionLevel: pulumi.Int(0),
MysqlxMaxAllowedPacket: pulumi.Int(0),
MysqlxReadTimeout: pulumi.Int(0),
MysqlxWaitTimeout: pulumi.Int(0),
MysqlxWriteTimeout: pulumi.Int(0),
MysqlxZstdDefaultCompressionLevel: pulumi.Int(0),
MysqlxZstdMaxClientCompressionLevel: pulumi.Int(0),
NetReadTimeout: pulumi.Int(0),
NetWriteTimeout: pulumi.Int(0),
ParserMaxMemSize: pulumi.String("string"),
RegexpTimeLimit: pulumi.Int(0),
SortBufferSize: pulumi.String("string"),
SqlMode: pulumi.String("string"),
SqlRequirePrimaryKey: pulumi.Bool(false),
SqlWarnings: pulumi.Bool(false),
ThreadPoolDedicatedListeners: pulumi.Bool(false),
ThreadPoolMaxTransactionsLimit: pulumi.Int(0),
TimeZone: pulumi.String("string"),
TmpTableSize: pulumi.String("string"),
TransactionIsolation: pulumi.String("string"),
WaitTimeout: pulumi.Int(0),
},
})
var mysqlConfigurationResource = new MysqlConfiguration("mysqlConfigurationResource", MysqlConfigurationArgs.builder()
.compartmentId("string")
.shapeName("string")
.definedTags(Map.of("string", "string"))
.description("string")
.displayName("string")
.freeformTags(Map.of("string", "string"))
.initVariables(MysqlConfigurationInitVariablesArgs.builder()
.lowerCaseTableNames("string")
.build())
.parentConfigurationId("string")
.variables(MysqlConfigurationVariablesArgs.builder()
.autocommit(false)
.bigTables(false)
.binlogExpireLogsSeconds(0)
.binlogRowMetadata("string")
.binlogRowValueOptions("string")
.binlogTransactionCompression(false)
.completionType("string")
.connectTimeout(0)
.connectionMemoryChunkSize(0)
.connectionMemoryLimit("string")
.cteMaxRecursionDepth("string")
.defaultAuthenticationPlugin("string")
.foreignKeyChecks(false)
.globalConnectionMemoryLimit("string")
.globalConnectionMemoryTracking(false)
.groupReplicationConsistency("string")
.informationSchemaStatsExpiry(0)
.innodbBufferPoolDumpPct(0)
.innodbBufferPoolInstances(0)
.innodbBufferPoolSize("string")
.innodbDdlBufferSize("string")
.innodbDdlThreads(0)
.innodbFtEnableStopword(false)
.innodbFtMaxTokenSize(0)
.innodbFtMinTokenSize(0)
.innodbFtNumWordOptimize(0)
.innodbFtResultCacheLimit("string")
.innodbFtServerStopwordTable("string")
.innodbLockWaitTimeout(0)
.innodbLogWriterThreads(false)
.innodbMaxPurgeLag("string")
.innodbMaxPurgeLagDelay(0)
.innodbStatsPersistentSamplePages("string")
.innodbStatsTransientSamplePages("string")
.interactiveTimeout(0)
.localInfile(false)
.mandatoryRoles("string")
.maxAllowedPacket(0)
.maxBinlogCacheSize("string")
.maxConnectErrors("string")
.maxConnections(0)
.maxExecutionTime("string")
.maxHeapTableSize("string")
.maxPreparedStmtCount(0)
.mysqlFirewallMode(false)
.mysqlxConnectTimeout(0)
.mysqlxDeflateDefaultCompressionLevel(0)
.mysqlxDeflateMaxClientCompressionLevel(0)
.mysqlxEnableHelloNotice(false)
.mysqlxInteractiveTimeout(0)
.mysqlxLz4defaultCompressionLevel(0)
.mysqlxLz4maxClientCompressionLevel(0)
.mysqlxMaxAllowedPacket(0)
.mysqlxReadTimeout(0)
.mysqlxWaitTimeout(0)
.mysqlxWriteTimeout(0)
.mysqlxZstdDefaultCompressionLevel(0)
.mysqlxZstdMaxClientCompressionLevel(0)
.netReadTimeout(0)
.netWriteTimeout(0)
.parserMaxMemSize("string")
.regexpTimeLimit(0)
.sortBufferSize("string")
.sqlMode("string")
.sqlRequirePrimaryKey(false)
.sqlWarnings(false)
.threadPoolDedicatedListeners(false)
.threadPoolMaxTransactionsLimit(0)
.timeZone("string")
.tmpTableSize("string")
.transactionIsolation("string")
.waitTimeout(0)
.build())
.build());
mysql_configuration_resource = oci.mysql.MysqlConfiguration("mysqlConfigurationResource",
compartment_id="string",
shape_name="string",
defined_tags={
"string": "string",
},
description="string",
display_name="string",
freeform_tags={
"string": "string",
},
init_variables={
"lower_case_table_names": "string",
},
parent_configuration_id="string",
variables={
"autocommit": False,
"big_tables": False,
"binlog_expire_logs_seconds": 0,
"binlog_row_metadata": "string",
"binlog_row_value_options": "string",
"binlog_transaction_compression": False,
"completion_type": "string",
"connect_timeout": 0,
"connection_memory_chunk_size": 0,
"connection_memory_limit": "string",
"cte_max_recursion_depth": "string",
"default_authentication_plugin": "string",
"foreign_key_checks": False,
"global_connection_memory_limit": "string",
"global_connection_memory_tracking": False,
"group_replication_consistency": "string",
"information_schema_stats_expiry": 0,
"innodb_buffer_pool_dump_pct": 0,
"innodb_buffer_pool_instances": 0,
"innodb_buffer_pool_size": "string",
"innodb_ddl_buffer_size": "string",
"innodb_ddl_threads": 0,
"innodb_ft_enable_stopword": False,
"innodb_ft_max_token_size": 0,
"innodb_ft_min_token_size": 0,
"innodb_ft_num_word_optimize": 0,
"innodb_ft_result_cache_limit": "string",
"innodb_ft_server_stopword_table": "string",
"innodb_lock_wait_timeout": 0,
"innodb_log_writer_threads": False,
"innodb_max_purge_lag": "string",
"innodb_max_purge_lag_delay": 0,
"innodb_stats_persistent_sample_pages": "string",
"innodb_stats_transient_sample_pages": "string",
"interactive_timeout": 0,
"local_infile": False,
"mandatory_roles": "string",
"max_allowed_packet": 0,
"max_binlog_cache_size": "string",
"max_connect_errors": "string",
"max_connections": 0,
"max_execution_time": "string",
"max_heap_table_size": "string",
"max_prepared_stmt_count": 0,
"mysql_firewall_mode": False,
"mysqlx_connect_timeout": 0,
"mysqlx_deflate_default_compression_level": 0,
"mysqlx_deflate_max_client_compression_level": 0,
"mysqlx_enable_hello_notice": False,
"mysqlx_interactive_timeout": 0,
"mysqlx_lz4default_compression_level": 0,
"mysqlx_lz4max_client_compression_level": 0,
"mysqlx_max_allowed_packet": 0,
"mysqlx_read_timeout": 0,
"mysqlx_wait_timeout": 0,
"mysqlx_write_timeout": 0,
"mysqlx_zstd_default_compression_level": 0,
"mysqlx_zstd_max_client_compression_level": 0,
"net_read_timeout": 0,
"net_write_timeout": 0,
"parser_max_mem_size": "string",
"regexp_time_limit": 0,
"sort_buffer_size": "string",
"sql_mode": "string",
"sql_require_primary_key": False,
"sql_warnings": False,
"thread_pool_dedicated_listeners": False,
"thread_pool_max_transactions_limit": 0,
"time_zone": "string",
"tmp_table_size": "string",
"transaction_isolation": "string",
"wait_timeout": 0,
})
const mysqlConfigurationResource = new oci.mysql.MysqlConfiguration("mysqlConfigurationResource", {
compartmentId: "string",
shapeName: "string",
definedTags: {
string: "string",
},
description: "string",
displayName: "string",
freeformTags: {
string: "string",
},
initVariables: {
lowerCaseTableNames: "string",
},
parentConfigurationId: "string",
variables: {
autocommit: false,
bigTables: false,
binlogExpireLogsSeconds: 0,
binlogRowMetadata: "string",
binlogRowValueOptions: "string",
binlogTransactionCompression: false,
completionType: "string",
connectTimeout: 0,
connectionMemoryChunkSize: 0,
connectionMemoryLimit: "string",
cteMaxRecursionDepth: "string",
defaultAuthenticationPlugin: "string",
foreignKeyChecks: false,
globalConnectionMemoryLimit: "string",
globalConnectionMemoryTracking: false,
groupReplicationConsistency: "string",
informationSchemaStatsExpiry: 0,
innodbBufferPoolDumpPct: 0,
innodbBufferPoolInstances: 0,
innodbBufferPoolSize: "string",
innodbDdlBufferSize: "string",
innodbDdlThreads: 0,
innodbFtEnableStopword: false,
innodbFtMaxTokenSize: 0,
innodbFtMinTokenSize: 0,
innodbFtNumWordOptimize: 0,
innodbFtResultCacheLimit: "string",
innodbFtServerStopwordTable: "string",
innodbLockWaitTimeout: 0,
innodbLogWriterThreads: false,
innodbMaxPurgeLag: "string",
innodbMaxPurgeLagDelay: 0,
innodbStatsPersistentSamplePages: "string",
innodbStatsTransientSamplePages: "string",
interactiveTimeout: 0,
localInfile: false,
mandatoryRoles: "string",
maxAllowedPacket: 0,
maxBinlogCacheSize: "string",
maxConnectErrors: "string",
maxConnections: 0,
maxExecutionTime: "string",
maxHeapTableSize: "string",
maxPreparedStmtCount: 0,
mysqlFirewallMode: false,
mysqlxConnectTimeout: 0,
mysqlxDeflateDefaultCompressionLevel: 0,
mysqlxDeflateMaxClientCompressionLevel: 0,
mysqlxEnableHelloNotice: false,
mysqlxInteractiveTimeout: 0,
mysqlxLz4defaultCompressionLevel: 0,
mysqlxLz4maxClientCompressionLevel: 0,
mysqlxMaxAllowedPacket: 0,
mysqlxReadTimeout: 0,
mysqlxWaitTimeout: 0,
mysqlxWriteTimeout: 0,
mysqlxZstdDefaultCompressionLevel: 0,
mysqlxZstdMaxClientCompressionLevel: 0,
netReadTimeout: 0,
netWriteTimeout: 0,
parserMaxMemSize: "string",
regexpTimeLimit: 0,
sortBufferSize: "string",
sqlMode: "string",
sqlRequirePrimaryKey: false,
sqlWarnings: false,
threadPoolDedicatedListeners: false,
threadPoolMaxTransactionsLimit: 0,
timeZone: "string",
tmpTableSize: "string",
transactionIsolation: "string",
waitTimeout: 0,
},
});
type: oci:Mysql:MysqlConfiguration
properties:
compartmentId: string
definedTags:
string: string
description: string
displayName: string
freeformTags:
string: string
initVariables:
lowerCaseTableNames: string
parentConfigurationId: string
shapeName: string
variables:
autocommit: false
bigTables: false
binlogExpireLogsSeconds: 0
binlogRowMetadata: string
binlogRowValueOptions: string
binlogTransactionCompression: false
completionType: string
connectTimeout: 0
connectionMemoryChunkSize: 0
connectionMemoryLimit: string
cteMaxRecursionDepth: string
defaultAuthenticationPlugin: string
foreignKeyChecks: false
globalConnectionMemoryLimit: string
globalConnectionMemoryTracking: false
groupReplicationConsistency: string
informationSchemaStatsExpiry: 0
innodbBufferPoolDumpPct: 0
innodbBufferPoolInstances: 0
innodbBufferPoolSize: string
innodbDdlBufferSize: string
innodbDdlThreads: 0
innodbFtEnableStopword: false
innodbFtMaxTokenSize: 0
innodbFtMinTokenSize: 0
innodbFtNumWordOptimize: 0
innodbFtResultCacheLimit: string
innodbFtServerStopwordTable: string
innodbLockWaitTimeout: 0
innodbLogWriterThreads: false
innodbMaxPurgeLag: string
innodbMaxPurgeLagDelay: 0
innodbStatsPersistentSamplePages: string
innodbStatsTransientSamplePages: string
interactiveTimeout: 0
localInfile: false
mandatoryRoles: string
maxAllowedPacket: 0
maxBinlogCacheSize: string
maxConnectErrors: string
maxConnections: 0
maxExecutionTime: string
maxHeapTableSize: string
maxPreparedStmtCount: 0
mysqlFirewallMode: false
mysqlxConnectTimeout: 0
mysqlxDeflateDefaultCompressionLevel: 0
mysqlxDeflateMaxClientCompressionLevel: 0
mysqlxEnableHelloNotice: false
mysqlxInteractiveTimeout: 0
mysqlxLz4defaultCompressionLevel: 0
mysqlxLz4maxClientCompressionLevel: 0
mysqlxMaxAllowedPacket: 0
mysqlxReadTimeout: 0
mysqlxWaitTimeout: 0
mysqlxWriteTimeout: 0
mysqlxZstdDefaultCompressionLevel: 0
mysqlxZstdMaxClientCompressionLevel: 0
netReadTimeout: 0
netWriteTimeout: 0
parserMaxMemSize: string
regexpTimeLimit: 0
sortBufferSize: string
sqlMode: string
sqlRequirePrimaryKey: false
sqlWarnings: false
threadPoolDedicatedListeners: false
threadPoolMaxTransactionsLimit: 0
timeZone: string
tmpTableSize: string
transactionIsolation: string
waitTimeout: 0
MysqlConfiguration 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 MysqlConfiguration resource accepts the following input properties:
- Compartment
Id string - The OCID of the compartment.
- Shape
Name string - The name of the associated Shape.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) User-provided data about the Configuration.
- Display
Name string - (Updatable) The display name of the Configuration.
- Dictionary<string, string>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - Init
Variables MysqlConfiguration Init Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- Variables
Mysql
Configuration Variables - User-defined service variables.
- Compartment
Id string - The OCID of the compartment.
- Shape
Name string - The name of the associated Shape.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) User-provided data about the Configuration.
- Display
Name string - (Updatable) The display name of the Configuration.
- map[string]string
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - Init
Variables MysqlConfiguration Init Variables Args - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- Variables
Mysql
Configuration Variables Args - User-defined service variables.
- compartment
Id String - The OCID of the compartment.
- shape
Name String - The name of the associated Shape.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) User-provided data about the Configuration.
- display
Name String - (Updatable) The display name of the Configuration.
- Map<String,String>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables ConfigurationInit Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- variables
Configuration
Variables - User-defined service variables.
- compartment
Id string - The OCID of the compartment.
- shape
Name string - The name of the associated Shape.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description string
- (Updatable) User-provided data about the Configuration.
- display
Name string - (Updatable) The display name of the Configuration.
- {[key: string]: string}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables MysqlConfiguration Init Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- variables
Mysql
Configuration Variables - User-defined service variables.
- compartment_
id str - The OCID of the compartment.
- shape_
name str - The name of the associated Shape.
- Mapping[str, str]
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description str
- (Updatable) User-provided data about the Configuration.
- display_
name str - (Updatable) The display name of the Configuration.
- Mapping[str, str]
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init_
variables mysql.Mysql Configuration Init Variables Args - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent_
configuration_ strid - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- variables
mysql.
Mysql Configuration Variables Args - User-defined service variables.
- compartment
Id String - The OCID of the compartment.
- shape
Name String - The name of the associated Shape.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) User-provided data about the Configuration.
- display
Name String - (Updatable) The display name of the Configuration.
- Map<String>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables Property Map - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- variables Property Map
- User-defined service variables.
Outputs
All input properties are implicitly available as output properties. Additionally, the MysqlConfiguration resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- State string
- The current state of the Configuration.
- Time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
- The Configuration type, DEFAULT or CUSTOM.
- Id string
- The provider-assigned unique ID for this managed resource.
- State string
- The current state of the Configuration.
- Time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
- The Configuration type, DEFAULT or CUSTOM.
- id String
- The provider-assigned unique ID for this managed resource.
- state String
- The current state of the Configuration.
- time
Created String - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated String - The date and time the Configuration was last updated, as described by RFC 3339.
- type String
- The Configuration type, DEFAULT or CUSTOM.
- id string
- The provider-assigned unique ID for this managed resource.
- state string
- The current state of the Configuration.
- time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- type string
- The Configuration type, DEFAULT or CUSTOM.
- id str
- The provider-assigned unique ID for this managed resource.
- state str
- The current state of the Configuration.
- time_
created str - The date and time the Configuration was created, as described by RFC 3339.
- time_
updated str - The date and time the Configuration was last updated, as described by RFC 3339.
- type str
- The Configuration type, DEFAULT or CUSTOM.
- id String
- The provider-assigned unique ID for this managed resource.
- state String
- The current state of the Configuration.
- time
Created String - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated String - The date and time the Configuration was last updated, as described by RFC 3339.
- type String
- The Configuration type, DEFAULT or CUSTOM.
Look up Existing MysqlConfiguration Resource
Get an existing MysqlConfiguration 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?: MysqlConfigurationState, opts?: CustomResourceOptions): MysqlConfiguration@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
compartment_id: Optional[str] = None,
defined_tags: Optional[Mapping[str, str]] = None,
description: Optional[str] = None,
display_name: Optional[str] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
init_variables: Optional[_mysql.MysqlConfigurationInitVariablesArgs] = None,
parent_configuration_id: Optional[str] = None,
shape_name: Optional[str] = None,
state: Optional[str] = None,
time_created: Optional[str] = None,
time_updated: Optional[str] = None,
type: Optional[str] = None,
variables: Optional[_mysql.MysqlConfigurationVariablesArgs] = None) -> MysqlConfigurationfunc GetMysqlConfiguration(ctx *Context, name string, id IDInput, state *MysqlConfigurationState, opts ...ResourceOption) (*MysqlConfiguration, error)public static MysqlConfiguration Get(string name, Input<string> id, MysqlConfigurationState? state, CustomResourceOptions? opts = null)public static MysqlConfiguration get(String name, Output<String> id, MysqlConfigurationState state, CustomResourceOptions options)Resource lookup is not supported in YAML- 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.
- Compartment
Id string - The OCID of the compartment.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) User-provided data about the Configuration.
- Display
Name string - (Updatable) The display name of the Configuration.
- Dictionary<string, string>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - Init
Variables MysqlConfiguration Init Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- Shape
Name string - The name of the associated Shape.
- State string
- The current state of the Configuration.
- Time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
- The Configuration type, DEFAULT or CUSTOM.
- Variables
Mysql
Configuration Variables - User-defined service variables.
- Compartment
Id string - The OCID of the compartment.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) User-provided data about the Configuration.
- Display
Name string - (Updatable) The display name of the Configuration.
- map[string]string
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - Init
Variables MysqlConfiguration Init Variables Args - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- Parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- Shape
Name string - The name of the associated Shape.
- State string
- The current state of the Configuration.
- Time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- Time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- Type string
- The Configuration type, DEFAULT or CUSTOM.
- Variables
Mysql
Configuration Variables Args - User-defined service variables.
- compartment
Id String - The OCID of the compartment.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) User-provided data about the Configuration.
- display
Name String - (Updatable) The display name of the Configuration.
- Map<String,String>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables ConfigurationInit Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- shape
Name String - The name of the associated Shape.
- state String
- The current state of the Configuration.
- time
Created String - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated String - The date and time the Configuration was last updated, as described by RFC 3339.
- type String
- The Configuration type, DEFAULT or CUSTOM.
- variables
Configuration
Variables - User-defined service variables.
- compartment
Id string - The OCID of the compartment.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description string
- (Updatable) User-provided data about the Configuration.
- display
Name string - (Updatable) The display name of the Configuration.
- {[key: string]: string}
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables MysqlConfiguration Init Variables - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration stringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- shape
Name string - The name of the associated Shape.
- state string
- The current state of the Configuration.
- time
Created string - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated string - The date and time the Configuration was last updated, as described by RFC 3339.
- type string
- The Configuration type, DEFAULT or CUSTOM.
- variables
Mysql
Configuration Variables - User-defined service variables.
- compartment_
id str - The OCID of the compartment.
- Mapping[str, str]
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description str
- (Updatable) User-provided data about the Configuration.
- display_
name str - (Updatable) The display name of the Configuration.
- Mapping[str, str]
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init_
variables mysql.Mysql Configuration Init Variables Args - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent_
configuration_ strid - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- shape_
name str - The name of the associated Shape.
- state str
- The current state of the Configuration.
- time_
created str - The date and time the Configuration was created, as described by RFC 3339.
- time_
updated str - The date and time the Configuration was last updated, as described by RFC 3339.
- type str
- The Configuration type, DEFAULT or CUSTOM.
- variables
mysql.
Mysql Configuration Variables Args - User-defined service variables.
- compartment
Id String - The OCID of the compartment.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) User-provided data about the Configuration.
- display
Name String - (Updatable) The display name of the Configuration.
- Map<String>
- (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example:
{"bar-key": "value"} - init
Variables Property Map - User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
- parent
Configuration StringId - The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
- shape
Name String - The name of the associated Shape.
- state String
- The current state of the Configuration.
- time
Created String - The date and time the Configuration was created, as described by RFC 3339.
- time
Updated String - The date and time the Configuration was last updated, as described by RFC 3339.
- type String
- The Configuration type, DEFAULT or CUSTOM.
- variables Property Map
- User-defined service variables.
Supporting Types
MysqlConfigurationInitVariables, MysqlConfigurationInitVariablesArgs
- Lower
Case stringTable Names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
- Lower
Case stringTable Names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
- lower
Case StringTable Names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
- lower
Case stringTable Names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
- lower_
case_ strtable_ names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
- lower
Case StringTable Names Represents the MySQL server system variable lower_case_table_names (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names).
lowerCaseTableNames controls case-sensitivity of tables and schema names and how they are stored in the DB System.
Valid values are:
- CASE_SENSITIVE - (default) Table and schema name comparisons are case-sensitive and stored as specified. (lower_case_table_names=0)
- CASE_INSENSITIVE_LOWERCASE - Table and schema name comparisons are not case-sensitive and stored in lowercase. (lower_case_table_names=1)
MysqlConfigurationVariables, MysqlConfigurationVariablesArgs
- Autocommit bool
- ("autocommit")
- Big
Tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- Binlog
Expire intLogs Seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- Binlog
Row stringValue Options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- Binlog
Transaction boolCompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- Completion
Type string - ("completion_type")
- Connect
Timeout int The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- Connection
Memory intChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- Connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- Cte
Max stringRecursion Depth - ("cte_max_recursion_depth")
- Default
Authentication stringPlugin - ("default_authentication_plugin")
- Foreign
Key boolChecks - ("foreign_key_checks")
- Generated
Random intPassword Length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- Global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- Global
Connection boolMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- Group
Replication stringConsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- Information
Schema intStats Expiry - ("information_schema_stats_expiry")
- Innodb
Buffer intPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- Innodb
Buffer intPool Instances - ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- Innodb
Ddl stringBuffer Size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- Innodb
Ddl intThreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- Innodb
Ft boolEnable Stopword - ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size - ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size - ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize - ("innodb_ft_num_word_optimize")
- Innodb
Ft stringResult Cache Limit - ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table - ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout - ("innodb_lock_wait_timeout")
- Innodb
Log boolWriter Threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- Innodb
Max stringPurge Lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- Innodb
Max intPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- Innodb
Stats stringPersistent Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- Innodb
Stats stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- Interactive
Timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- Local
Infile bool - ("local_infile")
- Mandatory
Roles string - ("mandatory_roles")
- Max
Allowed intPacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- Max
Binlog stringCache Size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- Max
Connect stringErrors - ("max_connect_errors")
- Max
Connections int - ("max_connections")
- Max
Execution stringTime - ("max_execution_time")
- Max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- Max
Prepared intStmt Count - ("max_prepared_stmt_count")
- Mysql
Firewall boolMode - ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- Mysqlx
Connect intTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- Mysqlx
Deflate intDefault Compression Level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Enable boolHello Notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Interactive intTimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- Mysqlx
Lz4default intCompression Level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- Mysqlx
Min intWorker Threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Read intTimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- Mysqlx
Wait intTimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- Mysqlx
Write intTimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- Mysqlx
Zstd intDefault Compression Level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Net
Read intTimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- Net
Write intTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- Parser
Max stringMem Size - ("parser_max_mem_size")
- Query
Alloc stringBlock Size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- Query
Prealloc stringSize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- Regexp
Time intLimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- Sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- Sql
Mode string - ("sql_mode")
- Sql
Require boolPrimary Key - ("sql_require_primary_key")
- Sql
Warnings bool - ("sql_warnings")
- Thread
Pool boolDedicated Listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- Thread
Pool intMax Transactions Limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- Time
Zone string Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- Tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- Transaction
Isolation string - ("transaction_isolation")
- Wait
Timeout int The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- Autocommit bool
- ("autocommit")
- Big
Tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- Binlog
Expire intLogs Seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- Binlog
Row stringMetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- Binlog
Row stringValue Options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- Binlog
Transaction boolCompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- Completion
Type string - ("completion_type")
- Connect
Timeout int The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- Connection
Memory intChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- Connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- Cte
Max stringRecursion Depth - ("cte_max_recursion_depth")
- Default
Authentication stringPlugin - ("default_authentication_plugin")
- Foreign
Key boolChecks - ("foreign_key_checks")
- Generated
Random intPassword Length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- Global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- Global
Connection boolMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- Group
Replication stringConsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- Information
Schema intStats Expiry - ("information_schema_stats_expiry")
- Innodb
Buffer intPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- Innodb
Buffer intPool Instances - ("innodb_buffer_pool_instances")
- Innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- Innodb
Ddl stringBuffer Size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- Innodb
Ddl intThreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- Innodb
Ft boolEnable Stopword - ("innodb_ft_enable_stopword")
- Innodb
Ft intMax Token Size - ("innodb_ft_max_token_size")
- Innodb
Ft intMin Token Size - ("innodb_ft_min_token_size")
- Innodb
Ft intNum Word Optimize - ("innodb_ft_num_word_optimize")
- Innodb
Ft stringResult Cache Limit - ("innodb_ft_result_cache_limit")
- Innodb
Ft stringServer Stopword Table - ("innodb_ft_server_stopword_table")
- Innodb
Lock intWait Timeout - ("innodb_lock_wait_timeout")
- Innodb
Log boolWriter Threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- Innodb
Max stringPurge Lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- Innodb
Max intPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- Innodb
Stats stringPersistent Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- Innodb
Stats stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- Interactive
Timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- Local
Infile bool - ("local_infile")
- Mandatory
Roles string - ("mandatory_roles")
- Max
Allowed intPacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- Max
Binlog stringCache Size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- Max
Connect stringErrors - ("max_connect_errors")
- Max
Connections int - ("max_connections")
- Max
Execution stringTime - ("max_execution_time")
- Max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- Max
Prepared intStmt Count - ("max_prepared_stmt_count")
- Mysql
Firewall boolMode - ("mysql_firewall_mode")
- Mysql
Zstd intDefault Compression Level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- Mysqlx
Connect intTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- Mysqlx
Deflate intDefault Compression Level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- Mysqlx
Deflate intMax Client Compression Level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- Mysqlx
Document intId Unique Prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Enable boolHello Notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Idle intWorker Thread Timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Interactive intTimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- Mysqlx
Lz4default intCompression Level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- Mysqlx
Lz4max intClient Compression Level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- Mysqlx
Max intAllowed Packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- Mysqlx
Min intWorker Threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- Mysqlx
Read intTimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- Mysqlx
Wait intTimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- Mysqlx
Write intTimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- Mysqlx
Zstd intDefault Compression Level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- Mysqlx
Zstd intMax Client Compression Level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- Net
Read intTimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- Net
Write intTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- Parser
Max stringMem Size - ("parser_max_mem_size")
- Query
Alloc stringBlock Size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- Query
Prealloc stringSize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- Regexp
Time intLimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- Sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- Sql
Mode string - ("sql_mode")
- Sql
Require boolPrimary Key - ("sql_require_primary_key")
- Sql
Warnings bool - ("sql_warnings")
- Thread
Pool boolDedicated Listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- Thread
Pool intMax Transactions Limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- Time
Zone string Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- Tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- Transaction
Isolation string - ("transaction_isolation")
- Wait
Timeout int The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- autocommit Boolean
- ("autocommit")
- big
Tables Boolean If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- binlog
Expire IntegerLogs Seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- binlog
Row StringValue Options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- binlog
Transaction BooleanCompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- completion
Type String - ("completion_type")
- connect
Timeout Integer The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- connection
Memory IntegerChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- connection
Memory StringLimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- cte
Max StringRecursion Depth - ("cte_max_recursion_depth")
- default
Authentication StringPlugin - ("default_authentication_plugin")
- foreign
Key BooleanChecks - ("foreign_key_checks")
- generated
Random IntegerPassword Length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- global
Connection StringMemory Limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- global
Connection BooleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- group
Replication StringConsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- information
Schema IntegerStats Expiry - ("information_schema_stats_expiry")
- innodb
Buffer IntegerPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- innodb
Buffer IntegerPool Instances - ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- innodb
Ddl StringBuffer Size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- innodb
Ddl IntegerThreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- innodb
Ft BooleanEnable Stopword - ("innodb_ft_enable_stopword")
- innodb
Ft IntegerMax Token Size - ("innodb_ft_max_token_size")
- innodb
Ft IntegerMin Token Size - ("innodb_ft_min_token_size")
- innodb
Ft IntegerNum Word Optimize - ("innodb_ft_num_word_optimize")
- innodb
Ft StringResult Cache Limit - ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table - ("innodb_ft_server_stopword_table")
- innodb
Lock IntegerWait Timeout - ("innodb_lock_wait_timeout")
- innodb
Log BooleanWriter Threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- innodb
Max StringPurge Lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- innodb
Max IntegerPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- innodb
Stats StringPersistent Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- innodb
Stats StringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- interactive
Timeout Integer The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- local
Infile Boolean - ("local_infile")
- mandatory
Roles String - ("mandatory_roles")
- max
Allowed IntegerPacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- max
Binlog StringCache Size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- max
Connect StringErrors - ("max_connect_errors")
- max
Connections Integer - ("max_connections")
- max
Execution StringTime - ("max_execution_time")
- max
Heap StringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- max
Prepared IntegerStmt Count - ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode - ("mysql_firewall_mode")
- mysql
Zstd IntegerDefault Compression Level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect IntegerTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- mysqlx
Deflate IntegerDefault Compression Level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate IntegerMax Client Compression Level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document IntegerId Unique Prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable BooleanHello Notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle IntegerWorker Thread Timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive IntegerTimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- mysqlx
Lz4default IntegerCompression Level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max IntegerClient Compression Level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max IntegerAllowed Packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- mysqlx
Min IntegerWorker Threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read IntegerTimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- mysqlx
Wait IntegerTimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- mysqlx
Write IntegerTimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- mysqlx
Zstd IntegerDefault Compression Level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd IntegerMax Client Compression Level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read IntegerTimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- net
Write IntegerTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- parser
Max StringMem Size - ("parser_max_mem_size")
- query
Alloc StringBlock Size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc StringSize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- regexp
Time IntegerLimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- sort
Buffer StringSize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- sql
Mode String - ("sql_mode")
- sql
Require BooleanPrimary Key - ("sql_require_primary_key")
- sql
Warnings Boolean - ("sql_warnings")
- thread
Pool BooleanDedicated Listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- thread
Pool IntegerMax Transactions Limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- time
Zone String Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- tmp
Table StringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- transaction
Isolation String - ("transaction_isolation")
- wait
Timeout Integer The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- autocommit boolean
- ("autocommit")
- big
Tables boolean If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- binlog
Expire numberLogs Seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row stringMetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- binlog
Row stringValue Options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- binlog
Transaction booleanCompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- completion
Type string - ("completion_type")
- connect
Timeout number The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- connection
Memory numberChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- connection
Memory stringLimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- cte
Max stringRecursion Depth - ("cte_max_recursion_depth")
- default
Authentication stringPlugin - ("default_authentication_plugin")
- foreign
Key booleanChecks - ("foreign_key_checks")
- generated
Random numberPassword Length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- global
Connection stringMemory Limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- global
Connection booleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- group
Replication stringConsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- information
Schema numberStats Expiry - ("information_schema_stats_expiry")
- innodb
Buffer numberPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- innodb
Buffer numberPool Instances - ("innodb_buffer_pool_instances")
- innodb
Buffer stringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- innodb
Ddl stringBuffer Size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- innodb
Ddl numberThreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- innodb
Ft booleanEnable Stopword - ("innodb_ft_enable_stopword")
- innodb
Ft numberMax Token Size - ("innodb_ft_max_token_size")
- innodb
Ft numberMin Token Size - ("innodb_ft_min_token_size")
- innodb
Ft numberNum Word Optimize - ("innodb_ft_num_word_optimize")
- innodb
Ft stringResult Cache Limit - ("innodb_ft_result_cache_limit")
- innodb
Ft stringServer Stopword Table - ("innodb_ft_server_stopword_table")
- innodb
Lock numberWait Timeout - ("innodb_lock_wait_timeout")
- innodb
Log booleanWriter Threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- innodb
Max stringPurge Lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- innodb
Max numberPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- innodb
Stats stringPersistent Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- innodb
Stats stringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- interactive
Timeout number The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- local
Infile boolean - ("local_infile")
- mandatory
Roles string - ("mandatory_roles")
- max
Allowed numberPacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- max
Binlog stringCache Size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- max
Connect stringErrors - ("max_connect_errors")
- max
Connections number - ("max_connections")
- max
Execution stringTime - ("max_execution_time")
- max
Heap stringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- max
Prepared numberStmt Count - ("max_prepared_stmt_count")
- mysql
Firewall booleanMode - ("mysql_firewall_mode")
- mysql
Zstd numberDefault Compression Level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect numberTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- mysqlx
Deflate numberDefault Compression Level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate numberMax Client Compression Level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document numberId Unique Prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable booleanHello Notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle numberWorker Thread Timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive numberTimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- mysqlx
Lz4default numberCompression Level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max numberClient Compression Level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max numberAllowed Packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- mysqlx
Min numberWorker Threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read numberTimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- mysqlx
Wait numberTimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- mysqlx
Write numberTimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- mysqlx
Zstd numberDefault Compression Level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd numberMax Client Compression Level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read numberTimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- net
Write numberTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- parser
Max stringMem Size - ("parser_max_mem_size")
- query
Alloc stringBlock Size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc stringSize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- regexp
Time numberLimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- sort
Buffer stringSize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- sql
Mode string - ("sql_mode")
- sql
Require booleanPrimary Key - ("sql_require_primary_key")
- sql
Warnings boolean - ("sql_warnings")
- thread
Pool booleanDedicated Listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- thread
Pool numberMax Transactions Limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- time
Zone string Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- tmp
Table stringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- transaction
Isolation string - ("transaction_isolation")
- wait
Timeout number The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- autocommit bool
- ("autocommit")
- big_
tables bool If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- binlog_
expire_ intlogs_ seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog_
row_ strmetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- binlog_
row_ strvalue_ options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- binlog_
transaction_ boolcompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- completion_
type str - ("completion_type")
- connect_
timeout int The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- connection_
memory_ intchunk_ size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- connection_
memory_ strlimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- cte_
max_ strrecursion_ depth - ("cte_max_recursion_depth")
- default_
authentication_ strplugin - ("default_authentication_plugin")
- foreign_
key_ boolchecks - ("foreign_key_checks")
- generated_
random_ intpassword_ length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- global_
connection_ strmemory_ limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- global_
connection_ boolmemory_ tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- group_
replication_ strconsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- information_
schema_ intstats_ expiry - ("information_schema_stats_expiry")
- innodb_
buffer_ intpool_ dump_ pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- innodb_
buffer_ intpool_ instances - ("innodb_buffer_pool_instances")
- innodb_
buffer_ strpool_ size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- innodb_
ddl_ strbuffer_ size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- innodb_
ddl_ intthreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- innodb_
ft_ boolenable_ stopword - ("innodb_ft_enable_stopword")
- innodb_
ft_ intmax_ token_ size - ("innodb_ft_max_token_size")
- innodb_
ft_ intmin_ token_ size - ("innodb_ft_min_token_size")
- innodb_
ft_ intnum_ word_ optimize - ("innodb_ft_num_word_optimize")
- innodb_
ft_ strresult_ cache_ limit - ("innodb_ft_result_cache_limit")
- innodb_
ft_ strserver_ stopword_ table - ("innodb_ft_server_stopword_table")
- innodb_
lock_ intwait_ timeout - ("innodb_lock_wait_timeout")
- innodb_
log_ boolwriter_ threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- innodb_
max_ strpurge_ lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- innodb_
max_ intpurge_ lag_ delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- innodb_
stats_ strpersistent_ sample_ pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- innodb_
stats_ strtransient_ sample_ pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- interactive_
timeout int The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- local_
infile bool - ("local_infile")
- mandatory_
roles str - ("mandatory_roles")
- max_
allowed_ intpacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- max_
binlog_ strcache_ size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- max_
connect_ strerrors - ("max_connect_errors")
- max_
connections int - ("max_connections")
- max_
execution_ strtime - ("max_execution_time")
- max_
heap_ strtable_ size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- max_
prepared_ intstmt_ count - ("max_prepared_stmt_count")
- mysql_
firewall_ boolmode - ("mysql_firewall_mode")
- mysql_
zstd_ intdefault_ compression_ level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx_
connect_ inttimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- mysqlx_
deflate_ intdefault_ compression_ level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx_
deflate_ intmax_ client_ compression_ level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx_
document_ intid_ unique_ prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
enable_ boolhello_ notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
idle_ intworker_ thread_ timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
interactive_ inttimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- mysqlx_
lz4default_ intcompression_ level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx_
lz4max_ intclient_ compression_ level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx_
max_ intallowed_ packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- mysqlx_
min_ intworker_ threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx_
read_ inttimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- mysqlx_
wait_ inttimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- mysqlx_
write_ inttimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- mysqlx_
zstd_ intdefault_ compression_ level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx_
zstd_ intmax_ client_ compression_ level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net_
read_ inttimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- net_
write_ inttimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- parser_
max_ strmem_ size - ("parser_max_mem_size")
- query_
alloc_ strblock_ size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query_
prealloc_ strsize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- regexp_
time_ intlimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- sort_
buffer_ strsize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- sql_
mode str - ("sql_mode")
- sql_
require_ boolprimary_ key - ("sql_require_primary_key")
- sql_
warnings bool - ("sql_warnings")
- thread_
pool_ booldedicated_ listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- thread_
pool_ intmax_ transactions_ limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- time_
zone str Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- tmp_
table_ strsize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- transaction_
isolation str - ("transaction_isolation")
- wait_
timeout int The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
- autocommit Boolean
- ("autocommit")
- big
Tables Boolean If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable big_tables.
- binlog
Expire NumberLogs Seconds - Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
- binlog
Row StringMetadata - Configures the amount of table metadata added to the binary log when using row-based logging. binlogRowMetadata corresponds to the MySQL binary logging system variable binlog_row_metadata.
- binlog
Row StringValue Options - When set to PARTIAL_JSON, this enables use of a space-efficient binary log format for updates that modify only a small portion of a JSON document. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
- binlog
Transaction BooleanCompression - Enables compression for transactions that are written to binary log files on this server. binlogTransactionCompression corresponds to the MySQL binary logging system variable binlog_transaction_compression.
- completion
Type String - ("completion_type")
- connect
Timeout Number The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
connectTimeout corresponds to the MySQL system variable connect_timeout
Increasing the connect_timeout value might help if clients frequently encounter errors of the form "Lost connection to MySQL server at 'XXX', system error: errno".
- connection
Memory NumberChunk Size Set the chunking size for updates to the global memory usage counter Global_connection_memory.
connectionMemoryChunkSize corresponds to the MySQL system variable connection_memory_chunk_size.
- connection
Memory StringLimit Set the maximum amount of memory that can be used by a single user connection.
connectionMemoryLimit corresponds to the MySQL system variable connection_memory_limit.
- cte
Max StringRecursion Depth - ("cte_max_recursion_depth")
- default
Authentication StringPlugin - ("default_authentication_plugin")
- foreign
Key BooleanChecks - ("foreign_key_checks")
- generated
Random NumberPassword Length - ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored
- global
Connection StringMemory Limit Set the total amount of memory that can be used by all user connections.
globalConnectionMemoryLimit corresponds to the MySQL system variable global_connection_memory_limit.
- global
Connection BooleanMemory Tracking Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.
- group
Replication StringConsistency - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts.
- BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog.
- BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
- information
Schema NumberStats Expiry - ("information_schema_stats_expiry")
- innodb
Buffer NumberPool Dump Pct Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
innodbBufferPoolDumpPct corresponds to the MySQL InnoDB system variable innodb_buffer_pool_dump_pct.
The range is 1 to 100. The default value is 25.
For example, if there are 4 buffer pools with 100 pages each, and innodb_buffer_pool_dump_pct is set to 25, the 25 most recently used pages from each buffer pool are dumped.
- innodb
Buffer NumberPool Instances - ("innodb_buffer_pool_instances")
- innodb
Buffer StringPool Size The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
innodbBufferPoolSize corresponds to the MySQL server system variable innodb_buffer_pool_size.
The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.
- innodb
Ddl StringBuffer Size - innodbDdlBufferSize corresponds to the MySQL system variable [innodb_ddl_buffer_size] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_buffer_size)
- innodb
Ddl NumberThreads - innodbDdlThreads corresponds to the MySQL system variable [innodb_ddl_threads] (https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads)
- innodb
Ft BooleanEnable Stopword - ("innodb_ft_enable_stopword")
- innodb
Ft NumberMax Token Size - ("innodb_ft_max_token_size")
- innodb
Ft NumberMin Token Size - ("innodb_ft_min_token_size")
- innodb
Ft NumberNum Word Optimize - ("innodb_ft_num_word_optimize")
- innodb
Ft StringResult Cache Limit - ("innodb_ft_result_cache_limit")
- innodb
Ft StringServer Stopword Table - ("innodb_ft_server_stopword_table")
- innodb
Lock NumberWait Timeout - ("innodb_lock_wait_timeout")
- innodb
Log BooleanWriter Threads Enables dedicated log writer threads for writing redo log records from the log buffer to the system buffers and flushing the system buffers to the redo log files.
This is the MySQL variable "innodb_log_writer_threads". For more information, please see the MySQL documentation
- innodb
Max StringPurge Lag The desired maximum purge lag in terms of transactions.
InnoDB maintains a list of transactions that have index records delete-marked by UPDATE or DELETE operations. The length of the list is the purge lag.
If this value is exceeded, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge to catch up.
The default value is 0, which means there is no maximum purge lag and no delay.
innodbMaxPurgeLag corresponds to the MySQL server system variable innodb_max_purge_lag.
- innodb
Max NumberPurge Lag Delay The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
The specified innodb_max_purge_lag_delay value is an upper limit on the delay period.
innodbMaxPurgeLagDelay corresponds to the MySQL server system variable innodb_max_purge_lag_delay.
- innodb
Stats StringPersistent Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsPersistentSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_persistent_sample_pages
innodb_stats_persistent_sample_pages only applies when innodb_stats_persistent is enabled for a table; when innodb_stats_persistent is disabled, innodb_stats_transient_sample_pages applies instead.
- innodb
Stats StringTransient Sample Pages The number of index pages to sample when estimating cardinality and other statistics for an indexed column, such as those calculated by ANALYZE TABLE.
innodbStatsTransientSamplePages corresponds to the MySQL InnoDB system variable innodb_stats_transient_sample_pages
innodb_stats_transient_sample_pages only applies when innodb_stats_persistent is disabled for a table; when innodb_stats_persistent is enabled, innodb_stats_persistent_sample_pages applies instead.
innodb_stats_persistent is ON by default and cannot be changed. It is possible to override it using the STATS_PERSISTENT clause of the CREATE TABLE and ALTER TABLE statements.
- interactive
Timeout Number The number of seconds the server waits for activity on an interactive connection before closing it.
interactiveTimeout corresponds to the MySQL system variable. interactive_timeout
- local
Infile Boolean - ("local_infile")
- mandatory
Roles String - ("mandatory_roles")
- max
Allowed NumberPacket The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
- max
Binlog StringCache Size Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.
- max
Connect StringErrors - ("max_connect_errors")
- max
Connections Number - ("max_connections")
- max
Execution StringTime - ("max_execution_time")
- max
Heap StringTable Size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
maxHeapTableSize corresponds to the MySQL system variable max_heap_table_size
- max
Prepared NumberStmt Count - ("max_prepared_stmt_count")
- mysql
Firewall BooleanMode - ("mysql_firewall_mode")
- mysql
Zstd NumberDefault Compression Level - DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.
- mysqlx
Connect NumberTimeout The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
mysqlxConnectTimeout corresponds to the MySQL X Plugin system variable mysqlx_connect_timeout
- mysqlx
Deflate NumberDefault Compression Level - Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
- mysqlx
Deflate NumberMax Client Compression Level - Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
- mysqlx
Document NumberId Unique Prefix - ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Enable BooleanHello Notice - ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Idle NumberWorker Thread Timeout - ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Interactive NumberTimeout The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout
- mysqlx
Lz4default NumberCompression Level - Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
- mysqlx
Lz4max NumberClient Compression Level - Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
- mysqlx
Max NumberAllowed Packet The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
- mysqlx
Min NumberWorker Threads - ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored
- mysqlx
Read NumberTimeout The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application.
mysqlxReadTimeout corresponds to the MySQL X Plugin system variable mysqlx_read_timeout
- mysqlx
Wait NumberTimeout The number of seconds that X Plugin waits for activity on a connection.
mysqlxWaitTimeout corresponds to the MySQL X Plugin system variable. mysqlx_wait_timeout
- mysqlx
Write NumberTimeout The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, X Plugin closes the connection.
mysqlxReadmysqlxWriteTimeoutTimeout corresponds to the MySQL X Plugin system variable mysqlx_write_timeout
- mysqlx
Zstd NumberDefault Compression Level - Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
- mysqlx
Zstd NumberMax Client Compression Level - Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
- net
Read NumberTimeout The number of seconds to wait for more data from a connection before aborting the read.
netReadTimeout corresponds to the MySQL system variable net_read_timeout
- net
Write NumberTimeout The number of seconds to wait for a block to be written to a connection before aborting the write.
netWriteTimeout corresponds to the MySQL system variable net_write_timeout
- parser
Max StringMem Size - ("parser_max_mem_size")
- query
Alloc StringBlock Size - ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored
- query
Prealloc StringSize - ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored
- regexp
Time NumberLimit - regexpTimeLimit corresponds to the MySQL system variable [regexp_time_limit] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_regexp_time_limit)
- sort
Buffer StringSize Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable sort_buffer_size
- sql
Mode String - ("sql_mode")
- sql
Require BooleanPrimary Key - ("sql_require_primary_key")
- sql
Warnings Boolean - ("sql_warnings")
- thread
Pool BooleanDedicated Listeners - Controls whether the thread pool uses dedicated listener threads. If enabled, a listener thread in each thread group is dedicated to the task of listening for network events from clients, ensuring that the maximum number of query worker threads is no more than the value specified by threadPoolMaxTransactionsLimit. threadPoolDedicatedListeners corresponds to the MySQL Database Service-specific system variable thread_pool_dedicated_listeners.
- thread
Pool NumberMax Transactions Limit - Limits the maximum number of open transactions to the defined value. The default value is 0, which enforces no limit. threadPoolMaxTransactionsLimit corresponds to the MySQL Database Service-specific system variable thread_pool_max_transactions_limit.
- time
Zone String Initializes the time zone for each client that connects.
This corresponds to the MySQL System Variable "time_zone".
The values can be given in one of the following formats, none of which are case-sensitive:
- As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. The permitted range is '-13:59' to '+14:00', inclusive.
- As a named time zone, as defined by the "IANA Time Zone database", such as 'Europe/Helsinki', 'US/Eastern', 'MET', or 'UTC'.
- tmp
Table StringSize The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
tmp_table_size corresponds to the MySQL system variable tmp_table_size
- transaction
Isolation String - ("transaction_isolation")
- wait
Timeout Number The number of seconds the server waits for activity on a noninteractive connection before closing it.
waitTimeout corresponds to the MySQL system variable. wait_timeout
** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values
Import
MysqlConfigurations can be imported using the id, e.g.
$ pulumi import oci:Mysql/mysqlConfiguration:MysqlConfiguration test_mysql_configuration "configurations/{configurationId}"
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
ociTerraform Provider.