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