ConfigurationVariables.Builder (Oracle Cloud Infrastructure Java SDK

java.lang.Object
- com.oracle.bmc.mysql.model.ConfigurationVariables.Builder

Enclosing class:: ConfigurationVariables

public static class ConfigurationVariables.Builder
extends Object

Constructor Summary

Constructors
Constructor and Description

Builder()

Constructors
Constructor and Description
`Builder()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`ConfigurationVariables.Builder`	`autocommit(Boolean autocommit)` (“autocommit”)
`ConfigurationVariables.Builder`	`bigTables(Boolean bigTables)` If enabled, the server stores all temporary tables on disk rather than in memory.
`ConfigurationVariables.Builder`	`binlogExpireLogsSeconds(Integer binlogExpireLogsSeconds)` Sets the binary log expiration period in seconds.
`ConfigurationVariables.Builder`	`binlogRowMetadata(ConfigurationVariables.BinlogRowMetadata binlogRowMetadata)` Configures the amount of table metadata added to the binary log when using row-based logging.
`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`	`binlogTransactionCompression(Boolean binlogTransactionCompression)` Enables compression for transactions that are written to binary log files on this server.
`ConfigurationVariables`	`build()`
`ConfigurationVariables.Builder`	`completionType(ConfigurationVariables.CompletionType completionType)` (“completion_type”)
`ConfigurationVariables.Builder`	`connectionMemoryChunkSize(Integer connectionMemoryChunkSize)` Set the chunking size for updates to the global memory usage counter Global_connection_memory.
`ConfigurationVariables.Builder`	`connectionMemoryLimit(Long connectionMemoryLimit)` Set the maximum amount of memory that can be used by a single user connection.
`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`	`copy(ConfigurationVariables model)`
`ConfigurationVariables.Builder`	`cteMaxRecursionDepth(Long cteMaxRecursionDepth)` (“cte_max_recursion_depth”)
`ConfigurationVariables.Builder`	`defaultAuthenticationPlugin(ConfigurationVariables.DefaultAuthenticationPlugin defaultAuthenticationPlugin)` (“default_authentication_plugin”)
`ConfigurationVariables.Builder`	`foreignKeyChecks(Boolean foreignKeyChecks)` (“foreign_key_checks”)
`ConfigurationVariables.Builder`	`generatedRandomPasswordLength(Integer generatedRandomPasswordLength)` (“generated_random_password_length”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`globalConnectionMemoryLimit(Long globalConnectionMemoryLimit)` Set the total amount of memory that can be used by all user connections.
`ConfigurationVariables.Builder`	`globalConnectionMemoryTracking(Boolean globalConnectionMemoryTracking)` Determines whether the MySQL server calculates Global_connection_memory.
`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`	`informationSchemaStatsExpiry(Integer informationSchemaStatsExpiry)` (“information_schema_stats_expiry”)
`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`	`innodbBufferPoolInstances(Integer innodbBufferPoolInstances)` (“innodb_buffer_pool_instances”)
`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`	`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`	`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`	`innodbFtEnableStopword(Boolean innodbFtEnableStopword)` (“innodb_ft_enable_stopword”)
`ConfigurationVariables.Builder`	`innodbFtMaxTokenSize(Integer innodbFtMaxTokenSize)` (“innodb_ft_max_token_size”)
`ConfigurationVariables.Builder`	`innodbFtMinTokenSize(Integer innodbFtMinTokenSize)` (“innodb_ft_min_token_size”)
`ConfigurationVariables.Builder`	`innodbFtNumWordOptimize(Integer innodbFtNumWordOptimize)` (“innodb_ft_num_word_optimize”)
`ConfigurationVariables.Builder`	`innodbFtResultCacheLimit(Long innodbFtResultCacheLimit)` (“innodb_ft_result_cache_limit”)
`ConfigurationVariables.Builder`	`innodbFtServerStopwordTable(String innodbFtServerStopwordTable)` (“innodb_ft_server_stopword_table”)
`ConfigurationVariables.Builder`	`innodbLockWaitTimeout(Integer innodbLockWaitTimeout)` (“innodb_lock_wait_timeout”)
`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`	`innodbMaxPurgeLag(Long innodbMaxPurgeLag)` The desired maximum purge lag in terms of transactions.
`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`	`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`	`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`	`interactiveTimeout(Integer interactiveTimeout)` The number of seconds the server waits for activity on an interactive connection before closing it.
`ConfigurationVariables.Builder`	`localInfile(Boolean localInfile)` (“local_infile”)
`ConfigurationVariables.Builder`	`mandatoryRoles(String mandatoryRoles)` (“mandatory_roles”)
`ConfigurationVariables.Builder`	`maxAllowedPacket(Integer maxAllowedPacket)` The maximum size of one packet or any generated/intermediate string.
`ConfigurationVariables.Builder`	`maxBinlogCacheSize(Long maxBinlogCacheSize)` Sets the size of the transaction cache.
`ConfigurationVariables.Builder`	`maxConnectErrors(Long maxConnectErrors)` (“max_connect_errors”)
`ConfigurationVariables.Builder`	`maxConnections(Integer maxConnections)` (“max_connections”)
`ConfigurationVariables.Builder`	`maxExecutionTime(Long maxExecutionTime)` (“max_execution_time”)
`ConfigurationVariables.Builder`	`maxHeapTableSize(Long maxHeapTableSize)` This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.
`ConfigurationVariables.Builder`	`maxPreparedStmtCount(Integer maxPreparedStmtCount)` (“max_prepared_stmt_count”)
`ConfigurationVariables.Builder`	`mysqlFirewallMode(Boolean mysqlFirewallMode)` (“mysql_firewall_mode”)
`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`	`mysqlxDeflateDefaultCompressionLevel(Integer mysqlxDeflateDefaultCompressionLevel)` Set the default compression level for the deflate algorithm.
`ConfigurationVariables.Builder`	`mysqlxDeflateMaxClientCompressionLevel(Integer mysqlxDeflateMaxClientCompressionLevel)` Limit the upper bound of accepted compression levels for the deflate algorithm.
`ConfigurationVariables.Builder`	`mysqlxDocumentIdUniquePrefix(Integer mysqlxDocumentIdUniquePrefix)` (“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`mysqlxEnableHelloNotice(Boolean mysqlxEnableHelloNotice)` (“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`mysqlxIdleWorkerThreadTimeout(Integer mysqlxIdleWorkerThreadTimeout)` (“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`mysqlxInteractiveTimeout(Integer mysqlxInteractiveTimeout)` The number of seconds to wait for interactive clients to timeout.
`ConfigurationVariables.Builder`	`mysqlxLz4DefaultCompressionLevel(Integer mysqlxLz4DefaultCompressionLevel)` Set the default compression level for the lz4 algorithm.
`ConfigurationVariables.Builder`	`mysqlxLz4MaxClientCompressionLevel(Integer mysqlxLz4MaxClientCompressionLevel)` Limit the upper bound of accepted compression levels for the lz4 algorithm.
`ConfigurationVariables.Builder`	`mysqlxMaxAllowedPacket(Integer mysqlxMaxAllowedPacket)` The maximum size of network packets that can be received by X Plugin.
`ConfigurationVariables.Builder`	`mysqlxMinWorkerThreads(Integer mysqlxMinWorkerThreads)` (“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`mysqlxReadTimeout(Integer mysqlxReadTimeout)` The number of seconds that X Plugin waits for blocking read operations to complete.
`ConfigurationVariables.Builder`	`mysqlxWaitTimeout(Integer mysqlxWaitTimeout)` The number of seconds that X Plugin waits for activity on a connection.
`ConfigurationVariables.Builder`	`mysqlxWriteTimeout(Integer mysqlxWriteTimeout)` The number of seconds that X Plugin waits for blocking write operations to complete.
`ConfigurationVariables.Builder`	`mysqlxZstdDefaultCompressionLevel(Integer mysqlxZstdDefaultCompressionLevel)` Set the default compression level for the zstd algorithm.
`ConfigurationVariables.Builder`	`mysqlxZstdMaxClientCompressionLevel(Integer mysqlxZstdMaxClientCompressionLevel)` Limit the upper bound of accepted compression levels for the zstd algorithm.
`ConfigurationVariables.Builder`	`mysqlZstdDefaultCompressionLevel(Integer mysqlZstdDefaultCompressionLevel)` DEPRECATED – typo of mysqlx_zstd_default_compression_level.
`ConfigurationVariables.Builder`	`netReadTimeout(Integer netReadTimeout)` The number of seconds to wait for more data from a connection before aborting the read.
`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`	`parserMaxMemSize(Long parserMaxMemSize)` (“parser_max_mem_size”)
`ConfigurationVariables.Builder`	`queryAllocBlockSize(Long queryAllocBlockSize)` (“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored
`ConfigurationVariables.Builder`	`queryPreallocSize(Long queryPreallocSize)` (“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored
`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`	`sortBufferSize(Long sortBufferSize)` Each session that must perform a sort allocates a buffer of this size.
`ConfigurationVariables.Builder`	`sqlMode(String sqlMode)` (“sql_mode”)
`ConfigurationVariables.Builder`	`sqlRequirePrimaryKey(Boolean sqlRequirePrimaryKey)` (“sql_require_primary_key”)
`ConfigurationVariables.Builder`	`sqlWarnings(Boolean sqlWarnings)` (“sql_warnings”)
`ConfigurationVariables.Builder`	`threadPoolDedicatedListeners(Boolean threadPoolDedicatedListeners)` Controls whether the thread pool uses dedicated listener threads.
`ConfigurationVariables.Builder`	`threadPoolMaxTransactionsLimit(Integer threadPoolMaxTransactionsLimit)` Limits the maximum number of open transactions to the defined value.
`ConfigurationVariables.Builder`	`timeZone(String timeZone)` Initializes the time zone for each client that connects.
`ConfigurationVariables.Builder`	`tmpTableSize(Long tmpTableSize)` The maximum size of internal in-memory temporary tables.
`ConfigurationVariables.Builder`	`transactionIsolation(ConfigurationVariables.TransactionIsolation transactionIsolation)` (“transaction_isolation”)
`ConfigurationVariables.Builder`	`waitTimeout(Integer waitTimeout)` The number of seconds the server waits for activity on a noninteractive connection before closing it.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Builder
```
public Builder()
```
- Method Detail
  - completionType
```
public ConfigurationVariables.Builder completionType(ConfigurationVariables.CompletionType completionType)
```
    (“completion_type”)
    
    Parameters:
    
    completionType - the value to set
    
    Returns:
    
    this builder
  - bigTables
```
public ConfigurationVariables.Builder bigTables(Boolean bigTables)
```
    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).
    
    Parameters:
    
    bigTables - the value to set
    
    Returns:
    
    this builder
  - connectionMemoryChunkSize
```
public ConfigurationVariables.Builder connectionMemoryChunkSize(Integer connectionMemoryChunkSize)
```
    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).
    
    Parameters:
    
    connectionMemoryChunkSize - the value to set
    
    Returns:
    
    this builder
  - connectionMemoryLimit
```
public ConfigurationVariables.Builder connectionMemoryLimit(Long connectionMemoryLimit)
```
    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).
    
    Parameters:
    
    connectionMemoryLimit - the value to set
    
    Returns:
    
    this builder
  - defaultAuthenticationPlugin
```
public ConfigurationVariables.Builder defaultAuthenticationPlugin(ConfigurationVariables.DefaultAuthenticationPlugin defaultAuthenticationPlugin)
```
    (“default_authentication_plugin”)
    
    Parameters:
    
    defaultAuthenticationPlugin - the value to set
    
    Returns:
    
    this builder
  - globalConnectionMemoryLimit
```
public ConfigurationVariables.Builder globalConnectionMemoryLimit(Long globalConnectionMemoryLimit)
```
    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).
    
    Parameters:
    
    globalConnectionMemoryLimit - the value to set
    
    Returns:
    
    this builder
  - globalConnectionMemoryTracking
```
public ConfigurationVariables.Builder globalConnectionMemoryTracking(Boolean globalConnectionMemoryTracking)
```
    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).
    
    Parameters:
    
    globalConnectionMemoryTracking - the value to set
    
    Returns:
    
    this builder
  - transactionIsolation
```
public ConfigurationVariables.Builder transactionIsolation(ConfigurationVariables.TransactionIsolation transactionIsolation)
```
    (“transaction_isolation”)
    
    Parameters:
    
    transactionIsolation - the value to set
    
    Returns:
    
    this builder
  - innodbFtServerStopwordTable
```
public ConfigurationVariables.Builder innodbFtServerStopwordTable(String innodbFtServerStopwordTable)
```
    (“innodb_ft_server_stopword_table”)
    
    Parameters:
    
    innodbFtServerStopwordTable - the value to set
    
    Returns:
    
    this builder
  - mandatoryRoles
```
public ConfigurationVariables.Builder mandatoryRoles(String mandatoryRoles)
```
    (“mandatory_roles”)
    
    Parameters:
    
    mandatoryRoles - the value to set
    
    Returns:
    
    this builder
  - autocommit
```
public ConfigurationVariables.Builder autocommit(Boolean autocommit)
```
    (“autocommit”)
    
    Parameters:
    
    autocommit - the value to set
    
    Returns:
    
    this builder
  - foreignKeyChecks
```
public ConfigurationVariables.Builder foreignKeyChecks(Boolean foreignKeyChecks)
```
    (“foreign_key_checks”)
    
    Parameters:
    
    foreignKeyChecks - the value to set
    
    Returns:
    
    this builder
  - groupReplicationConsistency
```
public ConfigurationVariables.Builder groupReplicationConsistency(ConfigurationVariables.GroupReplicationConsistency groupReplicationConsistency)
```
    - EVENTUAL: Both RO and RW transactions do not wait for preceding transactions to be applied before executing. A RW transaction does not wait for other members to apply a transaction. This means that a transaction could be externalized on one member before the others. This also means that in the event of a primary failover, the new primary can accept new RO and RW transactions before the previous primary transactions are all applied. RO transactions could result in outdated values, RW transactions could result in a rollback due to conflicts. - BEFORE_ON_PRIMARY_FAILOVER: New RO or RW transactions with a newly elected primary that is applying backlog from the old primary are held (not applied) until any backlog has been applied. This ensures that when a primary failover happens, intentionally or not, clients always see the latest value on the primary. This guarantees consistency, but means that clients must be able to handle the delay in the event that a backlog is being applied. Usually this delay should be minimal, but does depend on the size of the backlog. - BEFORE: A RW transaction waits for all preceding transactions to complete before being applied. A RO transaction waits for all preceding transactions to complete before being executed. This ensures that this transaction reads the latest value by only affecting the latency of the transaction. This reduces the overhead of synchronization on every RW transaction, by ensuring synchronization is used only on RO transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER. - AFTER: A RW transaction waits until its changes have been applied to all of the other members. This value has no effect on RO transactions. This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly RO operations to ensure that applied RW transactions are applied everywhere once they commit. This could be used by your application to ensure that subsequent reads fetch the latest data which includes the latest writes. This reduces the overhead of synchronization on every RO transaction, by ensuring synchronization is used only on RW transactions. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER. - BEFORE_AND_AFTER: A RW transaction waits for 1) all preceding transactions to complete before being applied and 2) until its changes have been applied on other members. A RO transaction waits for all preceding transactions to complete before execution takes place. This consistency level also includes the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER.
    Parameters:
    
    groupReplicationConsistency - the value to set
    
    Returns:
    
    this builder
  - innodbFtEnableStopword
```
public ConfigurationVariables.Builder innodbFtEnableStopword(Boolean innodbFtEnableStopword)
```
    (“innodb_ft_enable_stopword”)
    
    Parameters:
    
    innodbFtEnableStopword - the value to set
    
    Returns:
    
    this builder
  - innodbLogWriterThreads
```
public 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.
    
    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)
    
    Parameters:
    
    innodbLogWriterThreads - the value to set
    
    Returns:
    
    this builder
  - localInfile
