ConfigurationVariables

class oci.mysql.models.ConfigurationVariables(**kwargs)

Bases: object

User controllable service variables.

Attributes

BINLOG_ROW_METADATA_FULL A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables.
BINLOG_ROW_METADATA_MINIMAL A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables.
COMPLETION_TYPE_CHAIN A constant which can be used with the completion_type property of a ConfigurationVariables.
COMPLETION_TYPE_NO_CHAIN A constant which can be used with the completion_type property of a ConfigurationVariables.
COMPLETION_TYPE_RELEASE A constant which can be used with the completion_type property of a ConfigurationVariables.
DEFAULT_AUTHENTICATION_PLUGIN_CACHING_SHA2_PASSWORD A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
DEFAULT_AUTHENTICATION_PLUGIN_MYSQL_NATIVE_PASSWORD A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
DEFAULT_AUTHENTICATION_PLUGIN_SHA256_PASSWORD A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables.
GROUP_REPLICATION_CONSISTENCY_AFTER A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
GROUP_REPLICATION_CONSISTENCY_BEFORE A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
GROUP_REPLICATION_CONSISTENCY_BEFORE_AND_AFTER A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
GROUP_REPLICATION_CONSISTENCY_BEFORE_ON_PRIMARY_FAILOVER A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
GROUP_REPLICATION_CONSISTENCY_EVENTUAL A constant which can be used with the group_replication_consistency property of a ConfigurationVariables.
TRANSACTION_ISOLATION_READ_COMMITED A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
TRANSACTION_ISOLATION_READ_COMMITTED A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
TRANSACTION_ISOLATION_READ_UNCOMMITTED A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
TRANSACTION_ISOLATION_REPEATABLE_READ A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
TRANSACTION_ISOLATION_SERIALIZABLE A constant which can be used with the transaction_isolation property of a ConfigurationVariables.
autocommit Gets the autocommit of this ConfigurationVariables.
binlog_expire_logs_seconds Gets the binlog_expire_logs_seconds of this ConfigurationVariables.
binlog_row_metadata Gets the binlog_row_metadata of this ConfigurationVariables.
binlog_row_value_options Gets the binlog_row_value_options of this ConfigurationVariables.
binlog_transaction_compression Gets the binlog_transaction_compression of this ConfigurationVariables.
completion_type Gets the completion_type of this ConfigurationVariables.
connect_timeout Gets the connect_timeout of this ConfigurationVariables.
cte_max_recursion_depth Gets the cte_max_recursion_depth of this ConfigurationVariables.
default_authentication_plugin Gets the default_authentication_plugin of this ConfigurationVariables.
foreign_key_checks Gets the foreign_key_checks of this ConfigurationVariables.
generated_random_password_length Gets the generated_random_password_length of this ConfigurationVariables.
group_replication_consistency Gets the group_replication_consistency of this ConfigurationVariables.
information_schema_stats_expiry Gets the information_schema_stats_expiry of this ConfigurationVariables.
innodb_buffer_pool_instances Gets the innodb_buffer_pool_instances of this ConfigurationVariables.
innodb_buffer_pool_size Gets the innodb_buffer_pool_size of this ConfigurationVariables.
innodb_ft_enable_stopword Gets the innodb_ft_enable_stopword of this ConfigurationVariables.
innodb_ft_max_token_size Gets the innodb_ft_max_token_size of this ConfigurationVariables.
innodb_ft_min_token_size Gets the innodb_ft_min_token_size of this ConfigurationVariables.
innodb_ft_num_word_optimize Gets the innodb_ft_num_word_optimize of this ConfigurationVariables.
innodb_ft_result_cache_limit Gets the innodb_ft_result_cache_limit of this ConfigurationVariables.
innodb_ft_server_stopword_table Gets the innodb_ft_server_stopword_table of this ConfigurationVariables.
innodb_lock_wait_timeout Gets the innodb_lock_wait_timeout of this ConfigurationVariables.
innodb_max_purge_lag Gets the innodb_max_purge_lag of this ConfigurationVariables.
innodb_max_purge_lag_delay Gets the innodb_max_purge_lag_delay of this ConfigurationVariables.
local_infile Gets the local_infile of this ConfigurationVariables.
mandatory_roles Gets the mandatory_roles of this ConfigurationVariables.
max_connections Gets the max_connections of this ConfigurationVariables.
max_execution_time Gets the max_execution_time of this ConfigurationVariables.
max_prepared_stmt_count Gets the max_prepared_stmt_count of this ConfigurationVariables.
mysql_firewall_mode Gets the mysql_firewall_mode of this ConfigurationVariables.
mysql_zstd_default_compression_level Gets the mysql_zstd_default_compression_level of this ConfigurationVariables.
mysqlx_connect_timeout Gets the mysqlx_connect_timeout of this ConfigurationVariables.
mysqlx_deflate_default_compression_level Gets the mysqlx_deflate_default_compression_level of this ConfigurationVariables.
mysqlx_deflate_max_client_compression_level Gets the mysqlx_deflate_max_client_compression_level of this ConfigurationVariables.
mysqlx_document_id_unique_prefix Gets the mysqlx_document_id_unique_prefix of this ConfigurationVariables.
mysqlx_enable_hello_notice Gets the mysqlx_enable_hello_notice of this ConfigurationVariables.
mysqlx_idle_worker_thread_timeout Gets the mysqlx_idle_worker_thread_timeout of this ConfigurationVariables.
mysqlx_interactive_timeout Gets the mysqlx_interactive_timeout of this ConfigurationVariables.
mysqlx_lz4_default_compression_level Gets the mysqlx_lz4_default_compression_level of this ConfigurationVariables.
mysqlx_lz4_max_client_compression_level Gets the mysqlx_lz4_max_client_compression_level of this ConfigurationVariables.
mysqlx_max_allowed_packet Gets the mysqlx_max_allowed_packet of this ConfigurationVariables.
mysqlx_min_worker_threads Gets the mysqlx_min_worker_threads of this ConfigurationVariables.
mysqlx_read_timeout Gets the mysqlx_read_timeout of this ConfigurationVariables.
mysqlx_wait_timeout Gets the mysqlx_wait_timeout of this ConfigurationVariables.
mysqlx_write_timeout Gets the mysqlx_write_timeout of this ConfigurationVariables.
mysqlx_zstd_default_compression_level Gets the mysqlx_zstd_default_compression_level of this ConfigurationVariables.
mysqlx_zstd_max_client_compression_level Gets the mysqlx_zstd_max_client_compression_level of this ConfigurationVariables.
parser_max_mem_size Gets the parser_max_mem_size of this ConfigurationVariables.
query_alloc_block_size Gets the query_alloc_block_size of this ConfigurationVariables.
query_prealloc_size Gets the query_prealloc_size of this ConfigurationVariables.
sql_mode Gets the sql_mode of this ConfigurationVariables.
sql_require_primary_key Gets the sql_require_primary_key of this ConfigurationVariables.
sql_warnings Gets the sql_warnings of this ConfigurationVariables.
transaction_isolation Gets the transaction_isolation of this ConfigurationVariables.

