Package | Description |
---|---|
com.oracle.bmc.mysql.model |
Modifier and Type | Method and Description |
---|---|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.autocommit(Boolean autocommit)
(“autocommit”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.bigTables(Boolean bigTables)
If enabled, the server stores all temporary tables on disk rather than in memory.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.binlogExpireLogsSeconds(Integer binlogExpireLogsSeconds)
Sets the binary log expiration period in seconds.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.binlogRowMetadata(ConfigurationVariables.BinlogRowMetadata binlogRowMetadata)
Configures the amount of table metadata added to the binary log when using row-based
logging.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.binlogRowValueOptions(String binlogRowValueOptions)
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.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.binlogTransactionCompression(Boolean binlogTransactionCompression)
Enables compression for transactions that are written to binary log files on this server.
|
static ConfigurationVariables.Builder |
ConfigurationVariables.builder()
Create a new builder.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.completionType(ConfigurationVariables.CompletionType completionType)
(“completion_type”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.connectionMemoryChunkSize(Integer connectionMemoryChunkSize)
Set the chunking size for updates to the global memory usage counter
Global_connection_memory.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.connectionMemoryLimit(Long connectionMemoryLimit)
Set the maximum amount of memory that can be used by a single user connection.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.connectTimeout(Integer connectTimeout)
The number of seconds that the mysqld server waits for a connect packet before responding
with Bad handshake.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.copy(ConfigurationVariables model) |
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.cteMaxRecursionDepth(Long cteMaxRecursionDepth)
(“cte_max_recursion_depth”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.defaultAuthenticationPlugin(ConfigurationVariables.DefaultAuthenticationPlugin defaultAuthenticationPlugin)
(“default_authentication_plugin”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.foreignKeyChecks(Boolean foreignKeyChecks)
(“foreign_key_checks”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.generatedRandomPasswordLength(Integer generatedRandomPasswordLength)
(“generated_random_password_length”) DEPRECATED – variable should not be settable and
will be ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.globalConnectionMemoryLimit(Long globalConnectionMemoryLimit)
Set the total amount of memory that can be used by all user connections.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.globalConnectionMemoryTracking(Boolean globalConnectionMemoryTracking)
Determines whether the MySQL server calculates Global_connection_memory.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.groupReplicationConsistency(ConfigurationVariables.GroupReplicationConsistency groupReplicationConsistency)
EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be
applied before executing.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.informationSchemaStatsExpiry(Integer informationSchemaStatsExpiry)
(“information_schema_stats_expiry”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbBufferPoolDumpPct(Integer innodbBufferPoolDumpPct)
Specifies the percentage of the most recently used pages for each buffer pool to read out
and dump.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbBufferPoolInstances(Integer innodbBufferPoolInstances)
(“innodb_buffer_pool_instances”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbBufferPoolSize(Long innodbBufferPoolSize)
The size (in bytes) of the buffer pool, that is, the memory area where InnoDB caches
table and index data.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbDdlBufferSize(Long innodbDdlBufferSize)
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)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbDdlThreads(Integer innodbDdlThreads)
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)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtEnableStopword(Boolean innodbFtEnableStopword)
(“innodb_ft_enable_stopword”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtMaxTokenSize(Integer innodbFtMaxTokenSize)
(“innodb_ft_max_token_size”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtMinTokenSize(Integer innodbFtMinTokenSize)
(“innodb_ft_min_token_size”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtNumWordOptimize(Integer innodbFtNumWordOptimize)
(“innodb_ft_num_word_optimize”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtResultCacheLimit(Long innodbFtResultCacheLimit)
(“innodb_ft_result_cache_limit”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbFtServerStopwordTable(String innodbFtServerStopwordTable)
(“innodb_ft_server_stopword_table”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbLockWaitTimeout(Integer innodbLockWaitTimeout)
(“innodb_lock_wait_timeout”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbLogWriterThreads(Boolean innodbLogWriterThreads)
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.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbMaxPurgeLag(Long innodbMaxPurgeLag)
The desired maximum purge lag in terms of transactions.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbMaxPurgeLagDelay(Integer innodbMaxPurgeLagDelay)
The maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag
threshold is exceeded.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbStatsPersistentSamplePages(Long innodbStatsPersistentSamplePages)
The number of index pages to sample when estimating cardinality and other statistics for
an indexed column, such as those calculated by ANALYZE TABLE.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.innodbStatsTransientSamplePages(Long innodbStatsTransientSamplePages)
The number of index pages to sample when estimating cardinality and other statistics for
an indexed column, such as those calculated by ANALYZE
TABLE.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.interactiveTimeout(Integer interactiveTimeout)
The number of seconds the server waits for activity on an interactive connection before
closing it.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.localInfile(Boolean localInfile)
(“local_infile”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mandatoryRoles(String mandatoryRoles)
(“mandatory_roles”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxAllowedPacket(Integer maxAllowedPacket)
The maximum size of one packet or any generated/intermediate string.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxBinlogCacheSize(Long maxBinlogCacheSize)
Sets the size of the transaction cache.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxConnectErrors(Long maxConnectErrors)
(“max_connect_errors”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxConnections(Integer maxConnections)
(“max_connections”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxExecutionTime(Long maxExecutionTime)
(“max_execution_time”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxHeapTableSize(Long maxHeapTableSize)
This variable sets the maximum size to which user-created MEMORY tables are permitted to
grow.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.maxPreparedStmtCount(Integer maxPreparedStmtCount)
(“max_prepared_stmt_count”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlFirewallMode(Boolean mysqlFirewallMode)
(“mysql_firewall_mode”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxConnectTimeout(Integer mysqlxConnectTimeout)
The number of seconds X Plugin waits for the first packet to be received from newly
connected clients.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxDeflateDefaultCompressionLevel(Integer mysqlxDeflateDefaultCompressionLevel)
Set the default compression level for the deflate algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxDeflateMaxClientCompressionLevel(Integer mysqlxDeflateMaxClientCompressionLevel)
Limit the upper bound of accepted compression levels for the deflate algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxDocumentIdUniquePrefix(Integer mysqlxDocumentIdUniquePrefix)
(“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and
will be ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxEnableHelloNotice(Boolean mysqlxEnableHelloNotice)
(“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be
ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxIdleWorkerThreadTimeout(Integer mysqlxIdleWorkerThreadTimeout)
(“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and
will be ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxInteractiveTimeout(Integer mysqlxInteractiveTimeout)
The number of seconds to wait for interactive clients to timeout.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxLz4DefaultCompressionLevel(Integer mysqlxLz4DefaultCompressionLevel)
Set the default compression level for the lz4 algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxLz4MaxClientCompressionLevel(Integer mysqlxLz4MaxClientCompressionLevel)
Limit the upper bound of accepted compression levels for the lz4 algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxMaxAllowedPacket(Integer mysqlxMaxAllowedPacket)
The maximum size of network packets that can be received by X Plugin.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxMinWorkerThreads(Integer mysqlxMinWorkerThreads)
(“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be
ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxReadTimeout(Integer mysqlxReadTimeout)
The number of seconds that X Plugin waits for blocking read operations to complete.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxWaitTimeout(Integer mysqlxWaitTimeout)
The number of seconds that X Plugin waits for activity on a connection.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxWriteTimeout(Integer mysqlxWriteTimeout)
The number of seconds that X Plugin waits for blocking write operations to complete.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxZstdDefaultCompressionLevel(Integer mysqlxZstdDefaultCompressionLevel)
Set the default compression level for the zstd algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlxZstdMaxClientCompressionLevel(Integer mysqlxZstdMaxClientCompressionLevel)
Limit the upper bound of accepted compression levels for the zstd algorithm.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.mysqlZstdDefaultCompressionLevel(Integer mysqlZstdDefaultCompressionLevel)
DEPRECATED – typo of mysqlx_zstd_default_compression_level.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.netReadTimeout(Integer netReadTimeout)
The number of seconds to wait for more data from a connection before aborting the read.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.netWriteTimeout(Integer netWriteTimeout)
The number of seconds to wait for a block to be written to a connection before aborting
the write.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.parserMaxMemSize(Long parserMaxMemSize)
(“parser_max_mem_size”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.queryAllocBlockSize(Long queryAllocBlockSize)
(“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be
ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.queryPreallocSize(Long queryPreallocSize)
(“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.regexpTimeLimit(Integer regexpTimeLimit)
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)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.sortBufferSize(Long sortBufferSize)
Each session that must perform a sort allocates a buffer of this size.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.sqlMode(String sqlMode)
(“sql_mode”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.sqlRequirePrimaryKey(Boolean sqlRequirePrimaryKey)
(“sql_require_primary_key”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.sqlWarnings(Boolean sqlWarnings)
(“sql_warnings”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.threadPoolDedicatedListeners(Boolean threadPoolDedicatedListeners)
Controls whether the thread pool uses dedicated listener threads.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.threadPoolMaxTransactionsLimit(Integer threadPoolMaxTransactionsLimit)
Limits the maximum number of open transactions to the defined value.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.timeZone(String timeZone)
Initializes the time zone for each client that connects.
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.tmpTableSize(Long tmpTableSize)
The maximum size of internal in-memory temporary tables.
|
ConfigurationVariables.Builder |
ConfigurationVariables.toBuilder() |
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.transactionIsolation(ConfigurationVariables.TransactionIsolation transactionIsolation)
(“transaction_isolation”)
|
ConfigurationVariables.Builder |
ConfigurationVariables.Builder.waitTimeout(Integer waitTimeout)
The number of seconds the server waits for activity on a noninteractive connection before
closing it.
|
Copyright © 2016–2024. All rights reserved.