@Generated(value="OracleSDKGenerator",
comments="API Version: 20190415")
public final class ConfigurationVariables
extends com.oracle.bmc.http.client.internal.ExplicitlySetBmcModel
User-defined service variables.
Note: Objects should always be created or deserialized using the ConfigurationVariables.Builder. This model
distinguishes fields that are null because they are unset from fields that are explicitly
set to null. This is done in the setter methods of the ConfigurationVariables.Builder, which maintain a
set of all explicitly set fields called ConfigurationVariables.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set
fields into account. The constructor, on the other hand, does not take the explicitly set fields
into account (since the constructor cannot distinguish explicit null from unset null).
| Modifier and Type | Class and Description |
|---|---|
static class |
ConfigurationVariables.BinlogRowMetadata
Configures the amount of table metadata added to the binary log when using row-based logging.
|
static class |
ConfigurationVariables.Builder |
static class |
ConfigurationVariables.CompletionType
(“completion_type”)
|
static class |
ConfigurationVariables.DefaultAuthenticationPlugin
(“default_authentication_plugin”)
|
static class |
ConfigurationVariables.GroupReplicationConsistency
EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied
before executing.
|
static class |
ConfigurationVariables.TransactionIsolation
(“transaction_isolation”)
|
EXPLICITLY_SET_FILTER_NAME, EXPLICITLY_SET_PROPERTY_NAME| Constructor and Description |
|---|
ConfigurationVariables(ConfigurationVariables.CompletionType completionType,
Boolean bigTables,
Integer connectionMemoryChunkSize,
Long connectionMemoryLimit,
ConfigurationVariables.DefaultAuthenticationPlugin defaultAuthenticationPlugin,
Long globalConnectionMemoryLimit,
Boolean globalConnectionMemoryTracking,
ConfigurationVariables.TransactionIsolation transactionIsolation,
String innodbFtServerStopwordTable,
String mandatoryRoles,
Boolean autocommit,
Boolean foreignKeyChecks,
ConfigurationVariables.GroupReplicationConsistency groupReplicationConsistency,
Boolean innodbFtEnableStopword,
Boolean innodbLogWriterThreads,
Boolean localInfile,
Boolean mysqlFirewallMode,
Boolean mysqlxEnableHelloNotice,
Boolean sqlRequirePrimaryKey,
Boolean sqlWarnings,
Integer binlogExpireLogsSeconds,
ConfigurationVariables.BinlogRowMetadata binlogRowMetadata,
String binlogRowValueOptions,
Boolean binlogTransactionCompression,
Long innodbBufferPoolSize,
Long innodbFtResultCacheLimit,
Long maxBinlogCacheSize,
Long maxConnectErrors,
Long maxHeapTableSize,
Integer maxConnections,
Integer maxPreparedStmtCount,
Integer connectTimeout,
Long cteMaxRecursionDepth,
Integer generatedRandomPasswordLength,
Integer informationSchemaStatsExpiry,
Integer innodbBufferPoolDumpPct,
Integer innodbBufferPoolInstances,
Long innodbDdlBufferSize,
Integer innodbDdlThreads,
Integer innodbFtMaxTokenSize,
Integer innodbFtMinTokenSize,
Integer innodbFtNumWordOptimize,
Integer innodbLockWaitTimeout,
Long innodbMaxPurgeLag,
Integer innodbMaxPurgeLagDelay,
Integer interactiveTimeout,
Long innodbStatsPersistentSamplePages,
Long innodbStatsTransientSamplePages,
Integer maxAllowedPacket,
Long maxExecutionTime,
Integer mysqlxConnectTimeout,
Integer mysqlxDocumentIdUniquePrefix,
Integer mysqlxIdleWorkerThreadTimeout,
Integer mysqlxInteractiveTimeout,
Integer mysqlxMaxAllowedPacket,
Integer mysqlxMinWorkerThreads,
Integer mysqlxReadTimeout,
Integer mysqlxWaitTimeout,
Integer mysqlxWriteTimeout,
Integer netReadTimeout,
Integer netWriteTimeout,
Long parserMaxMemSize,
Long queryAllocBlockSize,
Long queryPreallocSize,
Integer regexpTimeLimit,
String sqlMode,
Long tmpTableSize,
Integer mysqlxDeflateDefaultCompressionLevel,
Integer mysqlxDeflateMaxClientCompressionLevel,
Integer mysqlxLz4MaxClientCompressionLevel,
Integer mysqlxLz4DefaultCompressionLevel,
Integer mysqlxZstdMaxClientCompressionLevel,
Integer mysqlxZstdDefaultCompressionLevel,
Integer mysqlZstdDefaultCompressionLevel,
Long sortBufferSize,
Integer waitTimeout,
Boolean threadPoolDedicatedListeners,
Integer threadPoolMaxTransactionsLimit,
String timeZone)
Deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
static ConfigurationVariables.Builder |
builder()
Create a new builder.
|
boolean |
equals(Object o) |
Boolean |
getAutocommit()
(“autocommit”)
|
Boolean |
getBigTables()
If enabled, the server stores all temporary tables on disk rather than in memory.
|
Integer |
getBinlogExpireLogsSeconds()
Sets the binary log expiration period in seconds.
|
ConfigurationVariables.BinlogRowMetadata |
getBinlogRowMetadata()
Configures the amount of table metadata added to the binary log when using row-based logging.
|
String |
getBinlogRowValueOptions()
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.
|
Boolean |
getBinlogTransactionCompression()
Enables compression for transactions that are written to binary log files on this server.
|
ConfigurationVariables.CompletionType |
getCompletionType()
(“completion_type”)
|
Integer |
getConnectionMemoryChunkSize()
Set the chunking size for updates to the global memory usage counter
Global_connection_memory.
|
Long |
getConnectionMemoryLimit()
Set the maximum amount of memory that can be used by a single user connection.
|
Integer |
getConnectTimeout()
The number of seconds that the mysqld server waits for a connect packet before responding
with Bad handshake.
|
Long |
getCteMaxRecursionDepth()
(“cte_max_recursion_depth”)
|
ConfigurationVariables.DefaultAuthenticationPlugin |
getDefaultAuthenticationPlugin()
(“default_authentication_plugin”)
|
Boolean |
getForeignKeyChecks()
(“foreign_key_checks”)
|
Integer |
getGeneratedRandomPasswordLength()
(“generated_random_password_length”) DEPRECATED – variable should not be settable and will
be ignored
|
Long |
getGlobalConnectionMemoryLimit()
Set the total amount of memory that can be used by all user connections.
|
Boolean |
getGlobalConnectionMemoryTracking()
Determines whether the MySQL server calculates Global_connection_memory.
|
ConfigurationVariables.GroupReplicationConsistency |
getGroupReplicationConsistency()
EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied
before executing.
|
Integer |
getInformationSchemaStatsExpiry()
(“information_schema_stats_expiry”)
|
Integer |
getInnodbBufferPoolDumpPct()
Specifies the percentage of the most recently used pages for each buffer pool to read out and
dump.
|
Integer |
getInnodbBufferPoolInstances()
(“innodb_buffer_pool_instances”)
|
Long |
getInnodbBufferPoolSize()
The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches table
and index data.
|
Long |
getInnodbDdlBufferSize()
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)
|
Integer |
getInnodbDdlThreads()
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)
|
Boolean |
getInnodbFtEnableStopword()
(“innodb_ft_enable_stopword”)
|
Integer |
getInnodbFtMaxTokenSize()
(“innodb_ft_max_token_size”)
|
Integer |
getInnodbFtMinTokenSize()
(“innodb_ft_min_token_size”)
|
Integer |
getInnodbFtNumWordOptimize()
(“innodb_ft_num_word_optimize”)
|
Long |
getInnodbFtResultCacheLimit()
(“innodb_ft_result_cache_limit”)
|
String |
getInnodbFtServerStopwordTable()
(“innodb_ft_server_stopword_table”)
|
Integer |
getInnodbLockWaitTimeout()
(“innodb_lock_wait_timeout”)
|
Boolean |
getInnodbLogWriterThreads()
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.
|
Long |
getInnodbMaxPurgeLag()
The desired maximum purge lag in terms of transactions.
|
Integer |
getInnodbMaxPurgeLagDelay()
The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag
threshold is exceeded.
|
Long |
getInnodbStatsPersistentSamplePages()
The number of index pages to sample when estimating cardinality and other statistics for an
indexed column, such as those calculated by ANALYZE TABLE.
|
Long |
getInnodbStatsTransientSamplePages()
The number of index pages to sample when estimating cardinality and other statistics for an
indexed column, such as those calculated by ANALYZE
TABLE.
|
Integer |
getInteractiveTimeout()
The number of seconds the server waits for activity on an interactive connection before
closing it.
|
Boolean |
getLocalInfile()
(“local_infile”)
|
String |
getMandatoryRoles()
(“mandatory_roles”)
|
Integer |
getMaxAllowedPacket()
The maximum size of one packet or any generated/intermediate string.
|
Long |
getMaxBinlogCacheSize()
Sets the size of the transaction cache.
|
Long |
getMaxConnectErrors()
(“max_connect_errors”)
|
Integer |
getMaxConnections()
(“max_connections”)
|
Long |
getMaxExecutionTime()
(“max_execution_time”)
|
Long |
getMaxHeapTableSize()
This variable sets the maximum size to which user-created MEMORY tables are permitted to
grow.
|
Integer |
getMaxPreparedStmtCount()
(“max_prepared_stmt_count”)
|
Boolean |
getMysqlFirewallMode()
(“mysql_firewall_mode”)
|
Integer |
getMysqlxConnectTimeout()
The number of seconds X Plugin waits for the first packet to be received from newly connected
clients.
|
Integer |
getMysqlxDeflateDefaultCompressionLevel()
Set the default compression level for the deflate algorithm.
|
Integer |
getMysqlxDeflateMaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the deflate algorithm.
|
Integer |
getMysqlxDocumentIdUniquePrefix()
(“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will
be ignored
|
Boolean |
getMysqlxEnableHelloNotice()
(“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be
ignored
|
Integer |
getMysqlxIdleWorkerThreadTimeout()
(“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will
be ignored
|
Integer |
getMysqlxInteractiveTimeout()
The number of seconds to wait for interactive clients to timeout.
|
Integer |
getMysqlxLz4DefaultCompressionLevel()
Set the default compression level for the lz4 algorithm.
|
Integer |
getMysqlxLz4MaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the lz4 algorithm.
|
Integer |
getMysqlxMaxAllowedPacket()
The maximum size of network packets that can be received by X Plugin.
|
Integer |
getMysqlxMinWorkerThreads()
(“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be
ignored
|
Integer |
getMysqlxReadTimeout()
The number of seconds that X Plugin waits for blocking read operations to complete.
|
Integer |
getMysqlxWaitTimeout()
The number of seconds that X Plugin waits for activity on a connection.
|
Integer |
getMysqlxWriteTimeout()
The number of seconds that X Plugin waits for blocking write operations to complete.
|
Integer |
getMysqlxZstdDefaultCompressionLevel()
Set the default compression level for the zstd algorithm.
|
Integer |
getMysqlxZstdMaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the zstd algorithm.
|
Integer |
getMysqlZstdDefaultCompressionLevel()
DEPRECATED – typo of mysqlx_zstd_default_compression_level.
|
Integer |
getNetReadTimeout()
The number of seconds to wait for more data from a connection before aborting the read.
|
Integer |
getNetWriteTimeout()
The number of seconds to wait for a block to be written to a connection before aborting the
write.
|
Long |
getParserMaxMemSize()
(“parser_max_mem_size”)
|
Long |
getQueryAllocBlockSize()
(“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored
|
Long |
getQueryPreallocSize()
(“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored
|
Integer |
getRegexpTimeLimit()
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)
|
Long |
getSortBufferSize()
Each session that must perform a sort allocates a buffer of this size.
|
String |
getSqlMode()
(“sql_mode”)
|
Boolean |
getSqlRequirePrimaryKey()
(“sql_require_primary_key”)
|
Boolean |
getSqlWarnings()
(“sql_warnings”)
|
Boolean |
getThreadPoolDedicatedListeners()
Controls whether the thread pool uses dedicated listener threads.
|
Integer |
getThreadPoolMaxTransactionsLimit()
Limits the maximum number of open transactions to the defined value.
|
String |
getTimeZone()
Initializes the time zone for each client that connects.
|
Long |
getTmpTableSize()
The maximum size of internal in-memory temporary tables.
|
ConfigurationVariables.TransactionIsolation |
getTransactionIsolation()
(“transaction_isolation”)
|
Integer |
getWaitTimeout()
The number of seconds the server waits for activity on a noninteractive connection before
closing it.
|
int |
hashCode() |
ConfigurationVariables.Builder |
toBuilder() |
String |
toString() |
String |
toString(boolean includeByteArrayContents)
Return a string representation of the object.
|
markPropertyAsExplicitlySet, wasPropertyExplicitlySet@Deprecated @ConstructorProperties(value={"completionType","bigTables","connectionMemoryChunkSize","connectionMemoryLimit","defaultAuthenticationPlugin","globalConnectionMemoryLimit","globalConnectionMemoryTracking","transactionIsolation","innodbFtServerStopwordTable","mandatoryRoles","autocommit","foreignKeyChecks","groupReplicationConsistency","innodbFtEnableStopword","innodbLogWriterThreads","localInfile","mysqlFirewallMode","mysqlxEnableHelloNotice","sqlRequirePrimaryKey","sqlWarnings","binlogExpireLogsSeconds","binlogRowMetadata","binlogRowValueOptions","binlogTransactionCompression","innodbBufferPoolSize","innodbFtResultCacheLimit","maxBinlogCacheSize","maxConnectErrors","maxHeapTableSize","maxConnections","maxPreparedStmtCount","connectTimeout","cteMaxRecursionDepth","generatedRandomPasswordLength","informationSchemaStatsExpiry","innodbBufferPoolDumpPct","innodbBufferPoolInstances","innodbDdlBufferSize","innodbDdlThreads","innodbFtMaxTokenSize","innodbFtMinTokenSize","innodbFtNumWordOptimize","innodbLockWaitTimeout","innodbMaxPurgeLag","innodbMaxPurgeLagDelay","interactiveTimeout","innodbStatsPersistentSamplePages","innodbStatsTransientSamplePages","maxAllowedPacket","maxExecutionTime","mysqlxConnectTimeout","mysqlxDocumentIdUniquePrefix","mysqlxIdleWorkerThreadTimeout","mysqlxInteractiveTimeout","mysqlxMaxAllowedPacket","mysqlxMinWorkerThreads","mysqlxReadTimeout","mysqlxWaitTimeout","mysqlxWriteTimeout","netReadTimeout","netWriteTimeout","parserMaxMemSize","queryAllocBlockSize","queryPreallocSize","regexpTimeLimit","sqlMode","tmpTableSize","mysqlxDeflateDefaultCompressionLevel","mysqlxDeflateMaxClientCompressionLevel","mysqlxLz4MaxClientCompressionLevel","mysqlxLz4DefaultCompressionLevel","mysqlxZstdMaxClientCompressionLevel","mysqlxZstdDefaultCompressionLevel","mysqlZstdDefaultCompressionLevel","sortBufferSize","waitTimeout","threadPoolDedicatedListeners","threadPoolMaxTransactionsLimit","timeZone"}) public ConfigurationVariables(ConfigurationVariables.CompletionType completionType, Boolean bigTables, Integer connectionMemoryChunkSize, Long connectionMemoryLimit, ConfigurationVariables.DefaultAuthenticationPlugin defaultAuthenticationPlugin, Long globalConnectionMemoryLimit, Boolean globalConnectionMemoryTracking, ConfigurationVariables.TransactionIsolation transactionIsolation, String innodbFtServerStopwordTable, String mandatoryRoles, Boolean autocommit, Boolean foreignKeyChecks, ConfigurationVariables.GroupReplicationConsistency groupReplicationConsistency, Boolean innodbFtEnableStopword, Boolean innodbLogWriterThreads, Boolean localInfile, Boolean mysqlFirewallMode, Boolean mysqlxEnableHelloNotice, Boolean sqlRequirePrimaryKey, Boolean sqlWarnings, Integer binlogExpireLogsSeconds, ConfigurationVariables.BinlogRowMetadata binlogRowMetadata, String binlogRowValueOptions, Boolean binlogTransactionCompression, Long innodbBufferPoolSize, Long innodbFtResultCacheLimit, Long maxBinlogCacheSize, Long maxConnectErrors, Long maxHeapTableSize, Integer maxConnections, Integer maxPreparedStmtCount, Integer connectTimeout, Long cteMaxRecursionDepth, Integer generatedRandomPasswordLength, Integer informationSchemaStatsExpiry, Integer innodbBufferPoolDumpPct, Integer innodbBufferPoolInstances, Long innodbDdlBufferSize, Integer innodbDdlThreads, Integer innodbFtMaxTokenSize, Integer innodbFtMinTokenSize, Integer innodbFtNumWordOptimize, Integer innodbLockWaitTimeout, Long innodbMaxPurgeLag, Integer innodbMaxPurgeLagDelay, Integer interactiveTimeout, Long innodbStatsPersistentSamplePages, Long innodbStatsTransientSamplePages, Integer maxAllowedPacket, Long maxExecutionTime, Integer mysqlxConnectTimeout, Integer mysqlxDocumentIdUniquePrefix, Integer mysqlxIdleWorkerThreadTimeout, Integer mysqlxInteractiveTimeout, Integer mysqlxMaxAllowedPacket, Integer mysqlxMinWorkerThreads, Integer mysqlxReadTimeout, Integer mysqlxWaitTimeout, Integer mysqlxWriteTimeout, Integer netReadTimeout, Integer netWriteTimeout, Long parserMaxMemSize, Long queryAllocBlockSize, Long queryPreallocSize, Integer regexpTimeLimit, String sqlMode, Long tmpTableSize, Integer mysqlxDeflateDefaultCompressionLevel, Integer mysqlxDeflateMaxClientCompressionLevel, Integer mysqlxLz4MaxClientCompressionLevel, Integer mysqlxLz4DefaultCompressionLevel, Integer mysqlxZstdMaxClientCompressionLevel, Integer mysqlxZstdDefaultCompressionLevel, Integer mysqlZstdDefaultCompressionLevel, Long sortBufferSize, Integer waitTimeout, Boolean threadPoolDedicatedListeners, Integer threadPoolMaxTransactionsLimit, String timeZone)
public static ConfigurationVariables.Builder builder()
Create a new builder.
public ConfigurationVariables.Builder toBuilder()
public ConfigurationVariables.CompletionType getCompletionType()
(“completion_type”)
public Boolean getBigTables()
If enabled, the server stores all temporary tables on disk rather than in memory.
bigTables corresponds to the MySQL server variable [big_tables](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_big_tables).
public Integer getConnectionMemoryChunkSize()
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](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_connection_memory_chunk_size).
public Long getConnectionMemoryLimit()
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](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_connection_memory_limit).
public ConfigurationVariables.DefaultAuthenticationPlugin getDefaultAuthenticationPlugin()
(“default_authentication_plugin”)
public Long getGlobalConnectionMemoryLimit()
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](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_global_connection_memory_limit).
public Boolean getGlobalConnectionMemoryTracking()
Determines whether the MySQL server calculates Global_connection_memory.
globalConnectionMemoryTracking corresponds to the MySQL system variable [global_connection_memory_tracking](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_global_connection_memory_tracking).
public ConfigurationVariables.TransactionIsolation getTransactionIsolation()
(“transaction_isolation”)
public String getInnodbFtServerStopwordTable()
(“innodb_ft_server_stopword_table”)
public String getMandatoryRoles()
(“mandatory_roles”)
public Boolean getAutocommit()
(“autocommit”)
public Boolean getForeignKeyChecks()
(“foreign_key_checks”)
public ConfigurationVariables.GroupReplicationConsistency getGroupReplicationConsistency()
public Boolean getInnodbFtEnableStopword()
(“innodb_ft_enable_stopword”)
public Boolean getInnodbLogWriterThreads()
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](https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_log_writer_threads)
public Boolean getLocalInfile()
(“local_infile”)
public Boolean getMysqlFirewallMode()
(“mysql_firewall_mode”)
public Boolean getMysqlxEnableHelloNotice()
(“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be ignored
public Boolean getSqlRequirePrimaryKey()
(“sql_require_primary_key”)
public Boolean getSqlWarnings()
(“sql_warnings”)
public Integer getBinlogExpireLogsSeconds()
Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
public ConfigurationVariables.BinlogRowMetadata getBinlogRowMetadata()
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.
public String getBinlogRowValueOptions()
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.
public Boolean getBinlogTransactionCompression()
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.
public Long getInnodbBufferPoolSize()
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](https://dev.mysql.com/doc/refman/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size).
The default and maximum values depend on the amount of RAM provisioned by the shape. See [Default User Variables](https://docs.cloud.oracle.com/mysql-database/doc/configuring-db-system.html#GUID-B5504C19-F6F4-4DAB-8506-189A4E8F4A6A).
public Long getInnodbFtResultCacheLimit()
(“innodb_ft_result_cache_limit”)
public Long getMaxBinlogCacheSize()
Sets the size of the transaction cache.
maxBinlogCacheSize corresponds to the MySQL server system variable [max_binlog_cache_size](https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_max_binlog_cache_size).
public Long getMaxConnectErrors()
(“max_connect_errors”)
public Long getMaxHeapTableSize()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_heap_table_size)
public Integer getMaxConnections()
(“max_connections”)
public Integer getMaxPreparedStmtCount()
(“max_prepared_stmt_count”)
public Integer getConnectTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_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".
public Long getCteMaxRecursionDepth()
(“cte_max_recursion_depth”)
public Integer getGeneratedRandomPasswordLength()
(“generated_random_password_length”) DEPRECATED – variable should not be settable and will be ignored
public Integer getInformationSchemaStatsExpiry()
(“information_schema_stats_expiry”)
public Integer getInnodbBufferPoolDumpPct()
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](https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_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.
public Integer getInnodbBufferPoolInstances()
(“innodb_buffer_pool_instances”)
public Long getInnodbDdlBufferSize()
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)
public Integer getInnodbDdlThreads()
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)
public Integer getInnodbFtMaxTokenSize()
(“innodb_ft_max_token_size”)
public Integer getInnodbFtMinTokenSize()
(“innodb_ft_min_token_size”)
public Integer getInnodbFtNumWordOptimize()
(“innodb_ft_num_word_optimize”)
public Integer getInnodbLockWaitTimeout()
(“innodb_lock_wait_timeout”)
public Long getInnodbMaxPurgeLag()
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](https://dev.mysql.com/doc/refman/en/innodb-parameters.html#sysvar_innodb_max_purge_lag).
public Integer getInnodbMaxPurgeLagDelay()
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](https://dev.mysql.com/doc/refman/en/innodb-parameters.html#sysvar_innodb_max_purge_lag_delay).
public Integer getInteractiveTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_interactive_timeout)
public Long getInnodbStatsPersistentSamplePages()
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](https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_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.
public Long getInnodbStatsTransientSamplePages()
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](https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_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](https://dev.mysql.com/doc/refman/8.0/en/create-table.html) and [ALTER TABLE](https://dev.mysql.com/doc/refman/8.0/en/alter-table.html) statements.
public Integer getMaxAllowedPacket()
The maximum size of one packet or any generated/intermediate string.
This is the mysql variable "max_allowed_packet".
public Long getMaxExecutionTime()
(“max_execution_time”)
public Integer getMysqlxConnectTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html#sysvar_mysqlx_connect_timeout)
public Integer getMysqlxDocumentIdUniquePrefix()
(“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will be ignored
public Integer getMysqlxIdleWorkerThreadTimeout()
(“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will be ignored
public Integer getMysqlxInteractiveTimeout()
The number of seconds to wait for interactive clients to timeout.
mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. [mysqlx_interactive_timeout](https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html#sysvar_mysqlx_interactive_timeout)
public Integer getMysqlxMaxAllowedPacket()
The maximum size of network packets that can be received by X Plugin.
This is the mysql variable "mysqlx_max_allowed_packet".
public Integer getMysqlxMinWorkerThreads()
(“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be ignored
public Integer getMysqlxReadTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html#sysvar_mysqlx_read_timeout)
public Integer getMysqlxWaitTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html#sysvar_mysqlx_wait_timeout)
public Integer getMysqlxWriteTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html#sysvar_mysqlx_write_timeout)
public Integer getNetReadTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_net_read_timeout)
public Integer getNetWriteTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_net_write_timeout)
public Long getParserMaxMemSize()
(“parser_max_mem_size”)
public Long getQueryAllocBlockSize()
(“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored
public Long getQueryPreallocSize()
(“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored
public Integer getRegexpTimeLimit()
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)
public String getSqlMode()
(“sql_mode”)
public Long getTmpTableSize()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmp_table_size)
public Integer getMysqlxDeflateDefaultCompressionLevel()
Set the default compression level for the deflate algorithm. (“mysqlx_deflate_default_compression_level”)
public Integer getMysqlxDeflateMaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the deflate algorithm. (“mysqlx_deflate_max_client_compression_level”)
public Integer getMysqlxLz4MaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the lz4 algorithm. (“mysqlx_lz4_max_client_compression_level”)
public Integer getMysqlxLz4DefaultCompressionLevel()
Set the default compression level for the lz4 algorithm. (“mysqlx_lz4_default_compression_level”)
public Integer getMysqlxZstdMaxClientCompressionLevel()
Limit the upper bound of accepted compression levels for the zstd algorithm. (“mysqlx_zstd_max_client_compression_level”)
public Integer getMysqlxZstdDefaultCompressionLevel()
Set the default compression level for the zstd algorithm. (“mysqlx_zstd_default_compression_level”)
public Integer getMysqlZstdDefaultCompressionLevel()
DEPRECATED – typo of mysqlx_zstd_default_compression_level. variable will be ignored.
public Long getSortBufferSize()
Each session that must perform a sort allocates a buffer of this size.
sortBufferSize corresponds to the MySQL system variable [sort_buffer_size](https://dev.mysql.com/doc/refman/en/server-system-variables.html#sysvar_sort_buffer_size)
public Integer getWaitTimeout()
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](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_wait_timeout)
public Boolean getThreadPoolDedicatedListeners()
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.
public Integer getThreadPoolMaxTransactionsLimit()
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.
public String getTimeZone()
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'.
public String toString()
toString in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic String toString(boolean includeByteArrayContents)
Return a string representation of the object.
includeByteArrayContents - true to include the full contents of byte arrayspublic boolean equals(Object o)
equals in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelpublic int hashCode()
hashCode in class com.oracle.bmc.http.client.internal.ExplicitlySetBmcModelCopyright © 2016–2024. All rights reserved.