Methods

__init__(**kwargs) Initializes a new ConfigurationVariables object with values from keyword arguments.
BINLOG_ROW_METADATA_FULL = 'FULL'

A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables. This constant has a value of “FULL”

BINLOG_ROW_METADATA_MINIMAL = 'MINIMAL'

A constant which can be used with the binlog_row_metadata property of a ConfigurationVariables. This constant has a value of “MINIMAL”

COMPLETION_TYPE_CHAIN = 'CHAIN'

A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “CHAIN”

COMPLETION_TYPE_NO_CHAIN = 'NO_CHAIN'

A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “NO_CHAIN”

COMPLETION_TYPE_RELEASE = 'RELEASE'

A constant which can be used with the completion_type property of a ConfigurationVariables. This constant has a value of “RELEASE”

DEFAULT_AUTHENTICATION_PLUGIN_CACHING_SHA2_PASSWORD = 'caching_sha2_password'

A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “caching_sha2_password”

DEFAULT_AUTHENTICATION_PLUGIN_MYSQL_NATIVE_PASSWORD = 'mysql_native_password'

A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “mysql_native_password”

DEFAULT_AUTHENTICATION_PLUGIN_SHA256_PASSWORD = 'sha256_password'

A constant which can be used with the default_authentication_plugin property of a ConfigurationVariables. This constant has a value of “sha256_password”

GROUP_REPLICATION_CONSISTENCY_AFTER = 'AFTER'

