MySQL 8.4.3
Source Code Documentation
System_variables Struct Reference

#include <system_variables.h>

Public Attributes

ulong dynamic_variables_version
 
char * dynamic_variables_ptr
 
uint dynamic_variables_head
 
uint dynamic_variables_size
 
LISTdynamic_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 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 keep_files_on_create
 
bool old_alter_table
 
bool big_tables
 
plugin_ref table_plugin
 
plugin_ref temp_table_plugin
 
const CHARSET_INFOcharacter_set_filesystem
 
const CHARSET_INFOcharacter_set_client
 
const CHARSET_INFOcharacter_set_results
 
const CHARSET_INFOcollation_server
 
const CHARSET_INFOcollation_database
 
const CHARSET_INFOcollation_connection
 
MY_LOCALElc_messages
 
MY_LOCALElc_time_names
 
Time_zonetime_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...
 
ulonglong original_commit_timestamp
 
ulong internal_tmp_mem_storage_engine
 
const CHARSET_INFOdefault_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...
 
uint explain_json_format_version
 Used to specify the JSON format version used by EXPLAIN FORMAT=JSON with the old (non-hypergraph) join optimizer. More...
 
ulonglong set_operations_buffer_size
 Max size of set operations hash buffer size. More...
 
char * debug_set_operations_secondary_overflow_at
 
bool restrict_fk_on_non_standard_key
 Restrict foreign keys on non-unique or partial keys. 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

◆ debug_set_operations_secondary_overflow_at

char* System_variables::debug_set_operations_secondary_overflow_at

◆ 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

◆ explain_json_format_version

uint System_variables::explain_json_format_version

Used to specify the JSON format version used by EXPLAIN FORMAT=JSON with the old (non-hypergraph) join optimizer.

See also
Sys_explain_json_format_version

◆ 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

◆ 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

◆ restrict_fk_on_non_standard_key

bool System_variables::restrict_fk_on_non_standard_key

Restrict foreign keys on non-unique or partial keys.

See also
Sys_restrict_fk_on_non_standard_key

◆ 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

◆ set_operations_buffer_size

ulonglong System_variables::set_operations_buffer_size

Max size of set operations hash buffer size.

◆ 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

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

◆ 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: