MySQL 8.3.0
Source Code Documentation
system_variables.h
Go to the documentation of this file.
1/* Copyright (c) 2015, 2023, Oracle and/or its affiliates.
2
3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License, version 2.0,
5 as published by the Free Software Foundation.
6
7 This program is also distributed with certain software (including
8 but not limited to OpenSSL) that is licensed under separate terms,
9 as designated in a particular file or component or in included license
10 documentation. The authors of MySQL hereby grant you an additional
11 permission to link the program and your derivative works with the
12 separately licensed software that they have included with MySQL.
13
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License, version 2.0, for more details.
18
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22
23#ifndef SYSTEM_VARIABLES_INCLUDED
24#define SYSTEM_VARIABLES_INCLUDED
25
26#include <stddef.h>
27#include <stdint.h>
28#include <sys/types.h>
29
30#include "my_base.h" // ha_rows
31#include "my_inttypes.h"
32#include "my_sqlcommand.h"
33#include "my_thread_local.h" // my_thread_id
35#include "sql/rpl_gtid.h" // Gitd_specification
36#include "sql/sql_plugin_ref.h" // plugin_ref
37
38class MY_LOCALE;
39class Time_zone;
40
41using sql_mode_t = uint64_t;
42struct LIST;
43
44// Values for binlog_format sysvar
46 BINLOG_FORMAT_MIXED = 0, ///< statement if safe, otherwise row - autodetected
47 BINLOG_FORMAT_STMT = 1, ///< statement-based
48 BINLOG_FORMAT_ROW = 2, ///< row-based
50 3 ///< thd_binlog_format() returns it when binlog is closed
51};
52
53// Values for rbr_exec_mode_options sysvar
58};
59
60// Values for binlog_row_image sysvar
62 /** PKE in the before image and changed columns in the after image */
64 /** Whenever possible, before and after image contain all columns except
65 blobs. */
67 /** All columns in both before and after image. */
69};
70
71// Bits for binlog_row_value_options sysvar
73 /// Store JSON updates in partial form
75};
76
77// Values for binlog_row_metadata sysvar
81};
82
83// Values for session_track_gtids sysvar
88};
89
90/** Values for use_secondary_engine sysvar. */
95};
96
97/**
98 Values for explain_format sysvar.
99
100 The value "TRADITIONAL_STRICT" is meant only to be used by the mtr test
101 suite. With hypergraph optimizer, if explain_format value is TRADITIONAL,
102 EXPLAIN without a format specifier prints in TREE format. The mtr tests were
103 written *before* this traditional-tree conversion was introduced. So mtr was
104 designed to just ignore the "format not supported with hypergraph" error when
105 a test runs an EXPLAIN without format specifier with --hypergraph. With the
106 conversion introduced, EXPLAIN without format specifier therefore would have
107 output in different formats with and without the mtr --hypergraph option. In
108 order for the mtr tests to be able to continue to pass, mtr internally sets
109 explain_format to TRADITIONAL_STRICT so that these statements continue to
110 error out rather than print TREE format as they would do with TRADITIONAL
111 format. This is a temporary stuff. Once all tests start using TREE format,
112 we will deprecate this value.
113*/
114enum class Explain_format_type : ulong {
115 TRADITIONAL = 0,
117 TREE = 2,
118 JSON = 3
119};
120
121/* Bits for different SQL modes modes (including ANSI mode) */
122inline constexpr sql_mode_t MODE_REAL_AS_FLOAT = 1;
123inline constexpr sql_mode_t MODE_PIPES_AS_CONCAT = 2;
124inline constexpr sql_mode_t MODE_ANSI_QUOTES = 4;
125inline constexpr sql_mode_t MODE_IGNORE_SPACE = 8;
126inline constexpr sql_mode_t MODE_NOT_USED = 16;
129inline constexpr sql_mode_t MODE_NO_DIR_IN_CREATE = 128;
130inline constexpr sql_mode_t MODE_ANSI = 0x40000;
138/*
139 * NO_ZERO_DATE, NO_ZERO_IN_DATE and ERROR_FOR_DIVISION_BY_ZERO modes are
140 * removed in 5.7 and their functionality is merged with STRICT MODE.
141 * However, For backward compatibility during upgrade, these modes are kept
142 * but they are not used. Setting these modes in 5.7 will give warning and
143 * have no effect.
144 */
150inline constexpr sql_mode_t MODE_TRADITIONAL =
152inline constexpr sql_mode_t MODE_HIGH_NOT_PRECEDENCE = 1ULL << 29;
155inline constexpr sql_mode_t MODE_PAD_CHAR_TO_FULL_LENGTH = 1ULL << 31;
156/*
157 If this mode is set the fractional seconds which cannot fit in given fsp will
158 be truncated.
159*/
160inline constexpr sql_mode_t MODE_TIME_TRUNCATE_FRACTIONAL = 1ULL << 32;
161
162inline constexpr sql_mode_t MODE_LAST = 1ULL << 33;
163
173
174/*
175 We can safely ignore and reset these obsolete mode bits while replicating:
176*/
177#define MODE_IGNORED_MASK \
178 (0x00100 | /* was: MODE_POSTGRESQL */ \
179 0x00200 | /* was: MODE_ORACLE */ \
180 0x00400 | /* was: MODE_MSSQL */ \
181 0x00800 | /* was: MODE_DB2 */ \
182 0x01000 | /* was: MODE_MAXDB */ \
183 0x02000 | /* was: MODE_NO_KEY_OPTIONS */ \
184 0x04000 | /* was: MODE_NO_TABLE_OPTIONS */ \
185 0x08000 | /* was: MODE_NO_FIELD_OPTIONS */ \
186 0x10000 | /* was: MODE_MYSQL323 */ \
187 0x20000 | /* was: MODE_MYSQL40 */ \
188 0x10000000 /* was: MODE_NO_AUTO_CREATE_USER */ \
189 )
190
191/*
192 Replication uses 8 bytes to store SQL_MODE in the binary log. The day you
193 use strictly more than 64 bits by adding one more define above, you should
194 contact the replication team because the replication code should then be
195 updated (to store more bytes on disk).
196
197 NOTE: When adding new SQL_MODE types, make sure to also add them to
198 the scripts used for creating the MySQL system tables
199 in scripts/mysql_system_tables.sql and scripts/mysql_system_tables_fix.sql
200*/
201
203 /*
204 How dynamically allocated system variables are handled:
205
206 The global_system_variables and max_system_variables are "authoritative"
207 They both should have the same 'version' and 'size'.
208 When attempting to access a dynamic variable, if the session version
209 is out of date, then the session version is updated and realloced if
210 necessary and bytes copied from global to make up for missing data.
211 */
214 uint dynamic_variables_head; /* largest valid variable offset */
215 uint dynamic_variables_size; /* how many bytes are in use */
216 LIST *dynamic_variables_allocs; /* memory hunks for PLUGIN_VAR_MEMALLOC */
217
223 /* A bitmap for switching optimizations on/off */
225 ulonglong optimizer_trace; ///< bitmap to tune optimizer tracing
226 ulonglong optimizer_trace_features; ///< bitmap to select features to trace
230 sql_mode_t sql_mode; ///< which non-standard SQL behaviour should be enabled
231 ulonglong option_bits; ///< OPTION_xxx constants, e.g. OPTION_PROFILING
243 ulong max_length_for_sort_data; ///< Unused.
274 ulong binlog_format; ///< binlog format for this thd (see enum_binlog_format)
275 ulong rbr_exec_mode_options; // see enum_rbr_exec_mode
277 ulong binlog_row_image; // see enum_binlog_row_image
279 ulong binlog_trx_compression_type; // see enum_binlog_trx_compression
289 /**
290 Controls what resultset metadata will be sent to the client.
291 @sa enum_resultset_metadata
292 */
294
295 /**
296 In slave thread we need to know in behalf of which
297 thread the query is being run to replicate temp tables properly
298 */
300 /**
301 Default transaction access mode. READ ONLY (true) or READ WRITE (false).
302 */
307
310
313
314 /* Only charset part of these variables is sensible */
318
319 /* Both charset and collation parts of these variables are important */
323
324 /* Error messages */
326 /* Locale Support */
328
330 /*
331 TIMESTAMP fields are by default created with DEFAULT clauses
332 implicitly without users request. This flag when set, disables
333 implicit default values and expect users to provide explicit
334 default clause. i.e., when set columns are defined as NULL,
335 instead of NOT NULL by default.
336 */
338
341
343
345
348 ulong session_track_gtids; // see enum_session_track_gtids
349
351
356
357 /*
358 Time in seconds, after which the statistics in mysql.table/index_stats
359 get invalid
360 */
362
363 /**
364 Used for the verbosity of SHOW CREATE TABLE. Currently used for displaying
365 the row format in the output even if the table uses default row format.
366 */
368
369 /**
370 Compatibility option to mark the pre MySQL-5.6.4 temporals columns using
371 the old format using comments for SHOW CREATE TABLE and in I_S.COLUMNS
372 'COLUMN_TYPE' field.
373 */
375 // Used for replication delay and lag monitoring
377
378 ulong
379 internal_tmp_mem_storage_engine; // enum_internal_tmp_mem_storage_engine
380
382
383 /** Used for controlling preparation of queries against secondary engine. */
385
386 /**
387 Used for controlling which statements to execute in a secondary
388 storage engine. Only queries with an estimated cost higher than
389 this value will be attempted executed in a secondary storage
390 engine.
391 */
393
394 /** Used for controlling Group Replication consistency guarantees */
396
398
399 /**
400 @sa Sys_sql_generate_invisible_primary_key
401 */
403
404 /**
405 @sa Sys_show_gipk_in_create_table_and_information_schema
406 */
408
409 /**
410 Used in replication to determine the server version of the original server
411 where the transaction was executed.
412 */
414
415 /**
416 Used in replication to determine the server version of the immediate server
417 in the replication topology.
418 */
420
421 /**
422 Used to determine if the database or tablespace should be encrypted by
423 default.
424 */
426
427 /**
428 @sa Sys_var_print_identified_with_as_hex
429 */
431
432 /**
433 @sa Sys_var_show_create_table_skip_secondary_engine
434 */
436
437 /**
438 @sa Sys_var_generated_random_password_length
439 */
441
442 /**
443 @sa Sys_var_require_row_format
444 */
446 /**
447 @sa Sys_select_into_buffer_size
448 */
450 /**
451 @sa Sys_select_into_disk_sync
452 */
454 /**
455 @sa Sys_select_disk_sync_delay
456 */
458
459 /**
460 @sa Sys_terminology_use_previous
461 */
463
464 /**
465 @sa Sys_connection_memory_limit
466 */
468 /**
469 @sa Sys_connection_memory_chunk_size
470 */
472 /**
473 @sa Sys_connection_global_memory_tracking
474 */
476
477 /**
478 Switch which controls whether XA transactions are detached
479 (made accessible to other connections for commit/rollback)
480 as part of XA PREPARE (true), or at session disconnect (false, default).
481 An important side effect of setting this to true is that temporary tables
482 are disallowed in XA transactions. This is necessary because temporary
483 tables and their contents (and thus changes to them) is bound to
484 specific connections, so they don't make sense if XA transaction is
485 committed or rolled back from another connection.
486 */
488
489 /**
490 @sa Sys_debug_sensitive_session_string
491 */
493
494 /**
495 Used to specify the format in which the EXPLAIN statement should display
496 information if the FORMAT option is not explicitly specified.
497 @sa Sys_explain_format
498 */
500
501 /**
502 Used to specify the JSON format version used by EXPLAIN FORMAT=JSON with
503 the old (non-hypergraph) join optimizer.
504 @sa Sys_explain_json_format_version
505 */
507
508 /// Max size of set operations hash buffer size.
510#ifndef NDEBUG
512#endif
513};
514
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);
518
519/**
520 Per thread status variables.
521 Must be long/ulong up to last_system_status_var so that
522 add_to_status/add_diff_to_status can work.
523*/
524
526 /* IMPORTANT! See first_system_status_var definition below. */
538 /*
539 This number doesn't include calls to the default implementation and
540 calls made by range access. The intent is to count only calls made by
541 BatchedKeyAccess.
542 */
567 /* Prepared statements and binary protocol. */
575
578
582
583 /* Number of statements sent from the client. */
585
586 /// How many queries have been executed on a secondary storage engine.
588
590 ulong com_stat[(uint)SQLCOM_END];
591
592 /*
593 IMPORTANT! See last_system_status_var definition below. Variables after
594 'last_system_status_var' cannot be handled automatically by add_to_status()
595 and add_diff_to_status().
596 */
599};
600
601/*
602 This must reference the LAST ulonglong variable in system_status_var that is
603 used as a global counter. It marks the end of a contiguous block of counters
604 that can be iteratively totaled. See add_to_status().
605*/
606#define LAST_STATUS_VAR secondary_engine_execution_count
607
608/*
609 This must reference the FIRST ulonglong variable in system_status_var that is
610 used as a global counter. It marks the start of a contiguous block of counters
611 that can be iteratively totaled.
612*/
613#define FIRST_STATUS_VAR created_tmp_disk_tables
614
615/* Number of contiguous global status variables. */
619 sizeof(ulonglong)) +
620 1;
621
623 System_status_var *dec_var);
624
625void add_to_status(System_status_var *to_var, System_status_var *from_var);
626
628
629#endif // SYSTEM_VARIABLES_INCLUDED
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
uint64_t sql_mode_t
Definition: dd_event.h:38
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:1140
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:11457
Definition: m_ctype.h:422
Holds information about a Gtid_set.
Definition: rpl_gtid.h:2512
This struct represents a specification of a GTID for a statement to be executed: either "AUTOMATIC",...
Definition: rpl_gtid.h:3971
Definition: my_list.h:35
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:202
ulong read_rnd_buff_size
Definition: system_variables.h:262
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:384
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:435
ulong trans_alloc_block_size
Definition: system_variables.h:271
bool print_identified_with_as_hex
Definition: system_variables.h:430
bool new_mode
Definition: system_variables.h:305
bool transaction_read_only
Default transaction access mode.
Definition: system_variables.h:303
ulonglong parser_max_mem_size
Definition: system_variables.h:257
bool select_into_disk_sync
Definition: system_variables.h:453
ulonglong conn_mem_limit
Definition: system_variables.h:467
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:413
bool sql_generate_invisible_primary_key
Definition: system_variables.h:402
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:293
ulong read_buff_size
Definition: system_variables.h:261
bool sysdate_is_now
Definition: system_variables.h:339
bool show_gipk_in_create_table_and_information_schema
Definition: system_variables.h:407
bool session_track_schema
Definition: system_variables.h:353
ulong ssl_fips_mode
Definition: system_variables.h:288
ulong optimizer_search_depth
Definition: system_variables.h:255
double long_query_time_double
Definition: system_variables.h:342
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:392
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:315
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:325
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:361
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:457
ulong net_read_timeout
Definition: system_variables.h:250
uint32_t generated_random_password_length
Definition: system_variables.h:440
ulong auto_increment_increment
Definition: system_variables.h:234
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:220
ulonglong optimizer_switch
Definition: system_variables.h:224
bool binlog_rows_query_log_events
Definition: system_variables.h:340
ulong net_write_timeout
Definition: system_variables.h:253
ulonglong original_commit_timestamp
Definition: system_variables.h:376
char * debug_sensitive_session_str
Definition: system_variables.h:492
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:337
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:445
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:268
ulong conn_mem_chunk_size
Definition: system_variables.h:471
ulong dynamic_variables_version
Definition: system_variables.h:212
bool session_track_state_change
Definition: system_variables.h:354
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:419
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:282
ulong updatable_views_with_limit
Definition: system_variables.h:285
ulong transaction_isolation
Definition: system_variables.h:284
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:506
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:299
Gtid_set_or_null gtid_next_list
Definition: system_variables.h:347
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:320
bool xa_detach_on_prepare
Switch which controls whether XA transactions are detached (made accessible to other connections for ...
Definition: system_variables.h:487
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:316
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:374
ulong terminology_use_previous
Definition: system_variables.h:462
uint binlog_trx_compression_level_zstd
Definition: system_variables.h:280
bool keep_files_on_create
Definition: system_variables.h:306
const CHARSET_INFO * default_collation_for_utf8mb4
Definition: system_variables.h:381
ulong optimizer_trace_max_mem_size
Definition: system_variables.h:229
bool conn_global_mem_tracking
Definition: system_variables.h:475
ulong bulk_insert_buff_size
Definition: system_variables.h:235
uint max_user_connections
Definition: system_variables.h:286
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:283
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:311
ulong group_replication_consistency
Used for controlling Group Replication consistency guarantees.
Definition: system_variables.h:395
ha_rows max_join_size
Definition: system_variables.h:233
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:263
bool low_priority_updates
Definition: system_variables.h:304
uint dynamic_variables_head
Definition: system_variables.h:214
ulong net_interactive_timeout
Definition: system_variables.h:249
ulonglong set_operations_buffer_size
Max size of set operations hash buffer size.
Definition: system_variables.h:509
const CHARSET_INFO * collation_database
Definition: system_variables.h:321
ulong select_into_buffer_size
Definition: system_variables.h:449
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:397
char * debug_set_operations_secondary_overflow_at
Definition: system_variables.h:511
bool default_table_encryption
Used to determine if the database or tablespace should be encrypted by default.
Definition: system_variables.h:425
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:287
ulonglong optimizer_trace
bitmap to tune optimizer tracing
Definition: system_variables.h:225
bool old_alter_table
Definition: system_variables.h:308
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:379
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:499
ulong session_track_transaction_info
Definition: system_variables.h:355
ulong sortbuff_size
Definition: system_variables.h:264
ulong optimizer_max_subgraph_pairs
Definition: system_variables.h:256
Definition: my_tree.h:67
Definition: sql_plugin_ref.h:44
constexpr sql_mode_t MODE_NO_ENGINE_SUBSTITUTION
Definition: system_variables.h:153
constexpr sql_mode_t MODE_ALLOWED_MASK
Definition: system_variables.h:164
constexpr sql_mode_t MODE_NOT_USED
Definition: system_variables.h:126
constexpr sql_mode_t MODE_INVALID_DATES
Definition: system_variables.h:147
enum_rbr_exec_mode
Definition: system_variables.h:54
@ RBR_EXEC_MODE_LAST_BIT
Definition: system_variables.h:57
@ RBR_EXEC_MODE_IDEMPOTENT
Definition: system_variables.h:56
@ RBR_EXEC_MODE_STRICT
Definition: system_variables.h:55
constexpr sql_mode_t MODE_NO_BACKSLASH_ESCAPES
Definition: system_variables.h:132
constexpr sql_mode_t MODE_NO_UNSIGNED_SUBTRACTION
Definition: system_variables.h:128
constexpr sql_mode_t MODE_TRADITIONAL
Definition: system_variables.h:150
constexpr sql_mode_t MODE_TIME_TRUNCATE_FRACTIONAL
Definition: system_variables.h:160
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:91
@ SECONDARY_ENGINE_OFF
Definition: system_variables.h:92
@ SECONDARY_ENGINE_FORCED
Definition: system_variables.h:94
@ SECONDARY_ENGINE_ON
Definition: system_variables.h:93
enum_binlog_row_metadata
Definition: system_variables.h:78
@ BINLOG_ROW_METADATA_FULL
Definition: system_variables.h:80
@ BINLOG_ROW_METADATA_MINIMAL
Definition: system_variables.h:79
constexpr sql_mode_t MODE_NO_ZERO_IN_DATE
Definition: system_variables.h:145
enum_binlog_row_value_options
Definition: system_variables.h:72
@ PARTIAL_JSON_UPDATES
Store JSON updates in partial form.
Definition: system_variables.h:74
constexpr sql_mode_t MODE_ONLY_FULL_GROUP_BY
Definition: system_variables.h:127
#define LAST_STATUS_VAR
Definition: system_variables.h:606
Explain_format_type
Values for explain_format sysvar.
Definition: system_variables.h:114
constexpr sql_mode_t MODE_ERROR_FOR_DIVISION_BY_ZERO
Definition: system_variables.h:148
const int COUNT_GLOBAL_STATUS_VARS
Definition: system_variables.h:616
constexpr sql_mode_t MODE_STRICT_TRANS_TABLES
Definition: system_variables.h:134
constexpr sql_mode_t MODE_PIPES_AS_CONCAT
Definition: system_variables.h:123
#define FIRST_STATUS_VAR
Definition: system_variables.h:613
constexpr sql_mode_t MODE_NO_AUTO_VALUE_ON_ZERO
Definition: system_variables.h:131
void reset_system_status_vars(System_status_var *status_vars)
Definition: system_variables.cc:94
enum_binlog_row_image
Definition: system_variables.h:61
@ BINLOG_ROW_IMAGE_MINIMAL
PKE in the before image and changed columns in the after image.
Definition: system_variables.h:63
@ BINLOG_ROW_IMAGE_FULL
All columns in both before and after image.
Definition: system_variables.h:68
@ BINLOG_ROW_IMAGE_NOBLOB
Whenever possible, before and after image contain all columns except blobs.
Definition: system_variables.h:66
constexpr sql_mode_t MODE_NO_ZERO_DATE
Definition: system_variables.h:146
constexpr sql_mode_t MODE_LAST
Definition: system_variables.h:162
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
constexpr sql_mode_t MODE_REAL_AS_FLOAT
Definition: system_variables.h:122
constexpr sql_mode_t MODE_NO_DIR_IN_CREATE
Definition: system_variables.h:129
enum_binlog_format
Definition: system_variables.h:45
@ BINLOG_FORMAT_UNSPEC
thd_binlog_format() returns it when binlog is closed
Definition: system_variables.h:49
@ BINLOG_FORMAT_MIXED
statement if safe, otherwise row - autodetected
Definition: system_variables.h:46
@ BINLOG_FORMAT_ROW
row-based
Definition: system_variables.h:48
@ BINLOG_FORMAT_STMT
statement-based
Definition: system_variables.h:47
enum_session_track_gtids
Definition: system_variables.h:84
@ SESSION_TRACK_GTIDS_ALL_GTIDS
Definition: system_variables.h:87
@ SESSION_TRACK_GTIDS_OWN_GTID
Definition: system_variables.h:86
@ SESSION_TRACK_GTIDS_OFF
Definition: system_variables.h:85
constexpr sql_mode_t MODE_STRICT_ALL_TABLES
Definition: system_variables.h:136
constexpr sql_mode_t MODE_PAD_CHAR_TO_FULL_LENGTH
Definition: system_variables.h:155
constexpr sql_mode_t MODE_ANSI
Definition: system_variables.h:130
constexpr sql_mode_t MODE_IGNORE_SPACE
Definition: system_variables.h:125
constexpr sql_mode_t MODE_HIGH_NOT_PRECEDENCE
Definition: system_variables.h:152
constexpr sql_mode_t MODE_ANSI_QUOTES
Definition: system_variables.h:124