#include <system_variables.h>

Public Attributes
ulong	dynamic_variables_version

char *	dynamic_variables_ptr

uint	dynamic_variables_head

uint	dynamic_variables_size

LIST *	dynamic_variables_allocs

ulonglong	max_heap_table_size

ulonglong	tmp_table_size

ulonglong	long_query_time

bool	end_markers_in_json

bool	windowing_use_high_precision

ulonglong	optimizer_switch

ulonglong	optimizer_trace
	bitmap to tune optimizer tracing More...

ulonglong	optimizer_trace_features
	bitmap to select features to trace More...

long	optimizer_trace_offset

long	optimizer_trace_limit

ulong	optimizer_trace_max_mem_size

sql_mode_t	sql_mode
	which non-standard SQL behaviour should be enabled More...

ulonglong	option_bits
	OPTION_xxx constants, e.g. OPTION_PROFILING. More...

ha_rows	select_limit

ha_rows	max_join_size

ulong	auto_increment_increment

ulong	auto_increment_offset

ulong	bulk_insert_buff_size

uint	eq_range_index_dive_limit

uint	cte_max_recursion_depth

ulonglong	histogram_generation_max_mem_size

ulong	join_buff_size

ulong	lock_wait_timeout

ulong	max_allowed_packet

ulong	max_error_count

ulong	max_length_for_sort_data
	Unused. More...

ulong	max_points_in_geometry

ulong	max_sort_length

ulong	max_insert_delayed_threads

ulong	min_examined_row_limit

ulong	net_buffer_length

ulong	net_interactive_timeout

ulong	net_read_timeout

ulong	net_retry_count

ulong	net_wait_timeout

ulong	net_write_timeout

ulong	optimizer_prune_level

ulong	optimizer_search_depth

ulong	optimizer_max_subgraph_pairs

ulonglong	parser_max_mem_size

ulong	range_optimizer_max_mem_size

ulong	preload_buff_size

ulong	profiling_history_size

ulong	read_buff_size

ulong	read_rnd_buff_size

ulong	div_precincrement

ulong	sortbuff_size

ulong	max_sp_recursion_depth

ulong	default_week_format

ulong	max_seeks_for_key

ulong	range_alloc_block_size

ulong	query_alloc_block_size

ulong	query_prealloc_size

ulong	trans_alloc_block_size

ulong	trans_prealloc_size

ulong	group_concat_max_len

ulong	binlog_format
	binlog format for this thd (see enum_binlog_format) More...

ulong	rbr_exec_mode_options

bool	binlog_direct_non_trans_update

ulong	binlog_row_image

bool	binlog_trx_compression

ulong	binlog_trx_compression_type

uint	binlog_trx_compression_level_zstd

ulonglong	binlog_row_value_options

bool	sql_log_bin

ulong	transaction_write_set_extraction

ulong	completion_type

ulong	transaction_isolation

ulong	updatable_views_with_limit

uint	max_user_connections

ulong	my_aes_mode

ulong	ssl_fips_mode

ulong	resultset_metadata
	Controls what resultset metadata will be sent to the client. More...

my_thread_id	pseudo_thread_id
	In slave thread we need to know in behalf of which thread the query is being run to replicate temp tables properly. More...

bool	transaction_read_only
	Default transaction access mode. More...

bool	low_priority_updates

bool	new_mode

bool	keep_files_on_create

bool	old_alter_table

bool	big_tables

plugin_ref	table_plugin

plugin_ref	temp_table_plugin

const CHARSET_INFO *	character_set_filesystem

const CHARSET_INFO *	character_set_client

const CHARSET_INFO *	character_set_results

const CHARSET_INFO *	collation_server

const CHARSET_INFO *	collation_database

const CHARSET_INFO *	collation_connection

MY_LOCALE *	lc_messages

MY_LOCALE *	lc_time_names

Time_zone *	time_zone

bool	explicit_defaults_for_timestamp

