MySQL  8.0.26
Source Code Documentation
system_variables.h
Go to the documentation of this file.
1 /* Copyright (c) 2015, 2021, 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 <sys/types.h>
28 
29 #include "m_ctype.h"
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
34 #include "sql/rpl_gtid.h" // Gitd_specification
35 #include "sql/sql_plugin_ref.h" // plugin_ref
36 
37 class MY_LOCALE;
38 class Time_zone;
39 
41 struct LIST;
42 
43 // Values for binlog_format sysvar
45  BINLOG_FORMAT_MIXED = 0, ///< statement if safe, otherwise row - autodetected
46  BINLOG_FORMAT_STMT = 1, ///< statement-based
47  BINLOG_FORMAT_ROW = 2, ///< row-based
49  3 ///< thd_binlog_format() returns it when binlog is closed
50 };
51 
52 // Values for rbr_exec_mode_options sysvar
57 };
58 
59 // Values for binlog_row_image sysvar
61  /** PKE in the before image and changed columns in the after image */
63  /** Whenever possible, before and after image contain all columns except
64  blobs. */
66  /** All columns in both before and after image. */
68 };
69 
70 // Bits for binlog_row_value_options sysvar
72  /// Store JSON updates in partial form
74 };
75 
76 // Values for binlog_row_metadata sysvar
80 };
81 
82 // Values for transaction_write_set_extraction sysvar
87 };
88 
89 // Values for session_track_gtids sysvar
94 };
95 
96 /** Values for use_secondary_engine sysvar. */
101 };
102 
103 /* Bits for different SQL modes modes (including ANSI mode) */
104 #define MODE_REAL_AS_FLOAT 1
105 #define MODE_PIPES_AS_CONCAT 2
106 #define MODE_ANSI_QUOTES 4
107 #define MODE_IGNORE_SPACE 8
108 #define MODE_NOT_USED 16
109 #define MODE_ONLY_FULL_GROUP_BY 32
110 #define MODE_NO_UNSIGNED_SUBTRACTION 64
111 #define MODE_NO_DIR_IN_CREATE 128
112 #define MODE_ANSI 262144L
113 #define MODE_NO_AUTO_VALUE_ON_ZERO (MODE_ANSI * 2)
114 #define MODE_NO_BACKSLASH_ESCAPES (MODE_NO_AUTO_VALUE_ON_ZERO * 2)
115 #define MODE_STRICT_TRANS_TABLES (MODE_NO_BACKSLASH_ESCAPES * 2)
116 #define MODE_STRICT_ALL_TABLES (MODE_STRICT_TRANS_TABLES * 2)
117 /*
118  * NO_ZERO_DATE, NO_ZERO_IN_DATE and ERROR_FOR_DIVISION_BY_ZERO modes are
119  * removed in 5.7 and their functionality is merged with STRICT MODE.
120  * However, For backward compatibility during upgrade, these modes are kept
121  * but they are not used. Setting these modes in 5.7 will give warning and
122  * have no effect.
123  */
124 #define MODE_NO_ZERO_IN_DATE (MODE_STRICT_ALL_TABLES * 2)
125 #define MODE_NO_ZERO_DATE (MODE_NO_ZERO_IN_DATE * 2)
126 #define MODE_INVALID_DATES (MODE_NO_ZERO_DATE * 2)
127 #define MODE_ERROR_FOR_DIVISION_BY_ZERO (MODE_INVALID_DATES * 2)
128 #define MODE_TRADITIONAL (MODE_ERROR_FOR_DIVISION_BY_ZERO * 2)
129 #define MODE_HIGH_NOT_PRECEDENCE (1ULL << 29)
130 #define MODE_NO_ENGINE_SUBSTITUTION (MODE_HIGH_NOT_PRECEDENCE * 2)
131 #define MODE_PAD_CHAR_TO_FULL_LENGTH (1ULL << 31)
132 /*
133  If this mode is set the fractional seconds which cannot fit in given fsp will
134  be truncated.
135 */
136 #define MODE_TIME_TRUNCATE_FRACTIONAL (1ULL << 32)
137 
138 #define MODE_LAST (1ULL << 33)
139 
140 #define MODE_ALLOWED_MASK \
141  (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES | \
142  MODE_IGNORE_SPACE | MODE_NOT_USED | MODE_ONLY_FULL_GROUP_BY | \
143  MODE_NO_UNSIGNED_SUBTRACTION | MODE_NO_DIR_IN_CREATE | MODE_ANSI | \
144  MODE_NO_AUTO_VALUE_ON_ZERO | MODE_NO_BACKSLASH_ESCAPES | \
145  MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES | MODE_NO_ZERO_IN_DATE | \
146  MODE_NO_ZERO_DATE | MODE_INVALID_DATES | MODE_ERROR_FOR_DIVISION_BY_ZERO | \
147  MODE_TRADITIONAL | MODE_HIGH_NOT_PRECEDENCE | MODE_NO_ENGINE_SUBSTITUTION | \
148  MODE_PAD_CHAR_TO_FULL_LENGTH | MODE_TIME_TRUNCATE_FRACTIONAL)
149 
150 /*
151  We can safely ignore and reset these obsolete mode bits while replicating:
152 */
153 #define MODE_IGNORED_MASK \
154  (0x00100 | /* was: MODE_POSTGRESQL */ \
155  0x00200 | /* was: MODE_ORACLE */ \
156  0x00400 | /* was: MODE_MSSQL */ \
157  0x00800 | /* was: MODE_DB2 */ \
158  0x01000 | /* was: MODE_MAXDB */ \
159  0x02000 | /* was: MODE_NO_KEY_OPTIONS */ \
160  0x04000 | /* was: MODE_NO_TABLE_OPTIONS */ \
161  0x08000 | /* was: MODE_NO_FIELD_OPTIONS */ \
162  0x10000 | /* was: MODE_MYSQL323 */ \
163  0x20000 | /* was: MODE_MYSQL40 */ \
164  0x10000000 /* was: MODE_NO_AUTO_CREATE_USER */ \
165  )
166 
167 /*
168  Replication uses 8 bytes to store SQL_MODE in the binary log. The day you
169  use strictly more than 64 bits by adding one more define above, you should
170  contact the replication team because the replication code should then be
171  updated (to store more bytes on disk).
172 
173  NOTE: When adding new SQL_MODE types, make sure to also add them to
174  the scripts used for creating the MySQL system tables
175  in scripts/mysql_system_tables.sql and scripts/mysql_system_tables_fix.sql
176 */
177 
179  /*
180  How dynamically allocated system variables are handled:
181 
182  The global_system_variables and max_system_variables are "authoritative"
183  They both should have the same 'version' and 'size'.
184  When attempting to access a dynamic variable, if the session version
185  is out of date, then the session version is updated and realloced if
186  neccessary and bytes copied from global to make up for missing data.
187  */
190  uint dynamic_variables_head; /* largest valid variable offset */
191  uint dynamic_variables_size; /* how many bytes are in use */
192  LIST *dynamic_variables_allocs; /* memory hunks for PLUGIN_VAR_MEMALLOC */
193 
199  /* A bitmap for switching optimizations on/off */
201  ulonglong optimizer_trace; ///< bitmap to tune optimizer tracing
202  ulonglong optimizer_trace_features; ///< bitmap to select features to trace
206  sql_mode_t sql_mode; ///< which non-standard SQL behaviour should be enabled
207  ulonglong option_bits; ///< OPTION_xxx constants, e.g. OPTION_PROFILING
219  ulong max_length_for_sort_data; ///< Unused.
249  ulong binlog_format; ///< binlog format for this thd (see enum_binlog_format)
250  ulong rbr_exec_mode_options; // see enum_rbr_exec_mode
252  ulong binlog_row_image; // see enum_binlog_row_image
254  ulong binlog_trx_compression_type; // see enum_binlog_trx_compression
258  // see enum_transaction_write_set_hashing_algorithm
264  ulong my_aes_mode;
266  /**
267  Controls what resultset metadata will be sent to the client.
268  @sa enum_resultset_metadata
269  */
271 
272  /**
273  In slave thread we need to know in behalf of which
274  thread the query is being run to replicate temp tables properly
275  */
277  /**
278  Default transaction access mode. READ ONLY (true) or READ WRITE (false).
279  */
282  bool new_mode;
284 
287 
290 
291  /* Only charset part of these variables is sensible */
295 
296  /* Both charset and collation parts of these variables are important */
300 
301  /* Error messages */
303  /* Locale Support */
305 
307  /*
308  TIMESTAMP fields are by default created with DEFAULT clauses
309  implicitly without users request. This flag when set, disables
310  implicit default values and expect users to provide explicit
311  default clause. i.e., when set columns are defined as NULL,
312  instead of NOT NULL by default.
313  */
315 
318 
320 
322 
325  ulong session_track_gtids; // see enum_session_track_gtids
326 
328 
333 
334  /*
335  Time in seconds, after which the statistics in mysql.table/index_stats
336  get invalid
337  */
339 
340  /**
341  Used for the verbosity of SHOW CREATE TABLE. Currently used for displaying
342  the row format in the output even if the table uses default row format.
343  */
345 
346  /**
347  Compatibility option to mark the pre MySQL-5.6.4 temporals columns using
348  the old format using comments for SHOW CREATE TABLE and in I_S.COLUMNS
349  'COLUMN_TYPE' field.
350  */
352  // Used for replication delay and lag monitoring
354 
355  ulong
356  internal_tmp_mem_storage_engine; // enum_internal_tmp_mem_storage_engine
357 
359 
360  /** Used for controlling preparation of queries against secondary engine. */
362 
363  /**
364  Used for controlling which statements to execute in a secondary
365  storage engine. Only queries with an estimated cost higher than
366  this value will be attempted executed in a secondary storage
367  engine.
368  */
370 
371  /** Used for controlling Group Replication consistency guarantees */
373 
375 
376  /**
377  Used in replication to determine the server version of the original server
378  where the transaction was executed.
379  */
381 
382  /**
383  Used in replication to determine the server version of the immediate server
384  in the replication topology.
385  */
387 
388  /**
389  Used to determine if the database or tablespace should be encrypted by
390  default.
391  */
393 
394  /**
395  @sa Sys_var_print_identified_with_as_hex
396  */
398 
399  /**
400  @sa Sys_var_show_create_table_skip_secondary_engine
401  */
403 
404  /**
405  @sa Sys_var_generated_random_password_length
406  */
408 
409  /**
410  @sa Sys_var_require_row_format
411  */
413  /**
414  @sa Sys_select_into_buffer_size
415  */
417  /**
418  @sa Sys_select_into_disk_sync
419  */
421  /**
422  @sa Sys_select_disk_sync_delay
423  */
425  /**
426  @sa Sys_terminology_use_previous
427  */
429 };
430 
431 /**
432  Per thread status variables.
433  Must be long/ulong up to last_system_status_var so that
434  add_to_status/add_diff_to_status can work.
435 */
436 
438  /* IMPORTANT! See first_system_status_var definition below. */
450  /*
451  This number doesn't include calls to the default implementation and
452  calls made by range access. The intent is to count only calls made by
453  BatchedKeyAccess.
454  */
479  /* Prepared statements and binary protocol. */
487 
490 
494 
495  /* Number of statements sent from the client. */
497 
498  /// How many queries have been executed on a secondary storage engine.
500 
501  ulong com_other;
503 
504  /*
505  IMPORTANT! See last_system_status_var definition below. Variables after
506  'last_system_status_var' cannot be handled automatically by add_to_status()
507  and add_diff_to_status().
508  */
511 };
512 
513 /*
514  This must reference the LAST ulonglong variable in system_status_var that is
515  used as a global counter. It marks the end of a contiguous block of counters
516  that can be iteratively totaled. See add_to_status().
517 */
518 #define LAST_STATUS_VAR secondary_engine_execution_count
519 
520 /*
521  This must reference the FIRST ulonglong variable in system_status_var that is
522  used as a global counter. It marks the start of a contiguous block of counters
523  that can be iteratively totaled.
524 */
525 #define FIRST_STATUS_VAR created_tmp_disk_tables
526 
527 /* Number of contiguous global status variables. */
529  ((offsetof(System_status_var, LAST_STATUS_VAR) -
530  offsetof(System_status_var, FIRST_STATUS_VAR)) /
531  sizeof(ulonglong)) +
532  1;
533 
535  System_status_var *dec_var);
536 
537 void add_to_status(System_status_var *to_var, System_status_var *from_var);
538 
540 
541 #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
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:1138
Some integer typedefs for easier portability.
unsigned long long int ulonglong
Definition: my_inttypes.h:55
@ SQLCOM_END
Definition: my_sqlcommand.h:206
uint32 my_thread_id
Definition: my_thread_local.h:33
SHOW_VAR status_vars[]
Definition: mysqld.cc:9042
Definition: m_ctype.h:354
Holds information about a Gtid_set.
Definition: rpl_gtid.h:2350
This struct represents a specification of a GTID for a statement to be executed: either "AUTOMATIC",...
Definition: rpl_gtid.h:3765
Definition: my_list.h:35
Per thread status variables.
Definition: system_variables.h:437
ulonglong com_stmt_reprepare
Definition: system_variables.h:481
ulonglong bytes_sent
Definition: system_variables.h:489
ulonglong ha_read_first_count
Definition: system_variables.h:443
ulonglong long_query_count
Definition: system_variables.h:474
ulonglong ha_commit_count
Definition: system_variables.h:441
ulonglong secondary_engine_execution_count
How many queries have been executed on a secondary storage engine.
Definition: system_variables.h:499
ulonglong opened_tables
Definition: system_variables.h:464
ulonglong created_tmp_tables
Definition: system_variables.h:440
ulonglong com_stmt_prepare
Definition: system_variables.h:480
ulonglong max_execution_time_exceeded
Definition: system_variables.h:491
ulonglong table_open_cache_overflows
Definition: system_variables.h:468
ulonglong select_full_range_join_count
Definition: system_variables.h:470
ulonglong select_full_join_count
Definition: system_variables.h:469
ulonglong ha_savepoint_count
Definition: system_variables.h:461
ulonglong table_open_cache_misses
Definition: system_variables.h:467
ulonglong filesort_range_count
Definition: system_variables.h:476
ulonglong last_query_partial_plans
Definition: system_variables.h:510
ulong com_other
Definition: system_variables.h:501
ulonglong max_execution_time_set_failed
Definition: system_variables.h:493
ulonglong filesort_scan_count
Definition: system_variables.h:478
ulonglong com_stmt_execute
Definition: system_variables.h:482
ulong com_stat[(uint) SQLCOM_END]
Definition: system_variables.h:502
ulonglong com_stmt_reset
Definition: system_variables.h:485
ulonglong ha_read_next_count
Definition: system_variables.h:446
ulonglong ha_update_count
Definition: system_variables.h:457
ulonglong ha_read_rnd_count
Definition: system_variables.h:448
ulonglong ha_read_rnd_next_count
Definition: system_variables.h:449
ulonglong com_stmt_fetch
Definition: system_variables.h:484
ulonglong created_tmp_disk_tables
Definition: system_variables.h:439
ulonglong opened_shares
Definition: system_variables.h:465
ulonglong com_stmt_send_long_data
Definition: system_variables.h:483
ulonglong com_stmt_close
Definition: system_variables.h:486
ulonglong bytes_received
Definition: system_variables.h:488
double last_query_cost
Definition: system_variables.h:509
ulonglong ha_read_prev_count
Definition: system_variables.h:447
ulonglong select_range_check_count
Definition: system_variables.h:472
ulonglong table_open_cache_hits
Definition: system_variables.h:466
ulonglong filesort_merge_passes
Definition: system_variables.h:475
ulonglong ha_read_last_count
Definition: system_variables.h:444
ulonglong ha_delete_count
Definition: system_variables.h:442
ulonglong ha_multi_range_read_init_count
Definition: system_variables.h:455
ulonglong filesort_rows
Definition: system_variables.h:477
ulonglong ha_savepoint_rollback_count
Definition: system_variables.h:462
ulonglong ha_external_lock_count
Definition: system_variables.h:463
ulonglong ha_read_key_count
Definition: system_variables.h:445
ulonglong select_range_count
Definition: system_variables.h:471
ulonglong ha_rollback_count
Definition: system_variables.h:456
ulonglong ha_prepare_count
Definition: system_variables.h:459
ulonglong ha_write_count
Definition: system_variables.h:458
ulonglong questions
Definition: system_variables.h:496
ulonglong select_scan_count
Definition: system_variables.h:473
ulonglong max_execution_time_set
Definition: system_variables.h:492
ulonglong ha_discover_count
Definition: system_variables.h:460
Definition: system_variables.h:178
ulong read_rnd_buff_size
Definition: system_variables.h:237
plugin_ref temp_table_plugin
Definition: system_variables.h:289
ulong use_secondary_engine
Used for controlling preparation of queries against secondary engine.
Definition: system_variables.h:361
ulong profiling_history_size
Definition: system_variables.h:235
ulong group_concat_max_len
Definition: system_variables.h:248
long optimizer_trace_offset
Definition: system_variables.h:203
ulong trans_prealloc_size
Definition: system_variables.h:247
bool show_create_table_skip_secondary_engine
Definition: system_variables.h:402
ulong trans_alloc_block_size
Definition: system_variables.h:246
bool print_identified_with_as_hex
Definition: system_variables.h:397
bool new_mode
Definition: system_variables.h:282
bool transaction_read_only
Default transaction access mode.
Definition: system_variables.h:280
ulonglong parser_max_mem_size
Definition: system_variables.h:232
bool select_into_disk_sync
Definition: system_variables.h:420
uint cte_max_recursion_depth
Definition: system_variables.h:213
ulong range_optimizer_max_mem_size
Definition: system_variables.h:233
ulong min_examined_row_limit
Definition: system_variables.h:223
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:380
ulong max_length_for_sort_data
Unused.
Definition: system_variables.h:219
ulong net_retry_count
Definition: system_variables.h:227
ulong resultset_metadata
Controls what resultset metadata will be sent to the client.
Definition: system_variables.h:270
ulong read_buff_size
Definition: system_variables.h:236
bool sysdate_is_now
Definition: system_variables.h:316
bool session_track_schema
Definition: system_variables.h:330
ulong ssl_fips_mode
Definition: system_variables.h:265
ulong optimizer_search_depth
Definition: system_variables.h:231
double long_query_time_double
Definition: system_variables.h:319
ulong max_sp_recursion_depth
Definition: system_variables.h:240
ulong max_insert_delayed_threads
Definition: system_variables.h:222
double secondary_engine_cost_threshold
Used for controlling which statements to execute in a secondary storage engine.
Definition: system_variables.h:369
char * dynamic_variables_ptr
Definition: system_variables.h:189
long optimizer_trace_limit
Definition: system_variables.h:204
const CHARSET_INFO * character_set_filesystem
Definition: system_variables.h:292
ulong auto_increment_offset
Definition: system_variables.h:210
ulong net_buffer_length
Definition: system_variables.h:224
ulong binlog_trx_compression_type
Definition: system_variables.h:254
MY_LOCALE * lc_messages
Definition: system_variables.h:302
ulong max_points_in_geometry
Definition: system_variables.h:220
ulong lock_wait_timeout
Definition: system_variables.h:216
ulonglong option_bits
OPTION_xxx constants, e.g. OPTION_PROFILING.
Definition: system_variables.h:207
ulong information_schema_stats_expiry
Definition: system_variables.h:338
ulong join_buff_size
Definition: system_variables.h:215
bool windowing_use_high_precision
Definition: system_variables.h:198
uint select_into_disk_sync_delay
Definition: system_variables.h:424
ulong net_read_timeout
Definition: system_variables.h:226
uint32_t generated_random_password_length
Definition: system_variables.h:407
ulong auto_increment_increment
Definition: system_variables.h:210
ulong max_execution_time
Definition: system_variables.h:327
MY_LOCALE * lc_time_names
Definition: system_variables.h:304
ulong session_track_gtids
Definition: system_variables.h:325
ulonglong long_query_time
Definition: system_variables.h:196
ulonglong optimizer_switch
Definition: system_variables.h:200
bool binlog_rows_query_log_events
Definition: system_variables.h:317
ulong net_write_timeout
Definition: system_variables.h:229
ulonglong original_commit_timestamp
Definition: system_variables.h:353
LIST * dynamic_variables_allocs
Definition: system_variables.h:192
ulong max_allowed_packet
Definition: system_variables.h:217
ulonglong optimizer_trace_features
bitmap to select features to trace
Definition: system_variables.h:202
bool explicit_defaults_for_timestamp
Definition: system_variables.h:314
bool end_markers_in_json
Definition: system_variables.h:197
ulong optimizer_prune_level
Definition: system_variables.h:230
bool require_row_format
Definition: system_variables.h:412
Time_zone * time_zone
Definition: system_variables.h:306
Gtid_specification gtid_next
Definition: system_variables.h:323
bool big_tables
Definition: system_variables.h:286
ulong range_alloc_block_size
Definition: system_variables.h:243
ulong dynamic_variables_version
Definition: system_variables.h:188
bool session_track_state_change
Definition: system_variables.h:331
ulong binlog_row_image
Definition: system_variables.h:252
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:386
bool show_create_table_verbosity
Used for the verbosity of SHOW CREATE TABLE.
Definition: system_variables.h:344
bool sql_log_bin
Definition: system_variables.h:257
ulong updatable_views_with_limit
Definition: system_variables.h:262
ulong transaction_isolation
Definition: system_variables.h:261
sql_mode_t sql_mode
which non-standard SQL behaviour should be enabled
Definition: system_variables.h:206
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:276
Gtid_set_or_null gtid_next_list
Definition: system_variables.h:324
ulonglong tmp_table_size
Definition: system_variables.h:195
ulong query_prealloc_size
Definition: system_variables.h:245
const CHARSET_INFO * collation_server
Definition: system_variables.h:297
ulonglong binlog_row_value_options
Definition: system_variables.h:256
ulonglong max_heap_table_size
Definition: system_variables.h:194
ulong rbr_exec_mode_options
Definition: system_variables.h:250
const CHARSET_INFO * character_set_client
Definition: system_variables.h:293
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:351
ulong terminology_use_previous
Definition: system_variables.h:428
uint binlog_trx_compression_level_zstd
Definition: system_variables.h:255
bool keep_files_on_create
Definition: system_variables.h:283
const CHARSET_INFO * default_collation_for_utf8mb4
Definition: system_variables.h:358
ulong optimizer_trace_max_mem_size
Definition: system_variables.h:205
ulong bulk_insert_buff_size
Definition: system_variables.h:211
uint max_user_connections
Definition: system_variables.h:263
ulonglong histogram_generation_max_mem_size
Definition: system_variables.h:214
bool binlog_direct_non_trans_update
Definition: system_variables.h:251
ulong default_week_format
Definition: system_variables.h:241
ulong completion_type
Definition: system_variables.h:260
bool binlog_trx_compression
Definition: system_variables.h:253
uint dynamic_variables_size
Definition: system_variables.h:191
plugin_ref table_plugin
Definition: system_variables.h:288
ulong group_replication_consistency
Used for controlling Group Replication consistency guarantees.
Definition: system_variables.h:372
ha_rows max_join_size
Definition: system_variables.h:209
const CHARSET_INFO * character_set_results
Definition: system_variables.h:294
bool pseudo_replica_mode
Definition: system_variables.h:321
char * track_sysvars_ptr
Definition: system_variables.h:329
ulong div_precincrement
Definition: system_variables.h:238
bool low_priority_updates
Definition: system_variables.h:281
uint dynamic_variables_head
Definition: system_variables.h:190
ulong net_interactive_timeout
Definition: system_variables.h:225
const CHARSET_INFO * collation_database
Definition: system_variables.h:298
ulong select_into_buffer_size
Definition: system_variables.h:416
ulong preload_buff_size
Definition: system_variables.h:234
ulong binlog_format
binlog format for this thd (see enum_binlog_format)
Definition: system_variables.h:249
ulong max_sort_length
Definition: system_variables.h:221
ulong net_wait_timeout
Definition: system_variables.h:228
bool sql_require_primary_key
Definition: system_variables.h:374
ulong transaction_write_set_extraction
Definition: system_variables.h:259
bool default_table_encryption
Used to determine if the database or tablespace should be encrypted by default.
Definition: system_variables.h:392
ulong query_alloc_block_size
Definition: system_variables.h:244
ulong max_seeks_for_key
Definition: system_variables.h:242
ulong my_aes_mode
Definition: system_variables.h:264
ulonglong optimizer_trace
bitmap to tune optimizer tracing
Definition: system_variables.h:201
bool old_alter_table
Definition: system_variables.h:285
uint eq_range_index_dive_limit
Definition: system_variables.h:212
ha_rows select_limit
Definition: system_variables.h:208
ulong max_error_count
Definition: system_variables.h:218
ulong internal_tmp_mem_storage_engine
Definition: system_variables.h:356
const CHARSET_INFO * collation_connection
Definition: system_variables.h:299
ulong session_track_transaction_info
Definition: system_variables.h:332
ulong sortbuff_size
Definition: system_variables.h:239
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:518
const int COUNT_GLOBAL_STATUS_VARS
Definition: system_variables.h:528
#define FIRST_STATUS_VAR
Definition: system_variables.h:525
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
unsigned int uint
Definition: uca-dump.cc:29