```
public ConfigurationVariables.Builder localInfile(Boolean localInfile)
```
    (“local_infile”)
    
    Parameters:
    
    localInfile - the value to set
    
    Returns:
    
    this builder
  - mysqlFirewallMode
```
public ConfigurationVariables.Builder mysqlFirewallMode(Boolean mysqlFirewallMode)
```
    (“mysql_firewall_mode”)
    
    Parameters:
    
    mysqlFirewallMode - the value to set
    
    Returns:
    
    this builder
  - mysqlxEnableHelloNotice
```
public ConfigurationVariables.Builder mysqlxEnableHelloNotice(Boolean mysqlxEnableHelloNotice)
```
    (“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    mysqlxEnableHelloNotice - the value to set
    
    Returns:
    
    this builder
  - sqlRequirePrimaryKey
```
public ConfigurationVariables.Builder sqlRequirePrimaryKey(Boolean sqlRequirePrimaryKey)
```
    (“sql_require_primary_key”)
    
    Parameters:
    
    sqlRequirePrimaryKey - the value to set
    
    Returns:
    
    this builder
  - sqlWarnings
```
public ConfigurationVariables.Builder sqlWarnings(Boolean sqlWarnings)
```
    (“sql_warnings”)
    
    Parameters:
    
    sqlWarnings - the value to set
    
    Returns:
    
    this builder
  - binlogExpireLogsSeconds
```
public ConfigurationVariables.Builder binlogExpireLogsSeconds(Integer binlogExpireLogsSeconds)
```
    Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.
    
    Parameters:
    
    binlogExpireLogsSeconds - the value to set
    
    Returns:
    
    this builder
  - binlogRowMetadata
```
public ConfigurationVariables.Builder binlogRowMetadata(ConfigurationVariables.BinlogRowMetadata binlogRowMetadata)
```
    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.
    
    Parameters:
    
    binlogRowMetadata - the value to set
    
    Returns:
    
    this builder
  - binlogRowValueOptions
```
public 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. binlogRowValueOptions corresponds to the MySQL binary logging system variable binlog_row_value_options.
    
    Parameters:
    
    binlogRowValueOptions - the value to set
    
    Returns:
    
    this builder
  - binlogTransactionCompression
```
public ConfigurationVariables.Builder binlogTransactionCompression(Boolean binlogTransactionCompression)
```
    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.
    
    Parameters:
    
    binlogTransactionCompression - the value to set
    
    Returns:
    
    this builder
  - innodbBufferPoolSize
```
public 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.
    
    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).
    
    Parameters:
    
    innodbBufferPoolSize - the value to set
    
    Returns:
    
    this builder
  - innodbFtResultCacheLimit
