MySQL 8.4.3
Source Code Documentation
|
#include <system_variables.h>
ulong System_variables::auto_increment_increment |
ulong System_variables::auto_increment_offset |
bool System_variables::big_tables |
bool System_variables::binlog_direct_non_trans_update |
ulong System_variables::binlog_format |
binlog format for this thd (see enum_binlog_format)
ulong System_variables::binlog_row_image |
ulonglong System_variables::binlog_row_value_options |
bool System_variables::binlog_rows_query_log_events |
bool System_variables::binlog_trx_compression |
uint System_variables::binlog_trx_compression_level_zstd |
ulong System_variables::binlog_trx_compression_type |
ulong System_variables::bulk_insert_buff_size |
const CHARSET_INFO* System_variables::character_set_client |
const CHARSET_INFO* System_variables::character_set_filesystem |
const CHARSET_INFO* System_variables::character_set_results |
const CHARSET_INFO* System_variables::collation_connection |
const CHARSET_INFO* System_variables::collation_database |
const CHARSET_INFO* System_variables::collation_server |
ulong System_variables::completion_type |
bool System_variables::conn_global_mem_tracking |
ulong System_variables::conn_mem_chunk_size |
ulonglong System_variables::conn_mem_limit |
uint System_variables::cte_max_recursion_depth |
char* System_variables::debug_sensitive_session_str |
char* System_variables::debug_set_operations_secondary_overflow_at |
const CHARSET_INFO* System_variables::default_collation_for_utf8mb4 |
bool System_variables::default_table_encryption |
Used to determine if the database or tablespace should be encrypted by default.
ulong System_variables::default_week_format |
ulong System_variables::div_precincrement |
LIST* System_variables::dynamic_variables_allocs |
uint System_variables::dynamic_variables_head |
char* System_variables::dynamic_variables_ptr |
uint System_variables::dynamic_variables_size |
ulong System_variables::dynamic_variables_version |
bool System_variables::end_markers_in_json |
uint System_variables::eq_range_index_dive_limit |
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.
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.
bool System_variables::explicit_defaults_for_timestamp |
uint32_t System_variables::generated_random_password_length |
ulong System_variables::group_concat_max_len |
ulong System_variables::group_replication_consistency |
Used for controlling Group Replication consistency guarantees.
Gtid_specification System_variables::gtid_next |
Gtid_set_or_null System_variables::gtid_next_list |
ulonglong System_variables::histogram_generation_max_mem_size |
uint32_t System_variables::immediate_server_version |
Used in replication to determine the server version of the immediate server in the replication topology.
ulong System_variables::information_schema_stats_expiry |
ulong System_variables::internal_tmp_mem_storage_engine |
ulong System_variables::join_buff_size |
bool System_variables::keep_files_on_create |
MY_LOCALE* System_variables::lc_messages |
MY_LOCALE* System_variables::lc_time_names |
ulong System_variables::lock_wait_timeout |
ulonglong System_variables::long_query_time |
double System_variables::long_query_time_double |
bool System_variables::low_priority_updates |
ulong System_variables::max_allowed_packet |
ulong System_variables::max_error_count |
ulong System_variables::max_execution_time |
ulonglong System_variables::max_heap_table_size |
ulong System_variables::max_insert_delayed_threads |
ha_rows System_variables::max_join_size |
ulong System_variables::max_length_for_sort_data |
Unused.
ulong System_variables::max_points_in_geometry |
ulong System_variables::max_seeks_for_key |
ulong System_variables::max_sort_length |
ulong System_variables::max_sp_recursion_depth |
uint System_variables::max_user_connections |
ulong System_variables::min_examined_row_limit |
ulong System_variables::my_aes_mode |
ulong System_variables::net_buffer_length |
ulong System_variables::net_interactive_timeout |
ulong System_variables::net_read_timeout |
ulong System_variables::net_retry_count |
ulong System_variables::net_wait_timeout |
ulong System_variables::net_write_timeout |
bool System_variables::old_alter_table |
ulong System_variables::optimizer_max_subgraph_pairs |
ulong System_variables::optimizer_prune_level |
ulong System_variables::optimizer_search_depth |
ulonglong System_variables::optimizer_switch |
ulonglong System_variables::optimizer_trace |
bitmap to tune optimizer tracing
ulonglong System_variables::optimizer_trace_features |
bitmap to select features to trace
long System_variables::optimizer_trace_limit |
ulong System_variables::optimizer_trace_max_mem_size |
long System_variables::optimizer_trace_offset |
ulonglong System_variables::option_bits |
OPTION_xxx constants, e.g. OPTION_PROFILING.
ulonglong System_variables::original_commit_timestamp |
uint32_t System_variables::original_server_version |
Used in replication to determine the server version of the original server where the transaction was executed.
ulonglong System_variables::parser_max_mem_size |
ulong System_variables::preload_buff_size |
bool System_variables::print_identified_with_as_hex |
ulong System_variables::profiling_history_size |
bool System_variables::pseudo_replica_mode |
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.
ulong System_variables::query_alloc_block_size |
ulong System_variables::query_prealloc_size |
ulong System_variables::range_alloc_block_size |
ulong System_variables::range_optimizer_max_mem_size |
ulong System_variables::rbr_exec_mode_options |
ulong System_variables::read_buff_size |
ulong System_variables::read_rnd_buff_size |
bool System_variables::require_row_format |
bool System_variables::restrict_fk_on_non_standard_key |
Restrict foreign keys on non-unique or partial keys.
ulong System_variables::resultset_metadata |
Controls what resultset metadata will be sent to the client.
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.
ulong System_variables::select_into_buffer_size |
bool System_variables::select_into_disk_sync |
uint System_variables::select_into_disk_sync_delay |
ha_rows System_variables::select_limit |
ulong System_variables::session_track_gtids |
bool System_variables::session_track_schema |
bool System_variables::session_track_state_change |
ulong System_variables::session_track_transaction_info |
ulonglong System_variables::set_operations_buffer_size |
Max size of set operations hash buffer size.
bool System_variables::show_create_table_skip_secondary_engine |
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.
bool System_variables::show_gipk_in_create_table_and_information_schema |
ulong System_variables::sortbuff_size |
bool System_variables::sql_generate_invisible_primary_key |
bool System_variables::sql_log_bin |
sql_mode_t System_variables::sql_mode |
which non-standard SQL behaviour should be enabled
bool System_variables::sql_require_primary_key |
ulong System_variables::ssl_fips_mode |
bool System_variables::sysdate_is_now |
plugin_ref System_variables::table_plugin |
plugin_ref System_variables::temp_table_plugin |
ulong System_variables::terminology_use_previous |
Time_zone* System_variables::time_zone |
ulonglong System_variables::tmp_table_size |
char* System_variables::track_sysvars_ptr |
ulong System_variables::trans_alloc_block_size |
ulong System_variables::trans_prealloc_size |
ulong System_variables::transaction_isolation |
bool System_variables::transaction_read_only |
Default transaction access mode.
READ ONLY (true) or READ WRITE (false).
ulong System_variables::updatable_views_with_limit |
ulong System_variables::use_secondary_engine |
Used for controlling preparation of queries against secondary engine.
bool System_variables::windowing_use_high_precision |
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.