bool	sysdate_is_now

bool	binlog_rows_query_log_events

double	long_query_time_double

bool	pseudo_replica_mode

Gtid_specification	gtid_next

Gtid_set_or_null	gtid_next_list

ulong	session_track_gtids

ulong	max_execution_time

char *	track_sysvars_ptr

bool	session_track_schema

bool	session_track_state_change

ulong	session_track_transaction_info

ulong	information_schema_stats_expiry

bool	show_create_table_verbosity
	Used for the verbosity of SHOW CREATE TABLE. More...

bool	show_old_temporals
	Compatibility option to mark the pre MySQL-5.6.4 temporals columns using the old format using comments for SHOW CREATE TABLE and in I_S.COLUMNS 'COLUMN_TYPE' field. More...

ulonglong	original_commit_timestamp

ulong	internal_tmp_mem_storage_engine

const CHARSET_INFO *	default_collation_for_utf8mb4

ulong	use_secondary_engine
	Used for controlling preparation of queries against secondary engine. More...

double	secondary_engine_cost_threshold
	Used for controlling which statements to execute in a secondary storage engine. More...

ulong	group_replication_consistency
	Used for controlling Group Replication consistency guarantees. More...

bool	sql_require_primary_key

bool	sql_generate_invisible_primary_key

bool	show_gipk_in_create_table_and_information_schema

uint32_t	original_server_version
	Used in replication to determine the server version of the original server where the transaction was executed. More...

uint32_t	immediate_server_version
	Used in replication to determine the server version of the immediate server in the replication topology. More...

bool	default_table_encryption
	Used to determine if the database or tablespace should be encrypted by default. More...

bool	print_identified_with_as_hex

bool	show_create_table_skip_secondary_engine

uint32_t	generated_random_password_length

bool	require_row_format

ulong	select_into_buffer_size

bool	select_into_disk_sync

uint	select_into_disk_sync_delay

ulong	terminology_use_previous

ulonglong	conn_mem_limit

ulong	conn_mem_chunk_size

bool	conn_global_mem_tracking

bool	xa_detach_on_prepare
	Switch which controls whether XA transactions are detached (made accessible to other connections for commit/rollback) as part of XA PREPARE (true), or at session disconnect (false, default). More...

char *	debug_sensitive_session_str

Explain_format_type	explain_format
	Used to specify the format in which the EXPLAIN statement should display information if the FORMAT option is not explicitly specified. More...

Member Data Documentation

◆ auto_increment_increment

ulong System_variables::auto_increment_increment

◆ auto_increment_offset

ulong System_variables::auto_increment_offset

◆ big_tables

bool System_variables::big_tables

◆ binlog_direct_non_trans_update

bool System_variables::binlog_direct_non_trans_update

◆ binlog_format

ulong System_variables::binlog_format

binlog format for this thd (see enum_binlog_format)

◆ binlog_row_image

ulong System_variables::binlog_row_image

◆ binlog_row_value_options

ulonglong System_variables::binlog_row_value_options

◆ binlog_rows_query_log_events

bool System_variables::binlog_rows_query_log_events

◆ binlog_trx_compression

bool System_variables::binlog_trx_compression

◆ binlog_trx_compression_level_zstd

uint System_variables::binlog_trx_compression_level_zstd

◆ binlog_trx_compression_type

ulong System_variables::binlog_trx_compression_type

◆ bulk_insert_buff_size

ulong System_variables::bulk_insert_buff_size

◆ character_set_client

const CHARSET_INFO* System_variables::character_set_client

◆ character_set_filesystem

const CHARSET_INFO* System_variables::character_set_filesystem

◆ character_set_results

const CHARSET_INFO* System_variables::character_set_results

◆ collation_connection

const CHARSET_INFO* System_variables::collation_connection

◆ collation_database

const CHARSET_INFO* System_variables::collation_database

◆ collation_server