```
public ConfigurationVariables.Builder innodbFtResultCacheLimit(Long innodbFtResultCacheLimit)
```
    (“innodb_ft_result_cache_limit”)
    
    Parameters:
    
    innodbFtResultCacheLimit - the value to set
    
    Returns:
    
    this builder
  - maxBinlogCacheSize
```
public ConfigurationVariables.Builder maxBinlogCacheSize(Long maxBinlogCacheSize)
```
    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).
    
    Parameters:
    
    maxBinlogCacheSize - the value to set
    
    Returns:
    
    this builder
  - maxConnectErrors
```
public ConfigurationVariables.Builder maxConnectErrors(Long maxConnectErrors)
```
    (“max_connect_errors”)
    
    Parameters:
    
    maxConnectErrors - the value to set
    
    Returns:
    
    this builder
  - maxHeapTableSize
```
public ConfigurationVariables.Builder maxHeapTableSize(Long maxHeapTableSize)
```
    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)
    
    Parameters:
    
    maxHeapTableSize - the value to set
    
    Returns:
    
    this builder
  - maxConnections
```
public ConfigurationVariables.Builder maxConnections(Integer maxConnections)
```
    (“max_connections”)
    
    Parameters:
    
    maxConnections - the value to set
    
    Returns:
    
    this builder
  - maxPreparedStmtCount
