24#ifndef SYSTEM_VARIABLES_INCLUDED
25#define SYSTEM_VARIABLES_INCLUDED
178#define MODE_IGNORED_MASK \
515static_assert(std::is_trivially_copyable<System_variables>::value);
516static_assert(std::is_trivial<System_variables>::value);
517static_assert(std::is_standard_layout<System_variables>::value);
606#define LAST_STATUS_VAR secondary_engine_execution_count
613#define FIRST_STATUS_VAR created_tmp_disk_tables
Definition: sql_locale.h:37
This class represents abstract time zone and provides basic interface for MYSQL_TIME <-> my_time_t co...
Definition: tztime.h:49
uint64_t sql_mode_t
Definition: dd_event.h:39
A better implementation of the UNIX ctype(3) library.
This file includes constants used by all storage engines.
my_off_t ha_rows
Definition: my_base.h:1141
Some integer typedefs for easier portability.
unsigned long long int ulonglong
Definition: my_inttypes.h:56
@ SQLCOM_END
Definition: my_sqlcommand.h:208
uint32 my_thread_id
Definition: my_thread_local.h:34
SHOW_VAR status_vars[]
Definition: mysqld.cc:11277
Definition: m_ctype.h:423
Holds information about a Gtid_set.
Definition: rpl_gtid.h:2526
This struct represents a specification of a GTID for a statement to be executed: either "AUTOMATIC",...
Definition: rpl_gtid.h:3985
Per thread status variables.
Definition: system_variables.h:525
ulonglong com_stmt_reprepare
Definition: system_variables.h:569
ulonglong bytes_sent
Definition: system_variables.h:577
ulonglong ha_read_first_count
Definition: system_variables.h:531
ulonglong long_query_count
Definition: system_variables.h:562
ulonglong ha_commit_count
Definition: system_variables.h:529
ulonglong secondary_engine_execution_count
How many queries have been executed on a secondary storage engine.
Definition: system_variables.h:587
ulonglong opened_tables
Definition: system_variables.h:552
ulonglong created_tmp_tables
Definition: system_variables.h:528
ulonglong com_stmt_prepare
Definition: system_variables.h:568
ulonglong max_execution_time_exceeded
Definition: system_variables.h:579
ulonglong table_open_cache_overflows
Definition: system_variables.h:556
ulonglong select_full_range_join_count
Definition: system_variables.h:558
ulonglong select_full_join_count
Definition: system_variables.h:557
ulonglong ha_savepoint_count
Definition: system_variables.h:549
ulonglong table_open_cache_misses
Definition: system_variables.h:555
ulonglong filesort_range_count
Definition: system_variables.h:564
ulonglong last_query_partial_plans
Definition: system_variables.h:598
ulong com_other
Definition: system_variables.h:589
ulonglong max_execution_time_set_failed
Definition: system_variables.h:581
ulonglong filesort_scan_count
Definition: system_variables.h:566
ulonglong com_stmt_execute
Definition: system_variables.h:570
ulong com_stat[(uint) SQLCOM_END]
Definition: system_variables.h:590
ulonglong com_stmt_reset
Definition: system_variables.h:573
ulonglong ha_read_next_count
Definition: system_variables.h:534
ulonglong ha_update_count
Definition: system_variables.h:545
ulonglong ha_read_rnd_count
Definition: system_variables.h:536
ulonglong ha_read_rnd_next_count
Definition: system_variables.h:537
ulonglong com_stmt_fetch
Definition: system_variables.h:572
ulonglong created_tmp_disk_tables
Definition: system_variables.h:527
ulonglong opened_shares
Definition: system_variables.h:553
ulonglong com_stmt_send_long_data
Definition: system_variables.h:571
ulonglong com_stmt_close
Definition: system_variables.h:574
ulonglong bytes_received
Definition: system_variables.h:576
double last_query_cost
Definition: system_variables.h:597
ulonglong ha_read_prev_count
Definition: system_variables.h:535
ulonglong select_range_check_count
Definition: system_variables.h:560
ulonglong table_open_cache_hits
Definition: system_variables.h:554
ulonglong filesort_merge_passes
Definition: system_variables.h:563
ulonglong ha_read_last_count
Definition: system_variables.h:532
ulonglong ha_delete_count
Definition: system_variables.h:530
ulonglong ha_multi_range_read_init_count
Definition: system_variables.h:543
ulonglong filesort_rows
Definition: system_variables.h:565
ulonglong ha_savepoint_rollback_count
Definition: system_variables.h:550
ulonglong ha_external_lock_count
Definition: system_variables.h:551
ulonglong ha_read_key_count
Definition: system_variables.h:533
ulonglong select_range_count
Definition: system_variables.h:559
ulonglong ha_rollback_count
Definition: system_variables.h:544
ulonglong ha_prepare_count
Definition: system_variables.h:547
ulonglong ha_write_count
Definition: system_variables.h:546
ulonglong questions
Definition: system_variables.h:584
ulonglong select_scan_count
Definition: system_variables.h:561
ulonglong max_execution_time_set
Definition: system_variables.h:580
ulonglong ha_discover_count
Definition: system_variables.h:548
Definition: system_variables.h:203
ulong read_rnd_buff_size
Definition: system_variables.h:263
plugin_ref temp_table_plugin
Definition: system_variables.h:312
ulong use_secondary_engine
Used for controlling preparation of queries against secondary engine.
Definition: system_variables.h:378
ulong profiling_history_size
Definition: system_variables.h:261
ulong group_concat_max_len
Definition: system_variables.h:274
long optimizer_trace_offset
Definition: system_variables.h:228
ulong trans_prealloc_size
Definition: system_variables.h:273
bool show_create_table_skip_secondary_engine
Definition: system_variables.h:429
ulong trans_alloc_block_size
Definition: system_variables.h:272
bool print_identified_with_as_hex
Definition: system_variables.h:424
bool transaction_read_only
Default transaction access mode.
Definition: system_variables.h:304
ulonglong parser_max_mem_size
Definition: system_variables.h:258
bool select_into_disk_sync
Definition: system_variables.h:447
ulonglong conn_mem_limit
Definition: system_variables.h:461
uint cte_max_recursion_depth
Definition: system_variables.h:238
ulong range_optimizer_max_mem_size
Definition: system_variables.h:259
ulong min_examined_row_limit
Definition: system_variables.h:248
uint32_t original_server_version
Used in replication to determine the server version of the original server where the transaction was ...
Definition: system_variables.h:407
bool sql_generate_invisible_primary_key
Definition: system_variables.h:396
ulong max_length_for_sort_data
Unused.
Definition: system_variables.h:244
ulong net_retry_count
Definition: system_variables.h:252
ulong resultset_metadata
Controls what resultset metadata will be sent to the client.
Definition: system_variables.h:294
ulong read_buff_size
Definition: system_variables.h:262
bool sysdate_is_now
Definition: system_variables.h:339
bool show_gipk_in_create_table_and_information_schema
Definition: system_variables.h:401
bool session_track_schema
Definition: system_variables.h:353
ulong ssl_fips_mode
Definition: system_variables.h:289
ulong optimizer_search_depth
Definition: system_variables.h:256
double long_query_time_double
Definition: system_variables.h:342
ulong max_sp_recursion_depth
Definition: system_variables.h:266
ulong max_insert_delayed_threads
Definition: system_variables.h:247
double secondary_engine_cost_threshold
Used for controlling which statements to execute in a secondary storage engine.
Definition: system_variables.h:386
char * dynamic_variables_ptr
Definition: system_variables.h:214
long optimizer_trace_limit
Definition: system_variables.h:229
const CHARSET_INFO * character_set_filesystem
Definition: system_variables.h:315
ulong auto_increment_offset
Definition: system_variables.h:235
ulong net_buffer_length
Definition: system_variables.h:249
ulong binlog_trx_compression_type
Definition: system_variables.h:280
MY_LOCALE * lc_messages
Definition: system_variables.h:325
ulong max_points_in_geometry
Definition: system_variables.h:245
ulong lock_wait_timeout
Definition: system_variables.h:241
ulonglong option_bits
OPTION_xxx constants, e.g. OPTION_PROFILING.
Definition: system_variables.h:232
ulong information_schema_stats_expiry
Definition: system_variables.h:361
ulong join_buff_size
Definition: system_variables.h:240
bool windowing_use_high_precision
Definition: system_variables.h:223
uint select_into_disk_sync_delay
Definition: system_variables.h:451
ulong net_read_timeout
Definition: system_variables.h:251
uint32_t generated_random_password_length
Definition: system_variables.h:434
ulong auto_increment_increment
Definition: system_variables.h:235
ulong max_execution_time
Definition: system_variables.h:350
MY_LOCALE * lc_time_names
Definition: system_variables.h:327
ulong session_track_gtids
Definition: system_variables.h:348
ulonglong long_query_time
Definition: system_variables.h:221
ulonglong optimizer_switch
Definition: system_variables.h:225
bool binlog_rows_query_log_events
Definition: system_variables.h:340
ulong net_write_timeout
Definition: system_variables.h:254
ulonglong original_commit_timestamp
Definition: system_variables.h:370
char * debug_sensitive_session_str
Definition: system_variables.h:486
LIST * dynamic_variables_allocs
Definition: system_variables.h:217
ulong max_allowed_packet
Definition: system_variables.h:242
ulonglong optimizer_trace_features
bitmap to select features to trace
Definition: system_variables.h:227
bool explicit_defaults_for_timestamp
Definition: system_variables.h:337
bool end_markers_in_json
Definition: system_variables.h:222
ulong optimizer_prune_level
Definition: system_variables.h:255
bool require_row_format
Definition: system_variables.h:439
Time_zone * time_zone
Definition: system_variables.h:329
Gtid_specification gtid_next
Definition: system_variables.h:346
bool big_tables
Definition: system_variables.h:309
ulong range_alloc_block_size
Definition: system_variables.h:269
ulong conn_mem_chunk_size
Definition: system_variables.h:465
ulong dynamic_variables_version
Definition: system_variables.h:213
bool session_track_state_change
Definition: system_variables.h:354
ulong binlog_row_image
Definition: system_variables.h:278
uint32_t immediate_server_version
Used in replication to determine the server version of the immediate server in the replication topolo...
Definition: system_variables.h:413
bool show_create_table_verbosity
Used for the verbosity of SHOW CREATE TABLE.
Definition: system_variables.h:367
bool sql_log_bin
Definition: system_variables.h:283
ulong updatable_views_with_limit
Definition: system_variables.h:286
ulong transaction_isolation
Definition: system_variables.h:285
uint explain_json_format_version
Used to specify the JSON format version used by EXPLAIN FORMAT=JSON with the old (non-hypergraph) joi...
Definition: system_variables.h:500
sql_mode_t sql_mode
which non-standard SQL behaviour should be enabled
Definition: system_variables.h:231
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 ta...
Definition: system_variables.h:300
Gtid_set_or_null gtid_next_list
Definition: system_variables.h:347
ulonglong tmp_table_size
Definition: system_variables.h:220
ulong query_prealloc_size
Definition: system_variables.h:271
const CHARSET_INFO * collation_server
Definition: system_variables.h:320
bool xa_detach_on_prepare
Switch which controls whether XA transactions are detached (made accessible to other connections for ...
Definition: system_variables.h:481
ulonglong binlog_row_value_options
Definition: system_variables.h:282
ulonglong max_heap_table_size
Definition: system_variables.h:219
ulong rbr_exec_mode_options
Definition: system_variables.h:276
const CHARSET_INFO * character_set_client
Definition: system_variables.h:316
ulong terminology_use_previous
Definition: system_variables.h:456
uint binlog_trx_compression_level_zstd
Definition: system_variables.h:281
bool keep_files_on_create
Definition: system_variables.h:306
const CHARSET_INFO * default_collation_for_utf8mb4
Definition: system_variables.h:375
ulong optimizer_trace_max_mem_size
Definition: system_variables.h:230
bool restrict_fk_on_non_standard_key
Restrict foreign keys on non-unique or partial keys.
Definition: system_variables.h:512
bool conn_global_mem_tracking
Definition: system_variables.h:469
ulong bulk_insert_buff_size
Definition: system_variables.h:236
uint max_user_connections
Definition: system_variables.h:287
ulonglong histogram_generation_max_mem_size
Definition: system_variables.h:239
bool binlog_direct_non_trans_update
Definition: system_variables.h:277
ulong default_week_format
Definition: system_variables.h:267
ulong completion_type
Definition: system_variables.h:284
bool binlog_trx_compression
Definition: system_variables.h:279
uint dynamic_variables_size
Definition: system_variables.h:216
plugin_ref table_plugin
Definition: system_variables.h:311
ulong group_replication_consistency
Used for controlling Group Replication consistency guarantees.
Definition: system_variables.h:389
ha_rows max_join_size
Definition: system_variables.h:234
const CHARSET_INFO * character_set_results
Definition: system_variables.h:317
bool pseudo_replica_mode
Definition: system_variables.h:344
char * track_sysvars_ptr
Definition: system_variables.h:352
ulong div_precincrement
Definition: system_variables.h:264
bool low_priority_updates
Definition: system_variables.h:305
uint dynamic_variables_head
Definition: system_variables.h:215
ulong net_interactive_timeout
Definition: system_variables.h:250
ulonglong set_operations_buffer_size
Max size of set operations hash buffer size.
Definition: system_variables.h:503
const CHARSET_INFO * collation_database
Definition: system_variables.h:321
ulong select_into_buffer_size
Definition: system_variables.h:443
ulong preload_buff_size
Definition: system_variables.h:260
ulong binlog_format
binlog format for this thd (see enum_binlog_format)
Definition: system_variables.h:275
ulong max_sort_length
Definition: system_variables.h:246
ulong net_wait_timeout
Definition: system_variables.h:253
bool sql_require_primary_key
Definition: system_variables.h:391
char * debug_set_operations_secondary_overflow_at
Definition: system_variables.h:505
bool default_table_encryption
Used to determine if the database or tablespace should be encrypted by default.
Definition: system_variables.h:419
ulong query_alloc_block_size
Definition: system_variables.h:270
ulong max_seeks_for_key
Definition: system_variables.h:268
ulong my_aes_mode
Definition: system_variables.h:288
ulonglong optimizer_trace
bitmap to tune optimizer tracing
Definition: system_variables.h:226
bool old_alter_table
Definition: system_variables.h:308
uint eq_range_index_dive_limit
Definition: system_variables.h:237
ha_rows select_limit
Definition: system_variables.h:233
ulong max_error_count
Definition: system_variables.h:243
ulong internal_tmp_mem_storage_engine
Definition: system_variables.h:373
const CHARSET_INFO * collation_connection
Definition: system_variables.h:322
Explain_format_type explain_format
Used to specify the format in which the EXPLAIN statement should display information if the FORMAT op...
Definition: system_variables.h:493
ulong session_track_transaction_info
Definition: system_variables.h:355
ulong sortbuff_size
Definition: system_variables.h:265
ulong optimizer_max_subgraph_pairs
Definition: system_variables.h:257
Definition: sql_plugin_ref.h:45
constexpr sql_mode_t MODE_NO_ENGINE_SUBSTITUTION
Definition: system_variables.h:154
constexpr sql_mode_t MODE_ALLOWED_MASK
Definition: system_variables.h:165
constexpr sql_mode_t MODE_NOT_USED
Definition: system_variables.h:127
constexpr sql_mode_t MODE_INVALID_DATES
Definition: system_variables.h:148
enum_rbr_exec_mode
Definition: system_variables.h:55
@ RBR_EXEC_MODE_LAST_BIT
Definition: system_variables.h:58
@ RBR_EXEC_MODE_IDEMPOTENT
Definition: system_variables.h:57
@ RBR_EXEC_MODE_STRICT
Definition: system_variables.h:56
constexpr sql_mode_t MODE_NO_BACKSLASH_ESCAPES
Definition: system_variables.h:133
constexpr sql_mode_t MODE_NO_UNSIGNED_SUBTRACTION
Definition: system_variables.h:129
constexpr sql_mode_t MODE_TRADITIONAL
Definition: system_variables.h:151
constexpr sql_mode_t MODE_TIME_TRUNCATE_FRACTIONAL
Definition: system_variables.h:161
void add_to_status(System_status_var *to_var, System_status_var *from_var)
Definition: system_variables.cc:42
use_secondary_engine
Values for use_secondary_engine sysvar.
Definition: system_variables.h:92
@ SECONDARY_ENGINE_OFF
Definition: system_variables.h:93
@ SECONDARY_ENGINE_FORCED
Definition: system_variables.h:95
@ SECONDARY_ENGINE_ON
Definition: system_variables.h:94
enum_binlog_row_metadata
Definition: system_variables.h:79
@ BINLOG_ROW_METADATA_FULL
Definition: system_variables.h:81
@ BINLOG_ROW_METADATA_MINIMAL
Definition: system_variables.h:80
constexpr sql_mode_t MODE_NO_ZERO_IN_DATE
Definition: system_variables.h:146
enum_binlog_row_value_options
Definition: system_variables.h:73
@ PARTIAL_JSON_UPDATES
Store JSON updates in partial form.
Definition: system_variables.h:75
constexpr sql_mode_t MODE_ONLY_FULL_GROUP_BY
Definition: system_variables.h:128
#define LAST_STATUS_VAR
Definition: system_variables.h:606
Explain_format_type
Values for explain_format sysvar.
Definition: system_variables.h:115
constexpr sql_mode_t MODE_ERROR_FOR_DIVISION_BY_ZERO
Definition: system_variables.h:149
const int COUNT_GLOBAL_STATUS_VARS
Definition: system_variables.h:616
constexpr sql_mode_t MODE_STRICT_TRANS_TABLES
Definition: system_variables.h:135
constexpr sql_mode_t MODE_PIPES_AS_CONCAT
Definition: system_variables.h:124
#define FIRST_STATUS_VAR
Definition: system_variables.h:613
constexpr sql_mode_t MODE_NO_AUTO_VALUE_ON_ZERO
Definition: system_variables.h:132
void reset_system_status_vars(System_status_var *status_vars)
Definition: system_variables.cc:95
enum_binlog_row_image
Definition: system_variables.h:62
@ BINLOG_ROW_IMAGE_MINIMAL
PKE in the before image and changed columns in the after image.
Definition: system_variables.h:64
@ BINLOG_ROW_IMAGE_FULL
All columns in both before and after image.
Definition: system_variables.h:69
@ BINLOG_ROW_IMAGE_NOBLOB
Whenever possible, before and after image contain all columns except blobs.
Definition: system_variables.h:67
constexpr sql_mode_t MODE_NO_ZERO_DATE
Definition: system_variables.h:147
constexpr sql_mode_t MODE_LAST
Definition: system_variables.h:163
void add_diff_to_status(System_status_var *to_var, System_status_var *from_var, System_status_var *dec_var)
Definition: system_variables.cc:70
constexpr sql_mode_t MODE_REAL_AS_FLOAT
Definition: system_variables.h:123
constexpr sql_mode_t MODE_NO_DIR_IN_CREATE
Definition: system_variables.h:130
enum_binlog_format
Definition: system_variables.h:46
@ BINLOG_FORMAT_UNSPEC
thd_binlog_format() returns it when binlog is closed
Definition: system_variables.h:50
@ BINLOG_FORMAT_MIXED
statement if safe, otherwise row - autodetected
Definition: system_variables.h:47
@ BINLOG_FORMAT_ROW
row-based
Definition: system_variables.h:49
@ BINLOG_FORMAT_STMT
statement-based
Definition: system_variables.h:48
enum_session_track_gtids
Definition: system_variables.h:85
@ SESSION_TRACK_GTIDS_ALL_GTIDS
Definition: system_variables.h:88
@ SESSION_TRACK_GTIDS_OWN_GTID
Definition: system_variables.h:87
@ SESSION_TRACK_GTIDS_OFF
Definition: system_variables.h:86
constexpr sql_mode_t MODE_STRICT_ALL_TABLES
Definition: system_variables.h:137
constexpr sql_mode_t MODE_PAD_CHAR_TO_FULL_LENGTH
Definition: system_variables.h:156
constexpr sql_mode_t MODE_ANSI
Definition: system_variables.h:131
constexpr sql_mode_t MODE_IGNORE_SPACE
Definition: system_variables.h:126
constexpr sql_mode_t MODE_HIGH_NOT_PRECEDENCE
Definition: system_variables.h:153
constexpr sql_mode_t MODE_ANSI_QUOTES
Definition: system_variables.h:125