const CHARSET_INFO* System_variables::collation_server

◆ completion_type

ulong System_variables::completion_type

◆ conn_global_mem_tracking

bool System_variables::conn_global_mem_tracking

See also: Sys_connection_global_memory_tracking

◆ conn_mem_chunk_size

ulong System_variables::conn_mem_chunk_size

See also: Sys_connection_memory_chunk_size

◆ conn_mem_limit

ulonglong System_variables::conn_mem_limit

See also: Sys_connection_memory_limit

◆ cte_max_recursion_depth

uint System_variables::cte_max_recursion_depth

◆ debug_sensitive_session_str

char* System_variables::debug_sensitive_session_str

See also: Sys_debug_sensitive_session_string

◆ default_collation_for_utf8mb4

const CHARSET_INFO* System_variables::default_collation_for_utf8mb4

◆ default_table_encryption

bool System_variables::default_table_encryption

Used to determine if the database or tablespace should be encrypted by default.

◆ default_week_format

ulong System_variables::default_week_format

◆ div_precincrement

ulong System_variables::div_precincrement

◆ dynamic_variables_allocs

LIST* System_variables::dynamic_variables_allocs

◆ dynamic_variables_head

uint System_variables::dynamic_variables_head

◆ dynamic_variables_ptr

char* System_variables::dynamic_variables_ptr

◆ dynamic_variables_size

uint System_variables::dynamic_variables_size

◆ dynamic_variables_version

ulong System_variables::dynamic_variables_version

◆ end_markers_in_json

bool System_variables::end_markers_in_json

◆ eq_range_index_dive_limit

uint System_variables::eq_range_index_dive_limit

◆ explain_format

Explain_format_type System_variables::explain_format

Used to specify the format in which the EXPLAIN statement should display information if the FORMAT option is not explicitly specified.

See also: Sys_explain_format

◆ explicit_defaults_for_timestamp

bool System_variables::explicit_defaults_for_timestamp

◆ generated_random_password_length

uint32_t System_variables::generated_random_password_length

See also: Sys_var_generated_random_password_length

◆ group_concat_max_len

ulong System_variables::group_concat_max_len

◆ group_replication_consistency

ulong System_variables::group_replication_consistency

Used for controlling Group Replication consistency guarantees.

◆ gtid_next

Gtid_specification System_variables::gtid_next

◆ gtid_next_list

Gtid_set_or_null System_variables::gtid_next_list

◆ histogram_generation_max_mem_size

ulonglong System_variables::histogram_generation_max_mem_size

◆ immediate_server_version

uint32_t System_variables::immediate_server_version

Used in replication to determine the server version of the immediate server in the replication topology.

◆ information_schema_stats_expiry

ulong System_variables::information_schema_stats_expiry

◆ internal_tmp_mem_storage_engine

ulong System_variables::internal_tmp_mem_storage_engine

◆ join_buff_size

ulong System_variables::join_buff_size

◆ keep_files_on_create

bool System_variables::keep_files_on_create

◆ lc_messages

MY_LOCALE* System_variables::lc_messages

◆ lc_time_names

MY_LOCALE* System_variables::lc_time_names

◆ lock_wait_timeout

ulong System_variables::lock_wait_timeout

◆ long_query_time

ulonglong System_variables::long_query_time

◆ long_query_time_double

double System_variables::long_query_time_double

◆ low_priority_updates

bool System_variables::low_priority_updates

◆ max_allowed_packet

ulong System_variables::max_allowed_packet

◆ max_error_count

ulong System_variables::max_error_count

◆ max_execution_time

ulong System_variables::max_execution_time

◆ max_heap_table_size

ulonglong System_variables::max_heap_table_size

◆ max_insert_delayed_threads

ulong System_variables::max_insert_delayed_threads

◆ max_join_size

ha_rows System_variables::max_join_size

◆ max_length_for_sort_data

ulong System_variables::max_length_for_sort_data