```
public ConfigurationVariables.Builder maxPreparedStmtCount(Integer maxPreparedStmtCount)
```
    (“max_prepared_stmt_count”)
    
    Parameters:
    
    maxPreparedStmtCount - the value to set
    
    Returns:
    
    this builder
  - connectTimeout
```
public ConfigurationVariables.Builder connectTimeout(Integer connectTimeout)
```
    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".
    
    Parameters:
    
    connectTimeout - the value to set
    
    Returns:
    
    this builder
  - cteMaxRecursionDepth
```
public ConfigurationVariables.Builder cteMaxRecursionDepth(Long cteMaxRecursionDepth)
```
    (“cte_max_recursion_depth”)
    
    Parameters:
    
    cteMaxRecursionDepth - the value to set
    
    Returns:
    
    this builder
  - generatedRandomPasswordLength
```
public ConfigurationVariables.Builder generatedRandomPasswordLength(Integer generatedRandomPasswordLength)
```
    (“generated_random_password_length”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    generatedRandomPasswordLength - the value to set
    
    Returns:
    
    this builder
  - informationSchemaStatsExpiry
```
public ConfigurationVariables.Builder informationSchemaStatsExpiry(Integer informationSchemaStatsExpiry)
```
    (“information_schema_stats_expiry”)
    
    Parameters:
    
    informationSchemaStatsExpiry - the value to set
    
    Returns:
    
    this builder
  - innodbBufferPoolDumpPct
```
public ConfigurationVariables.Builder innodbBufferPoolDumpPct(Integer innodbBufferPoolDumpPct)
```
    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.
    
    Parameters:
    
    innodbBufferPoolDumpPct - the value to set
    
    Returns:
    
    this builder
  - innodbBufferPoolInstances
```
public ConfigurationVariables.Builder innodbBufferPoolInstances(Integer innodbBufferPoolInstances)
```
    (“innodb_buffer_pool_instances”)
    
    Parameters:
    
    innodbBufferPoolInstances - the value to set
    
    Returns:
    
    this builder
  - innodbDdlBufferSize
```
public 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)
    
    Parameters:
    
    innodbDdlBufferSize - the value to set
    
    Returns:
    
    this builder
  - innodbDdlThreads
```
public 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)
    
    Parameters:
    
    innodbDdlThreads - the value to set
    
    Returns:
    
    this builder
  - innodbFtMaxTokenSize
