23#ifndef SYSTEM_VARIABLES_INCLUDED
24#define SYSTEM_VARIABLES_INCLUDED
128#define MODE_REAL_AS_FLOAT 1
129#define MODE_PIPES_AS_CONCAT 2
130#define MODE_ANSI_QUOTES 4
131#define MODE_IGNORE_SPACE 8
132#define MODE_NOT_USED 16
133#define MODE_ONLY_FULL_GROUP_BY 32
134#define MODE_NO_UNSIGNED_SUBTRACTION 64
135#define MODE_NO_DIR_IN_CREATE 128
136#define MODE_ANSI 262144L
137#define MODE_NO_AUTO_VALUE_ON_ZERO (MODE_ANSI * 2)
138#define MODE_NO_BACKSLASH_ESCAPES (MODE_NO_AUTO_VALUE_ON_ZERO * 2)
139#define MODE_STRICT_TRANS_TABLES (MODE_NO_BACKSLASH_ESCAPES * 2)
140#define MODE_STRICT_ALL_TABLES (MODE_STRICT_TRANS_TABLES * 2)
148#define MODE_NO_ZERO_IN_DATE (MODE_STRICT_ALL_TABLES * 2)
149#define MODE_NO_ZERO_DATE (MODE_NO_ZERO_IN_DATE * 2)
150#define MODE_INVALID_DATES (MODE_NO_ZERO_DATE * 2)
151#define MODE_ERROR_FOR_DIVISION_BY_ZERO (MODE_INVALID_DATES * 2)
152#define MODE_TRADITIONAL (MODE_ERROR_FOR_DIVISION_BY_ZERO * 2)
153#define MODE_HIGH_NOT_PRECEDENCE (1ULL << 29)
154#define MODE_NO_ENGINE_SUBSTITUTION (MODE_HIGH_NOT_PRECEDENCE * 2)
155#define MODE_PAD_CHAR_TO_FULL_LENGTH (1ULL << 31)
160#define MODE_TIME_TRUNCATE_FRACTIONAL (1ULL << 32)
162#define MODE_LAST (1ULL << 33)
164#define MODE_ALLOWED_MASK \
165 (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES | \
166 MODE_IGNORE_SPACE | MODE_NOT_USED | MODE_ONLY_FULL_GROUP_BY | \
167 MODE_NO_UNSIGNED_SUBTRACTION | MODE_NO_DIR_IN_CREATE | MODE_ANSI | \
168 MODE_NO_AUTO_VALUE_ON_ZERO | MODE_NO_BACKSLASH_ESCAPES | \
169 MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES | MODE_NO_ZERO_IN_DATE | \
170 MODE_NO_ZERO_DATE | MODE_INVALID_DATES | MODE_ERROR_FOR_DIVISION_BY_ZERO | \
171 MODE_TRADITIONAL | MODE_HIGH_NOT_PRECEDENCE | MODE_NO_ENGINE_SUBSTITUTION | \
172 MODE_PAD_CHAR_TO_FULL_LENGTH | MODE_TIME_TRUNCATE_FRACTIONAL)
177#define MODE_IGNORED_MASK \
591#define LAST_STATUS_VAR secondary_engine_execution_count
598#define FIRST_STATUS_VAR created_tmp_disk_tables
Definition: sql_locale.h:36
This class represents abstract time zone and provides basic interface for MYSQL_TIME <-> my_time_t co...
Definition: tztime.h:48
ulonglong sql_mode_t
Definition: dd_event.h:36
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:1139
Some integer typedefs for easier portability.
unsigned long long int ulonglong
Definition: my_inttypes.h:55
@ SQLCOM_END
Definition: my_sqlcommand.h:207
uint32 my_thread_id
Definition: my_thread_local.h:33
SHOW_VAR status_vars[]
Definition: mysqld.cc:9723
Definition: m_ctype.h:422
Holds information about a Gtid_set.
Definition: rpl_gtid.h:2380
This struct represents a specification of a GTID for a statement to be executed: either "AUTOMATIC",...
Definition: rpl_gtid.h:3801
Per thread status variables.
Definition: system_variables.h:510
ulonglong com_stmt_reprepare
Definition: system_variables.h:554
ulonglong bytes_sent
Definition: system_variables.h:562
ulonglong ha_read_first_count
Definition: system_variables.h:516
ulonglong long_query_count
Definition: system_variables.h:547
ulonglong ha_commit_count
Definition: system_variables.h:514
ulonglong secondary_engine_execution_count
How many queries have been executed on a secondary storage engine.
Definition: system_variables.h:572
ulonglong opened_tables
Definition: system_variables.h:537
ulonglong created_tmp_tables
Definition: system_variables.h:513
ulonglong com_stmt_prepare
Definition: system_variables.h:553
ulonglong max_execution_time_exceeded
Definition: system_variables.h:564
ulonglong table_open_cache_overflows
Definition: system_variables.h:541
ulonglong select_full_range_join_count
Definition: system_variables.h:543
ulonglong select_full_join_count
Definition: system_variables.h:542
ulonglong ha_savepoint_count
Definition: system_variables.h:534
ulonglong table_open_cache_misses
Definition: system_variables.h:540
ulonglong filesort_range_count
Definition: system_variables.h:549
ulonglong last_query_partial_plans
Definition: system_variables.h:583
ulong com_other
Definition: system_variables.h:574
ulonglong max_execution_time_set_failed
Definition: system_variables.h:566
ulonglong filesort_scan_count
Definition: system_variables.h:551
ulonglong com_stmt_execute
Definition: system_variables.h:555
ulong com_stat[(uint) SQLCOM_END]
Definition: system_variables.h:575
ulonglong com_stmt_reset
Definition: system_variables.h:558
ulonglong ha_read_next_count
Definition: system_variables.h:519
ulonglong ha_update_count
Definition: system_variables.h:530
ulonglong ha_read_rnd_count
Definition: system_variables.h:521
ulonglong ha_read_rnd_next_count
Definition: system_variables.h:522
ulonglong com_stmt_fetch
Definition: system_variables.h:557
ulonglong created_tmp_disk_tables
Definition: system_variables.h:512
ulonglong opened_shares
Definition: system_variables.h:538
ulonglong com_stmt_send_long_data
Definition: system_variables.h:556
ulonglong com_stmt_close
Definition: system_variables.h:559
ulonglong bytes_received
Definition: system_variables.h:561
double last_query_cost
Definition: system_variables.h:582
ulonglong ha_read_prev_count
Definition: system_variables.h:520
ulonglong select_range_check_count
Definition: system_variables.h:545
ulonglong table_open_cache_hits
Definition: system_variables.h:539
ulonglong filesort_merge_passes
Definition: system_variables.h:548
ulonglong ha_read_last_count
Definition: system_variables.h:517
ulonglong ha_delete_count
Definition: system_variables.h:515
ulonglong ha_multi_range_read_init_count
Definition: system_variables.h:528
ulonglong filesort_rows
Definition: system_variables.h:550
ulonglong ha_savepoint_rollback_count
Definition: system_variables.h:535
ulonglong ha_external_lock_count
Definition: system_variables.h:536
ulonglong ha_read_key_count
Definition: system_variables.h:518
ulonglong select_range_count
Definition: system_variables.h:544
ulonglong ha_rollback_count
Definition: system_variables.h:529
ulonglong ha_prepare_count
Definition: system_variables.h:532
ulonglong ha_write_count
Definition: system_variables.h:531
ulonglong questions
Definition: system_variables.h:569
ulonglong select_scan_count
Definition: system_variables.h:546
ulonglong max_execution_time_set
Definition: system_variables.h:565
ulonglong ha_discover_count
Definition: system_variables.h:533
Definition: system_variables.h:202
ulong read_rnd_buff_size
Definition: system_variables.h:262
plugin_ref temp_table_plugin
Definition: system_variables.h:314
ulong use_secondary_engine
Used for controlling preparation of queries against secondary engine.
Definition: system_variables.h:386
ulong profiling_history_size
Definition: system_variables.h:260
ulong group_concat_max_len
Definition: system_variables.h:273
long optimizer_trace_offset
Definition: system_variables.h:227
ulong trans_prealloc_size
Definition: system_variables.h:272
bool show_create_table_skip_secondary_engine
Definition: system_variables.h:437
ulong trans_alloc_block_size
Definition: system_variables.h:271
bool print_identified_with_as_hex
Definition: system_variables.h:432
bool new_mode
Definition: system_variables.h:307
bool transaction_read_only
Default transaction access mode.
Definition: system_variables.h:305
ulonglong parser_max_mem_size
Definition: system_variables.h:257
bool select_into_disk_sync
Definition: system_variables.h:455
ulonglong conn_mem_limit
Definition: system_variables.h:469
uint cte_max_recursion_depth
Definition: system_variables.h:237
ulong range_optimizer_max_mem_size
Definition: system_variables.h:258
ulong min_examined_row_limit
Definition: system_variables.h:247
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:415
bool sql_generate_invisible_primary_key
Definition: system_variables.h:404
ulong max_length_for_sort_data
Unused.
Definition: system_variables.h:243
ulong net_retry_count
Definition: system_variables.h:251
ulong resultset_metadata
Controls what resultset metadata will be sent to the client.
Definition: system_variables.h:295
ulong read_buff_size
Definition: system_variables.h:261
bool sysdate_is_now
Definition: system_variables.h:341
bool show_gipk_in_create_table_and_information_schema
Definition: system_variables.h:409
bool session_track_schema
Definition: system_variables.h:355
ulong ssl_fips_mode
Definition: system_variables.h:290
ulong optimizer_search_depth
Definition: system_variables.h:255
double long_query_time_double
Definition: system_variables.h:344
ulong max_sp_recursion_depth
Definition: system_variables.h:265
ulong max_insert_delayed_threads
Definition: system_variables.h:246
double secondary_engine_cost_threshold
Used for controlling which statements to execute in a secondary storage engine.
Definition: system_variables.h:394
char * dynamic_variables_ptr
Definition: system_variables.h:213
long optimizer_trace_limit
Definition: system_variables.h:228
const CHARSET_INFO * character_set_filesystem
Definition: system_variables.h:317
ulong auto_increment_offset
Definition: system_variables.h:234
ulong net_buffer_length
Definition: system_variables.h:248
ulong binlog_trx_compression_type
Definition: system_variables.h:279
MY_LOCALE * lc_messages
Definition: system_variables.h:327
ulong max_points_in_geometry
Definition: system_variables.h:244
ulong lock_wait_timeout
Definition: system_variables.h:240
ulonglong option_bits
OPTION_xxx constants, e.g. OPTION_PROFILING.
Definition: system_variables.h:231
ulong information_schema_stats_expiry
Definition: system_variables.h:363
ulong join_buff_size
Definition: system_variables.h:239
bool windowing_use_high_precision
Definition: system_variables.h:222
uint select_into_disk_sync_delay
Definition: system_variables.h:459
ulong net_read_timeout
Definition: system_variables.h:250
uint32_t generated_random_password_length
Definition: system_variables.h:442
ulong auto_increment_increment
Definition: system_variables.h:234
ulong max_execution_time
Definition: system_variables.h:352
MY_LOCALE * lc_time_names
Definition: system_variables.h:329
ulong session_track_gtids
Definition: system_variables.h:350
ulonglong long_query_time
Definition: system_variables.h:220
ulonglong optimizer_switch
Definition: system_variables.h:224
bool binlog_rows_query_log_events
Definition: system_variables.h:342
ulong net_write_timeout
Definition: system_variables.h:253
ulonglong original_commit_timestamp
Definition: system_variables.h:378
char * debug_sensitive_session_str
Definition: system_variables.h:494
LIST * dynamic_variables_allocs
Definition: system_variables.h:216
ulong max_allowed_packet
Definition: system_variables.h:241
ulonglong optimizer_trace_features
bitmap to select features to trace
Definition: system_variables.h:226
bool explicit_defaults_for_timestamp
Definition: system_variables.h:339
bool end_markers_in_json
Definition: system_variables.h:221
ulong optimizer_prune_level
Definition: system_variables.h:254
bool require_row_format
Definition: system_variables.h:447
Time_zone * time_zone
Definition: system_variables.h:331
Gtid_specification gtid_next
Definition: system_variables.h:348
bool big_tables
Definition: system_variables.h:311
ulong range_alloc_block_size
Definition: system_variables.h:268
ulong conn_mem_chunk_size
Definition: system_variables.h:473
ulong dynamic_variables_version
Definition: system_variables.h:212
bool session_track_state_change
Definition: system_variables.h:356
ulong binlog_row_image
Definition: system_variables.h:277
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:421
bool show_create_table_verbosity
Used for the verbosity of SHOW CREATE TABLE.
Definition: system_variables.h:369
bool sql_log_bin
Definition: system_variables.h:282
ulong updatable_views_with_limit
Definition: system_variables.h:287
ulong transaction_isolation
Definition: system_variables.h:286
sql_mode_t sql_mode
which non-standard SQL behaviour should be enabled
Definition: system_variables.h:230
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:301
Gtid_set_or_null gtid_next_list
Definition: system_variables.h:349
ulonglong tmp_table_size
Definition: system_variables.h:219
ulong query_prealloc_size
Definition: system_variables.h:270
const CHARSET_INFO * collation_server
Definition: system_variables.h:322
bool xa_detach_on_prepare
Switch which controls whether XA transactions are detached (made accessible to other connections for ...
Definition: system_variables.h:489
ulonglong binlog_row_value_options
Definition: system_variables.h:281
ulonglong max_heap_table_size
Definition: system_variables.h:218
ulong rbr_exec_mode_options
Definition: system_variables.h:275
const CHARSET_INFO * character_set_client
Definition: system_variables.h:318
bool show_old_temporals
Compatibility option to mark the pre MySQL-5.6.4 temporals columns using the old format using comment...
Definition: system_variables.h:376
ulong terminology_use_previous
Definition: system_variables.h:464
uint binlog_trx_compression_level_zstd
Definition: system_variables.h:280
bool keep_files_on_create
Definition: system_variables.h:308
const CHARSET_INFO * default_collation_for_utf8mb4
Definition: system_variables.h:383
ulong optimizer_trace_max_mem_size
Definition: system_variables.h:229
bool conn_global_mem_tracking
Definition: system_variables.h:477
ulong bulk_insert_buff_size
Definition: system_variables.h:235
uint max_user_connections
Definition: system_variables.h:288
ulonglong histogram_generation_max_mem_size
Definition: system_variables.h:238
bool binlog_direct_non_trans_update
Definition: system_variables.h:276
ulong default_week_format
Definition: system_variables.h:266
ulong completion_type
Definition: system_variables.h:285
bool binlog_trx_compression
Definition: system_variables.h:278
uint dynamic_variables_size
Definition: system_variables.h:215
plugin_ref table_plugin
Definition: system_variables.h:313
ulong group_replication_consistency
Used for controlling Group Replication consistency guarantees.
Definition: system_variables.h:397
ha_rows max_join_size
Definition: system_variables.h:233
const CHARSET_INFO * character_set_results
Definition: system_variables.h:319
bool pseudo_replica_mode
Definition: system_variables.h:346
char * track_sysvars_ptr
Definition: system_variables.h:354
ulong div_precincrement
Definition: system_variables.h:263
bool low_priority_updates
Definition: system_variables.h:306
uint dynamic_variables_head
Definition: system_variables.h:214
ulong net_interactive_timeout
Definition: system_variables.h:249
const CHARSET_INFO * collation_database
Definition: system_variables.h:323
ulong select_into_buffer_size
Definition: system_variables.h:451
ulong preload_buff_size
Definition: system_variables.h:259
ulong binlog_format
binlog format for this thd (see enum_binlog_format)
Definition: system_variables.h:274
ulong max_sort_length
Definition: system_variables.h:245
ulong net_wait_timeout
Definition: system_variables.h:252
bool sql_require_primary_key
Definition: system_variables.h:399
ulong transaction_write_set_extraction
Definition: system_variables.h:284
bool default_table_encryption
Used to determine if the database or tablespace should be encrypted by default.
Definition: system_variables.h:427
ulong query_alloc_block_size
Definition: system_variables.h:269
ulong max_seeks_for_key
Definition: system_variables.h:267
ulong my_aes_mode
Definition: system_variables.h:289
ulonglong optimizer_trace
bitmap to tune optimizer tracing
Definition: system_variables.h:225
bool old_alter_table
Definition: system_variables.h:310
uint eq_range_index_dive_limit
Definition: system_variables.h:236
ha_rows select_limit
Definition: system_variables.h:232
ulong max_error_count
Definition: system_variables.h:242
ulong internal_tmp_mem_storage_engine
Definition: system_variables.h:381
const CHARSET_INFO * collation_connection
Definition: system_variables.h:324
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:501
ulong session_track_transaction_info
Definition: system_variables.h:357
ulong sortbuff_size
Definition: system_variables.h:264
ulong optimizer_max_subgraph_pairs
Definition: system_variables.h:256
Definition: sql_plugin_ref.h:44
ulonglong sql_mode_t
Definition: system_variables.h:38
enum_rbr_exec_mode
Definition: system_variables.h:53
@ RBR_EXEC_MODE_LAST_BIT
Definition: system_variables.h:56
@ RBR_EXEC_MODE_IDEMPOTENT
Definition: system_variables.h:55
@ RBR_EXEC_MODE_STRICT
Definition: system_variables.h:54
void add_to_status(System_status_var *to_var, System_status_var *from_var)
Definition: system_variables.cc:41
use_secondary_engine
Values for use_secondary_engine sysvar.
Definition: system_variables.h:97
@ SECONDARY_ENGINE_OFF
Definition: system_variables.h:98
@ SECONDARY_ENGINE_FORCED
Definition: system_variables.h:100
@ SECONDARY_ENGINE_ON
Definition: system_variables.h:99
enum_binlog_row_metadata
Definition: system_variables.h:77
@ BINLOG_ROW_METADATA_FULL
Definition: system_variables.h:79
@ BINLOG_ROW_METADATA_MINIMAL
Definition: system_variables.h:78
enum_binlog_row_value_options
Definition: system_variables.h:71
@ PARTIAL_JSON_UPDATES
Store JSON updates in partial form.
Definition: system_variables.h:73
#define LAST_STATUS_VAR
Definition: system_variables.h:591
Explain_format_type
Values for explain_format sysvar.
Definition: system_variables.h:120
const int COUNT_GLOBAL_STATUS_VARS
Definition: system_variables.h:601
#define FIRST_STATUS_VAR
Definition: system_variables.h:598
void reset_system_status_vars(System_status_var *status_vars)
Definition: system_variables.cc:94
enum_binlog_row_image
Definition: system_variables.h:60
@ BINLOG_ROW_IMAGE_MINIMAL
PKE in the before image and changed columns in the after image.
Definition: system_variables.h:62
@ BINLOG_ROW_IMAGE_FULL
All columns in both before and after image.
Definition: system_variables.h:67
@ BINLOG_ROW_IMAGE_NOBLOB
Whenever possible, before and after image contain all columns except blobs.
Definition: system_variables.h:65
enum_transaction_write_set_hashing_algorithm
Definition: system_variables.h:83
@ HASH_ALGORITHM_MURMUR32
Definition: system_variables.h:85
@ HASH_ALGORITHM_OFF
Definition: system_variables.h:84
@ HASH_ALGORITHM_XXHASH64
Definition: system_variables.h:86
void add_diff_to_status(System_status_var *to_var, System_status_var *from_var, System_status_var *dec_var)
Definition: system_variables.cc:69
enum_binlog_format
Definition: system_variables.h:44
@ BINLOG_FORMAT_UNSPEC
thd_binlog_format() returns it when binlog is closed
Definition: system_variables.h:48
@ BINLOG_FORMAT_MIXED
statement if safe, otherwise row - autodetected
Definition: system_variables.h:45
@ BINLOG_FORMAT_ROW
row-based
Definition: system_variables.h:47
@ BINLOG_FORMAT_STMT
statement-based
Definition: system_variables.h:46
enum_session_track_gtids
Definition: system_variables.h:90
@ SESSION_TRACK_GTIDS_ALL_GTIDS
Definition: system_variables.h:93
@ SESSION_TRACK_GTIDS_OWN_GTID
Definition: system_variables.h:92
@ SESSION_TRACK_GTIDS_OFF
Definition: system_variables.h:91