Unused.

◆ max_points_in_geometry

ulong System_variables::max_points_in_geometry

◆ max_seeks_for_key

ulong System_variables::max_seeks_for_key

◆ max_sort_length

ulong System_variables::max_sort_length

◆ max_sp_recursion_depth

ulong System_variables::max_sp_recursion_depth

◆ max_user_connections

uint System_variables::max_user_connections

◆ min_examined_row_limit

ulong System_variables::min_examined_row_limit

◆ my_aes_mode

ulong System_variables::my_aes_mode

◆ net_buffer_length

ulong System_variables::net_buffer_length

◆ net_interactive_timeout

ulong System_variables::net_interactive_timeout

◆ net_read_timeout

ulong System_variables::net_read_timeout

◆ net_retry_count

ulong System_variables::net_retry_count

◆ net_wait_timeout

ulong System_variables::net_wait_timeout

◆ net_write_timeout

ulong System_variables::net_write_timeout

◆ new_mode

bool System_variables::new_mode

◆ old_alter_table

bool System_variables::old_alter_table

◆ optimizer_max_subgraph_pairs

ulong System_variables::optimizer_max_subgraph_pairs

◆ optimizer_prune_level

ulong System_variables::optimizer_prune_level

◆ optimizer_search_depth

ulong System_variables::optimizer_search_depth

◆ optimizer_switch

ulonglong System_variables::optimizer_switch

◆ optimizer_trace

ulonglong System_variables::optimizer_trace

bitmap to tune optimizer tracing

◆ optimizer_trace_features

ulonglong System_variables::optimizer_trace_features

bitmap to select features to trace

◆ optimizer_trace_limit

long System_variables::optimizer_trace_limit

◆ optimizer_trace_max_mem_size

ulong System_variables::optimizer_trace_max_mem_size

◆ optimizer_trace_offset

long System_variables::optimizer_trace_offset

◆ option_bits

ulonglong System_variables::option_bits

OPTION_xxx constants, e.g. OPTION_PROFILING.

◆ original_commit_timestamp

ulonglong System_variables::original_commit_timestamp

◆ original_server_version

uint32_t System_variables::original_server_version

Used in replication to determine the server version of the original server where the transaction was executed.

◆ parser_max_mem_size

ulonglong System_variables::parser_max_mem_size

◆ preload_buff_size

ulong System_variables::preload_buff_size

◆ print_identified_with_as_hex

bool System_variables::print_identified_with_as_hex

See also: Sys_var_print_identified_with_as_hex

◆ profiling_history_size

ulong System_variables::profiling_history_size

◆ pseudo_replica_mode

bool System_variables::pseudo_replica_mode

◆ pseudo_thread_id

my_thread_id System_variables::pseudo_thread_id

In slave thread we need to know in behalf of which thread the query is being run to replicate temp tables properly.

◆ query_alloc_block_size

ulong System_variables::query_alloc_block_size

◆ query_prealloc_size

ulong System_variables::query_prealloc_size

◆ range_alloc_block_size

ulong System_variables::range_alloc_block_size

◆ range_optimizer_max_mem_size

ulong System_variables::range_optimizer_max_mem_size

◆ rbr_exec_mode_options

ulong System_variables::rbr_exec_mode_options

◆ read_buff_size

ulong System_variables::read_buff_size

◆ read_rnd_buff_size

ulong System_variables::read_rnd_buff_size

◆ require_row_format

bool System_variables::require_row_format

See also: Sys_var_require_row_format

◆ resultset_metadata

ulong System_variables::resultset_metadata

Controls what resultset metadata will be sent to the client.

See also: enum_resultset_metadata

◆ secondary_engine_cost_threshold

double System_variables::secondary_engine_cost_threshold

Used for controlling which statements to execute in a secondary storage engine.

Only queries with an estimated cost higher than this value will be attempted executed in a secondary storage engine.

◆ select_into_buffer_size