```
public ConfigurationVariables.Builder innodbFtMaxTokenSize(Integer innodbFtMaxTokenSize)
```
    (“innodb_ft_max_token_size”)
    
    Parameters:
    
    innodbFtMaxTokenSize - the value to set
    
    Returns:
    
    this builder
  - innodbFtMinTokenSize
```
public ConfigurationVariables.Builder innodbFtMinTokenSize(Integer innodbFtMinTokenSize)
```
    (“innodb_ft_min_token_size”)
    
    Parameters:
    
    innodbFtMinTokenSize - the value to set
    
    Returns:
    
    this builder
  - innodbFtNumWordOptimize
```
public ConfigurationVariables.Builder innodbFtNumWordOptimize(Integer innodbFtNumWordOptimize)
```
    (“innodb_ft_num_word_optimize”)
    
    Parameters:
    
    innodbFtNumWordOptimize - the value to set
    
    Returns:
    
    this builder
  - innodbLockWaitTimeout
```
public ConfigurationVariables.Builder innodbLockWaitTimeout(Integer innodbLockWaitTimeout)
```
    (“innodb_lock_wait_timeout”)
    
    Parameters:
    
    innodbLockWaitTimeout - the value to set
    
    Returns:
    
    this builder
  - innodbMaxPurgeLag