A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “AFTER”

GROUP_REPLICATION_CONSISTENCY_BEFORE = 'BEFORE'

A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE”

GROUP_REPLICATION_CONSISTENCY_BEFORE_AND_AFTER = 'BEFORE_AND_AFTER'

A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE_AND_AFTER”

GROUP_REPLICATION_CONSISTENCY_BEFORE_ON_PRIMARY_FAILOVER = 'BEFORE_ON_PRIMARY_FAILOVER'

A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “BEFORE_ON_PRIMARY_FAILOVER”

GROUP_REPLICATION_CONSISTENCY_EVENTUAL = 'EVENTUAL'

A constant which can be used with the group_replication_consistency property of a ConfigurationVariables. This constant has a value of “EVENTUAL”

TRANSACTION_ISOLATION_READ_COMMITED = 'READ-COMMITED'

A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-COMMITED”

TRANSACTION_ISOLATION_READ_COMMITTED = 'READ-COMMITTED'

A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-COMMITTED”

TRANSACTION_ISOLATION_READ_UNCOMMITTED = 'READ-UNCOMMITTED'

A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “READ-UNCOMMITTED”

TRANSACTION_ISOLATION_REPEATABLE_READ = 'REPEATABLE-READ'

A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “REPEATABLE-READ”

TRANSACTION_ISOLATION_SERIALIZABLE = 'SERIALIZABLE'

A constant which can be used with the transaction_isolation property of a ConfigurationVariables. This constant has a value of “SERIALIZABLE”

__init__(**kwargs)

