1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Mysql
  5. MysqlConfiguration
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

oci.Mysql.MysqlConfiguration

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi

    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=oci.mysql.MysqlConfigurationInitVariablesArgs(
            lower_case_table_names=mysql_configuration_init_variables_lower_case_table_names,
        ),
        parent_configuration_id=test_configuration["id"],
        variables=oci.mysql.MysqlConfigurationVariablesArgs(
            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/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.Map{
    				"foo-namespace.bar-key": pulumi.Any("value"),
    			},
    			Description: pulumi.Any(mysqlConfigurationDescription),
    			DisplayName: pulumi.Any(mysqlConfigurationDisplayName),
    			FreeformTags: pulumi.Map{
    				"bar-key": pulumi.Any("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, Any]] = None,
                           description: Optional[str] = None,
                           display_name: Optional[str] = None,
                           freeform_tags: Optional[Mapping[str, Any]] = 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.

    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", "any" },
        },
        Description = "string",
        DisplayName = "string",
        FreeformTags = 
        {
            { "string", "any" },
        },
        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.Map{
    		"string": pulumi.Any("any"),
    	},
    	Description: pulumi.String("string"),
    	DisplayName: pulumi.String("string"),
    	FreeformTags: pulumi.Map{
    		"string": pulumi.Any("any"),
    	},
    	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", "any"))
        .description("string")
        .displayName("string")
        .freeformTags(Map.of("string", "any"))
        .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": "any",
        },
        description="string",
        display_name="string",
        freeform_tags={
            "string": "any",
        },
        init_variables=oci.mysql.MysqlConfigurationInitVariablesArgs(
            lower_case_table_names="string",
        ),
        parent_configuration_id="string",
        variables=oci.mysql.MysqlConfigurationVariablesArgs(
            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: "any",
        },
        description: "string",
        displayName: "string",
        freeformTags: {
            string: "any",
        },
        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: any
        description: string
        displayName: string
        freeformTags:
            string: any
        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

    The MysqlConfiguration resource accepts the following input properties:

    CompartmentId string
    The OCID of the compartment.
    ShapeName string
    The name of the associated Shape.
    DefinedTags Dictionary<string, object>
    (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.
    DisplayName string
    (Updatable) The display name of the Configuration.
    FreeformTags Dictionary<string, object>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    InitVariables MysqlConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    ParentConfigurationId string
    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 MysqlConfigurationVariables
    User-defined service variables.
    CompartmentId string
    The OCID of the compartment.
    ShapeName string
    The name of the associated Shape.
    DefinedTags map[string]interface{}
    (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.
    DisplayName string
    (Updatable) The display name of the Configuration.
    FreeformTags map[string]interface{}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    InitVariables MysqlConfigurationInitVariablesArgs
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    ParentConfigurationId string
    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 MysqlConfigurationVariablesArgs
    User-defined service variables.
    compartmentId String
    The OCID of the compartment.
    shapeName String
    The name of the associated Shape.
    definedTags Map<String,Object>
    (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.
    displayName String
    (Updatable) The display name of the Configuration.
    freeformTags Map<String,Object>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables ConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId String
    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 ConfigurationVariables
    User-defined service variables.
    compartmentId string
    The OCID of the compartment.
    shapeName string
    The name of the associated Shape.
    definedTags {[key: string]: any}
    (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.
    displayName string
    (Updatable) The display name of the Configuration.
    freeformTags {[key: string]: any}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables MysqlConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId string
    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 MysqlConfigurationVariables
    User-defined service variables.
    compartment_id str
    The OCID of the compartment.
    shape_name str
    The name of the associated Shape.
    defined_tags Mapping[str, Any]
    (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.
    freeform_tags Mapping[str, Any]
    (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.MysqlConfigurationInitVariablesArgs
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parent_configuration_id str
    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.MysqlConfigurationVariablesArgs
    User-defined service variables.
    compartmentId String
    The OCID of the compartment.
    shapeName String
    The name of the associated Shape.
    definedTags Map<Any>
    (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.
    displayName String
    (Updatable) The display name of the Configuration.
    freeformTags Map<Any>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables Property Map
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId String
    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.
    TimeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    TimeUpdated 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.
    TimeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    TimeUpdated 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.
    timeCreated String
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated 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.
    timeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated 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.
    timeCreated String
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated 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, Any]] = None,
            description: Optional[str] = None,
            display_name: Optional[str] = None,
            freeform_tags: Optional[Mapping[str, Any]] = 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) -> MysqlConfiguration
    func 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.
    The following state arguments are supported:
    CompartmentId string
    The OCID of the compartment.
    DefinedTags Dictionary<string, object>
    (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.
    DisplayName string
    (Updatable) The display name of the Configuration.
    FreeformTags Dictionary<string, object>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    InitVariables MysqlConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    ParentConfigurationId string
    The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
    ShapeName string
    The name of the associated Shape.
    State string
    The current state of the Configuration.
    TimeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    TimeUpdated string
    The date and time the Configuration was last updated, as described by RFC 3339.
    Type string
    The Configuration type, DEFAULT or CUSTOM.
    Variables MysqlConfigurationVariables
    User-defined service variables.
    CompartmentId string
    The OCID of the compartment.
    DefinedTags map[string]interface{}
    (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.
    DisplayName string
    (Updatable) The display name of the Configuration.
    FreeformTags map[string]interface{}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    InitVariables MysqlConfigurationInitVariablesArgs
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    ParentConfigurationId string
    The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
    ShapeName string
    The name of the associated Shape.
    State string
    The current state of the Configuration.
    TimeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    TimeUpdated string
    The date and time the Configuration was last updated, as described by RFC 3339.
    Type string
    The Configuration type, DEFAULT or CUSTOM.
    Variables MysqlConfigurationVariablesArgs
    User-defined service variables.
    compartmentId String
    The OCID of the compartment.
    definedTags Map<String,Object>
    (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.
    displayName String
    (Updatable) The display name of the Configuration.
    freeformTags Map<String,Object>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables ConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId String
    The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
    shapeName String
    The name of the associated Shape.
    state String
    The current state of the Configuration.
    timeCreated String
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated String
    The date and time the Configuration was last updated, as described by RFC 3339.
    type String
    The Configuration type, DEFAULT or CUSTOM.
    variables ConfigurationVariables
    User-defined service variables.
    compartmentId string
    The OCID of the compartment.
    definedTags {[key: string]: any}
    (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.
    displayName string
    (Updatable) The display name of the Configuration.
    freeformTags {[key: string]: any}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables MysqlConfigurationInitVariables
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId string
    The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
    shapeName string
    The name of the associated Shape.
    state string
    The current state of the Configuration.
    timeCreated string
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated string
    The date and time the Configuration was last updated, as described by RFC 3339.
    type string
    The Configuration type, DEFAULT or CUSTOM.
    variables MysqlConfigurationVariables
    User-defined service variables.
    compartment_id str
    The OCID of the compartment.
    defined_tags Mapping[str, Any]
    (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.
    freeform_tags Mapping[str, Any]
    (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.MysqlConfigurationInitVariablesArgs
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parent_configuration_id str
    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.MysqlConfigurationVariablesArgs
    User-defined service variables.
    compartmentId String
    The OCID of the compartment.
    definedTags Map<Any>
    (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.
    displayName String
    (Updatable) The display name of the Configuration.
    freeformTags Map<Any>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    initVariables Property Map
    User-defined service variables set only at DB system initialization. These variables cannot be changed later at runtime.
    parentConfigurationId String
    The OCID of the Configuration from which the new Configuration is derived. The values in CreateConfigurationDetails.variables supersede the variables of the parent Configuration.
    shapeName String
    The name of the associated Shape.
    state String
    The current state of the Configuration.
    timeCreated String
    The date and time the Configuration was created, as described by RFC 3339.
    timeUpdated 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

    LowerCaseTableNames string

    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)
    LowerCaseTableNames string

    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)
    lowerCaseTableNames String

    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)
    lowerCaseTableNames string

    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_table_names str

    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)
    lowerCaseTableNames String

    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")
    BigTables bool

    If enabled, the server stores all temporary tables on disk rather than in memory.

    bigTables corresponds to the MySQL server variable big_tables.

    BinlogExpireLogsSeconds int
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    BinlogRowMetadata string
    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.
    BinlogRowValueOptions string
    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.
    BinlogTransactionCompression bool
    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.
    CompletionType string
    ("completion_type")
    ConnectTimeout 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".

    ConnectionMemoryChunkSize int

    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.

    ConnectionMemoryLimit string

    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.

    CteMaxRecursionDepth string
    ("cte_max_recursion_depth")
    DefaultAuthenticationPlugin string
    ("default_authentication_plugin")
    ForeignKeyChecks bool
    ("foreign_key_checks")
    GeneratedRandomPasswordLength int
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    GlobalConnectionMemoryLimit string

    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.

    GlobalConnectionMemoryTracking bool

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    GroupReplicationConsistency string
    • 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.
    InformationSchemaStatsExpiry int
    ("information_schema_stats_expiry")
    InnodbBufferPoolDumpPct int

    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.

    InnodbBufferPoolInstances int
    ("innodb_buffer_pool_instances")
    InnodbBufferPoolSize string

    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.

    InnodbDdlBufferSize string
    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)
    InnodbDdlThreads int
    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)
    InnodbFtEnableStopword bool
    ("innodb_ft_enable_stopword")
    InnodbFtMaxTokenSize int
    ("innodb_ft_max_token_size")
    InnodbFtMinTokenSize int
    ("innodb_ft_min_token_size")
    InnodbFtNumWordOptimize int
    ("innodb_ft_num_word_optimize")
    InnodbFtResultCacheLimit string
    ("innodb_ft_result_cache_limit")
    InnodbFtServerStopwordTable string
    ("innodb_ft_server_stopword_table")
    InnodbLockWaitTimeout int
    ("innodb_lock_wait_timeout")
    InnodbLogWriterThreads bool

    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

    InnodbMaxPurgeLag string

    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.

    InnodbMaxPurgeLagDelay int

    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.

    InnodbStatsPersistentSamplePages string

    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.

    InnodbStatsTransientSamplePages string

    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.

    InteractiveTimeout 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

    LocalInfile bool
    ("local_infile")
    MandatoryRoles string
    ("mandatory_roles")
    MaxAllowedPacket int

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    MaxBinlogCacheSize string

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    MaxConnectErrors string
    ("max_connect_errors")
    MaxConnections int
    ("max_connections")
    MaxExecutionTime string
    ("max_execution_time")
    MaxHeapTableSize string

    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

    MaxPreparedStmtCount int
    ("max_prepared_stmt_count")
    MysqlFirewallMode bool
    ("mysql_firewall_mode")
    MysqlZstdDefaultCompressionLevel int
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxConnectTimeout int

    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

    MysqlxDeflateDefaultCompressionLevel int
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    MysqlxDeflateMaxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    MysqlxDocumentIdUniquePrefix int
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxEnableHelloNotice bool
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    MysqlxIdleWorkerThreadTimeout int
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxInteractiveTimeout int

    The number of seconds to wait for interactive clients to timeout.

    mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

    MysqlxLz4defaultCompressionLevel int
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    MysqlxLz4maxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    MysqlxMaxAllowedPacket int

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    MysqlxMinWorkerThreads int
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxReadTimeout int

    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

    MysqlxWaitTimeout int

    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

    MysqlxWriteTimeout int

    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

    MysqlxZstdDefaultCompressionLevel int
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    MysqlxZstdMaxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    NetReadTimeout int

    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

    NetWriteTimeout int

    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

    ParserMaxMemSize string
    ("parser_max_mem_size")
    QueryAllocBlockSize string
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    QueryPreallocSize string
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    RegexpTimeLimit int
    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)
    SortBufferSize string

    Each session that must perform a sort allocates a buffer of this size.

    sortBufferSize corresponds to the MySQL system variable sort_buffer_size

    SqlMode string
    ("sql_mode")
    SqlRequirePrimaryKey bool
    ("sql_require_primary_key")
    SqlWarnings bool
    ("sql_warnings")
    ThreadPoolDedicatedListeners bool
    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.
    ThreadPoolMaxTransactionsLimit int
    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.
    TimeZone 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'.
    TmpTableSize string

    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

    TransactionIsolation string
    ("transaction_isolation")
    WaitTimeout 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")
    BigTables bool

    If enabled, the server stores all temporary tables on disk rather than in memory.

    bigTables corresponds to the MySQL server variable big_tables.

    BinlogExpireLogsSeconds int
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    BinlogRowMetadata string
    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.
    BinlogRowValueOptions string
    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.
    BinlogTransactionCompression bool
    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.
    CompletionType string
    ("completion_type")
    ConnectTimeout 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".

    ConnectionMemoryChunkSize int

    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.

    ConnectionMemoryLimit string

    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.

    CteMaxRecursionDepth string
    ("cte_max_recursion_depth")
    DefaultAuthenticationPlugin string
    ("default_authentication_plugin")
    ForeignKeyChecks bool
    ("foreign_key_checks")
    GeneratedRandomPasswordLength int
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    GlobalConnectionMemoryLimit string

    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.

    GlobalConnectionMemoryTracking bool

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    GroupReplicationConsistency string
    • 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.
    InformationSchemaStatsExpiry int
    ("information_schema_stats_expiry")
    InnodbBufferPoolDumpPct int

    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.

    InnodbBufferPoolInstances int
    ("innodb_buffer_pool_instances")
    InnodbBufferPoolSize string

    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.

    InnodbDdlBufferSize string
    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)
    InnodbDdlThreads int
    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)
    InnodbFtEnableStopword bool
    ("innodb_ft_enable_stopword")
    InnodbFtMaxTokenSize int
    ("innodb_ft_max_token_size")
    InnodbFtMinTokenSize int
    ("innodb_ft_min_token_size")
    InnodbFtNumWordOptimize int
    ("innodb_ft_num_word_optimize")
    InnodbFtResultCacheLimit string
    ("innodb_ft_result_cache_limit")
    InnodbFtServerStopwordTable string
    ("innodb_ft_server_stopword_table")
    InnodbLockWaitTimeout int
    ("innodb_lock_wait_timeout")
    InnodbLogWriterThreads bool

    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

    InnodbMaxPurgeLag string

    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.

    InnodbMaxPurgeLagDelay int

    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.

    InnodbStatsPersistentSamplePages string

    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.

    InnodbStatsTransientSamplePages string

    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.

    InteractiveTimeout 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

    LocalInfile bool
    ("local_infile")
    MandatoryRoles string
    ("mandatory_roles")
    MaxAllowedPacket int

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    MaxBinlogCacheSize string

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    MaxConnectErrors string
    ("max_connect_errors")
    MaxConnections int
    ("max_connections")
    MaxExecutionTime string
    ("max_execution_time")
    MaxHeapTableSize string

    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

    MaxPreparedStmtCount int
    ("max_prepared_stmt_count")
    MysqlFirewallMode bool
    ("mysql_firewall_mode")
    MysqlZstdDefaultCompressionLevel int
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxConnectTimeout int

    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

    MysqlxDeflateDefaultCompressionLevel int
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    MysqlxDeflateMaxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    MysqlxDocumentIdUniquePrefix int
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxEnableHelloNotice bool
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    MysqlxIdleWorkerThreadTimeout int
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxInteractiveTimeout int

    The number of seconds to wait for interactive clients to timeout.

    mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

    MysqlxLz4defaultCompressionLevel int
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    MysqlxLz4maxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    MysqlxMaxAllowedPacket int

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    MysqlxMinWorkerThreads int
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    MysqlxReadTimeout int

    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

    MysqlxWaitTimeout int

    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

    MysqlxWriteTimeout int

    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

    MysqlxZstdDefaultCompressionLevel int
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    MysqlxZstdMaxClientCompressionLevel int
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    NetReadTimeout int

    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

    NetWriteTimeout int

    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

    ParserMaxMemSize string
    ("parser_max_mem_size")
    QueryAllocBlockSize string
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    QueryPreallocSize string
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    RegexpTimeLimit int
    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)
    SortBufferSize string

    Each session that must perform a sort allocates a buffer of this size.

    sortBufferSize corresponds to the MySQL system variable sort_buffer_size

    SqlMode string
    ("sql_mode")
    SqlRequirePrimaryKey bool
    ("sql_require_primary_key")
    SqlWarnings bool
    ("sql_warnings")
    ThreadPoolDedicatedListeners bool
    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.
    ThreadPoolMaxTransactionsLimit int
    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.
    TimeZone 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'.
    TmpTableSize string

    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

    TransactionIsolation string
    ("transaction_isolation")
    WaitTimeout 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")
    bigTables Boolean

    If enabled, the server stores all temporary tables on disk rather than in memory.

    bigTables corresponds to the MySQL server variable big_tables.

    binlogExpireLogsSeconds Integer
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    binlogRowMetadata String
    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.
    binlogRowValueOptions String
    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.
    binlogTransactionCompression Boolean
    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.
    completionType String
    ("completion_type")
    connectTimeout 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".

    connectionMemoryChunkSize Integer

    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.

    connectionMemoryLimit String

    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.

    cteMaxRecursionDepth String
    ("cte_max_recursion_depth")
    defaultAuthenticationPlugin String
    ("default_authentication_plugin")
    foreignKeyChecks Boolean
    ("foreign_key_checks")
    generatedRandomPasswordLength Integer
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    globalConnectionMemoryLimit String

    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.

    globalConnectionMemoryTracking Boolean

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    groupReplicationConsistency String
    • 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.
    informationSchemaStatsExpiry Integer
    ("information_schema_stats_expiry")
    innodbBufferPoolDumpPct Integer

    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.

    innodbBufferPoolInstances Integer
    ("innodb_buffer_pool_instances")
    innodbBufferPoolSize String

    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.

    innodbDdlBufferSize String
    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)
    innodbDdlThreads Integer
    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)
    innodbFtEnableStopword Boolean
    ("innodb_ft_enable_stopword")
    innodbFtMaxTokenSize Integer
    ("innodb_ft_max_token_size")
    innodbFtMinTokenSize Integer
    ("innodb_ft_min_token_size")
    innodbFtNumWordOptimize Integer
    ("innodb_ft_num_word_optimize")
    innodbFtResultCacheLimit String
    ("innodb_ft_result_cache_limit")
    innodbFtServerStopwordTable String
    ("innodb_ft_server_stopword_table")
    innodbLockWaitTimeout Integer
    ("innodb_lock_wait_timeout")
    innodbLogWriterThreads Boolean

    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

    innodbMaxPurgeLag String

    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.

    innodbMaxPurgeLagDelay Integer

    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.

    innodbStatsPersistentSamplePages String

    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.

    innodbStatsTransientSamplePages String

    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.

    interactiveTimeout 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

    localInfile Boolean
    ("local_infile")
    mandatoryRoles String
    ("mandatory_roles")
    maxAllowedPacket Integer

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    maxBinlogCacheSize String

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    maxConnectErrors String
    ("max_connect_errors")
    maxConnections Integer
    ("max_connections")
    maxExecutionTime String
    ("max_execution_time")
    maxHeapTableSize String

    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

    maxPreparedStmtCount Integer
    ("max_prepared_stmt_count")
    mysqlFirewallMode Boolean
    ("mysql_firewall_mode")
    mysqlZstdDefaultCompressionLevel Integer
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxConnectTimeout Integer

    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

    mysqlxDeflateDefaultCompressionLevel Integer
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    mysqlxDeflateMaxClientCompressionLevel Integer
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    mysqlxDocumentIdUniquePrefix Integer
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxEnableHelloNotice Boolean
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    mysqlxIdleWorkerThreadTimeout Integer
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxInteractiveTimeout Integer

    The number of seconds to wait for interactive clients to timeout.

    mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

    mysqlxLz4defaultCompressionLevel Integer
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    mysqlxLz4maxClientCompressionLevel Integer
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    mysqlxMaxAllowedPacket Integer

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    mysqlxMinWorkerThreads Integer
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxReadTimeout Integer

    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

    mysqlxWaitTimeout Integer

    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

    mysqlxWriteTimeout Integer

    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

    mysqlxZstdDefaultCompressionLevel Integer
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    mysqlxZstdMaxClientCompressionLevel Integer
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    netReadTimeout Integer

    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

    netWriteTimeout Integer

    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

    parserMaxMemSize String
    ("parser_max_mem_size")
    queryAllocBlockSize String
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    queryPreallocSize String
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    regexpTimeLimit Integer
    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)
    sortBufferSize String

    Each session that must perform a sort allocates a buffer of this size.

    sortBufferSize corresponds to the MySQL system variable sort_buffer_size

    sqlMode String
    ("sql_mode")
    sqlRequirePrimaryKey Boolean
    ("sql_require_primary_key")
    sqlWarnings Boolean
    ("sql_warnings")
    threadPoolDedicatedListeners Boolean
    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.
    threadPoolMaxTransactionsLimit Integer
    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.
    timeZone 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'.
    tmpTableSize String

    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

    transactionIsolation String
    ("transaction_isolation")
    waitTimeout 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")
    bigTables boolean

    If enabled, the server stores all temporary tables on disk rather than in memory.

    bigTables corresponds to the MySQL server variable big_tables.

    binlogExpireLogsSeconds number
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    binlogRowMetadata string
    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.
    binlogRowValueOptions string
    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.
    binlogTransactionCompression boolean
    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.
    completionType string
    ("completion_type")
    connectTimeout 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".

    connectionMemoryChunkSize number

    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.

    connectionMemoryLimit string

    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.

    cteMaxRecursionDepth string
    ("cte_max_recursion_depth")
    defaultAuthenticationPlugin string
    ("default_authentication_plugin")
    foreignKeyChecks boolean
    ("foreign_key_checks")
    generatedRandomPasswordLength number
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    globalConnectionMemoryLimit string

    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.

    globalConnectionMemoryTracking boolean

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    groupReplicationConsistency string
    • 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.
    informationSchemaStatsExpiry number
    ("information_schema_stats_expiry")
    innodbBufferPoolDumpPct number

    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.

    innodbBufferPoolInstances number
    ("innodb_buffer_pool_instances")
    innodbBufferPoolSize string

    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.

    innodbDdlBufferSize string
    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)
    innodbDdlThreads number
    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)
    innodbFtEnableStopword boolean
    ("innodb_ft_enable_stopword")
    innodbFtMaxTokenSize number
    ("innodb_ft_max_token_size")
    innodbFtMinTokenSize number
    ("innodb_ft_min_token_size")
    innodbFtNumWordOptimize number
    ("innodb_ft_num_word_optimize")
    innodbFtResultCacheLimit string
    ("innodb_ft_result_cache_limit")
    innodbFtServerStopwordTable string
    ("innodb_ft_server_stopword_table")
    innodbLockWaitTimeout number
    ("innodb_lock_wait_timeout")
    innodbLogWriterThreads boolean

    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

    innodbMaxPurgeLag string

    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.

    innodbMaxPurgeLagDelay number

    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.

    innodbStatsPersistentSamplePages string

    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.

    innodbStatsTransientSamplePages string

    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.

    interactiveTimeout 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

    localInfile boolean
    ("local_infile")
    mandatoryRoles string
    ("mandatory_roles")
    maxAllowedPacket number

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    maxBinlogCacheSize string

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    maxConnectErrors string
    ("max_connect_errors")
    maxConnections number
    ("max_connections")
    maxExecutionTime string
    ("max_execution_time")
    maxHeapTableSize string

    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

    maxPreparedStmtCount number
    ("max_prepared_stmt_count")
    mysqlFirewallMode boolean
    ("mysql_firewall_mode")
    mysqlZstdDefaultCompressionLevel number
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxConnectTimeout number

    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

    mysqlxDeflateDefaultCompressionLevel number
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    mysqlxDeflateMaxClientCompressionLevel number
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    mysqlxDocumentIdUniquePrefix number
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxEnableHelloNotice boolean
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    mysqlxIdleWorkerThreadTimeout number
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxInteractiveTimeout number

    The number of seconds to wait for interactive clients to timeout.

    mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

    mysqlxLz4defaultCompressionLevel number
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    mysqlxLz4maxClientCompressionLevel number
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    mysqlxMaxAllowedPacket number

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    mysqlxMinWorkerThreads number
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxReadTimeout number

    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

    mysqlxWaitTimeout number

    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

    mysqlxWriteTimeout number

    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

    mysqlxZstdDefaultCompressionLevel number
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    mysqlxZstdMaxClientCompressionLevel number
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    netReadTimeout number

    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

    netWriteTimeout number

    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

    parserMaxMemSize string
    ("parser_max_mem_size")
    queryAllocBlockSize string
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    queryPreallocSize string
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    regexpTimeLimit number
    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)
    sortBufferSize string

    Each session that must perform a sort allocates a buffer of this size.

    sortBufferSize corresponds to the MySQL system variable sort_buffer_size

    sqlMode string
    ("sql_mode")
    sqlRequirePrimaryKey boolean
    ("sql_require_primary_key")
    sqlWarnings boolean
    ("sql_warnings")
    threadPoolDedicatedListeners boolean
    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.
    threadPoolMaxTransactionsLimit number
    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.
    timeZone 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'.
    tmpTableSize string

    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

    transactionIsolation string
    ("transaction_isolation")
    waitTimeout 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_logs_seconds int
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    binlog_row_metadata str
    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_value_options str
    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_compression bool
    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_chunk_size int

    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_limit str

    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_recursion_depth str
    ("cte_max_recursion_depth")
    default_authentication_plugin str
    ("default_authentication_plugin")
    foreign_key_checks bool
    ("foreign_key_checks")
    generated_random_password_length int
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    global_connection_memory_limit str

    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_memory_tracking bool

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    group_replication_consistency str
    • 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_stats_expiry int
    ("information_schema_stats_expiry")
    innodb_buffer_pool_dump_pct int

    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_pool_instances int
    ("innodb_buffer_pool_instances")
    innodb_buffer_pool_size str

    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_buffer_size str
    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_threads int
    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_enable_stopword bool
    ("innodb_ft_enable_stopword")
    innodb_ft_max_token_size int
    ("innodb_ft_max_token_size")
    innodb_ft_min_token_size int
    ("innodb_ft_min_token_size")
    innodb_ft_num_word_optimize int
    ("innodb_ft_num_word_optimize")
    innodb_ft_result_cache_limit str
    ("innodb_ft_result_cache_limit")
    innodb_ft_server_stopword_table str
    ("innodb_ft_server_stopword_table")
    innodb_lock_wait_timeout int
    ("innodb_lock_wait_timeout")
    innodb_log_writer_threads bool

    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_purge_lag str

    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_purge_lag_delay int

    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_persistent_sample_pages str

    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_transient_sample_pages str

    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_packet int

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    max_binlog_cache_size str

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    max_connect_errors str
    ("max_connect_errors")
    max_connections int
    ("max_connections")
    max_execution_time str
    ("max_execution_time")
    max_heap_table_size str

    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_stmt_count int
    ("max_prepared_stmt_count")
    mysql_firewall_mode bool
    ("mysql_firewall_mode")
    mysql_zstd_default_compression_level int
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlx_connect_timeout int

    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_default_compression_level int
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    mysqlx_deflate_max_client_compression_level int
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    mysqlx_document_id_unique_prefix int
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlx_enable_hello_notice bool
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    mysqlx_idle_worker_thread_timeout int
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlx_interactive_timeout int

    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_compression_level int
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    mysqlx_lz4max_client_compression_level int
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    mysqlx_max_allowed_packet int

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    mysqlx_min_worker_threads int
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlx_read_timeout int

    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_timeout int

    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_timeout int

    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_default_compression_level int
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    mysqlx_zstd_max_client_compression_level int
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    net_read_timeout int

    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_timeout int

    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_mem_size str
    ("parser_max_mem_size")
    query_alloc_block_size str
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    query_prealloc_size str
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    regexp_time_limit int
    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_size str

    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_primary_key bool
    ("sql_require_primary_key")
    sql_warnings bool
    ("sql_warnings")
    thread_pool_dedicated_listeners bool
    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_max_transactions_limit int
    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_size str

    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")
    bigTables Boolean

    If enabled, the server stores all temporary tables on disk rather than in memory.

    bigTables corresponds to the MySQL server variable big_tables.

    binlogExpireLogsSeconds Number
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    binlogRowMetadata String
    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.
    binlogRowValueOptions String
    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.
    binlogTransactionCompression Boolean
    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.
    completionType String
    ("completion_type")
    connectTimeout 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".

    connectionMemoryChunkSize Number

    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.

    connectionMemoryLimit String

    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.

    cteMaxRecursionDepth String
    ("cte_max_recursion_depth")
    defaultAuthenticationPlugin String
    ("default_authentication_plugin")
    foreignKeyChecks Boolean
    ("foreign_key_checks")
    generatedRandomPasswordLength Number
    ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'generated_random_password_length' field has been deprecated and may be removed in a future version. Do not use this field.

    globalConnectionMemoryLimit String

    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.

    globalConnectionMemoryTracking Boolean

    Determines whether the MySQL server calculates Global_connection_memory.

    globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

    groupReplicationConsistency String
    • 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.
    informationSchemaStatsExpiry Number
    ("information_schema_stats_expiry")
    innodbBufferPoolDumpPct Number

    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.

    innodbBufferPoolInstances Number
    ("innodb_buffer_pool_instances")
    innodbBufferPoolSize String

    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.

    innodbDdlBufferSize String
    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)
    innodbDdlThreads Number
    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)
    innodbFtEnableStopword Boolean
    ("innodb_ft_enable_stopword")
    innodbFtMaxTokenSize Number
    ("innodb_ft_max_token_size")
    innodbFtMinTokenSize Number
    ("innodb_ft_min_token_size")
    innodbFtNumWordOptimize Number
    ("innodb_ft_num_word_optimize")
    innodbFtResultCacheLimit String
    ("innodb_ft_result_cache_limit")
    innodbFtServerStopwordTable String
    ("innodb_ft_server_stopword_table")
    innodbLockWaitTimeout Number
    ("innodb_lock_wait_timeout")
    innodbLogWriterThreads Boolean

    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

    innodbMaxPurgeLag String

    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.

    innodbMaxPurgeLagDelay Number

    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.

    innodbStatsPersistentSamplePages String

    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.

    innodbStatsTransientSamplePages String

    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.

    interactiveTimeout 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

    localInfile Boolean
    ("local_infile")
    mandatoryRoles String
    ("mandatory_roles")
    maxAllowedPacket Number

    The maximum size of one packet or any generated/intermediate string.

    This is the mysql variable "max_allowed_packet".

    maxBinlogCacheSize String

    Sets the size of the transaction cache.

    maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

    maxConnectErrors String
    ("max_connect_errors")
    maxConnections Number
    ("max_connections")
    maxExecutionTime String
    ("max_execution_time")
    maxHeapTableSize String

    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

    maxPreparedStmtCount Number
    ("max_prepared_stmt_count")
    mysqlFirewallMode Boolean
    ("mysql_firewall_mode")
    mysqlZstdDefaultCompressionLevel Number
    DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored.

    Deprecated: The 'mysql_zstd_default_compression_level' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxConnectTimeout Number

    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

    mysqlxDeflateDefaultCompressionLevel Number
    Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level")
    mysqlxDeflateMaxClientCompressionLevel Number
    Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level")
    mysqlxDocumentIdUniquePrefix Number
    ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_document_id_unique_prefix' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxEnableHelloNotice Boolean
    ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored
    mysqlxIdleWorkerThreadTimeout Number
    ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_idle_worker_thread_timeout' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxInteractiveTimeout Number

    The number of seconds to wait for interactive clients to timeout.

    mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

    mysqlxLz4defaultCompressionLevel Number
    Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level")
    mysqlxLz4maxClientCompressionLevel Number
    Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level")
    mysqlxMaxAllowedPacket Number

    The maximum size of network packets that can be received by X Plugin.

    This is the mysql variable "mysqlx_max_allowed_packet".

    mysqlxMinWorkerThreads Number
    ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'mysqlx_min_worker_threads' field has been deprecated and may be removed in a future version. Do not use this field.

    mysqlxReadTimeout Number

    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

    mysqlxWaitTimeout Number

    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

    mysqlxWriteTimeout Number

    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

    mysqlxZstdDefaultCompressionLevel Number
    Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level")
    mysqlxZstdMaxClientCompressionLevel Number
    Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level")
    netReadTimeout Number

    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

    netWriteTimeout Number

    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

    parserMaxMemSize String
    ("parser_max_mem_size")
    queryAllocBlockSize String
    ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_alloc_block_size' field has been deprecated and may be removed in a future version. Do not use this field.

    queryPreallocSize String
    ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored

    Deprecated: The 'query_prealloc_size' field has been deprecated and may be removed in a future version. Do not use this field.

    regexpTimeLimit Number
    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)
    sortBufferSize String

    Each session that must perform a sort allocates a buffer of this size.

    sortBufferSize corresponds to the MySQL system variable sort_buffer_size

    sqlMode String
    ("sql_mode")
    sqlRequirePrimaryKey Boolean
    ("sql_require_primary_key")
    sqlWarnings Boolean
    ("sql_warnings")
    threadPoolDedicatedListeners Boolean
    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.
    threadPoolMaxTransactionsLimit Number
    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.
    timeZone 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'.
    tmpTableSize String

    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

    transactionIsolation String
    ("transaction_isolation")
    waitTimeout 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 oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.33.0 published on Thursday, Apr 25, 2024 by Pulumi