```
public ConfigurationVariables.Builder innodbMaxPurgeLag(Long innodbMaxPurgeLag)
```
    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).
    
    Parameters:
    
    innodbMaxPurgeLag - the value to set
    
    Returns:
    
    this builder
  - innodbMaxPurgeLagDelay
```
public ConfigurationVariables.Builder innodbMaxPurgeLagDelay(Integer innodbMaxPurgeLagDelay)
```
    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).
    
    Parameters:
    
    innodbMaxPurgeLagDelay - the value to set
    
    Returns:
    
    this builder
  - interactiveTimeout
```
public ConfigurationVariables.Builder interactiveTimeout(Integer interactiveTimeout)
```
    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)
    
    Parameters:
    
    interactiveTimeout - the value to set
    
    Returns:
    
    this builder
  - innodbStatsPersistentSamplePages
```
public 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.
    
    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.
    
    Parameters:
    
    innodbStatsPersistentSamplePages - the value to set
    
    Returns:
    
    this builder
  - innodbStatsTransientSamplePages
```
public 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.
    
    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.
    
    Parameters:
    
    innodbStatsTransientSamplePages - the value to set
    
    Returns:
    
    this builder
  - maxAllowedPacket
```
public ConfigurationVariables.Builder maxAllowedPacket(Integer maxAllowedPacket)
```
    The maximum size of one packet or any generated/intermediate string.
    
    This is the mysql variable "max_allowed_packet".
    
    Parameters:
    
    maxAllowedPacket - the value to set
    
    Returns:
    
    this builder
  - maxExecutionTime
```
public ConfigurationVariables.Builder maxExecutionTime(Long maxExecutionTime)
```
    (“max_execution_time”)
    
    Parameters:
    
    maxExecutionTime - the value to set
    
    Returns:
    
    this builder
  - mysqlxConnectTimeout
