Uses of Class
com.oracle.bmc.mysql.model.ConfigurationVariables.Builder

Packages that use ConfigurationVariables.Builder

Package	Description
com.oracle.bmc.mysql.model

Uses of ConfigurationVariables.Builder in com.oracle.bmc.mysql.model

Methods in com.oracle.bmc.mysql.model that return ConfigurationVariables.Builder

Modifier and Type	Method and Description
ConfigurationVariables.Builder	ConfigurationVariables.Builder.autocommit(Boolean autocommit) (“autocommit”)
ConfigurationVariables.Builder	ConfigurationVariables.Builder.autoIncrementIncrement(Integer autoIncrementIncrement) auto_increment_increment and auto_increment_offset are intended for use with circular (source-to-source) replication, and can be used to control the operation of AUTO_INCREMENT columns.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.autoIncrementOffset(Integer autoIncrementOffset) This variable has a default value of 1.
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.binlogGroupCommitSyncDelay(Integer binlogGroupCommitSyncDelay) Controls how many microseconds the binary log commit waits before synchronizing the binary log file to disk.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.binlogGroupCommitSyncNoDelayCount(Integer binlogGroupCommitSyncNoDelayCount) The maximum number of transactions to wait for before aborting the current delay as specified by binlog_group_commit_sync_delay.
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.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.blockEncryptionMode(String blockEncryptionMode) This variable controls the block encryption mode for block-based algorithms such as AES.
static ConfigurationVariables.Builder	ConfigurationVariables.builder() Create a new builder.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.characterSetServer(ConfigurationVariables.CharacterSetServer characterSetServer) The server’s default character set.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.collationServer(ConfigurationVariables.CollationServer collationServer) The server’s default collation.
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) The default authentication plugin.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.explainFormat(ConfigurationVariables.ExplainFormat explainFormat) This variable determines the default output format used by EXPLAIN in the absence of a FORMAT option when displaying a query execution plan.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.explicitDefaultsForTimestamp(Boolean explicitDefaultsForTimestamp) This system variable determines whether the server enables certain nonstandard behaviors for default values and NULL-value handling in TIMESTAMP columns.
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.groupConcatMaxLen(Long groupConcatMaxLen) Specifies the maximum permitted result length in bytes for the GROUP_CONCAT() function.
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.innodbAdaptiveHashIndex(Boolean innodbAdaptiveHashIndex) Whether the InnoDB adaptive hash index is enabled or disabled.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbAutoincLockMode(Integer innodbAutoincLockMode) The lock mode to use for generating auto-increment values.
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.innodbChangeBuffering(ConfigurationVariables.InnodbChangeBuffering innodbChangeBuffering) Whether InnoDB performs change buffering, an optimization that delays write operations to secondary indexes so that the I/O operations can be performed sequentially.
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.innodbNumaInterleave(Boolean innodbNumaInterleave) Enables the NUMA interleave memory policy for allocation of the InnoDB buffer pool.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbOnlineAlterLogMaxSize(Long innodbOnlineAlterLogMaxSize) Specifies an upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbRedoLogCapacity(Long innodbRedoLogCapacity) Defines the amount of disk space occupied by redo log files.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbRollbackOnTimeout(Boolean innodbRollbackOnTimeout) InnoDB rolls back only the last statement on a transaction timeout by default.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbSortBufferSize(Integer innodbSortBufferSize) This variable defines:
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.innodbStrictMode(Boolean innodbStrictMode) When you enable innodbStrictMode, the InnoDB storage engine returns errors instead of warnings for invalid or incompatible table options.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.innodbUndoLogTruncate(Boolean innodbUndoLogTruncate) When enabled, undo tablespaces that exceed the threshold value defined by innodb_max_undo_log_size are marked for truncation.
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.joinBufferSize(Long joinBufferSize) The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use indexes and thus perform full table scans.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.localInfile(Boolean localInfile) This variable controls server-side LOCAL capability for LOAD DATA statements.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.longQueryTime(Integer longQueryTime) If a query takes longer than this many seconds, the server increments the Slow_queries status variable.
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.maxSeeksForKey(Long maxSeeksForKey) Limit the assumed maximum number of seeks when looking up rows based on a key.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.maxUserConnections(Long maxUserConnections) The maximum number of simultaneous connections permitted to any given MySQL user account.
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.optimizerSwitch(String optimizerSwitch) The optimizer_switch system variable enables control over optimizer behavior.
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.rangeOptimizerMaxMemSize(Long rangeOptimizerMaxMemSize) The limit on memory consumption for the range optimizer.
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.relayLogSpaceLimit(Long relayLogSpaceLimit) The maximum amount of space to use for all relay logs.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.replicaNetTimeout(Integer replicaNetTimeout) Specifies the number of seconds to wait for more data or a heartbeat signal from the source before the replica considers the connection broken, aborts the read, and tries to reconnect.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.replicaParallelWorkers(Integer replicaParallelWorkers) Beginning with MySQL 8.0.26, slave_parallel_workers is deprecated, and you should use replica_parallel_workers instead.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.replicaTypeConversions(String replicaTypeConversions) From MySQL 8.0.26, use replica_type_conversions in place of slave_type_conversions, which is deprecated from that release.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.requireSecureTransport(Boolean requireSecureTransport) Whether client connections to the server are required to use some form of secure transport.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.skipNameResolve(Boolean skipNameResolve) Whether to resolve host names when checking client connections.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.sortBufferSize(Long sortBufferSize) Each session that must perform a sort allocates a buffer of this size.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.sqlGenerateInvisiblePrimaryKey(Boolean sqlGenerateInvisiblePrimaryKey) Whether GIPK mode is in effect, in which case a MySQL replication source server adds a generated invisible primary key to any InnoDB table that is created without one.
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.tableDefinitionCache(Integer tableDefinitionCache) The number of table definitions that can be stored in the table definition cache.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.tableOpenCache(Integer tableOpenCache) The number of open tables for all threads.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.temptableMaxRam(Long temptableMaxRam) Defines the maximum amount of memory that can be occupied by the TempTable storage engine before it starts storing data on disk.
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.threadPoolQueryThreadsPerGroup(Integer threadPoolQueryThreadsPerGroup) The maximum number of query threads permitted in a thread group.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.threadPoolSize(Integer threadPoolSize) The number of thread groups in the thread pool.
ConfigurationVariables.Builder	ConfigurationVariables.Builder.threadPoolTransactionDelay(Integer threadPoolTransactionDelay) The delay period before executing a new transaction, in milliseconds.
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.