ConfigurationVariables¶

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

Bases: object

User-defined 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.
`big_tables`	Gets the big_tables 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.
`connection_memory_chunk_size`	Gets the connection_memory_chunk_size of this ConfigurationVariables.
`connection_memory_limit`	Gets the connection_memory_limit 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.
`global_connection_memory_limit`	Gets the global_connection_memory_limit of this ConfigurationVariables.
`global_connection_memory_tracking`	Gets the global_connection_memory_tracking 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_dump_pct`	Gets the innodb_buffer_pool_dump_pct 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_ddl_buffer_size`	Gets the innodb_ddl_buffer_size of this ConfigurationVariables.
`innodb_ddl_threads`	Gets the innodb_ddl_threads 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_log_writer_threads`	Gets the innodb_log_writer_threads 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.
`innodb_stats_persistent_sample_pages`	Gets the innodb_stats_persistent_sample_pages of this ConfigurationVariables.
`innodb_stats_transient_sample_pages`	Gets the innodb_stats_transient_sample_pages of this ConfigurationVariables.
`interactive_timeout`	Gets the interactive_timeout of this ConfigurationVariables.
`local_infile`	Gets the local_infile of this ConfigurationVariables.
`mandatory_roles`	Gets the mandatory_roles of this ConfigurationVariables.
`max_allowed_packet`	Gets the max_allowed_packet of this ConfigurationVariables.
`max_binlog_cache_size`	Gets the max_binlog_cache_size of this ConfigurationVariables.
`max_connect_errors`	Gets the max_connect_errors of this ConfigurationVariables.
`max_connections`	Gets the max_connections of this ConfigurationVariables.
`max_execution_time`	Gets the max_execution_time of this ConfigurationVariables.
`max_heap_table_size`	Gets the max_heap_table_size 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.
`net_read_timeout`	Gets the net_read_timeout of this ConfigurationVariables.
`net_write_timeout`	Gets the net_write_timeout 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.
`regexp_time_limit`	Gets the regexp_time_limit of this ConfigurationVariables.
`sort_buffer_size`	Gets the sort_buffer_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.
`thread_pool_dedicated_listeners`	Gets the thread_pool_dedicated_listeners of this ConfigurationVariables.
`thread_pool_max_transactions_limit`	Gets the thread_pool_max_transactions_limit of this ConfigurationVariables.
`time_zone`	Gets the time_zone of this ConfigurationVariables.
`tmp_table_size`	Gets the tmp_table_size of this ConfigurationVariables.
`transaction_isolation`	Gets the transaction_isolation of this ConfigurationVariables.
`wait_timeout`	Gets the wait_timeout 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’.
big_tables (bool) – The value to assign to the big_tables property of this ConfigurationVariables.
connection_memory_chunk_size (int) – The value to assign to the connection_memory_chunk_size property of this ConfigurationVariables.
connection_memory_limit (int) – The value to assign to the connection_memory_limit property of this ConfigurationVariables.
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’.
global_connection_memory_limit (int) – The value to assign to the global_connection_memory_limit property of this ConfigurationVariables.
global_connection_memory_tracking (bool) – The value to assign to the global_connection_memory_tracking property of this ConfigurationVariables.
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.
innodb_log_writer_threads (bool) – The value to assign to the innodb_log_writer_threads 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_binlog_cache_size (int) – The value to assign to the max_binlog_cache_size property of this ConfigurationVariables.
max_connect_errors (int) – The value to assign to the max_connect_errors property of this ConfigurationVariables.
max_heap_table_size (int) – The value to assign to the max_heap_table_size 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_dump_pct (int) – The value to assign to the innodb_buffer_pool_dump_pct property of this ConfigurationVariables.
innodb_buffer_pool_instances (int) – The value to assign to the innodb_buffer_pool_instances property of this ConfigurationVariables.
innodb_ddl_buffer_size (int) – The value to assign to the innodb_ddl_buffer_size property of this ConfigurationVariables.
innodb_ddl_threads (int) – The value to assign to the innodb_ddl_threads 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.
interactive_timeout (int) – The value to assign to the interactive_timeout property of this ConfigurationVariables.
innodb_stats_persistent_sample_pages (int) – The value to assign to the innodb_stats_persistent_sample_pages property of this ConfigurationVariables.
innodb_stats_transient_sample_pages (int) – The value to assign to the innodb_stats_transient_sample_pages property of this ConfigurationVariables.
max_allowed_packet (int) – The value to assign to the max_allowed_packet 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.
net_read_timeout (int) – The value to assign to the net_read_timeout property of this ConfigurationVariables.
net_write_timeout (int) – The value to assign to the net_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.
regexp_time_limit (int) – The value to assign to the regexp_time_limit property of this ConfigurationVariables.
sql_mode (str) – The value to assign to the sql_mode property of this ConfigurationVariables.
tmp_table_size (int) – The value to assign to the tmp_table_size 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.
sort_buffer_size (int) – The value to assign to the sort_buffer_size property of this ConfigurationVariables.
wait_timeout (int) – The value to assign to the wait_timeout property of this ConfigurationVariables.
thread_pool_dedicated_listeners (bool) – The value to assign to the thread_pool_dedicated_listeners property of this ConfigurationVariables.
thread_pool_max_transactions_limit (int) – The value to assign to the thread_pool_max_transactions_limit property of this ConfigurationVariables.
time_zone (str) – The value to assign to the time_zone property of this ConfigurationVariables.

autocommit¶

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

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

big_tables¶

Gets the big_tables of this ConfigurationVariables. If enabled, the server stores all temporary tables on disk rather than in memory.

bigTables corresponds to the MySQL server variable big_tables.

Returns:	The big_tables 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. 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

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”.

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

connection_memory_chunk_size¶

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

Returns:	The connection_memory_chunk_size of this ConfigurationVariables.
Return type:	int

connection_memory_limit¶

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

Returns:	The connection_memory_limit 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

global_connection_memory_limit¶

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

Returns:	The global_connection_memory_limit of this ConfigurationVariables.
Return type:	int

global_connection_memory_tracking¶

Gets the global_connection_memory_tracking of this ConfigurationVariables. Determines whether the MySQL server calculates Global_connection_memory.

globalConnectionMemoryTracking corresponds to the MySQL system variable global_connection_memory_tracking.

Returns:	The global_connection_memory_tracking of this ConfigurationVariables.
Return type:	bool

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_dump_pct¶

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

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.

Returns:	The innodb_buffer_pool_dump_pct 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. 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.

The default and maximum values depend on the amount of RAM provisioned by the shape. See Default User Variables.

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

innodb_ddl_buffer_size¶

Gets the innodb_ddl_buffer_size of this ConfigurationVariables. innodbDdlBufferSize corresponds to the MySQL system variable innodb_ddl_buffer_size]

Returns:	The innodb_ddl_buffer_size of this ConfigurationVariables.
Return type:	int

innodb_ddl_threads¶

Gets the innodb_ddl_threads of this ConfigurationVariables. innodbDdlThreads corresponds to the MySQL system variable innodb_ddl_threads]

Returns:	The innodb_ddl_threads 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_log_writer_threads¶

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

Returns:	The innodb_log_writer_threads of this ConfigurationVariables.
Return type:	bool

innodb_max_purge_lag¶

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

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. 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.

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

innodb_stats_persistent_sample_pages¶

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

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.

Returns:	The innodb_stats_persistent_sample_pages of this ConfigurationVariables.
Return type:	int

innodb_stats_transient_sample_pages¶

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

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 and ALTER TABLE statements.

Returns:	The innodb_stats_transient_sample_pages of this ConfigurationVariables.
Return type:	int

interactive_timeout¶

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

Returns:	The interactive_timeout 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_allowed_packet¶

Gets the max_allowed_packet of this ConfigurationVariables. The maximum size of one packet or any generated/intermediate string.

This is the mysql variable “max_allowed_packet”.

Returns:	The max_allowed_packet of this ConfigurationVariables.
Return type:	int

max_binlog_cache_size¶

Gets the max_binlog_cache_size of this ConfigurationVariables. Sets the size of the transaction cache.

maxBinlogCacheSize corresponds to the MySQL server system variable max_binlog_cache_size.

Returns:	The max_binlog_cache_size of this ConfigurationVariables.
Return type:	int

max_connect_errors¶

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

Returns:	The max_connect_errors of this ConfigurationVariables.
Return type:	int

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_heap_table_size¶

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

Returns:	The max_heap_table_size 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. 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

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. The number of seconds to wait for interactive clients to timeout.

mysqlxInteractiveTimeout corresponds to the MySQL X Plugin system variable. mysqlx_interactive_timeout

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. The maximum size of network packets that can be received by X Plugin.

This is the mysql variable “mysqlx_max_allowed_packet”.

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. 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

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

mysqlx_wait_timeout¶

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

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

mysqlx_write_timeout¶

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

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

net_read_timeout¶

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

Returns:	The net_read_timeout of this ConfigurationVariables.
Return type:	int

net_write_timeout¶

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

Returns:	The net_write_timeout 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

regexp_time_limit¶

Gets the regexp_time_limit of this ConfigurationVariables. regexpTimeLimit corresponds to the MySQL system variable regexp_time_limit]

Returns:	The regexp_time_limit of this ConfigurationVariables.
Return type:	int

sort_buffer_size¶

Gets the sort_buffer_size of this ConfigurationVariables. Each session that must perform a sort allocates a buffer of this size.

sortBufferSize corresponds to the MySQL system variable sort_buffer_size

Returns:	The sort_buffer_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

thread_pool_dedicated_listeners¶

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

Returns:	The thread_pool_dedicated_listeners of this ConfigurationVariables.
Return type:	bool

thread_pool_max_transactions_limit¶

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

Returns:	The thread_pool_max_transactions_limit of this ConfigurationVariables.
Return type:	int

time_zone¶

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

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

tmp_table_size¶

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

Returns:	The tmp_table_size of this ConfigurationVariables.
Return type:	int

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

wait_timeout¶

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

Returns:	The wait_timeout of this ConfigurationVariables.
Return type:	int