```
public ConfigurationVariables.Builder mysqlxConnectTimeout(Integer mysqlxConnectTimeout)
```
    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)
    
    Parameters:
    
    mysqlxConnectTimeout - the value to set
    
    Returns:
    
    this builder
  - mysqlxDocumentIdUniquePrefix
```
public ConfigurationVariables.Builder mysqlxDocumentIdUniquePrefix(Integer mysqlxDocumentIdUniquePrefix)
```
    (“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    mysqlxDocumentIdUniquePrefix - the value to set
    
    Returns:
    
    this builder
  - mysqlxIdleWorkerThreadTimeout
```
public ConfigurationVariables.Builder mysqlxIdleWorkerThreadTimeout(Integer mysqlxIdleWorkerThreadTimeout)
```
    (“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    mysqlxIdleWorkerThreadTimeout - the value to set
    
    Returns:
    
    this builder
  - mysqlxInteractiveTimeout
```
public ConfigurationVariables.Builder mysqlxInteractiveTimeout(Integer mysqlxInteractiveTimeout)
```
    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)
    
    Parameters:
    
    mysqlxInteractiveTimeout - the value to set
    
    Returns:
    
    this builder
  - mysqlxMaxAllowedPacket
```
public ConfigurationVariables.Builder mysqlxMaxAllowedPacket(Integer mysqlxMaxAllowedPacket)
```
    The maximum size of network packets that can be received by X Plugin.
    
    This is the mysql variable "mysqlx_max_allowed_packet".
    
    Parameters:
    
    mysqlxMaxAllowedPacket - the value to set
    
    Returns:
    
    this builder
  - mysqlxMinWorkerThreads
```
public ConfigurationVariables.Builder mysqlxMinWorkerThreads(Integer mysqlxMinWorkerThreads)
```
    (“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    mysqlxMinWorkerThreads - the value to set
    
    Returns:
    
    this builder
  - mysqlxReadTimeout
```
public ConfigurationVariables.Builder mysqlxReadTimeout(Integer mysqlxReadTimeout)
```
    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)
    
    Parameters:
    
    mysqlxReadTimeout - the value to set
    
    Returns:
    
    this builder
  - mysqlxWaitTimeout
```
public ConfigurationVariables.Builder mysqlxWaitTimeout(Integer mysqlxWaitTimeout)
```
    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)
    
    Parameters:
    
    mysqlxWaitTimeout - the value to set
    
    Returns:
    
    this builder
  - mysqlxWriteTimeout
```
public ConfigurationVariables.Builder mysqlxWriteTimeout(Integer mysqlxWriteTimeout)
```
    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)
    
    Parameters:
    
    mysqlxWriteTimeout - the value to set
    
    Returns:
    
    this builder
  - netReadTimeout
```
public ConfigurationVariables.Builder netReadTimeout(Integer netReadTimeout)
```
    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)
    
    Parameters:
    
    netReadTimeout - the value to set
    
    Returns:
    
    this builder
  - netWriteTimeout
```
public ConfigurationVariables.Builder netWriteTimeout(Integer netWriteTimeout)
```
    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)
    
    Parameters:
    
    netWriteTimeout - the value to set
    
    Returns:
    
    this builder
  - parserMaxMemSize
```
public ConfigurationVariables.Builder parserMaxMemSize(Long parserMaxMemSize)
```
    (“parser_max_mem_size”)
    
    Parameters:
    
    parserMaxMemSize - the value to set
    
    Returns:
    
    this builder
  - queryAllocBlockSize