Initializes a new ConfigurationVariables object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:
  • completion_type (str) – The value to assign to the completion_type property of this ConfigurationVariables. Allowed values for this property are: “NO_CHAIN”, “CHAIN”, “RELEASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • default_authentication_plugin (str) – The value to assign to the default_authentication_plugin property of this ConfigurationVariables. Allowed values for this property are: “mysql_native_password”, “sha256_password”, “caching_sha2_password”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • transaction_isolation (str) – The value to assign to the transaction_isolation property of this ConfigurationVariables. Allowed values for this property are: “READ-UNCOMMITTED”, “READ-COMMITED”, “READ-COMMITTED”, “REPEATABLE-READ”, “SERIALIZABLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • innodb_ft_server_stopword_table (str) – The value to assign to the innodb_ft_server_stopword_table property of this ConfigurationVariables.
  • mandatory_roles (str) – The value to assign to the mandatory_roles property of this ConfigurationVariables.
  • autocommit (bool) – The value to assign to the autocommit property of this ConfigurationVariables.
  • foreign_key_checks (bool) – The value to assign to the foreign_key_checks property of this ConfigurationVariables.
  • group_replication_consistency (str) – The value to assign to the group_replication_consistency property of this ConfigurationVariables. Allowed values for this property are: “EVENTUAL”, “BEFORE_ON_PRIMARY_FAILOVER”, “BEFORE”, “AFTER”, “BEFORE_AND_AFTER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • innodb_ft_enable_stopword (bool) – The value to assign to the innodb_ft_enable_stopword property of this ConfigurationVariables.
  • local_infile (bool) – The value to assign to the local_infile property of this ConfigurationVariables.
  • mysql_firewall_mode (bool) – The value to assign to the mysql_firewall_mode property of this ConfigurationVariables.
  • mysqlx_enable_hello_notice (bool) – The value to assign to the mysqlx_enable_hello_notice property of this ConfigurationVariables.
  • sql_require_primary_key (bool) – The value to assign to the sql_require_primary_key property of this ConfigurationVariables.
  • sql_warnings (bool) – The value to assign to the sql_warnings property of this ConfigurationVariables.
  • binlog_expire_logs_seconds (int) – The value to assign to the binlog_expire_logs_seconds property of this ConfigurationVariables.
  • binlog_row_metadata (str) – The value to assign to the binlog_row_metadata property of this ConfigurationVariables. Allowed values for this property are: “FULL”, “MINIMAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
  • binlog_row_value_options (str) – The value to assign to the binlog_row_value_options property of this ConfigurationVariables.
  • binlog_transaction_compression (bool) – The value to assign to the binlog_transaction_compression property of this ConfigurationVariables.
  • innodb_buffer_pool_size (int) – The value to assign to the innodb_buffer_pool_size property of this ConfigurationVariables.
  • innodb_ft_result_cache_limit (int) – The value to assign to the innodb_ft_result_cache_limit property of this ConfigurationVariables.
  • max_connections (int) – The value to assign to the max_connections property of this ConfigurationVariables.
  • max_prepared_stmt_count (int) – The value to assign to the max_prepared_stmt_count property of this ConfigurationVariables.
  • connect_timeout (int) – The value to assign to the connect_timeout property of this ConfigurationVariables.
  • cte_max_recursion_depth (int) – The value to assign to the cte_max_recursion_depth property of this ConfigurationVariables.
  • generated_random_password_length (int) – The value to assign to the generated_random_password_length property of this ConfigurationVariables.
  • information_schema_stats_expiry (int) – The value to assign to the information_schema_stats_expiry property of this ConfigurationVariables.
  • innodb_buffer_pool_instances (int) – The value to assign to the innodb_buffer_pool_instances property of this ConfigurationVariables.
  • innodb_ft_max_token_size (int) – The value to assign to the innodb_ft_max_token_size property of this ConfigurationVariables.
  • innodb_ft_min_token_size (int) – The value to assign to the innodb_ft_min_token_size property of this ConfigurationVariables.
  • innodb_ft_num_word_optimize (int) – The value to assign to the innodb_ft_num_word_optimize property of this ConfigurationVariables.
  • innodb_lock_wait_timeout (int) – The value to assign to the innodb_lock_wait_timeout property of this ConfigurationVariables.
  • innodb_max_purge_lag (int) – The value to assign to the innodb_max_purge_lag property of this ConfigurationVariables.
  • innodb_max_purge_lag_delay (int) – The value to assign to the innodb_max_purge_lag_delay property of this ConfigurationVariables.
  • max_execution_time (int) – The value to assign to the max_execution_time property of this ConfigurationVariables.
  • mysqlx_connect_timeout (int) – The value to assign to the mysqlx_connect_timeout property of this ConfigurationVariables.
  • mysqlx_document_id_unique_prefix (int) – The value to assign to the mysqlx_document_id_unique_prefix property of this ConfigurationVariables.
  • mysqlx_idle_worker_thread_timeout (int) – The value to assign to the mysqlx_idle_worker_thread_timeout property of this ConfigurationVariables.
  • mysqlx_interactive_timeout (int) – The value to assign to the mysqlx_interactive_timeout property of this ConfigurationVariables.
  • mysqlx_max_allowed_packet (int) – The value to assign to the mysqlx_max_allowed_packet property of this ConfigurationVariables.
  • mysqlx_min_worker_threads (int) – The value to assign to the mysqlx_min_worker_threads property of this ConfigurationVariables.
  • mysqlx_read_timeout (int) – The value to assign to the mysqlx_read_timeout property of this ConfigurationVariables.
  • mysqlx_wait_timeout (int) – The value to assign to the mysqlx_wait_timeout property of this ConfigurationVariables.
  • mysqlx_write_timeout (int) – The value to assign to the mysqlx_write_timeout property of this ConfigurationVariables.
  • parser_max_mem_size (int) – The value to assign to the parser_max_mem_size property of this ConfigurationVariables.
  • query_alloc_block_size (int) – The value to assign to the query_alloc_block_size property of this ConfigurationVariables.
  • query_prealloc_size (int) – The value to assign to the query_prealloc_size property of this ConfigurationVariables.
  • sql_mode (str) – The value to assign to the sql_mode property of this ConfigurationVariables.
  • mysqlx_deflate_default_compression_level (int) – The value to assign to the mysqlx_deflate_default_compression_level property of this ConfigurationVariables.
  • mysqlx_deflate_max_client_compression_level (int) – The value to assign to the mysqlx_deflate_max_client_compression_level property of this ConfigurationVariables.
  • mysqlx_lz4_max_client_compression_level (int) – The value to assign to the mysqlx_lz4_max_client_compression_level property of this ConfigurationVariables.
  • mysqlx_lz4_default_compression_level (int) – The value to assign to the mysqlx_lz4_default_compression_level property of this ConfigurationVariables.
  • mysqlx_zstd_max_client_compression_level (int) – The value to assign to the mysqlx_zstd_max_client_compression_level property of this ConfigurationVariables.
  • mysqlx_zstd_default_compression_level (int) – The value to assign to the mysqlx_zstd_default_compression_level property of this ConfigurationVariables.
  • mysql_zstd_default_compression_level (int) – The value to assign to the mysql_zstd_default_compression_level property of this ConfigurationVariables.
