MySQL  8.0.18
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
 
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
 
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
 
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_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_slave_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_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
 
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
 

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

◆ 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

◆ cte_max_recursion_depth

uint System_variables::cte_max_recursion_depth

◆ 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

◆ 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

◆ 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_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_slave_mode

bool System_variables::pseudo_slave_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

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

◆ 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

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