```
public ConfigurationVariables.Builder queryAllocBlockSize(Long queryAllocBlockSize)
```
    (“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    queryAllocBlockSize - the value to set
    
    Returns:
    
    this builder
  - queryPreallocSize
```
public ConfigurationVariables.Builder queryPreallocSize(Long queryPreallocSize)
```
    (“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored
    
    Parameters:
    
    queryPreallocSize - the value to set
    
    Returns:
    
    this builder
  - regexpTimeLimit
```
public 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)
    
    Parameters:
    
    regexpTimeLimit - the value to set
    
    Returns:
    
    this builder
  - sqlMode
```
public ConfigurationVariables.Builder sqlMode(String sqlMode)
```
    (“sql_mode”)
    
    Parameters:
    
    sqlMode - the value to set
    
    Returns:
    
    this builder
  - tmpTableSize
```
public ConfigurationVariables.Builder tmpTableSize(Long tmpTableSize)
```
    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)
    
    Parameters:
    
    tmpTableSize - the value to set
    
    Returns:
    
    this builder
  - mysqlxDeflateDefaultCompressionLevel
```
public ConfigurationVariables.Builder mysqlxDeflateDefaultCompressionLevel(Integer mysqlxDeflateDefaultCompressionLevel)
```
    Set the default compression level for the deflate algorithm. (“mysqlx_deflate_default_compression_level”)
    
    Parameters:
    
    mysqlxDeflateDefaultCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlxDeflateMaxClientCompressionLevel
```
public ConfigurationVariables.Builder mysqlxDeflateMaxClientCompressionLevel(Integer mysqlxDeflateMaxClientCompressionLevel)
```
    Limit the upper bound of accepted compression levels for the deflate algorithm. (“mysqlx_deflate_max_client_compression_level”)
    
    Parameters:
    
    mysqlxDeflateMaxClientCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlxLz4MaxClientCompressionLevel
```
public ConfigurationVariables.Builder mysqlxLz4MaxClientCompressionLevel(Integer mysqlxLz4MaxClientCompressionLevel)
```
    Limit the upper bound of accepted compression levels for the lz4 algorithm. (“mysqlx_lz4_max_client_compression_level”)
    
    Parameters:
    
    mysqlxLz4MaxClientCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlxLz4DefaultCompressionLevel
```
public ConfigurationVariables.Builder mysqlxLz4DefaultCompressionLevel(Integer mysqlxLz4DefaultCompressionLevel)
```
    Set the default compression level for the lz4 algorithm. (“mysqlx_lz4_default_compression_level”)
    
    Parameters:
    
    mysqlxLz4DefaultCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlxZstdMaxClientCompressionLevel
```
public ConfigurationVariables.Builder mysqlxZstdMaxClientCompressionLevel(Integer mysqlxZstdMaxClientCompressionLevel)
```
    Limit the upper bound of accepted compression levels for the zstd algorithm. (“mysqlx_zstd_max_client_compression_level”)
    
    Parameters:
    
    mysqlxZstdMaxClientCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlxZstdDefaultCompressionLevel
```
public ConfigurationVariables.Builder mysqlxZstdDefaultCompressionLevel(Integer mysqlxZstdDefaultCompressionLevel)
```
    Set the default compression level for the zstd algorithm. (“mysqlx_zstd_default_compression_level”)
    
    Parameters:
    
    mysqlxZstdDefaultCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - mysqlZstdDefaultCompressionLevel
```
public ConfigurationVariables.Builder mysqlZstdDefaultCompressionLevel(Integer mysqlZstdDefaultCompressionLevel)
```
    DEPRECATED – typo of mysqlx_zstd_default_compression_level. variable will be ignored.
    
    Parameters:
    
    mysqlZstdDefaultCompressionLevel - the value to set
    
    Returns:
    
    this builder
  - sortBufferSize
```
public ConfigurationVariables.Builder sortBufferSize(Long sortBufferSize)
```
    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)
    
    Parameters:
    
    sortBufferSize - the value to set
    
    Returns:
    
    this builder
  - waitTimeout
```
public ConfigurationVariables.Builder waitTimeout(Integer waitTimeout)
```
    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)
    
    Parameters:
    
    waitTimeout - the value to set
    
    Returns:
    
    this builder
  - threadPoolDedicatedListeners
```
public ConfigurationVariables.Builder threadPoolDedicatedListeners(Boolean threadPoolDedicatedListeners)
```
    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.
    
    Parameters:
    
    threadPoolDedicatedListeners - the value to set
    
    Returns:
    
    this builder
  - threadPoolMaxTransactionsLimit
```
public ConfigurationVariables.Builder threadPoolMaxTransactionsLimit(Integer threadPoolMaxTransactionsLimit)
```
    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.
    
    Parameters:
    
    threadPoolMaxTransactionsLimit - the value to set
    
    Returns:
    
    this builder
  - timeZone
```
public ConfigurationVariables.Builder timeZone(String timeZone)
```
    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'.
    
    Parameters:
    
    timeZone - the value to set
    
    Returns:
    
    this builder
  - build
```
public ConfigurationVariables build()
```
  - copy
```
public ConfigurationVariables.Builder copy(ConfigurationVariables model)
```

Class ConfigurationVariables.Builder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Builder

Method Detail

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