autocommit

Gets the autocommit of this ConfigurationVariables. (“autocommit”)

Returns:The autocommit of this ConfigurationVariables.
Return type:bool
binlog_expire_logs_seconds

Gets the binlog_expire_logs_seconds of this ConfigurationVariables. Sets the binary log expiration period in seconds. binlogExpireLogsSeconds corresponds to the MySQL binary logging system variable binlog_expire_logs_seconds.

Returns:The binlog_expire_logs_seconds of this ConfigurationVariables.
Return type:int
binlog_row_metadata

Gets the binlog_row_metadata of this ConfigurationVariables. 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.

Allowed values for this property are: “FULL”, “MINIMAL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The binlog_row_metadata of this ConfigurationVariables.
Return type:str
binlog_row_value_options

Gets the binlog_row_value_options of this ConfigurationVariables. 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.

Returns:The binlog_row_value_options of this ConfigurationVariables.
Return type:str
binlog_transaction_compression

Gets the binlog_transaction_compression of this ConfigurationVariables. 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.

Returns:The binlog_transaction_compression of this ConfigurationVariables.
Return type:bool
completion_type

Gets the completion_type of this ConfigurationVariables. (“completion_type”)

Allowed values for this property are: “NO_CHAIN”, “CHAIN”, “RELEASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The completion_type of this ConfigurationVariables.
Return type:str
connect_timeout

Gets the connect_timeout of this ConfigurationVariables. (“connect_timeout”)

Returns:The connect_timeout of this ConfigurationVariables.
Return type:int
cte_max_recursion_depth

Gets the cte_max_recursion_depth of this ConfigurationVariables. (“cte_max_recursion_depth”)

Returns:The cte_max_recursion_depth of this ConfigurationVariables.
Return type:int
default_authentication_plugin

Gets the default_authentication_plugin of this ConfigurationVariables. (“default_authentication_plugin”)

Allowed values for this property are: “mysql_native_password”, “sha256_password”, “caching_sha2_password”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The default_authentication_plugin of this ConfigurationVariables.
Return type:str
foreign_key_checks

Gets the foreign_key_checks of this ConfigurationVariables. (“foreign_key_checks”)

Returns:The foreign_key_checks of this ConfigurationVariables.
Return type:bool
generated_random_password_length

Gets the generated_random_password_length of this ConfigurationVariables. (“generated_random_password_length”) DEPRECATED – variable should not be settable and will be ignored

Returns:The generated_random_password_length of this ConfigurationVariables.
Return type:int
group_replication_consistency

Gets the group_replication_consistency of this ConfigurationVariables. - 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.

Allowed values for this property are: “EVENTUAL”, “BEFORE_ON_PRIMARY_FAILOVER”, “BEFORE”, “AFTER”, “BEFORE_AND_AFTER”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The group_replication_consistency of this ConfigurationVariables.
Return type:str
information_schema_stats_expiry

Gets the information_schema_stats_expiry of this ConfigurationVariables. (“information_schema_stats_expiry”)

Returns:The information_schema_stats_expiry of this ConfigurationVariables.
Return type:int
innodb_buffer_pool_instances

Gets the innodb_buffer_pool_instances of this ConfigurationVariables. (“innodb_buffer_pool_instances”)

Returns:The innodb_buffer_pool_instances of this ConfigurationVariables.
Return type:int
innodb_buffer_pool_size

Gets the innodb_buffer_pool_size of this ConfigurationVariables. (“innodb_buffer_pool_size”)

Returns:The innodb_buffer_pool_size of this ConfigurationVariables.
Return type:int
innodb_ft_enable_stopword

Gets the innodb_ft_enable_stopword of this ConfigurationVariables. (“innodb_ft_enable_stopword”)

Returns:The innodb_ft_enable_stopword of this ConfigurationVariables.
Return type:bool
innodb_ft_max_token_size

Gets the innodb_ft_max_token_size of this ConfigurationVariables. (“innodb_ft_max_token_size”)

Returns:The innodb_ft_max_token_size of this ConfigurationVariables.
Return type:int
innodb_ft_min_token_size