ulong System_variables::select_into_buffer_size

See also: Sys_select_into_buffer_size

◆ select_into_disk_sync

bool System_variables::select_into_disk_sync

See also: Sys_select_into_disk_sync

◆ select_into_disk_sync_delay

uint System_variables::select_into_disk_sync_delay

See also: Sys_select_disk_sync_delay

◆ select_limit

ha_rows System_variables::select_limit

◆ session_track_gtids

ulong System_variables::session_track_gtids

◆ session_track_schema

bool System_variables::session_track_schema

◆ session_track_state_change

bool System_variables::session_track_state_change

◆ session_track_transaction_info

ulong System_variables::session_track_transaction_info

◆ show_create_table_skip_secondary_engine

bool System_variables::show_create_table_skip_secondary_engine

See also: Sys_var_show_create_table_skip_secondary_engine

◆ show_create_table_verbosity

bool System_variables::show_create_table_verbosity

Used for the verbosity of SHOW CREATE TABLE.

Currently used for displaying the row format in the output even if the table uses default row format.

◆ show_gipk_in_create_table_and_information_schema

bool System_variables::show_gipk_in_create_table_and_information_schema

See also: Sys_show_gipk_in_create_table_and_information_schema

◆ show_old_temporals

bool System_variables::show_old_temporals

Compatibility option to mark the pre MySQL-5.6.4 temporals columns using the old format using comments for SHOW CREATE TABLE and in I_S.COLUMNS 'COLUMN_TYPE' field.

◆ sortbuff_size

ulong System_variables::sortbuff_size

◆ sql_generate_invisible_primary_key

bool System_variables::sql_generate_invisible_primary_key

See also: Sys_sql_generate_invisible_primary_key

◆ sql_log_bin

bool System_variables::sql_log_bin

◆ sql_mode

sql_mode_t System_variables::sql_mode

which non-standard SQL behaviour should be enabled

◆ sql_require_primary_key

bool System_variables::sql_require_primary_key

◆ ssl_fips_mode

ulong System_variables::ssl_fips_mode

◆ sysdate_is_now

bool System_variables::sysdate_is_now

◆ table_plugin

plugin_ref System_variables::table_plugin

◆ temp_table_plugin

plugin_ref System_variables::temp_table_plugin

◆ terminology_use_previous

ulong System_variables::terminology_use_previous

See also: Sys_terminology_use_previous

◆ time_zone

Time_zone* System_variables::time_zone

◆ tmp_table_size

ulonglong System_variables::tmp_table_size

◆ track_sysvars_ptr

char* System_variables::track_sysvars_ptr

◆ trans_alloc_block_size

ulong System_variables::trans_alloc_block_size

◆ trans_prealloc_size

ulong System_variables::trans_prealloc_size

◆ transaction_isolation

ulong System_variables::transaction_isolation

◆ transaction_read_only

bool System_variables::transaction_read_only

Default transaction access mode.

READ ONLY (true) or READ WRITE (false).

◆ transaction_write_set_extraction

ulong System_variables::transaction_write_set_extraction

◆ updatable_views_with_limit

ulong System_variables::updatable_views_with_limit

◆ use_secondary_engine

ulong System_variables::use_secondary_engine

Used for controlling preparation of queries against secondary engine.

◆ windowing_use_high_precision

bool System_variables::windowing_use_high_precision

◆ xa_detach_on_prepare

bool System_variables::xa_detach_on_prepare

Switch which controls whether XA transactions are detached (made accessible to other connections for commit/rollback) as part of XA PREPARE (true), or at session disconnect (false, default).

An important side effect of setting this to true is that temporary tables are disallowed in XA transactions. This is necessary because temporary tables and their contents (and thus changes to them) is bound to specific connections, so they don't make sense if XA transaction is committed or rolled back from another connection.

The documentation for this struct was generated from the following file:

sql/system_variables.h

Public Attributes