Class ConfigurationVariables
User-defined service variables.
Inherited Members
Namespace: Oci.MysqlService.Models
Assembly: OCI.DotNetSDK.Mysql.dll
Syntax
public class ConfigurationVariables
Properties
Autocommit
Declaration
[JsonProperty(PropertyName = "autocommit")]
public bool? Autocommit { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("autocommit") |
BigTables
Declaration
[JsonProperty(PropertyName = "bigTables")]
public bool? BigTables { get; set; }
Property Value
Type | Description |
---|---|
bool? | If enabled, the server stores all temporary tables on disk rather than in memory.
|
BinlogExpireLogsSeconds
Declaration
[JsonProperty(PropertyName = "binlogExpireLogsSeconds")]
public int? BinlogExpireLogsSeconds { get; set; }
Property Value
Type | Description |
---|---|
int? | Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds. |
BinlogRowMetadata
Declaration
[JsonProperty(PropertyName = "binlogRowMetadata")]
[JsonConverter(typeof(ResponseEnumConverter))]
public ConfigurationVariables.BinlogRowMetadataEnum? BinlogRowMetadata { get; set; }
Property Value
Type | Description |
---|---|
ConfigurationVariables.BinlogRowMetadataEnum? | 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
Declaration
[JsonProperty(PropertyName = "binlogRowValueOptions")]
public string BinlogRowValueOptions { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "binlogTransactionCompression")]
public bool? BinlogTransactionCompression { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "completionType")]
[JsonConverter(typeof(ResponseEnumConverter))]
public ConfigurationVariables.CompletionTypeEnum? CompletionType { get; set; }
Property Value
Type | Description |
---|---|
ConfigurationVariables.CompletionTypeEnum? | ("completion_type") |
ConnectTimeout
Declaration
[JsonProperty(PropertyName = "connectTimeout")]
public int? ConnectTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
|
ConnectionMemoryChunkSize
Declaration
[JsonProperty(PropertyName = "connectionMemoryChunkSize")]
public int? ConnectionMemoryChunkSize { get; set; }
Property Value
Type | Description |
---|---|
int? | Set the chunking size for updates to the global memory usage counter Global_connection_memory.
|
ConnectionMemoryLimit
Declaration
[JsonProperty(PropertyName = "connectionMemoryLimit")]
public long? ConnectionMemoryLimit { get; set; }
Property Value
Type | Description |
---|---|
long? | Set the maximum amount of memory that can be used by a single user connection.
|
CteMaxRecursionDepth
Declaration
[JsonProperty(PropertyName = "cteMaxRecursionDepth")]
public long? CteMaxRecursionDepth { get; set; }
Property Value
Type | Description |
---|---|
long? | ("cte_max_recursion_depth") |
DefaultAuthenticationPlugin
Declaration
[JsonProperty(PropertyName = "defaultAuthenticationPlugin")]
[JsonConverter(typeof(ResponseEnumConverter))]
public ConfigurationVariables.DefaultAuthenticationPluginEnum? DefaultAuthenticationPlugin { get; set; }
Property Value
Type | Description |
---|---|
ConfigurationVariables.DefaultAuthenticationPluginEnum? | ("default_authentication_plugin") |
ForeignKeyChecks
Declaration
[JsonProperty(PropertyName = "foreignKeyChecks")]
public bool? ForeignKeyChecks { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("foreign_key_checks") |
GeneratedRandomPasswordLength
Declaration
[JsonProperty(PropertyName = "generatedRandomPasswordLength")]
public int? GeneratedRandomPasswordLength { get; set; }
Property Value
Type | Description |
---|---|
int? | ("generated_random_password_length") DEPRECATED -- variable should not be settable and will be ignored |
GlobalConnectionMemoryLimit
Declaration
[JsonProperty(PropertyName = "globalConnectionMemoryLimit")]
public long? GlobalConnectionMemoryLimit { get; set; }
Property Value
Type | Description |
---|---|
long? | Set the total amount of memory that can be used by all user connections.
|
GlobalConnectionMemoryTracking
Declaration
[JsonProperty(PropertyName = "globalConnectionMemoryTracking")]
public bool? GlobalConnectionMemoryTracking { get; set; }
Property Value
Type | Description |
---|---|
bool? | Determines whether the MySQL server calculates Global_connection_memory.
|
GroupReplicationConsistency
Declaration
[JsonProperty(PropertyName = "groupReplicationConsistency")]
[JsonConverter(typeof(ResponseEnumConverter))]
public ConfigurationVariables.GroupReplicationConsistencyEnum? GroupReplicationConsistency { get; set; }
Property Value
Type | Description |
---|---|
ConfigurationVariables.GroupReplicationConsistencyEnum? |
|
InformationSchemaStatsExpiry
Declaration
[JsonProperty(PropertyName = "informationSchemaStatsExpiry")]
public int? InformationSchemaStatsExpiry { get; set; }
Property Value
Type | Description |
---|---|
int? | ("information_schema_stats_expiry") |
InnodbBufferPoolDumpPct
Declaration
[JsonProperty(PropertyName = "innodbBufferPoolDumpPct")]
public int? InnodbBufferPoolDumpPct { get; set; }
Property Value
Type | Description |
---|---|
int? | Specifies the percentage of the most recently used pages for each buffer pool to read out and dump.
|
InnodbBufferPoolInstances
Declaration
[JsonProperty(PropertyName = "innodbBufferPoolInstances")]
public int? InnodbBufferPoolInstances { get; set; }
Property Value
Type | Description |
---|---|
int? | ("innodb_buffer_pool_instances") |
InnodbBufferPoolSize
Declaration
[JsonProperty(PropertyName = "innodbBufferPoolSize")]
public long? InnodbBufferPoolSize { get; set; }
Property Value
Type | Description |
---|---|
long? | The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table and index data.
|
InnodbDdlBufferSize
Declaration
[JsonProperty(PropertyName = "innodbDdlBufferSize")]
public long? InnodbDdlBufferSize { get; set; }
Property Value
Type | Description |
---|---|
long? | 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
Declaration
[JsonProperty(PropertyName = "innodbDdlThreads")]
public int? InnodbDdlThreads { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "innodbFtEnableStopword")]
public bool? InnodbFtEnableStopword { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("innodb_ft_enable_stopword") |
InnodbFtMaxTokenSize
Declaration
[JsonProperty(PropertyName = "innodbFtMaxTokenSize")]
public int? InnodbFtMaxTokenSize { get; set; }
Property Value
Type | Description |
---|---|
int? | ("innodb_ft_max_token_size") |
InnodbFtMinTokenSize
Declaration
[JsonProperty(PropertyName = "innodbFtMinTokenSize")]
public int? InnodbFtMinTokenSize { get; set; }
Property Value
Type | Description |
---|---|
int? | ("innodb_ft_min_token_size") |
InnodbFtNumWordOptimize
Declaration
[JsonProperty(PropertyName = "innodbFtNumWordOptimize")]
public int? InnodbFtNumWordOptimize { get; set; }
Property Value
Type | Description |
---|---|
int? | ("innodb_ft_num_word_optimize") |
InnodbFtResultCacheLimit
Declaration
[JsonProperty(PropertyName = "innodbFtResultCacheLimit")]
public long? InnodbFtResultCacheLimit { get; set; }
Property Value
Type | Description |
---|---|
long? | ("innodb_ft_result_cache_limit") |
InnodbFtServerStopwordTable
Declaration
[JsonProperty(PropertyName = "innodbFtServerStopwordTable")]
public string InnodbFtServerStopwordTable { get; set; }
Property Value
Type | Description |
---|---|
string | ("innodb_ft_server_stopword_table") |
InnodbLockWaitTimeout
Declaration
[JsonProperty(PropertyName = "innodbLockWaitTimeout")]
public int? InnodbLockWaitTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | ("innodb_lock_wait_timeout") |
InnodbLogWriterThreads
Declaration
[JsonProperty(PropertyName = "innodbLogWriterThreads")]
public bool? InnodbLogWriterThreads { get; set; }
Property Value
Type | Description |
---|---|
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.
|
InnodbMaxPurgeLag
Declaration
[JsonProperty(PropertyName = "innodbMaxPurgeLag")]
public long? InnodbMaxPurgeLag { get; set; }
Property Value
Type | Description |
---|---|
long? | The desired maximum purge lag in terms of transactions.
|
InnodbMaxPurgeLagDelay
Declaration
[JsonProperty(PropertyName = "innodbMaxPurgeLagDelay")]
public int? InnodbMaxPurgeLagDelay { get; set; }
Property Value
Type | Description |
---|---|
int? | The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded.
|
InnodbStatsPersistentSamplePages
Declaration
[JsonProperty(PropertyName = "innodbStatsPersistentSamplePages")]
public long? InnodbStatsPersistentSamplePages { get; set; }
Property Value
Type | Description |
---|---|
long? | 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
Declaration
[JsonProperty(PropertyName = "innodbStatsTransientSamplePages")]
public long? InnodbStatsTransientSamplePages { get; set; }
Property Value
Type | Description |
---|---|
long? | The number of index pages to sample when estimating cardinality and other statistics for an indexed column,
such as those calculated by ANALYZE TABLE.
|
InteractiveTimeout
Declaration
[JsonProperty(PropertyName = "interactiveTimeout")]
public int? InteractiveTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds the server waits for activity on an interactive connection before closing it.
|
LocalInfile
Declaration
[JsonProperty(PropertyName = "localInfile")]
public bool? LocalInfile { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("local_infile") |
MandatoryRoles
Declaration
[JsonProperty(PropertyName = "mandatoryRoles")]
public string MandatoryRoles { get; set; }
Property Value
Type | Description |
---|---|
string | ("mandatory_roles") |
MaxAllowedPacket
Declaration
[JsonProperty(PropertyName = "maxAllowedPacket")]
public int? MaxAllowedPacket { get; set; }
Property Value
Type | Description |
---|---|
int? | The maximum size of one packet or any generated/intermediate string.
|
MaxBinlogCacheSize
Declaration
[JsonProperty(PropertyName = "maxBinlogCacheSize")]
public long? MaxBinlogCacheSize { get; set; }
Property Value
Type | Description |
---|---|
long? | Sets the size of the transaction cache.
|
MaxConnectErrors
Declaration
[JsonProperty(PropertyName = "maxConnectErrors")]
public long? MaxConnectErrors { get; set; }
Property Value
Type | Description |
---|---|
long? | ("max_connect_errors") |
MaxConnections
Declaration
[JsonProperty(PropertyName = "maxConnections")]
public int? MaxConnections { get; set; }
Property Value
Type | Description |
---|---|
int? | ("max_connections") |
MaxExecutionTime
Declaration
[JsonProperty(PropertyName = "maxExecutionTime")]
public long? MaxExecutionTime { get; set; }
Property Value
Type | Description |
---|---|
long? | ("max_execution_time") |
MaxHeapTableSize
Declaration
[JsonProperty(PropertyName = "maxHeapTableSize")]
public long? MaxHeapTableSize { get; set; }
Property Value
Type | Description |
---|---|
long? | This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
|
MaxPreparedStmtCount
Declaration
[JsonProperty(PropertyName = "maxPreparedStmtCount")]
public int? MaxPreparedStmtCount { get; set; }
Property Value
Type | Description |
---|---|
int? | ("max_prepared_stmt_count") |
MysqlFirewallMode
Declaration
[JsonProperty(PropertyName = "mysqlFirewallMode")]
public bool? MysqlFirewallMode { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("mysql_firewall_mode") |
MysqlZstdDefaultCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlZstdDefaultCompressionLevel")]
public int? MysqlZstdDefaultCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | DEPRECATED -- typo of mysqlx_zstd_default_compression_level. variable will be ignored. |
MysqlxConnectTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxConnectTimeout")]
public int? MysqlxConnectTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds X Plugin waits for the first packet to be received from newly connected clients.
|
MysqlxDeflateDefaultCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxDeflateDefaultCompressionLevel")]
public int? MysqlxDeflateDefaultCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Set the default compression level for the deflate algorithm. ("mysqlx_deflate_default_compression_level") |
MysqlxDeflateMaxClientCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxDeflateMaxClientCompressionLevel")]
public int? MysqlxDeflateMaxClientCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Limit the upper bound of accepted compression levels for the deflate algorithm. ("mysqlx_deflate_max_client_compression_level") |
MysqlxDocumentIdUniquePrefix
Declaration
[JsonProperty(PropertyName = "mysqlxDocumentIdUniquePrefix")]
public int? MysqlxDocumentIdUniquePrefix { get; set; }
Property Value
Type | Description |
---|---|
int? | ("mysqlx_document_id_unique_prefix") DEPRECATED -- variable should not be settable and will be ignored |
MysqlxEnableHelloNotice
Declaration
[JsonProperty(PropertyName = "mysqlxEnableHelloNotice")]
public bool? MysqlxEnableHelloNotice { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("mysqlx_enable_hello_notice") DEPRECATED -- variable should not be settable and will be ignored |
MysqlxIdleWorkerThreadTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxIdleWorkerThreadTimeout")]
public int? MysqlxIdleWorkerThreadTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | ("mysqlx_idle_worker_thread_timeout") DEPRECATED -- variable should not be settable and will be ignored |
MysqlxInteractiveTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxInteractiveTimeout")]
public int? MysqlxInteractiveTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds to wait for interactive clients to timeout.
|
MysqlxLz4DefaultCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxLz4DefaultCompressionLevel")]
public int? MysqlxLz4DefaultCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Set the default compression level for the lz4 algorithm. ("mysqlx_lz4_default_compression_level") |
MysqlxLz4MaxClientCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxLz4MaxClientCompressionLevel")]
public int? MysqlxLz4MaxClientCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Limit the upper bound of accepted compression levels for the lz4 algorithm. ("mysqlx_lz4_max_client_compression_level") |
MysqlxMaxAllowedPacket
Declaration
[JsonProperty(PropertyName = "mysqlxMaxAllowedPacket")]
public int? MysqlxMaxAllowedPacket { get; set; }
Property Value
Type | Description |
---|---|
int? | The maximum size of network packets that can be received by X Plugin.
|
MysqlxMinWorkerThreads
Declaration
[JsonProperty(PropertyName = "mysqlxMinWorkerThreads")]
public int? MysqlxMinWorkerThreads { get; set; }
Property Value
Type | Description |
---|---|
int? | ("mysqlx_min_worker_threads") DEPRECATED -- variable should not be settable and will be ignored |
MysqlxReadTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxReadTimeout")]
public int? MysqlxReadTimeout { get; set; }
Property Value
Type | Description |
---|---|
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.
|
MysqlxWaitTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxWaitTimeout")]
public int? MysqlxWaitTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds that X Plugin waits for activity on a connection.
|
MysqlxWriteTimeout
Declaration
[JsonProperty(PropertyName = "mysqlxWriteTimeout")]
public int? MysqlxWriteTimeout { get; set; }
Property Value
Type | Description |
---|---|
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.
|
MysqlxZstdDefaultCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxZstdDefaultCompressionLevel")]
public int? MysqlxZstdDefaultCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Set the default compression level for the zstd algorithm. ("mysqlx_zstd_default_compression_level") |
MysqlxZstdMaxClientCompressionLevel
Declaration
[JsonProperty(PropertyName = "mysqlxZstdMaxClientCompressionLevel")]
public int? MysqlxZstdMaxClientCompressionLevel { get; set; }
Property Value
Type | Description |
---|---|
int? | Limit the upper bound of accepted compression levels for the zstd algorithm. ("mysqlx_zstd_max_client_compression_level") |
NetReadTimeout
Declaration
[JsonProperty(PropertyName = "netReadTimeout")]
public int? NetReadTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds to wait for more data from a connection before aborting the read.
|
NetWriteTimeout
Declaration
[JsonProperty(PropertyName = "netWriteTimeout")]
public int? NetWriteTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds to wait for a block to be written to a connection before aborting the write.
|
ParserMaxMemSize
Declaration
[JsonProperty(PropertyName = "parserMaxMemSize")]
public long? ParserMaxMemSize { get; set; }
Property Value
Type | Description |
---|---|
long? | ("parser_max_mem_size") |
QueryAllocBlockSize
Declaration
[JsonProperty(PropertyName = "queryAllocBlockSize")]
public long? QueryAllocBlockSize { get; set; }
Property Value
Type | Description |
---|---|
long? | ("query_alloc_block_size") DEPRECATED -- variable should not be settable and will be ignored |
QueryPreallocSize
Declaration
[JsonProperty(PropertyName = "queryPreallocSize")]
public long? QueryPreallocSize { get; set; }
Property Value
Type | Description |
---|---|
long? | ("query_prealloc_size") DEPRECATED -- variable should not be settable and will be ignored |
RegexpTimeLimit
Declaration
[JsonProperty(PropertyName = "regexpTimeLimit")]
public int? RegexpTimeLimit { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "sortBufferSize")]
public long? SortBufferSize { get; set; }
Property Value
Type | Description |
---|---|
long? | Each session that must perform a sort allocates a buffer of this size.
|
SqlMode
Declaration
[JsonProperty(PropertyName = "sqlMode")]
public string SqlMode { get; set; }
Property Value
Type | Description |
---|---|
string | ("sql_mode") |
SqlRequirePrimaryKey
Declaration
[JsonProperty(PropertyName = "sqlRequirePrimaryKey")]
public bool? SqlRequirePrimaryKey { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("sql_require_primary_key") |
SqlWarnings
Declaration
[JsonProperty(PropertyName = "sqlWarnings")]
public bool? SqlWarnings { get; set; }
Property Value
Type | Description |
---|---|
bool? | ("sql_warnings") |
ThreadPoolDedicatedListeners
Declaration
[JsonProperty(PropertyName = "threadPoolDedicatedListeners")]
public bool? ThreadPoolDedicatedListeners { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "threadPoolMaxTransactionsLimit")]
public int? ThreadPoolMaxTransactionsLimit { get; set; }
Property Value
Type | Description |
---|---|
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
Declaration
[JsonProperty(PropertyName = "timeZone")]
public string TimeZone { get; set; }
Property Value
Type | Description |
---|---|
string | Initializes the time zone for each client that connects.
|
TmpTableSize
Declaration
[JsonProperty(PropertyName = "tmpTableSize")]
public long? TmpTableSize { get; set; }
Property Value
Type | Description |
---|---|
long? | The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.
|
TransactionIsolation
Declaration
[JsonProperty(PropertyName = "transactionIsolation")]
[JsonConverter(typeof(ResponseEnumConverter))]
public ConfigurationVariables.TransactionIsolationEnum? TransactionIsolation { get; set; }
Property Value
Type | Description |
---|---|
ConfigurationVariables.TransactionIsolationEnum? | ("transaction_isolation") |
WaitTimeout
Declaration
[JsonProperty(PropertyName = "waitTimeout")]
public int? WaitTimeout { get; set; }
Property Value
Type | Description |
---|---|
int? | The number of seconds the server waits for activity on a noninteractive connection before closing it.
|