Gets the innodb_ft_min_token_size of this ConfigurationVariables. (“innodb_ft_min_token_size”)

Returns:The innodb_ft_min_token_size of this ConfigurationVariables.
Return type:int
innodb_ft_num_word_optimize

Gets the innodb_ft_num_word_optimize of this ConfigurationVariables. (“innodb_ft_num_word_optimize”)

Returns:The innodb_ft_num_word_optimize of this ConfigurationVariables.
Return type:int
innodb_ft_result_cache_limit

Gets the innodb_ft_result_cache_limit of this ConfigurationVariables. (“innodb_ft_result_cache_limit”)

Returns:The innodb_ft_result_cache_limit of this ConfigurationVariables.
Return type:int
innodb_ft_server_stopword_table

Gets the innodb_ft_server_stopword_table of this ConfigurationVariables. (“innodb_ft_server_stopword_table”)

Returns:The innodb_ft_server_stopword_table of this ConfigurationVariables.
Return type:str
innodb_lock_wait_timeout

Gets the innodb_lock_wait_timeout of this ConfigurationVariables. (“innodb_lock_wait_timeout”)

Returns:The innodb_lock_wait_timeout of this ConfigurationVariables.
Return type:int
innodb_max_purge_lag

Gets the innodb_max_purge_lag of this ConfigurationVariables. (“innodb_max_purge_lag”)

Returns:The innodb_max_purge_lag of this ConfigurationVariables.
Return type:int
innodb_max_purge_lag_delay

Gets the innodb_max_purge_lag_delay of this ConfigurationVariables. (“innodb_max_purge_lag_delay”)

Returns:The innodb_max_purge_lag_delay of this ConfigurationVariables.
Return type:int
local_infile

Gets the local_infile of this ConfigurationVariables. (“local_infile”)

Returns:The local_infile of this ConfigurationVariables.
Return type:bool
mandatory_roles

Gets the mandatory_roles of this ConfigurationVariables. (“mandatory_roles”)

Returns:The mandatory_roles of this ConfigurationVariables.
Return type:str
max_connections

Gets the max_connections of this ConfigurationVariables. (“max_connections”)

Returns:The max_connections of this ConfigurationVariables.
Return type:int
max_execution_time

Gets the max_execution_time of this ConfigurationVariables. (“max_execution_time”)

Returns:The max_execution_time of this ConfigurationVariables.
Return type:int
max_prepared_stmt_count

Gets the max_prepared_stmt_count of this ConfigurationVariables. (“max_prepared_stmt_count”)

Returns:The max_prepared_stmt_count of this ConfigurationVariables.
Return type:int
mysql_firewall_mode

Gets the mysql_firewall_mode of this ConfigurationVariables. (“mysql_firewall_mode”)

Returns:The mysql_firewall_mode of this ConfigurationVariables.
Return type:bool
mysql_zstd_default_compression_level

Gets the mysql_zstd_default_compression_level of this ConfigurationVariables. DEPRECATED – typo of mysqlx_zstd_default_compression_level. variable will be ignored.

Returns:The mysql_zstd_default_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_connect_timeout

Gets the mysqlx_connect_timeout of this ConfigurationVariables. (“mysqlx_connect_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_connect_timeout of this ConfigurationVariables.
Return type:int
mysqlx_deflate_default_compression_level

Gets the mysqlx_deflate_default_compression_level of this ConfigurationVariables. Set the default compression level for the deflate algorithm. (“mysqlx_deflate_default_compression_level”)

Returns:The mysqlx_deflate_default_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_deflate_max_client_compression_level

Gets the mysqlx_deflate_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the deflate algorithm. (“mysqlx_deflate_max_client_compression_level”)

Returns:The mysqlx_deflate_max_client_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_document_id_unique_prefix

Gets the mysqlx_document_id_unique_prefix of this ConfigurationVariables. (“mysqlx_document_id_unique_prefix”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_document_id_unique_prefix of this ConfigurationVariables.
Return type:int
mysqlx_enable_hello_notice

Gets the mysqlx_enable_hello_notice of this ConfigurationVariables. (“mysqlx_enable_hello_notice”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_enable_hello_notice of this ConfigurationVariables.
Return type:bool
mysqlx_idle_worker_thread_timeout

Gets the mysqlx_idle_worker_thread_timeout of this ConfigurationVariables. (“mysqlx_idle_worker_thread_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_idle_worker_thread_timeout of this ConfigurationVariables.
Return type:int
mysqlx_interactive_timeout

Gets the mysqlx_interactive_timeout of this ConfigurationVariables. (“mysqlx_interactive_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_interactive_timeout of this ConfigurationVariables.
Return type:int
mysqlx_lz4_default_compression_level

Gets the mysqlx_lz4_default_compression_level of this ConfigurationVariables. Set the default compression level for the lz4 algorithm. (“mysqlx_lz4_default_compression_level”)

Returns:The mysqlx_lz4_default_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_lz4_max_client_compression_level

Gets the mysqlx_lz4_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the lz4 algorithm. (“mysqlx_lz4_max_client_compression_level”)

Returns:The mysqlx_lz4_max_client_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_max_allowed_packet

Gets the mysqlx_max_allowed_packet of this ConfigurationVariables. (“mysqlx_max_allowed_packet”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_max_allowed_packet of this ConfigurationVariables.
Return type:int
mysqlx_min_worker_threads

Gets the mysqlx_min_worker_threads of this ConfigurationVariables. (“mysqlx_min_worker_threads”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_min_worker_threads of this ConfigurationVariables.
Return type:int
mysqlx_read_timeout

Gets the mysqlx_read_timeout of this ConfigurationVariables. (“mysqlx_read_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_read_timeout of this ConfigurationVariables.
Return type:int
mysqlx_wait_timeout

Gets the mysqlx_wait_timeout of this ConfigurationVariables. (“mysqlx_wait_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_wait_timeout of this ConfigurationVariables.
Return type:int
mysqlx_write_timeout

Gets the mysqlx_write_timeout of this ConfigurationVariables. (“mysqlx_write_timeout”) DEPRECATED – variable should not be settable and will be ignored

Returns:The mysqlx_write_timeout of this ConfigurationVariables.
Return type:int
mysqlx_zstd_default_compression_level

Gets the mysqlx_zstd_default_compression_level of this ConfigurationVariables. Set the default compression level for the zstd algorithm. (“mysqlx_zstd_default_compression_level”)

Returns:The mysqlx_zstd_default_compression_level of this ConfigurationVariables.
Return type:int
mysqlx_zstd_max_client_compression_level

Gets the mysqlx_zstd_max_client_compression_level of this ConfigurationVariables. Limit the upper bound of accepted compression levels for the zstd algorithm. (“mysqlx_zstd_max_client_compression_level”)

Returns:The mysqlx_zstd_max_client_compression_level of this ConfigurationVariables.
Return type:int
parser_max_mem_size

Gets the parser_max_mem_size of this ConfigurationVariables. (“parser_max_mem_size”)

Returns:The parser_max_mem_size of this ConfigurationVariables.
Return type:int
query_alloc_block_size

Gets the query_alloc_block_size of this ConfigurationVariables. (“query_alloc_block_size”) DEPRECATED – variable should not be settable and will be ignored

Returns:The query_alloc_block_size of this ConfigurationVariables.
Return type:int
query_prealloc_size

Gets the query_prealloc_size of this ConfigurationVariables. (“query_prealloc_size”) DEPRECATED – variable should not be settable and will be ignored

Returns:The query_prealloc_size of this ConfigurationVariables.
Return type:int
sql_mode

Gets the sql_mode of this ConfigurationVariables. (“sql_mode”)

Returns:The sql_mode of this ConfigurationVariables.
Return type:str
sql_require_primary_key

Gets the sql_require_primary_key of this ConfigurationVariables. (“sql_require_primary_key”)

Returns:The sql_require_primary_key of this ConfigurationVariables.
Return type:bool
sql_warnings

Gets the sql_warnings of this ConfigurationVariables. (“sql_warnings”)

Returns:The sql_warnings of this ConfigurationVariables.
Return type:bool
transaction_isolation

Gets the transaction_isolation of this ConfigurationVariables. (“transaction_isolation”)

Allowed values for this property are: “READ-UNCOMMITTED”, “READ-COMMITED”, “READ-COMMITTED”, “REPEATABLE-READ”, “SERIALIZABLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:The transaction_isolation of this ConfigurationVariables.
Return type:str