1set time_zone='+00:00'; 2set timestamp=unix_timestamp('2014-09-01 13:40:23'); 3set pseudo_thread_id=10; 4set sql_mode=ansi_quotes; 5set global div_precision_increment=5; 6select VARIABLE_NAME,VARIABLE_SCOPE,VARIABLE_TYPE,VARIABLE_COMMENT,NUMERIC_MIN_VALUE,NUMERIC_MAX_VALUE,NUMERIC_BLOCK_SIZE,ENUM_VALUE_LIST,READ_ONLY,COMMAND_LINE_ARGUMENT 7from information_schema.system_variables 8where variable_name not like 'debug%' and 9variable_name not like 'wsrep%' and 10variable_name not like 's3%' and 11variable_name not in ( 12'log_tc_size','have_sanitizer' 13 ) 14order by variable_name; 15VARIABLE_NAME ALTER_ALGORITHM 16VARIABLE_SCOPE SESSION 17VARIABLE_TYPE ENUM 18VARIABLE_COMMENT Specify the alter table algorithm 19NUMERIC_MIN_VALUE NULL 20NUMERIC_MAX_VALUE NULL 21NUMERIC_BLOCK_SIZE NULL 22ENUM_VALUE_LIST DEFAULT,COPY,INPLACE,NOCOPY,INSTANT 23READ_ONLY NO 24COMMAND_LINE_ARGUMENT OPTIONAL 25VARIABLE_NAME ANALYZE_SAMPLE_PERCENTAGE 26VARIABLE_SCOPE SESSION 27VARIABLE_TYPE DOUBLE 28VARIABLE_COMMENT Percentage of rows from the table ANALYZE TABLE will sample to collect table statistics. Set to 0 to let MariaDB decide what percentage of rows to sample. 29NUMERIC_MIN_VALUE 0 30NUMERIC_MAX_VALUE 100 31NUMERIC_BLOCK_SIZE NULL 32ENUM_VALUE_LIST NULL 33READ_ONLY NO 34COMMAND_LINE_ARGUMENT REQUIRED 35VARIABLE_NAME ARIA_BLOCK_SIZE 36VARIABLE_SCOPE GLOBAL 37VARIABLE_TYPE BIGINT UNSIGNED 38VARIABLE_COMMENT Block size to be used for Aria index pages. 39NUMERIC_MIN_VALUE 4096 40NUMERIC_MAX_VALUE 32768 41NUMERIC_BLOCK_SIZE 1024 42ENUM_VALUE_LIST NULL 43READ_ONLY YES 44COMMAND_LINE_ARGUMENT REQUIRED 45VARIABLE_NAME ARIA_CHECKPOINT_INTERVAL 46VARIABLE_SCOPE GLOBAL 47VARIABLE_TYPE BIGINT UNSIGNED 48VARIABLE_COMMENT Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing. 49NUMERIC_MIN_VALUE 0 50NUMERIC_MAX_VALUE 4294967295 51NUMERIC_BLOCK_SIZE 1 52ENUM_VALUE_LIST NULL 53READ_ONLY NO 54COMMAND_LINE_ARGUMENT REQUIRED 55VARIABLE_NAME ARIA_CHECKPOINT_LOG_ACTIVITY 56VARIABLE_SCOPE GLOBAL 57VARIABLE_TYPE BIGINT UNSIGNED 58VARIABLE_COMMENT Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log. 59NUMERIC_MIN_VALUE 0 60NUMERIC_MAX_VALUE 4294967295 61NUMERIC_BLOCK_SIZE 1 62ENUM_VALUE_LIST NULL 63READ_ONLY NO 64COMMAND_LINE_ARGUMENT REQUIRED 65VARIABLE_NAME ARIA_ENCRYPT_TABLES 66VARIABLE_SCOPE GLOBAL 67VARIABLE_TYPE BOOLEAN 68VARIABLE_COMMENT Encrypt tables (only for tables with ROW_FORMAT=PAGE (default) and not FIXED/DYNAMIC) 69NUMERIC_MIN_VALUE NULL 70NUMERIC_MAX_VALUE NULL 71NUMERIC_BLOCK_SIZE NULL 72ENUM_VALUE_LIST OFF,ON 73READ_ONLY NO 74COMMAND_LINE_ARGUMENT OPTIONAL 75VARIABLE_NAME ARIA_FORCE_START_AFTER_RECOVERY_FAILURES 76VARIABLE_SCOPE GLOBAL 77VARIABLE_TYPE BIGINT UNSIGNED 78VARIABLE_COMMENT Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature. 79NUMERIC_MIN_VALUE 0 80NUMERIC_MAX_VALUE 255 81NUMERIC_BLOCK_SIZE 1 82ENUM_VALUE_LIST NULL 83READ_ONLY YES 84COMMAND_LINE_ARGUMENT REQUIRED 85VARIABLE_NAME ARIA_GROUP_COMMIT 86VARIABLE_SCOPE GLOBAL 87VARIABLE_TYPE ENUM 88VARIABLE_COMMENT Specifies Aria group commit mode. Possible values are "none" (no group commit), "hard" (with waiting to actual commit), "soft" (no wait for commit (DANGEROUS!!!)) 89NUMERIC_MIN_VALUE NULL 90NUMERIC_MAX_VALUE NULL 91NUMERIC_BLOCK_SIZE NULL 92ENUM_VALUE_LIST none,hard,soft 93READ_ONLY NO 94COMMAND_LINE_ARGUMENT REQUIRED 95VARIABLE_NAME ARIA_GROUP_COMMIT_INTERVAL 96VARIABLE_SCOPE GLOBAL 97VARIABLE_TYPE BIGINT UNSIGNED 98VARIABLE_COMMENT Interval between commite in microseconds (1/1000000c). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used 99NUMERIC_MIN_VALUE 0 100NUMERIC_MAX_VALUE 4294967295 101NUMERIC_BLOCK_SIZE 1 102ENUM_VALUE_LIST NULL 103READ_ONLY NO 104COMMAND_LINE_ARGUMENT REQUIRED 105VARIABLE_NAME ARIA_LOG_FILE_SIZE 106VARIABLE_SCOPE GLOBAL 107VARIABLE_TYPE BIGINT UNSIGNED 108VARIABLE_COMMENT Limit for transaction log size 109NUMERIC_MIN_VALUE 8388608 110NUMERIC_MAX_VALUE 4294967295 111NUMERIC_BLOCK_SIZE 8192 112ENUM_VALUE_LIST NULL 113READ_ONLY NO 114COMMAND_LINE_ARGUMENT REQUIRED 115VARIABLE_NAME ARIA_LOG_PURGE_TYPE 116VARIABLE_SCOPE GLOBAL 117VARIABLE_TYPE ENUM 118VARIABLE_COMMENT Specifies how Aria transactional log will be purged 119NUMERIC_MIN_VALUE NULL 120NUMERIC_MAX_VALUE NULL 121NUMERIC_BLOCK_SIZE NULL 122ENUM_VALUE_LIST immediate,external,at_flush 123READ_ONLY NO 124COMMAND_LINE_ARGUMENT REQUIRED 125VARIABLE_NAME ARIA_MAX_SORT_FILE_SIZE 126VARIABLE_SCOPE GLOBAL 127VARIABLE_TYPE BIGINT UNSIGNED 128VARIABLE_COMMENT Don't use the fast sort index method to created index if the temporary file would get bigger than this. 129NUMERIC_MIN_VALUE 0 130NUMERIC_MAX_VALUE 9223372036854775807 131NUMERIC_BLOCK_SIZE 1048576 132ENUM_VALUE_LIST NULL 133READ_ONLY NO 134COMMAND_LINE_ARGUMENT REQUIRED 135VARIABLE_NAME ARIA_PAGECACHE_AGE_THRESHOLD 136VARIABLE_SCOPE GLOBAL 137VARIABLE_TYPE BIGINT UNSIGNED 138VARIABLE_COMMENT This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache. 139NUMERIC_MIN_VALUE 100 140NUMERIC_MAX_VALUE 18446744073709551615 141NUMERIC_BLOCK_SIZE 100 142ENUM_VALUE_LIST NULL 143READ_ONLY NO 144COMMAND_LINE_ARGUMENT REQUIRED 145VARIABLE_NAME ARIA_PAGECACHE_BUFFER_SIZE 146VARIABLE_SCOPE GLOBAL 147VARIABLE_TYPE BIGINT UNSIGNED 148VARIABLE_COMMENT The size of the buffer used for index blocks for Aria tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford. 149NUMERIC_MIN_VALUE 131072 150NUMERIC_MAX_VALUE 18446744073709551615 151NUMERIC_BLOCK_SIZE 1 152ENUM_VALUE_LIST NULL 153READ_ONLY YES 154COMMAND_LINE_ARGUMENT REQUIRED 155VARIABLE_NAME ARIA_PAGECACHE_DIVISION_LIMIT 156VARIABLE_SCOPE GLOBAL 157VARIABLE_TYPE BIGINT UNSIGNED 158VARIABLE_COMMENT The minimum percentage of warm blocks in key cache 159NUMERIC_MIN_VALUE 1 160NUMERIC_MAX_VALUE 100 161NUMERIC_BLOCK_SIZE 1 162ENUM_VALUE_LIST NULL 163READ_ONLY NO 164COMMAND_LINE_ARGUMENT REQUIRED 165VARIABLE_NAME ARIA_PAGECACHE_FILE_HASH_SIZE 166VARIABLE_SCOPE GLOBAL 167VARIABLE_TYPE BIGINT UNSIGNED 168VARIABLE_COMMENT Number of hash buckets for open and changed files. If you have a lot of Aria files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open Aria files. 169NUMERIC_MIN_VALUE 128 170NUMERIC_MAX_VALUE 16384 171NUMERIC_BLOCK_SIZE 1 172ENUM_VALUE_LIST NULL 173READ_ONLY YES 174COMMAND_LINE_ARGUMENT REQUIRED 175VARIABLE_NAME ARIA_PAGE_CHECKSUM 176VARIABLE_SCOPE GLOBAL 177VARIABLE_TYPE BOOLEAN 178VARIABLE_COMMENT Maintain page checksums (can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE) 179NUMERIC_MIN_VALUE NULL 180NUMERIC_MAX_VALUE NULL 181NUMERIC_BLOCK_SIZE NULL 182ENUM_VALUE_LIST OFF,ON 183READ_ONLY NO 184COMMAND_LINE_ARGUMENT REQUIRED 185VARIABLE_NAME ARIA_RECOVER_OPTIONS 186VARIABLE_SCOPE GLOBAL 187VARIABLE_TYPE SET 188VARIABLE_COMMENT Specifies how corrupted tables should be automatically repaired 189NUMERIC_MIN_VALUE NULL 190NUMERIC_MAX_VALUE NULL 191NUMERIC_BLOCK_SIZE NULL 192ENUM_VALUE_LIST NORMAL,BACKUP,FORCE,QUICK,OFF 193READ_ONLY NO 194COMMAND_LINE_ARGUMENT OPTIONAL 195VARIABLE_NAME ARIA_REPAIR_THREADS 196VARIABLE_SCOPE SESSION 197VARIABLE_TYPE BIGINT UNSIGNED 198VARIABLE_COMMENT Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair. 199NUMERIC_MIN_VALUE 1 200NUMERIC_MAX_VALUE 128 201NUMERIC_BLOCK_SIZE 1 202ENUM_VALUE_LIST NULL 203READ_ONLY NO 204COMMAND_LINE_ARGUMENT REQUIRED 205VARIABLE_NAME ARIA_SORT_BUFFER_SIZE 206VARIABLE_SCOPE SESSION 207VARIABLE_TYPE BIGINT UNSIGNED 208VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE. 209NUMERIC_MIN_VALUE 4096 210NUMERIC_MAX_VALUE 18446744073709551615 211NUMERIC_BLOCK_SIZE 1 212ENUM_VALUE_LIST NULL 213READ_ONLY NO 214COMMAND_LINE_ARGUMENT REQUIRED 215VARIABLE_NAME ARIA_STATS_METHOD 216VARIABLE_SCOPE SESSION 217VARIABLE_TYPE ENUM 218VARIABLE_COMMENT Specifies how Aria index statistics collection code should treat NULLs 219NUMERIC_MIN_VALUE NULL 220NUMERIC_MAX_VALUE NULL 221NUMERIC_BLOCK_SIZE NULL 222ENUM_VALUE_LIST nulls_unequal,nulls_equal,nulls_ignored 223READ_ONLY NO 224COMMAND_LINE_ARGUMENT REQUIRED 225VARIABLE_NAME ARIA_SYNC_LOG_DIR 226VARIABLE_SCOPE GLOBAL 227VARIABLE_TYPE ENUM 228VARIABLE_COMMENT Controls syncing directory after log file growth and new file creation 229NUMERIC_MIN_VALUE NULL 230NUMERIC_MAX_VALUE NULL 231NUMERIC_BLOCK_SIZE NULL 232ENUM_VALUE_LIST NEVER,NEWFILE,ALWAYS 233READ_ONLY NO 234COMMAND_LINE_ARGUMENT REQUIRED 235VARIABLE_NAME ARIA_USED_FOR_TEMP_TABLES 236VARIABLE_SCOPE GLOBAL 237VARIABLE_TYPE BOOLEAN 238VARIABLE_COMMENT Whether temporary tables should be MyISAM or Aria 239NUMERIC_MIN_VALUE NULL 240NUMERIC_MAX_VALUE NULL 241NUMERIC_BLOCK_SIZE NULL 242ENUM_VALUE_LIST OFF,ON 243READ_ONLY YES 244COMMAND_LINE_ARGUMENT NULL 245VARIABLE_NAME AUTOCOMMIT 246VARIABLE_SCOPE SESSION 247VARIABLE_TYPE BOOLEAN 248VARIABLE_COMMENT If set to 1, the default, all queries are committed immediately. If set to 0, they are only committed upon a COMMIT statement, or rolled back with a ROLLBACK statement. If autocommit is set to 0, and then changed to 1, all open transactions are immediately committed. 249NUMERIC_MIN_VALUE NULL 250NUMERIC_MAX_VALUE NULL 251NUMERIC_BLOCK_SIZE NULL 252ENUM_VALUE_LIST OFF,ON 253READ_ONLY NO 254COMMAND_LINE_ARGUMENT NULL 255VARIABLE_NAME AUTOMATIC_SP_PRIVILEGES 256VARIABLE_SCOPE GLOBAL 257VARIABLE_TYPE BOOLEAN 258VARIABLE_COMMENT Creating and dropping stored procedures alters ACLs 259NUMERIC_MIN_VALUE NULL 260NUMERIC_MAX_VALUE NULL 261NUMERIC_BLOCK_SIZE NULL 262ENUM_VALUE_LIST OFF,ON 263READ_ONLY NO 264COMMAND_LINE_ARGUMENT OPTIONAL 265VARIABLE_NAME AUTO_INCREMENT_INCREMENT 266VARIABLE_SCOPE SESSION 267VARIABLE_TYPE BIGINT UNSIGNED 268VARIABLE_COMMENT Auto-increment columns are incremented by this 269NUMERIC_MIN_VALUE 1 270NUMERIC_MAX_VALUE 65535 271NUMERIC_BLOCK_SIZE 1 272ENUM_VALUE_LIST NULL 273READ_ONLY NO 274COMMAND_LINE_ARGUMENT OPTIONAL 275VARIABLE_NAME AUTO_INCREMENT_OFFSET 276VARIABLE_SCOPE SESSION 277VARIABLE_TYPE BIGINT UNSIGNED 278VARIABLE_COMMENT Offset added to Auto-increment columns. Used when auto-increment-increment != 1 279NUMERIC_MIN_VALUE 1 280NUMERIC_MAX_VALUE 65535 281NUMERIC_BLOCK_SIZE 1 282ENUM_VALUE_LIST NULL 283READ_ONLY NO 284COMMAND_LINE_ARGUMENT OPTIONAL 285VARIABLE_NAME BACK_LOG 286VARIABLE_SCOPE GLOBAL 287VARIABLE_TYPE BIGINT UNSIGNED 288VARIABLE_COMMENT The number of outstanding connection requests MariaDB can have. This comes into play when the main MariaDB thread gets very many connection requests in a very short time 289NUMERIC_MIN_VALUE 0 290NUMERIC_MAX_VALUE 65535 291NUMERIC_BLOCK_SIZE 1 292ENUM_VALUE_LIST NULL 293READ_ONLY YES 294COMMAND_LINE_ARGUMENT REQUIRED 295VARIABLE_NAME BASEDIR 296VARIABLE_SCOPE GLOBAL 297VARIABLE_TYPE VARCHAR 298VARIABLE_COMMENT Path to installation directory. All paths are usually resolved relative to this 299NUMERIC_MIN_VALUE NULL 300NUMERIC_MAX_VALUE NULL 301NUMERIC_BLOCK_SIZE NULL 302ENUM_VALUE_LIST NULL 303READ_ONLY YES 304COMMAND_LINE_ARGUMENT REQUIRED 305VARIABLE_NAME BIG_TABLES 306VARIABLE_SCOPE SESSION 307VARIABLE_TYPE BOOLEAN 308VARIABLE_COMMENT Old variable, which if set to 1, allows large result sets by saving all temporary sets to disk, avoiding 'table full' errors. No longer needed, as the server now handles this automatically. sql_big_tables is a synonym. 309NUMERIC_MIN_VALUE NULL 310NUMERIC_MAX_VALUE NULL 311NUMERIC_BLOCK_SIZE NULL 312ENUM_VALUE_LIST OFF,ON 313READ_ONLY NO 314COMMAND_LINE_ARGUMENT OPTIONAL 315VARIABLE_NAME BIND_ADDRESS 316VARIABLE_SCOPE GLOBAL 317VARIABLE_TYPE VARCHAR 318VARIABLE_COMMENT IP address to bind to. 319NUMERIC_MIN_VALUE NULL 320NUMERIC_MAX_VALUE NULL 321NUMERIC_BLOCK_SIZE NULL 322ENUM_VALUE_LIST NULL 323READ_ONLY YES 324COMMAND_LINE_ARGUMENT REQUIRED 325VARIABLE_NAME BINLOG_ANNOTATE_ROW_EVENTS 326VARIABLE_SCOPE SESSION 327VARIABLE_TYPE BOOLEAN 328VARIABLE_COMMENT Tells the master to annotate RBR events with the statement that caused these events 329NUMERIC_MIN_VALUE NULL 330NUMERIC_MAX_VALUE NULL 331NUMERIC_BLOCK_SIZE NULL 332ENUM_VALUE_LIST OFF,ON 333READ_ONLY NO 334COMMAND_LINE_ARGUMENT OPTIONAL 335VARIABLE_NAME BINLOG_CACHE_SIZE 336VARIABLE_SCOPE GLOBAL 337VARIABLE_TYPE BIGINT UNSIGNED 338VARIABLE_COMMENT The size of the transactional cache for updates to transactional engines for the binary log. If you often use transactions containing many statements, you can increase this to get more performance 339NUMERIC_MIN_VALUE 4096 340NUMERIC_MAX_VALUE 18446744073709551615 341NUMERIC_BLOCK_SIZE 4096 342ENUM_VALUE_LIST NULL 343READ_ONLY NO 344COMMAND_LINE_ARGUMENT REQUIRED 345VARIABLE_NAME BINLOG_CHECKSUM 346VARIABLE_SCOPE GLOBAL 347VARIABLE_TYPE ENUM 348VARIABLE_COMMENT Type of BINLOG_CHECKSUM_ALG. Include checksum for log events in the binary log 349NUMERIC_MIN_VALUE NULL 350NUMERIC_MAX_VALUE NULL 351NUMERIC_BLOCK_SIZE NULL 352ENUM_VALUE_LIST NONE,CRC32 353READ_ONLY NO 354COMMAND_LINE_ARGUMENT REQUIRED 355VARIABLE_NAME BINLOG_COMMIT_WAIT_COUNT 356VARIABLE_SCOPE GLOBAL 357VARIABLE_TYPE BIGINT UNSIGNED 358VARIABLE_COMMENT If non-zero, binlog write will wait at most binlog_commit_wait_usec microseconds for at least this many commits to queue up for group commit to the binlog. This can reduce I/O on the binlog and provide increased opportunity for parallel apply on the slave, but too high a value will decrease commit throughput. 359NUMERIC_MIN_VALUE 0 360NUMERIC_MAX_VALUE 18446744073709551615 361NUMERIC_BLOCK_SIZE 1 362ENUM_VALUE_LIST NULL 363READ_ONLY NO 364COMMAND_LINE_ARGUMENT REQUIRED 365VARIABLE_NAME BINLOG_COMMIT_WAIT_USEC 366VARIABLE_SCOPE GLOBAL 367VARIABLE_TYPE BIGINT UNSIGNED 368VARIABLE_COMMENT Maximum time, in microseconds, to wait for more commits to queue up for binlog group commit. Only takes effect if the value of binlog_commit_wait_count is non-zero. 369NUMERIC_MIN_VALUE 0 370NUMERIC_MAX_VALUE 18446744073709551615 371NUMERIC_BLOCK_SIZE 1 372ENUM_VALUE_LIST NULL 373READ_ONLY NO 374COMMAND_LINE_ARGUMENT REQUIRED 375VARIABLE_NAME BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES 376VARIABLE_SCOPE SESSION 377VARIABLE_TYPE BOOLEAN 378VARIABLE_COMMENT Causes updates to non-transactional engines using statement format to be written directly to binary log. Before using this option make sure that there are no dependencies between transactional and non-transactional tables such as in the statement INSERT INTO t_myisam SELECT * FROM t_innodb; otherwise, slaves may diverge from the master. 379NUMERIC_MIN_VALUE NULL 380NUMERIC_MAX_VALUE NULL 381NUMERIC_BLOCK_SIZE NULL 382ENUM_VALUE_LIST OFF,ON 383READ_ONLY NO 384COMMAND_LINE_ARGUMENT OPTIONAL 385VARIABLE_NAME BINLOG_FILE_CACHE_SIZE 386VARIABLE_SCOPE GLOBAL 387VARIABLE_TYPE BIGINT UNSIGNED 388VARIABLE_COMMENT The size of file cache for the binary log 389NUMERIC_MIN_VALUE 8192 390NUMERIC_MAX_VALUE 18446744073709551615 391NUMERIC_BLOCK_SIZE 4096 392ENUM_VALUE_LIST NULL 393READ_ONLY NO 394COMMAND_LINE_ARGUMENT REQUIRED 395VARIABLE_NAME BINLOG_FORMAT 396VARIABLE_SCOPE SESSION 397VARIABLE_TYPE ENUM 398VARIABLE_COMMENT What form of binary logging the master will use: either ROW for row-based binary logging, STATEMENT for statement-based binary logging, or MIXED. MIXED is statement-based binary logging except for those statements where only row-based is correct: those which involve user-defined functions (i.e. UDFs) or the UUID() function; for those, row-based binary logging is automatically used. 399NUMERIC_MIN_VALUE NULL 400NUMERIC_MAX_VALUE NULL 401NUMERIC_BLOCK_SIZE NULL 402ENUM_VALUE_LIST MIXED,STATEMENT,ROW 403READ_ONLY NO 404COMMAND_LINE_ARGUMENT REQUIRED 405VARIABLE_NAME BINLOG_OPTIMIZE_THREAD_SCHEDULING 406VARIABLE_SCOPE GLOBAL 407VARIABLE_TYPE BOOLEAN 408VARIABLE_COMMENT Run fast part of group commit in a single thread, to optimize kernel thread scheduling. On by default. Disable to run each transaction in group commit in its own thread, which can be slower at very high concurrency. This option is mostly for testing one algorithm versus the other, and it should not normally be necessary to change it. 409NUMERIC_MIN_VALUE NULL 410NUMERIC_MAX_VALUE NULL 411NUMERIC_BLOCK_SIZE NULL 412ENUM_VALUE_LIST OFF,ON 413READ_ONLY YES 414COMMAND_LINE_ARGUMENT REQUIRED 415VARIABLE_NAME BINLOG_ROW_IMAGE 416VARIABLE_SCOPE SESSION 417VARIABLE_TYPE ENUM 418VARIABLE_COMMENT Controls whether rows should be logged in 'FULL', 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all columns in the before and after image are logged. 'NOBLOB', means that mysqld avoids logging blob columns whenever possible (eg, blob column was not changed or is not part of primary key). 'MINIMAL', means that a PK equivalent (PK columns or full row if there is no PK in the table) is logged in the before image, and only changed columns are logged in the after image. (Default: FULL). 419NUMERIC_MIN_VALUE NULL 420NUMERIC_MAX_VALUE NULL 421NUMERIC_BLOCK_SIZE NULL 422ENUM_VALUE_LIST MINIMAL,NOBLOB,FULL 423READ_ONLY NO 424COMMAND_LINE_ARGUMENT REQUIRED 425VARIABLE_NAME BINLOG_STMT_CACHE_SIZE 426VARIABLE_SCOPE GLOBAL 427VARIABLE_TYPE BIGINT UNSIGNED 428VARIABLE_COMMENT The size of the statement cache for updates to non-transactional engines for the binary log. If you often use statements updating a great number of rows, you can increase this to get more performance. 429NUMERIC_MIN_VALUE 4096 430NUMERIC_MAX_VALUE 18446744073709551615 431NUMERIC_BLOCK_SIZE 4096 432ENUM_VALUE_LIST NULL 433READ_ONLY NO 434COMMAND_LINE_ARGUMENT REQUIRED 435VARIABLE_NAME BULK_INSERT_BUFFER_SIZE 436VARIABLE_SCOPE SESSION 437VARIABLE_TYPE BIGINT UNSIGNED 438VARIABLE_COMMENT Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread! 439NUMERIC_MIN_VALUE 0 440NUMERIC_MAX_VALUE 18446744073709551615 441NUMERIC_BLOCK_SIZE 1 442ENUM_VALUE_LIST NULL 443READ_ONLY NO 444COMMAND_LINE_ARGUMENT REQUIRED 445VARIABLE_NAME CHARACTER_SETS_DIR 446VARIABLE_SCOPE GLOBAL 447VARIABLE_TYPE VARCHAR 448VARIABLE_COMMENT Directory where character sets are 449NUMERIC_MIN_VALUE NULL 450NUMERIC_MAX_VALUE NULL 451NUMERIC_BLOCK_SIZE NULL 452ENUM_VALUE_LIST NULL 453READ_ONLY YES 454COMMAND_LINE_ARGUMENT REQUIRED 455VARIABLE_NAME CHARACTER_SET_CLIENT 456VARIABLE_SCOPE SESSION 457VARIABLE_TYPE ENUM 458VARIABLE_COMMENT The character set for statements that arrive from the client 459NUMERIC_MIN_VALUE NULL 460NUMERIC_MAX_VALUE NULL 461NUMERIC_BLOCK_SIZE NULL 462ENUM_VALUE_LIST NULL 463READ_ONLY NO 464COMMAND_LINE_ARGUMENT NULL 465VARIABLE_NAME CHARACTER_SET_CONNECTION 466VARIABLE_SCOPE SESSION 467VARIABLE_TYPE ENUM 468VARIABLE_COMMENT The character set used for literals that do not have a character set introducer and for number-to-string conversion 469NUMERIC_MIN_VALUE NULL 470NUMERIC_MAX_VALUE NULL 471NUMERIC_BLOCK_SIZE NULL 472ENUM_VALUE_LIST NULL 473READ_ONLY NO 474COMMAND_LINE_ARGUMENT NULL 475VARIABLE_NAME CHARACTER_SET_DATABASE 476VARIABLE_SCOPE SESSION 477VARIABLE_TYPE ENUM 478VARIABLE_COMMENT The character set used by the default database 479NUMERIC_MIN_VALUE NULL 480NUMERIC_MAX_VALUE NULL 481NUMERIC_BLOCK_SIZE NULL 482ENUM_VALUE_LIST NULL 483READ_ONLY NO 484COMMAND_LINE_ARGUMENT NULL 485VARIABLE_NAME CHARACTER_SET_FILESYSTEM 486VARIABLE_SCOPE SESSION 487VARIABLE_TYPE ENUM 488VARIABLE_COMMENT The filesystem character set 489NUMERIC_MIN_VALUE NULL 490NUMERIC_MAX_VALUE NULL 491NUMERIC_BLOCK_SIZE NULL 492ENUM_VALUE_LIST NULL 493READ_ONLY NO 494COMMAND_LINE_ARGUMENT NULL 495VARIABLE_NAME CHARACTER_SET_RESULTS 496VARIABLE_SCOPE SESSION 497VARIABLE_TYPE ENUM 498VARIABLE_COMMENT The character set used for returning query results to the client 499NUMERIC_MIN_VALUE NULL 500NUMERIC_MAX_VALUE NULL 501NUMERIC_BLOCK_SIZE NULL 502ENUM_VALUE_LIST NULL 503READ_ONLY NO 504COMMAND_LINE_ARGUMENT NULL 505VARIABLE_NAME CHARACTER_SET_SERVER 506VARIABLE_SCOPE SESSION 507VARIABLE_TYPE ENUM 508VARIABLE_COMMENT The default character set 509NUMERIC_MIN_VALUE NULL 510NUMERIC_MAX_VALUE NULL 511NUMERIC_BLOCK_SIZE NULL 512ENUM_VALUE_LIST NULL 513READ_ONLY NO 514COMMAND_LINE_ARGUMENT NULL 515VARIABLE_NAME CHARACTER_SET_SYSTEM 516VARIABLE_SCOPE GLOBAL 517VARIABLE_TYPE ENUM 518VARIABLE_COMMENT The character set used by the server for storing identifiers 519NUMERIC_MIN_VALUE NULL 520NUMERIC_MAX_VALUE NULL 521NUMERIC_BLOCK_SIZE NULL 522ENUM_VALUE_LIST NULL 523READ_ONLY YES 524COMMAND_LINE_ARGUMENT NULL 525VARIABLE_NAME CHECK_CONSTRAINT_CHECKS 526VARIABLE_SCOPE SESSION 527VARIABLE_TYPE BOOLEAN 528VARIABLE_COMMENT check_constraint_checks 529NUMERIC_MIN_VALUE NULL 530NUMERIC_MAX_VALUE NULL 531NUMERIC_BLOCK_SIZE NULL 532ENUM_VALUE_LIST OFF,ON 533READ_ONLY NO 534COMMAND_LINE_ARGUMENT NULL 535VARIABLE_NAME COLLATION_CONNECTION 536VARIABLE_SCOPE SESSION 537VARIABLE_TYPE ENUM 538VARIABLE_COMMENT The collation of the connection character set 539NUMERIC_MIN_VALUE NULL 540NUMERIC_MAX_VALUE NULL 541NUMERIC_BLOCK_SIZE NULL 542ENUM_VALUE_LIST NULL 543READ_ONLY NO 544COMMAND_LINE_ARGUMENT NULL 545VARIABLE_NAME COLLATION_DATABASE 546VARIABLE_SCOPE SESSION 547VARIABLE_TYPE ENUM 548VARIABLE_COMMENT The collation of the database character set 549NUMERIC_MIN_VALUE NULL 550NUMERIC_MAX_VALUE NULL 551NUMERIC_BLOCK_SIZE NULL 552ENUM_VALUE_LIST NULL 553READ_ONLY NO 554COMMAND_LINE_ARGUMENT NULL 555VARIABLE_NAME COLLATION_SERVER 556VARIABLE_SCOPE SESSION 557VARIABLE_TYPE ENUM 558VARIABLE_COMMENT The server default collation 559NUMERIC_MIN_VALUE NULL 560NUMERIC_MAX_VALUE NULL 561NUMERIC_BLOCK_SIZE NULL 562ENUM_VALUE_LIST NULL 563READ_ONLY NO 564COMMAND_LINE_ARGUMENT NULL 565VARIABLE_NAME COLUMN_COMPRESSION_THRESHOLD 566VARIABLE_SCOPE SESSION 567VARIABLE_TYPE INT UNSIGNED 568VARIABLE_COMMENT Minimum column data length eligible for compression 569NUMERIC_MIN_VALUE 0 570NUMERIC_MAX_VALUE 4294967295 571NUMERIC_BLOCK_SIZE 1 572ENUM_VALUE_LIST NULL 573READ_ONLY NO 574COMMAND_LINE_ARGUMENT REQUIRED 575VARIABLE_NAME COLUMN_COMPRESSION_ZLIB_LEVEL 576VARIABLE_SCOPE SESSION 577VARIABLE_TYPE INT UNSIGNED 578VARIABLE_COMMENT zlib compression level (1 gives best speed, 9 gives best compression) 579NUMERIC_MIN_VALUE 0 580NUMERIC_MAX_VALUE 9 581NUMERIC_BLOCK_SIZE 1 582ENUM_VALUE_LIST NULL 583READ_ONLY NO 584COMMAND_LINE_ARGUMENT REQUIRED 585VARIABLE_NAME COLUMN_COMPRESSION_ZLIB_STRATEGY 586VARIABLE_SCOPE SESSION 587VARIABLE_TYPE ENUM 588VARIABLE_COMMENT The strategy parameter is used to tune the compression algorithm. Use the value DEFAULT_STRATEGY for normal data, FILTERED for data produced by a filter (or predictor), HUFFMAN_ONLY to force Huffman encoding only (no string match), or RLE to limit match distances to one (run-length encoding). Filtered data consists mostly of small values with a somewhat random distribution. In this case, the compression algorithm is tuned to compress them better. The effect of FILTERED is to force more Huffman coding and less string matching; it is somewhat intermediate between DEFAULT_STRATEGY and HUFFMAN_ONLY. RLE is designed to be almost as fast as HUFFMAN_ONLY, but give better compression for PNG image data. The strategy parameter only affects the compression ratio but not the correctness of the compressed output even if it is not set appropriately. FIXED prevents the use of dynamic Huffman codes, allowing for a simpler decoder for special applications. 589NUMERIC_MIN_VALUE NULL 590NUMERIC_MAX_VALUE NULL 591NUMERIC_BLOCK_SIZE NULL 592ENUM_VALUE_LIST DEFAULT_STRATEGY,FILTERED,HUFFMAN_ONLY,RLE,FIXED 593READ_ONLY NO 594COMMAND_LINE_ARGUMENT REQUIRED 595VARIABLE_NAME COLUMN_COMPRESSION_ZLIB_WRAP 596VARIABLE_SCOPE SESSION 597VARIABLE_TYPE BOOLEAN 598VARIABLE_COMMENT Generate zlib header and trailer and compute adler32 check value. It can be used with storage engines that don't provide data integrity verification to detect data corruption. 599NUMERIC_MIN_VALUE NULL 600NUMERIC_MAX_VALUE NULL 601NUMERIC_BLOCK_SIZE NULL 602ENUM_VALUE_LIST OFF,ON 603READ_ONLY NO 604COMMAND_LINE_ARGUMENT OPTIONAL 605VARIABLE_NAME COMPLETION_TYPE 606VARIABLE_SCOPE SESSION 607VARIABLE_TYPE ENUM 608VARIABLE_COMMENT The transaction completion type 609NUMERIC_MIN_VALUE NULL 610NUMERIC_MAX_VALUE NULL 611NUMERIC_BLOCK_SIZE NULL 612ENUM_VALUE_LIST NO_CHAIN,CHAIN,RELEASE 613READ_ONLY NO 614COMMAND_LINE_ARGUMENT REQUIRED 615VARIABLE_NAME CONCURRENT_INSERT 616VARIABLE_SCOPE GLOBAL 617VARIABLE_TYPE ENUM 618VARIABLE_COMMENT Use concurrent insert with MyISAM 619NUMERIC_MIN_VALUE NULL 620NUMERIC_MAX_VALUE NULL 621NUMERIC_BLOCK_SIZE NULL 622ENUM_VALUE_LIST NEVER,AUTO,ALWAYS 623READ_ONLY NO 624COMMAND_LINE_ARGUMENT OPTIONAL 625VARIABLE_NAME CONNECT_TIMEOUT 626VARIABLE_SCOPE GLOBAL 627VARIABLE_TYPE BIGINT UNSIGNED 628VARIABLE_COMMENT The number of seconds the mysqld server is waiting for a connect packet before responding with 'Bad handshake' 629NUMERIC_MIN_VALUE 2 630NUMERIC_MAX_VALUE 31536000 631NUMERIC_BLOCK_SIZE 1 632ENUM_VALUE_LIST NULL 633READ_ONLY NO 634COMMAND_LINE_ARGUMENT REQUIRED 635VARIABLE_NAME CORE_FILE 636VARIABLE_SCOPE GLOBAL 637VARIABLE_TYPE BOOLEAN 638VARIABLE_COMMENT write a core-file on crashes 639NUMERIC_MIN_VALUE NULL 640NUMERIC_MAX_VALUE NULL 641NUMERIC_BLOCK_SIZE NULL 642ENUM_VALUE_LIST OFF,ON 643READ_ONLY YES 644COMMAND_LINE_ARGUMENT NULL 645VARIABLE_NAME DATADIR 646VARIABLE_SCOPE GLOBAL 647VARIABLE_TYPE VARCHAR 648VARIABLE_COMMENT Path to the database root directory 649NUMERIC_MIN_VALUE NULL 650NUMERIC_MAX_VALUE NULL 651NUMERIC_BLOCK_SIZE NULL 652ENUM_VALUE_LIST NULL 653READ_ONLY YES 654COMMAND_LINE_ARGUMENT REQUIRED 655VARIABLE_NAME DATETIME_FORMAT 656VARIABLE_SCOPE GLOBAL 657VARIABLE_TYPE VARCHAR 658VARIABLE_COMMENT The DATETIME format (ignored) 659NUMERIC_MIN_VALUE NULL 660NUMERIC_MAX_VALUE NULL 661NUMERIC_BLOCK_SIZE NULL 662ENUM_VALUE_LIST NULL 663READ_ONLY YES 664COMMAND_LINE_ARGUMENT REQUIRED 665VARIABLE_NAME DATE_FORMAT 666VARIABLE_SCOPE GLOBAL 667VARIABLE_TYPE VARCHAR 668VARIABLE_COMMENT The DATE format (ignored) 669NUMERIC_MIN_VALUE NULL 670NUMERIC_MAX_VALUE NULL 671NUMERIC_BLOCK_SIZE NULL 672ENUM_VALUE_LIST NULL 673READ_ONLY YES 674COMMAND_LINE_ARGUMENT REQUIRED 675VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_LONG 676VARIABLE_SCOPE SESSION 677VARIABLE_TYPE BIGINT UNSIGNED 678VARIABLE_COMMENT Long search depth for the two-step deadlock detection 679NUMERIC_MIN_VALUE 0 680NUMERIC_MAX_VALUE 33 681NUMERIC_BLOCK_SIZE 1 682ENUM_VALUE_LIST NULL 683READ_ONLY NO 684COMMAND_LINE_ARGUMENT REQUIRED 685VARIABLE_NAME DEADLOCK_SEARCH_DEPTH_SHORT 686VARIABLE_SCOPE SESSION 687VARIABLE_TYPE BIGINT UNSIGNED 688VARIABLE_COMMENT Short search depth for the two-step deadlock detection 689NUMERIC_MIN_VALUE 0 690NUMERIC_MAX_VALUE 32 691NUMERIC_BLOCK_SIZE 1 692ENUM_VALUE_LIST NULL 693READ_ONLY NO 694COMMAND_LINE_ARGUMENT REQUIRED 695VARIABLE_NAME DEADLOCK_TIMEOUT_LONG 696VARIABLE_SCOPE SESSION 697VARIABLE_TYPE BIGINT UNSIGNED 698VARIABLE_COMMENT Long timeout for the two-step deadlock detection (in microseconds) 699NUMERIC_MIN_VALUE 0 700NUMERIC_MAX_VALUE 4294967295 701NUMERIC_BLOCK_SIZE 1 702ENUM_VALUE_LIST NULL 703READ_ONLY NO 704COMMAND_LINE_ARGUMENT REQUIRED 705VARIABLE_NAME DEADLOCK_TIMEOUT_SHORT 706VARIABLE_SCOPE SESSION 707VARIABLE_TYPE BIGINT UNSIGNED 708VARIABLE_COMMENT Short timeout for the two-step deadlock detection (in microseconds) 709NUMERIC_MIN_VALUE 0 710NUMERIC_MAX_VALUE 4294967295 711NUMERIC_BLOCK_SIZE 1 712ENUM_VALUE_LIST NULL 713READ_ONLY NO 714COMMAND_LINE_ARGUMENT REQUIRED 715VARIABLE_NAME DEFAULT_MASTER_CONNECTION 716VARIABLE_SCOPE SESSION ONLY 717VARIABLE_TYPE VARCHAR 718VARIABLE_COMMENT Master connection to use for all slave variables and slave commands 719NUMERIC_MIN_VALUE NULL 720NUMERIC_MAX_VALUE NULL 721NUMERIC_BLOCK_SIZE NULL 722ENUM_VALUE_LIST NULL 723READ_ONLY NO 724COMMAND_LINE_ARGUMENT NULL 725VARIABLE_NAME DEFAULT_PASSWORD_LIFETIME 726VARIABLE_SCOPE GLOBAL 727VARIABLE_TYPE INT UNSIGNED 728VARIABLE_COMMENT This defines the global password expiration policy. 0 means automatic password expiration is disabled. If the value is a positive integer N, the passwords must be changed every N days. This behavior can be overridden using the password expiration options in ALTER USER. 729NUMERIC_MIN_VALUE 0 730NUMERIC_MAX_VALUE 4294967295 731NUMERIC_BLOCK_SIZE 1 732ENUM_VALUE_LIST NULL 733READ_ONLY NO 734COMMAND_LINE_ARGUMENT REQUIRED 735VARIABLE_NAME DEFAULT_REGEX_FLAGS 736VARIABLE_SCOPE SESSION 737VARIABLE_TYPE SET 738VARIABLE_COMMENT Default flags for the regex library 739NUMERIC_MIN_VALUE NULL 740NUMERIC_MAX_VALUE NULL 741NUMERIC_BLOCK_SIZE NULL 742ENUM_VALUE_LIST DOTALL,DUPNAMES,EXTENDED,EXTRA,MULTILINE,UNGREEDY 743READ_ONLY NO 744COMMAND_LINE_ARGUMENT REQUIRED 745VARIABLE_NAME DEFAULT_STORAGE_ENGINE 746VARIABLE_SCOPE SESSION 747VARIABLE_TYPE VARCHAR 748VARIABLE_COMMENT The default storage engine for new tables 749NUMERIC_MIN_VALUE NULL 750NUMERIC_MAX_VALUE NULL 751NUMERIC_BLOCK_SIZE NULL 752ENUM_VALUE_LIST NULL 753READ_ONLY NO 754COMMAND_LINE_ARGUMENT NULL 755VARIABLE_NAME DEFAULT_TMP_STORAGE_ENGINE 756VARIABLE_SCOPE SESSION 757VARIABLE_TYPE VARCHAR 758VARIABLE_COMMENT The default storage engine for user-created temporary tables 759NUMERIC_MIN_VALUE NULL 760NUMERIC_MAX_VALUE NULL 761NUMERIC_BLOCK_SIZE NULL 762ENUM_VALUE_LIST NULL 763READ_ONLY NO 764COMMAND_LINE_ARGUMENT NULL 765VARIABLE_NAME DEFAULT_WEEK_FORMAT 766VARIABLE_SCOPE SESSION 767VARIABLE_TYPE BIGINT UNSIGNED 768VARIABLE_COMMENT The default week format used by WEEK() functions 769NUMERIC_MIN_VALUE 0 770NUMERIC_MAX_VALUE 7 771NUMERIC_BLOCK_SIZE 1 772ENUM_VALUE_LIST NULL 773READ_ONLY NO 774COMMAND_LINE_ARGUMENT REQUIRED 775VARIABLE_NAME DELAYED_INSERT_LIMIT 776VARIABLE_SCOPE GLOBAL 777VARIABLE_TYPE BIGINT UNSIGNED 778VARIABLE_COMMENT After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing. 779NUMERIC_MIN_VALUE 1 780NUMERIC_MAX_VALUE 4294967295 781NUMERIC_BLOCK_SIZE 1 782ENUM_VALUE_LIST NULL 783READ_ONLY NO 784COMMAND_LINE_ARGUMENT REQUIRED 785VARIABLE_NAME DELAYED_INSERT_TIMEOUT 786VARIABLE_SCOPE GLOBAL 787VARIABLE_TYPE BIGINT UNSIGNED 788VARIABLE_COMMENT How long a INSERT DELAYED thread should wait for INSERT statements before terminating 789NUMERIC_MIN_VALUE 1 790NUMERIC_MAX_VALUE 31536000 791NUMERIC_BLOCK_SIZE 1 792ENUM_VALUE_LIST NULL 793READ_ONLY NO 794COMMAND_LINE_ARGUMENT REQUIRED 795VARIABLE_NAME DELAYED_QUEUE_SIZE 796VARIABLE_SCOPE GLOBAL 797VARIABLE_TYPE BIGINT UNSIGNED 798VARIABLE_COMMENT What size queue (in rows) should be allocated for handling INSERT DELAYED. If the queue becomes full, any client that does INSERT DELAYED will wait until there is room in the queue again 799NUMERIC_MIN_VALUE 1 800NUMERIC_MAX_VALUE 4294967295 801NUMERIC_BLOCK_SIZE 1 802ENUM_VALUE_LIST NULL 803READ_ONLY NO 804COMMAND_LINE_ARGUMENT REQUIRED 805VARIABLE_NAME DELAY_KEY_WRITE 806VARIABLE_SCOPE GLOBAL 807VARIABLE_TYPE ENUM 808VARIABLE_COMMENT Specifies how MyISAM tables handles CREATE TABLE DELAY_KEY_WRITE. If set to ON, the default, any DELAY KEY WRITEs are honored. The key buffer is then flushed only when the table closes, speeding up writes. MyISAM tables should be automatically checked upon startup in this case, and --external locking should not be used, as it can lead to index corruption. If set to OFF, DELAY KEY WRITEs are ignored, while if set to ALL, all new opened tables are treated as if created with DELAY KEY WRITEs enabled. 809NUMERIC_MIN_VALUE NULL 810NUMERIC_MAX_VALUE NULL 811NUMERIC_BLOCK_SIZE NULL 812ENUM_VALUE_LIST OFF,ON,ALL 813READ_ONLY NO 814COMMAND_LINE_ARGUMENT OPTIONAL 815VARIABLE_NAME DISCONNECT_ON_EXPIRED_PASSWORD 816VARIABLE_SCOPE GLOBAL 817VARIABLE_TYPE BOOLEAN 818VARIABLE_COMMENT This variable controls how the server handles clients that are not aware of the sandbox mode. If enabled, the server disconnects the client, otherwise the server puts the client in a sandbox mode. 819NUMERIC_MIN_VALUE NULL 820NUMERIC_MAX_VALUE NULL 821NUMERIC_BLOCK_SIZE NULL 822ENUM_VALUE_LIST OFF,ON 823READ_ONLY NO 824COMMAND_LINE_ARGUMENT OPTIONAL 825VARIABLE_NAME DIV_PRECISION_INCREMENT 826VARIABLE_SCOPE SESSION 827VARIABLE_TYPE BIGINT UNSIGNED 828VARIABLE_COMMENT Precision of the result of '/' operator will be increased on that value 829NUMERIC_MIN_VALUE 0 830NUMERIC_MAX_VALUE 38 831NUMERIC_BLOCK_SIZE 1 832ENUM_VALUE_LIST NULL 833READ_ONLY NO 834COMMAND_LINE_ARGUMENT REQUIRED 835VARIABLE_NAME ENCRYPT_BINLOG 836VARIABLE_SCOPE GLOBAL 837VARIABLE_TYPE BOOLEAN 838VARIABLE_COMMENT Encrypt binary logs (including relay logs) 839NUMERIC_MIN_VALUE NULL 840NUMERIC_MAX_VALUE NULL 841NUMERIC_BLOCK_SIZE NULL 842ENUM_VALUE_LIST OFF,ON 843READ_ONLY YES 844COMMAND_LINE_ARGUMENT OPTIONAL 845VARIABLE_NAME ENCRYPT_TMP_DISK_TABLES 846VARIABLE_SCOPE GLOBAL 847VARIABLE_TYPE BOOLEAN 848VARIABLE_COMMENT Encrypt temporary on-disk tables (created as part of query execution) 849NUMERIC_MIN_VALUE NULL 850NUMERIC_MAX_VALUE NULL 851NUMERIC_BLOCK_SIZE NULL 852ENUM_VALUE_LIST OFF,ON 853READ_ONLY NO 854COMMAND_LINE_ARGUMENT OPTIONAL 855VARIABLE_NAME ENCRYPT_TMP_FILES 856VARIABLE_SCOPE GLOBAL 857VARIABLE_TYPE BOOLEAN 858VARIABLE_COMMENT Encrypt temporary files (created for filesort, binary log cache, etc) 859NUMERIC_MIN_VALUE NULL 860NUMERIC_MAX_VALUE NULL 861NUMERIC_BLOCK_SIZE NULL 862ENUM_VALUE_LIST OFF,ON 863READ_ONLY YES 864COMMAND_LINE_ARGUMENT OPTIONAL 865VARIABLE_NAME ENFORCE_STORAGE_ENGINE 866VARIABLE_SCOPE SESSION 867VARIABLE_TYPE VARCHAR 868VARIABLE_COMMENT Force the use of a storage engine for new tables 869NUMERIC_MIN_VALUE NULL 870NUMERIC_MAX_VALUE NULL 871NUMERIC_BLOCK_SIZE NULL 872ENUM_VALUE_LIST NULL 873READ_ONLY NO 874COMMAND_LINE_ARGUMENT NULL 875VARIABLE_NAME EQ_RANGE_INDEX_DIVE_LIMIT 876VARIABLE_SCOPE SESSION 877VARIABLE_TYPE INT UNSIGNED 878VARIABLE_COMMENT The optimizer will use existing index statistics instead of doing index dives for equality ranges if the number of equality ranges for the index is larger than or equal to this number. If set to 0, index dives are always used. 879NUMERIC_MIN_VALUE 0 880NUMERIC_MAX_VALUE 4294967295 881NUMERIC_BLOCK_SIZE 1 882ENUM_VALUE_LIST NULL 883READ_ONLY NO 884COMMAND_LINE_ARGUMENT REQUIRED 885VARIABLE_NAME ERROR_COUNT 886VARIABLE_SCOPE SESSION ONLY 887VARIABLE_TYPE BIGINT UNSIGNED 888VARIABLE_COMMENT The number of errors that resulted from the last statement that generated messages 889NUMERIC_MIN_VALUE 0 890NUMERIC_MAX_VALUE 18446744073709551615 891NUMERIC_BLOCK_SIZE 1 892ENUM_VALUE_LIST NULL 893READ_ONLY YES 894COMMAND_LINE_ARGUMENT NULL 895VARIABLE_NAME EVENT_SCHEDULER 896VARIABLE_SCOPE GLOBAL 897VARIABLE_TYPE ENUM 898VARIABLE_COMMENT Enable the event scheduler. Possible values are ON, OFF, and DISABLED (keep the event scheduler completely deactivated, it cannot be activated run-time) 899NUMERIC_MIN_VALUE NULL 900NUMERIC_MAX_VALUE NULL 901NUMERIC_BLOCK_SIZE NULL 902ENUM_VALUE_LIST OFF,ON,DISABLED,ORIGINAL 903READ_ONLY NO 904COMMAND_LINE_ARGUMENT OPTIONAL 905VARIABLE_NAME EXPENSIVE_SUBQUERY_LIMIT 906VARIABLE_SCOPE SESSION 907VARIABLE_TYPE BIGINT UNSIGNED 908VARIABLE_COMMENT The maximum number of rows a subquery may examine in order to be executed during optimization and used for constant optimization 909NUMERIC_MIN_VALUE 0 910NUMERIC_MAX_VALUE 18446744073709551615 911NUMERIC_BLOCK_SIZE 1 912ENUM_VALUE_LIST NULL 913READ_ONLY NO 914COMMAND_LINE_ARGUMENT REQUIRED 915VARIABLE_NAME EXPIRE_LOGS_DAYS 916VARIABLE_SCOPE GLOBAL 917VARIABLE_TYPE BIGINT UNSIGNED 918VARIABLE_COMMENT If non-zero, binary logs will be purged after expire_logs_days days; possible purges happen at startup and at binary log rotation 919NUMERIC_MIN_VALUE 0 920NUMERIC_MAX_VALUE 99 921NUMERIC_BLOCK_SIZE 1 922ENUM_VALUE_LIST NULL 923READ_ONLY NO 924COMMAND_LINE_ARGUMENT REQUIRED 925VARIABLE_NAME EXPLICIT_DEFAULTS_FOR_TIMESTAMP 926VARIABLE_SCOPE GLOBAL 927VARIABLE_TYPE BOOLEAN 928VARIABLE_COMMENT This option causes CREATE TABLE to create all TIMESTAMP columns as NULL with DEFAULT NULL attribute, Without this option, TIMESTAMP columns are NOT NULL and have implicit DEFAULT clauses. 929NUMERIC_MIN_VALUE NULL 930NUMERIC_MAX_VALUE NULL 931NUMERIC_BLOCK_SIZE NULL 932ENUM_VALUE_LIST OFF,ON 933READ_ONLY YES 934COMMAND_LINE_ARGUMENT OPTIONAL 935VARIABLE_NAME EXTERNAL_USER 936VARIABLE_SCOPE SESSION ONLY 937VARIABLE_TYPE VARCHAR 938VARIABLE_COMMENT The external user account used when logging in 939NUMERIC_MIN_VALUE NULL 940NUMERIC_MAX_VALUE NULL 941NUMERIC_BLOCK_SIZE NULL 942ENUM_VALUE_LIST NULL 943READ_ONLY YES 944COMMAND_LINE_ARGUMENT NULL 945VARIABLE_NAME EXTRA_MAX_CONNECTIONS 946VARIABLE_SCOPE GLOBAL 947VARIABLE_TYPE BIGINT UNSIGNED 948VARIABLE_COMMENT The number of connections on extra-port 949NUMERIC_MIN_VALUE 1 950NUMERIC_MAX_VALUE 100000 951NUMERIC_BLOCK_SIZE 1 952ENUM_VALUE_LIST NULL 953READ_ONLY NO 954COMMAND_LINE_ARGUMENT REQUIRED 955VARIABLE_NAME EXTRA_PORT 956VARIABLE_SCOPE GLOBAL 957VARIABLE_TYPE INT UNSIGNED 958VARIABLE_COMMENT Extra port number to use for tcp connections in a one-thread-per-connection manner. 0 means don't use another port 959NUMERIC_MIN_VALUE 0 960NUMERIC_MAX_VALUE 4294967295 961NUMERIC_BLOCK_SIZE 1 962ENUM_VALUE_LIST NULL 963READ_ONLY YES 964COMMAND_LINE_ARGUMENT REQUIRED 965VARIABLE_NAME FLUSH 966VARIABLE_SCOPE GLOBAL 967VARIABLE_TYPE BOOLEAN 968VARIABLE_COMMENT Flush MyISAM tables to disk between SQL commands 969NUMERIC_MIN_VALUE NULL 970NUMERIC_MAX_VALUE NULL 971NUMERIC_BLOCK_SIZE NULL 972ENUM_VALUE_LIST OFF,ON 973READ_ONLY NO 974COMMAND_LINE_ARGUMENT OPTIONAL 975VARIABLE_NAME FLUSH_TIME 976VARIABLE_SCOPE GLOBAL 977VARIABLE_TYPE BIGINT UNSIGNED 978VARIABLE_COMMENT A dedicated thread is created to flush all tables at the given interval 979NUMERIC_MIN_VALUE 0 980NUMERIC_MAX_VALUE 31536000 981NUMERIC_BLOCK_SIZE 1 982ENUM_VALUE_LIST NULL 983READ_ONLY NO 984COMMAND_LINE_ARGUMENT REQUIRED 985VARIABLE_NAME FOREIGN_KEY_CHECKS 986VARIABLE_SCOPE SESSION 987VARIABLE_TYPE BOOLEAN 988VARIABLE_COMMENT If set to 1 (the default) foreign key constraints (including ON UPDATE and ON DELETE behavior) InnoDB tables are checked, while if set to 0, they are not checked. 0 is not recommended for normal use, though it can be useful in situations where you know the data is consistent, but want to reload data in a different order from that that specified by parent/child relationships. Setting this variable to 1 does not retrospectively check for inconsistencies introduced while set to 0. 989NUMERIC_MIN_VALUE NULL 990NUMERIC_MAX_VALUE NULL 991NUMERIC_BLOCK_SIZE NULL 992ENUM_VALUE_LIST OFF,ON 993READ_ONLY NO 994COMMAND_LINE_ARGUMENT NULL 995VARIABLE_NAME FT_BOOLEAN_SYNTAX 996VARIABLE_SCOPE GLOBAL 997VARIABLE_TYPE VARCHAR 998VARIABLE_COMMENT List of operators for MATCH ... AGAINST ( ... IN BOOLEAN MODE) 999NUMERIC_MIN_VALUE NULL 1000NUMERIC_MAX_VALUE NULL 1001NUMERIC_BLOCK_SIZE NULL 1002ENUM_VALUE_LIST NULL 1003READ_ONLY NO 1004COMMAND_LINE_ARGUMENT REQUIRED 1005VARIABLE_NAME FT_MAX_WORD_LEN 1006VARIABLE_SCOPE GLOBAL 1007VARIABLE_TYPE BIGINT UNSIGNED 1008VARIABLE_COMMENT The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable 1009NUMERIC_MIN_VALUE 10 1010NUMERIC_MAX_VALUE 84 1011NUMERIC_BLOCK_SIZE 1 1012ENUM_VALUE_LIST NULL 1013READ_ONLY YES 1014COMMAND_LINE_ARGUMENT REQUIRED 1015VARIABLE_NAME FT_MIN_WORD_LEN 1016VARIABLE_SCOPE GLOBAL 1017VARIABLE_TYPE BIGINT UNSIGNED 1018VARIABLE_COMMENT The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable 1019NUMERIC_MIN_VALUE 1 1020NUMERIC_MAX_VALUE 84 1021NUMERIC_BLOCK_SIZE 1 1022ENUM_VALUE_LIST NULL 1023READ_ONLY YES 1024COMMAND_LINE_ARGUMENT REQUIRED 1025VARIABLE_NAME FT_QUERY_EXPANSION_LIMIT 1026VARIABLE_SCOPE GLOBAL 1027VARIABLE_TYPE BIGINT UNSIGNED 1028VARIABLE_COMMENT Number of best matches to use for query expansion 1029NUMERIC_MIN_VALUE 0 1030NUMERIC_MAX_VALUE 1000 1031NUMERIC_BLOCK_SIZE 1 1032ENUM_VALUE_LIST NULL 1033READ_ONLY YES 1034COMMAND_LINE_ARGUMENT REQUIRED 1035VARIABLE_NAME FT_STOPWORD_FILE 1036VARIABLE_SCOPE GLOBAL 1037VARIABLE_TYPE VARCHAR 1038VARIABLE_COMMENT Use stopwords from this file instead of built-in list 1039NUMERIC_MIN_VALUE NULL 1040NUMERIC_MAX_VALUE NULL 1041NUMERIC_BLOCK_SIZE NULL 1042ENUM_VALUE_LIST NULL 1043READ_ONLY YES 1044COMMAND_LINE_ARGUMENT REQUIRED 1045VARIABLE_NAME GENERAL_LOG 1046VARIABLE_SCOPE GLOBAL 1047VARIABLE_TYPE BOOLEAN 1048VARIABLE_COMMENT Log connections and queries to a table or log file. Defaults logging to a file 'hostname'.log or a table mysql.general_logif --log-output=TABLE is used. 1049NUMERIC_MIN_VALUE NULL 1050NUMERIC_MAX_VALUE NULL 1051NUMERIC_BLOCK_SIZE NULL 1052ENUM_VALUE_LIST OFF,ON 1053READ_ONLY NO 1054COMMAND_LINE_ARGUMENT OPTIONAL 1055VARIABLE_NAME GENERAL_LOG_FILE 1056VARIABLE_SCOPE GLOBAL 1057VARIABLE_TYPE VARCHAR 1058VARIABLE_COMMENT Log connections and queries to given file 1059NUMERIC_MIN_VALUE NULL 1060NUMERIC_MAX_VALUE NULL 1061NUMERIC_BLOCK_SIZE NULL 1062ENUM_VALUE_LIST NULL 1063READ_ONLY NO 1064COMMAND_LINE_ARGUMENT REQUIRED 1065VARIABLE_NAME GROUP_CONCAT_MAX_LEN 1066VARIABLE_SCOPE SESSION 1067VARIABLE_TYPE INT UNSIGNED 1068VARIABLE_COMMENT The maximum length of the result of function GROUP_CONCAT() 1069NUMERIC_MIN_VALUE 4 1070NUMERIC_MAX_VALUE 4294967295 1071NUMERIC_BLOCK_SIZE 1 1072ENUM_VALUE_LIST NULL 1073READ_ONLY NO 1074COMMAND_LINE_ARGUMENT REQUIRED 1075VARIABLE_NAME GTID_BINLOG_POS 1076VARIABLE_SCOPE GLOBAL 1077VARIABLE_TYPE VARCHAR 1078VARIABLE_COMMENT Last GTID logged to the binary log, per replicationdomain 1079NUMERIC_MIN_VALUE NULL 1080NUMERIC_MAX_VALUE NULL 1081NUMERIC_BLOCK_SIZE NULL 1082ENUM_VALUE_LIST NULL 1083READ_ONLY YES 1084COMMAND_LINE_ARGUMENT NULL 1085VARIABLE_NAME GTID_BINLOG_STATE 1086VARIABLE_SCOPE GLOBAL 1087VARIABLE_TYPE VARCHAR 1088VARIABLE_COMMENT The internal GTID state of the binlog, used to keep track of all GTIDs ever logged to the binlog. 1089NUMERIC_MIN_VALUE NULL 1090NUMERIC_MAX_VALUE NULL 1091NUMERIC_BLOCK_SIZE NULL 1092ENUM_VALUE_LIST NULL 1093READ_ONLY NO 1094COMMAND_LINE_ARGUMENT NULL 1095VARIABLE_NAME GTID_CLEANUP_BATCH_SIZE 1096VARIABLE_SCOPE GLOBAL 1097VARIABLE_TYPE INT UNSIGNED 1098VARIABLE_COMMENT Normally does not need tuning. How many old rows must accumulate in the mysql.gtid_slave_pos table before a background job will be run to delete them. Can be increased to reduce number of commits if using many different engines with --gtid_pos_auto_engines, or to reduce CPU overhead if using a huge number of different gtid_domain_ids. Can be decreased to reduce number of old rows in the table. 1099NUMERIC_MIN_VALUE 0 1100NUMERIC_MAX_VALUE 2147483647 1101NUMERIC_BLOCK_SIZE 1 1102ENUM_VALUE_LIST NULL 1103READ_ONLY NO 1104COMMAND_LINE_ARGUMENT REQUIRED 1105VARIABLE_NAME GTID_CURRENT_POS 1106VARIABLE_SCOPE GLOBAL 1107VARIABLE_TYPE VARCHAR 1108VARIABLE_COMMENT Current GTID position of the server. Per replication domain, this is either the last GTID replicated by a slave thread, or the GTID logged to the binary log, whichever is most recent. 1109NUMERIC_MIN_VALUE NULL 1110NUMERIC_MAX_VALUE NULL 1111NUMERIC_BLOCK_SIZE NULL 1112ENUM_VALUE_LIST NULL 1113READ_ONLY YES 1114COMMAND_LINE_ARGUMENT NULL 1115VARIABLE_NAME GTID_DOMAIN_ID 1116VARIABLE_SCOPE SESSION 1117VARIABLE_TYPE INT UNSIGNED 1118VARIABLE_COMMENT Used with global transaction ID to identify logically independent replication streams. When events can propagate through multiple parallel paths (for example multiple masters), each independent source server must use a distinct domain_id. For simple tree-shaped replication topologies, it can be left at its default, 0. 1119NUMERIC_MIN_VALUE 0 1120NUMERIC_MAX_VALUE 4294967295 1121NUMERIC_BLOCK_SIZE 1 1122ENUM_VALUE_LIST NULL 1123READ_ONLY NO 1124COMMAND_LINE_ARGUMENT REQUIRED 1125VARIABLE_NAME GTID_IGNORE_DUPLICATES 1126VARIABLE_SCOPE GLOBAL 1127VARIABLE_TYPE BOOLEAN 1128VARIABLE_COMMENT When set, different master connections in multi-source replication are allowed to receive and process event groups with the same GTID (when using GTID mode). Only one will be applied, any others will be ignored. Within a given replication domain, just the sequence number will be used to decide whether a given GTID has been already applied; this means it is the responsibility of the user to ensure that GTID sequence numbers are strictly increasing. 1129NUMERIC_MIN_VALUE NULL 1130NUMERIC_MAX_VALUE NULL 1131NUMERIC_BLOCK_SIZE NULL 1132ENUM_VALUE_LIST OFF,ON 1133READ_ONLY NO 1134COMMAND_LINE_ARGUMENT OPTIONAL 1135VARIABLE_NAME GTID_POS_AUTO_ENGINES 1136VARIABLE_SCOPE GLOBAL 1137VARIABLE_TYPE VARCHAR 1138VARIABLE_COMMENT List of engines for which to automatically create a mysql.gtid_slave_pos_ENGINE table, if a transaction using that engine is replicated. This can be used to avoid introducing cross-engine transactions, if engines are used different from that used by table mysql.gtid_slave_pos 1139NUMERIC_MIN_VALUE NULL 1140NUMERIC_MAX_VALUE NULL 1141NUMERIC_BLOCK_SIZE NULL 1142ENUM_VALUE_LIST NULL 1143READ_ONLY NO 1144COMMAND_LINE_ARGUMENT NULL 1145VARIABLE_NAME GTID_SEQ_NO 1146VARIABLE_SCOPE SESSION ONLY 1147VARIABLE_TYPE BIGINT UNSIGNED 1148VARIABLE_COMMENT Internal server usage, for replication with global transaction id. When set, next event group logged to the binary log will use this sequence number, not generate a new one, thus allowing to preserve master's GTID in slave's binlog. 1149NUMERIC_MIN_VALUE 0 1150NUMERIC_MAX_VALUE 18446744073709551615 1151NUMERIC_BLOCK_SIZE 1 1152ENUM_VALUE_LIST NULL 1153READ_ONLY NO 1154COMMAND_LINE_ARGUMENT NULL 1155VARIABLE_NAME GTID_SLAVE_POS 1156VARIABLE_SCOPE GLOBAL 1157VARIABLE_TYPE VARCHAR 1158VARIABLE_COMMENT The list of global transaction IDs that were last replicated on the server, one for each replication domain. 1159NUMERIC_MIN_VALUE NULL 1160NUMERIC_MAX_VALUE NULL 1161NUMERIC_BLOCK_SIZE NULL 1162ENUM_VALUE_LIST NULL 1163READ_ONLY NO 1164COMMAND_LINE_ARGUMENT NULL 1165VARIABLE_NAME GTID_STRICT_MODE 1166VARIABLE_SCOPE GLOBAL 1167VARIABLE_TYPE BOOLEAN 1168VARIABLE_COMMENT Enforce strict seq_no ordering of events in the binary log. Slave stops with an error if it encounters an event that would cause it to generate an out-of-order binlog if executed. 1169NUMERIC_MIN_VALUE NULL 1170NUMERIC_MAX_VALUE NULL 1171NUMERIC_BLOCK_SIZE NULL 1172ENUM_VALUE_LIST OFF,ON 1173READ_ONLY NO 1174COMMAND_LINE_ARGUMENT OPTIONAL 1175VARIABLE_NAME HAVE_COMPRESS 1176VARIABLE_SCOPE GLOBAL 1177VARIABLE_TYPE VARCHAR 1178VARIABLE_COMMENT If the zlib compression library is accessible to the server, this will be set to YES, otherwise it will be NO. The COMPRESS() and UNCOMPRESS() functions will only be available if set to YES. 1179NUMERIC_MIN_VALUE NULL 1180NUMERIC_MAX_VALUE NULL 1181NUMERIC_BLOCK_SIZE NULL 1182ENUM_VALUE_LIST NULL 1183READ_ONLY YES 1184COMMAND_LINE_ARGUMENT NULL 1185VARIABLE_NAME HAVE_CRYPT 1186VARIABLE_SCOPE GLOBAL 1187VARIABLE_TYPE VARCHAR 1188VARIABLE_COMMENT If the crypt() system call is available this variable will be set to YES, otherwise it will be set to NO. If set to NO, the ENCRYPT() function cannot be used. 1189NUMERIC_MIN_VALUE NULL 1190NUMERIC_MAX_VALUE NULL 1191NUMERIC_BLOCK_SIZE NULL 1192ENUM_VALUE_LIST NULL 1193READ_ONLY YES 1194COMMAND_LINE_ARGUMENT NULL 1195VARIABLE_NAME HAVE_DYNAMIC_LOADING 1196VARIABLE_SCOPE GLOBAL 1197VARIABLE_TYPE VARCHAR 1198VARIABLE_COMMENT If the server supports dynamic loading of plugins, will be set to YES, otherwise will be set to NO. 1199NUMERIC_MIN_VALUE NULL 1200NUMERIC_MAX_VALUE NULL 1201NUMERIC_BLOCK_SIZE NULL 1202ENUM_VALUE_LIST NULL 1203READ_ONLY YES 1204COMMAND_LINE_ARGUMENT NULL 1205VARIABLE_NAME HAVE_GEOMETRY 1206VARIABLE_SCOPE GLOBAL 1207VARIABLE_TYPE VARCHAR 1208VARIABLE_COMMENT If the server supports spatial data types, will be set to YES, otherwise will be set to NO. 1209NUMERIC_MIN_VALUE NULL 1210NUMERIC_MAX_VALUE NULL 1211NUMERIC_BLOCK_SIZE NULL 1212ENUM_VALUE_LIST NULL 1213READ_ONLY YES 1214COMMAND_LINE_ARGUMENT NULL 1215VARIABLE_NAME HAVE_OPENSSL 1216VARIABLE_SCOPE GLOBAL 1217VARIABLE_TYPE VARCHAR 1218VARIABLE_COMMENT Comparing have_openssl with have_ssl will indicate whether YaSSL or openssl was used. If YaSSL, have_ssl will be YES, but have_openssl will be NO. 1219NUMERIC_MIN_VALUE NULL 1220NUMERIC_MAX_VALUE NULL 1221NUMERIC_BLOCK_SIZE NULL 1222ENUM_VALUE_LIST NULL 1223READ_ONLY YES 1224COMMAND_LINE_ARGUMENT NULL 1225VARIABLE_NAME HAVE_PROFILING 1226VARIABLE_SCOPE GLOBAL 1227VARIABLE_TYPE VARCHAR 1228VARIABLE_COMMENT If statement profiling is available, will be set to YES, otherwise will be set to NO. See SHOW PROFILES and SHOW PROFILE. 1229NUMERIC_MIN_VALUE NULL 1230NUMERIC_MAX_VALUE NULL 1231NUMERIC_BLOCK_SIZE NULL 1232ENUM_VALUE_LIST NULL 1233READ_ONLY YES 1234COMMAND_LINE_ARGUMENT NULL 1235VARIABLE_NAME HAVE_QUERY_CACHE 1236VARIABLE_SCOPE GLOBAL 1237VARIABLE_TYPE VARCHAR 1238VARIABLE_COMMENT If the server supports the query cache, will be set to YES, otherwise will be set to NO. 1239NUMERIC_MIN_VALUE NULL 1240NUMERIC_MAX_VALUE NULL 1241NUMERIC_BLOCK_SIZE NULL 1242ENUM_VALUE_LIST NULL 1243READ_ONLY YES 1244COMMAND_LINE_ARGUMENT NULL 1245VARIABLE_NAME HAVE_RTREE_KEYS 1246VARIABLE_SCOPE GLOBAL 1247VARIABLE_TYPE VARCHAR 1248VARIABLE_COMMENT If RTREE indexes (used for spatial indexes) are available, will be set to YES, otherwise will be set to NO. 1249NUMERIC_MIN_VALUE NULL 1250NUMERIC_MAX_VALUE NULL 1251NUMERIC_BLOCK_SIZE NULL 1252ENUM_VALUE_LIST NULL 1253READ_ONLY YES 1254COMMAND_LINE_ARGUMENT NULL 1255VARIABLE_NAME HAVE_SSL 1256VARIABLE_SCOPE GLOBAL 1257VARIABLE_TYPE VARCHAR 1258VARIABLE_COMMENT If the server supports secure connections, will be set to YES, otherwise will be set to NO. If set to DISABLED, the server was compiled with TLS support, but was not started with TLS support (see the mysqld options). See also have_openssl. 1259NUMERIC_MIN_VALUE NULL 1260NUMERIC_MAX_VALUE NULL 1261NUMERIC_BLOCK_SIZE NULL 1262ENUM_VALUE_LIST NULL 1263READ_ONLY YES 1264COMMAND_LINE_ARGUMENT NULL 1265VARIABLE_NAME HAVE_SYMLINK 1266VARIABLE_SCOPE GLOBAL 1267VARIABLE_TYPE VARCHAR 1268VARIABLE_COMMENT If symbolic link support is enabled, will be set to YES, otherwise will be set to NO. Required for the INDEX DIRECTORY and DATA DIRECTORY table options (see CREATE TABLE) and Windows symlink support. Will be set to DISABLED if the server is started with the --skip-symbolic-links option. 1269NUMERIC_MIN_VALUE NULL 1270NUMERIC_MAX_VALUE NULL 1271NUMERIC_BLOCK_SIZE NULL 1272ENUM_VALUE_LIST NULL 1273READ_ONLY YES 1274COMMAND_LINE_ARGUMENT NULL 1275VARIABLE_NAME HISTOGRAM_SIZE 1276VARIABLE_SCOPE SESSION 1277VARIABLE_TYPE BIGINT UNSIGNED 1278VARIABLE_COMMENT Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE. 1279NUMERIC_MIN_VALUE 0 1280NUMERIC_MAX_VALUE 255 1281NUMERIC_BLOCK_SIZE 1 1282ENUM_VALUE_LIST NULL 1283READ_ONLY NO 1284COMMAND_LINE_ARGUMENT REQUIRED 1285VARIABLE_NAME HISTOGRAM_TYPE 1286VARIABLE_SCOPE SESSION 1287VARIABLE_TYPE ENUM 1288VARIABLE_COMMENT Specifies type of the histograms created by ANALYZE. Possible values are: SINGLE_PREC_HB - single precision height-balanced, DOUBLE_PREC_HB - double precision height-balanced. 1289NUMERIC_MIN_VALUE NULL 1290NUMERIC_MAX_VALUE NULL 1291NUMERIC_BLOCK_SIZE NULL 1292ENUM_VALUE_LIST SINGLE_PREC_HB,DOUBLE_PREC_HB 1293READ_ONLY NO 1294COMMAND_LINE_ARGUMENT REQUIRED 1295VARIABLE_NAME HOSTNAME 1296VARIABLE_SCOPE GLOBAL 1297VARIABLE_TYPE VARCHAR 1298VARIABLE_COMMENT Server host name 1299NUMERIC_MIN_VALUE NULL 1300NUMERIC_MAX_VALUE NULL 1301NUMERIC_BLOCK_SIZE NULL 1302ENUM_VALUE_LIST NULL 1303READ_ONLY YES 1304COMMAND_LINE_ARGUMENT NULL 1305VARIABLE_NAME HOST_CACHE_SIZE 1306VARIABLE_SCOPE GLOBAL 1307VARIABLE_TYPE BIGINT UNSIGNED 1308VARIABLE_COMMENT How many host names should be cached to avoid resolving. 1309NUMERIC_MIN_VALUE 0 1310NUMERIC_MAX_VALUE 65536 1311NUMERIC_BLOCK_SIZE 1 1312ENUM_VALUE_LIST NULL 1313READ_ONLY NO 1314COMMAND_LINE_ARGUMENT REQUIRED 1315VARIABLE_NAME IDENTITY 1316VARIABLE_SCOPE SESSION ONLY 1317VARIABLE_TYPE BIGINT UNSIGNED 1318VARIABLE_COMMENT Synonym for the last_insert_id variable 1319NUMERIC_MIN_VALUE 0 1320NUMERIC_MAX_VALUE 18446744073709551615 1321NUMERIC_BLOCK_SIZE 1 1322ENUM_VALUE_LIST NULL 1323READ_ONLY NO 1324COMMAND_LINE_ARGUMENT NULL 1325VARIABLE_NAME IDLE_READONLY_TRANSACTION_TIMEOUT 1326VARIABLE_SCOPE SESSION 1327VARIABLE_TYPE INT UNSIGNED 1328VARIABLE_COMMENT The number of seconds the server waits for read-only idle transaction 1329NUMERIC_MIN_VALUE 0 1330NUMERIC_MAX_VALUE 31536000 1331NUMERIC_BLOCK_SIZE 1 1332ENUM_VALUE_LIST NULL 1333READ_ONLY NO 1334COMMAND_LINE_ARGUMENT REQUIRED 1335VARIABLE_NAME IDLE_TRANSACTION_TIMEOUT 1336VARIABLE_SCOPE SESSION 1337VARIABLE_TYPE INT UNSIGNED 1338VARIABLE_COMMENT The number of seconds the server waits for idle transaction 1339NUMERIC_MIN_VALUE 0 1340NUMERIC_MAX_VALUE 31536000 1341NUMERIC_BLOCK_SIZE 1 1342ENUM_VALUE_LIST NULL 1343READ_ONLY NO 1344COMMAND_LINE_ARGUMENT REQUIRED 1345VARIABLE_NAME IDLE_WRITE_TRANSACTION_TIMEOUT 1346VARIABLE_SCOPE SESSION 1347VARIABLE_TYPE INT UNSIGNED 1348VARIABLE_COMMENT The number of seconds the server waits for write idle transaction 1349NUMERIC_MIN_VALUE 0 1350NUMERIC_MAX_VALUE 31536000 1351NUMERIC_BLOCK_SIZE 1 1352ENUM_VALUE_LIST NULL 1353READ_ONLY NO 1354COMMAND_LINE_ARGUMENT REQUIRED 1355VARIABLE_NAME IGNORE_BUILTIN_INNODB 1356VARIABLE_SCOPE GLOBAL 1357VARIABLE_TYPE BOOLEAN 1358VARIABLE_COMMENT Disable initialization of builtin InnoDB plugin 1359NUMERIC_MIN_VALUE NULL 1360NUMERIC_MAX_VALUE NULL 1361NUMERIC_BLOCK_SIZE NULL 1362ENUM_VALUE_LIST OFF,ON 1363READ_ONLY YES 1364COMMAND_LINE_ARGUMENT OPTIONAL 1365VARIABLE_NAME IGNORE_DB_DIRS 1366VARIABLE_SCOPE GLOBAL 1367VARIABLE_TYPE VARCHAR 1368VARIABLE_COMMENT Specifies a directory to add to the ignore list when collecting database names from the datadir. Put a blank argument to reset the list accumulated so far. 1369NUMERIC_MIN_VALUE NULL 1370NUMERIC_MAX_VALUE NULL 1371NUMERIC_BLOCK_SIZE NULL 1372ENUM_VALUE_LIST NULL 1373READ_ONLY YES 1374COMMAND_LINE_ARGUMENT REQUIRED 1375VARIABLE_NAME INIT_CONNECT 1376VARIABLE_SCOPE GLOBAL 1377VARIABLE_TYPE VARCHAR 1378VARIABLE_COMMENT Command(s) that are executed for each new connection (unless the user has SUPER privilege) 1379NUMERIC_MIN_VALUE NULL 1380NUMERIC_MAX_VALUE NULL 1381NUMERIC_BLOCK_SIZE NULL 1382ENUM_VALUE_LIST NULL 1383READ_ONLY NO 1384COMMAND_LINE_ARGUMENT REQUIRED 1385VARIABLE_NAME INIT_FILE 1386VARIABLE_SCOPE GLOBAL 1387VARIABLE_TYPE VARCHAR 1388VARIABLE_COMMENT Read SQL commands from this file at startup 1389NUMERIC_MIN_VALUE NULL 1390NUMERIC_MAX_VALUE NULL 1391NUMERIC_BLOCK_SIZE NULL 1392ENUM_VALUE_LIST NULL 1393READ_ONLY YES 1394COMMAND_LINE_ARGUMENT REQUIRED 1395VARIABLE_NAME INIT_SLAVE 1396VARIABLE_SCOPE GLOBAL 1397VARIABLE_TYPE VARCHAR 1398VARIABLE_COMMENT Command(s) that are executed by a slave server each time the SQL thread starts 1399NUMERIC_MIN_VALUE NULL 1400NUMERIC_MAX_VALUE NULL 1401NUMERIC_BLOCK_SIZE NULL 1402ENUM_VALUE_LIST NULL 1403READ_ONLY NO 1404COMMAND_LINE_ARGUMENT REQUIRED 1405VARIABLE_NAME INSERT_ID 1406VARIABLE_SCOPE SESSION ONLY 1407VARIABLE_TYPE BIGINT UNSIGNED 1408VARIABLE_COMMENT The value to be used by the following INSERT or ALTER TABLE statement when inserting an AUTO_INCREMENT value 1409NUMERIC_MIN_VALUE 0 1410NUMERIC_MAX_VALUE 18446744073709551615 1411NUMERIC_BLOCK_SIZE 1 1412ENUM_VALUE_LIST NULL 1413READ_ONLY NO 1414COMMAND_LINE_ARGUMENT NULL 1415VARIABLE_NAME INTERACTIVE_TIMEOUT 1416VARIABLE_SCOPE SESSION 1417VARIABLE_TYPE BIGINT UNSIGNED 1418VARIABLE_COMMENT The number of seconds the server waits for activity on an interactive connection before closing it 1419NUMERIC_MIN_VALUE 1 1420NUMERIC_MAX_VALUE 31536000 1421NUMERIC_BLOCK_SIZE 1 1422ENUM_VALUE_LIST NULL 1423READ_ONLY NO 1424COMMAND_LINE_ARGUMENT REQUIRED 1425VARIABLE_NAME IN_PREDICATE_CONVERSION_THRESHOLD 1426VARIABLE_SCOPE SESSION 1427VARIABLE_TYPE INT UNSIGNED 1428VARIABLE_COMMENT The minimum number of scalar elements in the value list of IN predicate that triggers its conversion to IN subquery. Set to 0 to disable the conversion. 1429NUMERIC_MIN_VALUE 0 1430NUMERIC_MAX_VALUE 4294967295 1431NUMERIC_BLOCK_SIZE 1 1432ENUM_VALUE_LIST NULL 1433READ_ONLY NO 1434COMMAND_LINE_ARGUMENT REQUIRED 1435VARIABLE_NAME IN_TRANSACTION 1436VARIABLE_SCOPE SESSION ONLY 1437VARIABLE_TYPE BIGINT UNSIGNED 1438VARIABLE_COMMENT Whether there is an active transaction 1439NUMERIC_MIN_VALUE 0 1440NUMERIC_MAX_VALUE 1 1441NUMERIC_BLOCK_SIZE 1 1442ENUM_VALUE_LIST NULL 1443READ_ONLY YES 1444COMMAND_LINE_ARGUMENT NULL 1445VARIABLE_NAME JOIN_BUFFER_SIZE 1446VARIABLE_SCOPE SESSION 1447VARIABLE_TYPE BIGINT UNSIGNED 1448VARIABLE_COMMENT The size of the buffer that is used for joins 1449NUMERIC_MIN_VALUE 128 1450NUMERIC_MAX_VALUE 18446744073709551615 1451NUMERIC_BLOCK_SIZE 128 1452ENUM_VALUE_LIST NULL 1453READ_ONLY NO 1454COMMAND_LINE_ARGUMENT REQUIRED 1455VARIABLE_NAME JOIN_BUFFER_SPACE_LIMIT 1456VARIABLE_SCOPE SESSION 1457VARIABLE_TYPE BIGINT UNSIGNED 1458VARIABLE_COMMENT The limit of the space for all join buffers used by a query 1459NUMERIC_MIN_VALUE 2048 1460NUMERIC_MAX_VALUE 18446744073709551615 1461NUMERIC_BLOCK_SIZE 2048 1462ENUM_VALUE_LIST NULL 1463READ_ONLY NO 1464COMMAND_LINE_ARGUMENT REQUIRED 1465VARIABLE_NAME JOIN_CACHE_LEVEL 1466VARIABLE_SCOPE SESSION 1467VARIABLE_TYPE BIGINT UNSIGNED 1468VARIABLE_COMMENT Controls what join operations can be executed with join buffers. Odd numbers are used for plain join buffers while even numbers are used for linked buffers 1469NUMERIC_MIN_VALUE 0 1470NUMERIC_MAX_VALUE 8 1471NUMERIC_BLOCK_SIZE 1 1472ENUM_VALUE_LIST NULL 1473READ_ONLY NO 1474COMMAND_LINE_ARGUMENT REQUIRED 1475VARIABLE_NAME KEEP_FILES_ON_CREATE 1476VARIABLE_SCOPE SESSION 1477VARIABLE_TYPE BOOLEAN 1478VARIABLE_COMMENT Don't overwrite stale .MYD and .MYI even if no directory is specified 1479NUMERIC_MIN_VALUE NULL 1480NUMERIC_MAX_VALUE NULL 1481NUMERIC_BLOCK_SIZE NULL 1482ENUM_VALUE_LIST OFF,ON 1483READ_ONLY NO 1484COMMAND_LINE_ARGUMENT OPTIONAL 1485VARIABLE_NAME KEY_BUFFER_SIZE 1486VARIABLE_SCOPE GLOBAL 1487VARIABLE_TYPE BIGINT UNSIGNED 1488VARIABLE_COMMENT The size of the buffer used for index blocks for MyISAM tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford 1489NUMERIC_MIN_VALUE 0 1490NUMERIC_MAX_VALUE 18446744073709551615 1491NUMERIC_BLOCK_SIZE 4096 1492ENUM_VALUE_LIST NULL 1493READ_ONLY NO 1494COMMAND_LINE_ARGUMENT REQUIRED 1495VARIABLE_NAME KEY_CACHE_AGE_THRESHOLD 1496VARIABLE_SCOPE GLOBAL 1497VARIABLE_TYPE BIGINT UNSIGNED 1498VARIABLE_COMMENT This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in key cache 1499NUMERIC_MIN_VALUE 100 1500NUMERIC_MAX_VALUE 4294967295 1501NUMERIC_BLOCK_SIZE 100 1502ENUM_VALUE_LIST NULL 1503READ_ONLY NO 1504COMMAND_LINE_ARGUMENT REQUIRED 1505VARIABLE_NAME KEY_CACHE_BLOCK_SIZE 1506VARIABLE_SCOPE GLOBAL 1507VARIABLE_TYPE BIGINT UNSIGNED 1508VARIABLE_COMMENT The default size of key cache blocks 1509NUMERIC_MIN_VALUE 512 1510NUMERIC_MAX_VALUE 16384 1511NUMERIC_BLOCK_SIZE 512 1512ENUM_VALUE_LIST NULL 1513READ_ONLY NO 1514COMMAND_LINE_ARGUMENT REQUIRED 1515VARIABLE_NAME KEY_CACHE_DIVISION_LIMIT 1516VARIABLE_SCOPE GLOBAL 1517VARIABLE_TYPE BIGINT UNSIGNED 1518VARIABLE_COMMENT The minimum percentage of warm blocks in key cache 1519NUMERIC_MIN_VALUE 1 1520NUMERIC_MAX_VALUE 100 1521NUMERIC_BLOCK_SIZE 1 1522ENUM_VALUE_LIST NULL 1523READ_ONLY NO 1524COMMAND_LINE_ARGUMENT REQUIRED 1525VARIABLE_NAME KEY_CACHE_FILE_HASH_SIZE 1526VARIABLE_SCOPE GLOBAL 1527VARIABLE_TYPE BIGINT UNSIGNED 1528VARIABLE_COMMENT Number of hash buckets for open and changed files. If you have a lot of MyISAM files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open MyISAM files. 1529NUMERIC_MIN_VALUE 128 1530NUMERIC_MAX_VALUE 16384 1531NUMERIC_BLOCK_SIZE 1 1532ENUM_VALUE_LIST NULL 1533READ_ONLY NO 1534COMMAND_LINE_ARGUMENT REQUIRED 1535VARIABLE_NAME KEY_CACHE_SEGMENTS 1536VARIABLE_SCOPE GLOBAL 1537VARIABLE_TYPE BIGINT UNSIGNED 1538VARIABLE_COMMENT The number of segments in a key cache 1539NUMERIC_MIN_VALUE 0 1540NUMERIC_MAX_VALUE 64 1541NUMERIC_BLOCK_SIZE 1 1542ENUM_VALUE_LIST NULL 1543READ_ONLY NO 1544COMMAND_LINE_ARGUMENT REQUIRED 1545VARIABLE_NAME LARGE_FILES_SUPPORT 1546VARIABLE_SCOPE GLOBAL 1547VARIABLE_TYPE BOOLEAN 1548VARIABLE_COMMENT Whether mysqld was compiled with options for large file support 1549NUMERIC_MIN_VALUE NULL 1550NUMERIC_MAX_VALUE NULL 1551NUMERIC_BLOCK_SIZE NULL 1552ENUM_VALUE_LIST OFF,ON 1553READ_ONLY YES 1554COMMAND_LINE_ARGUMENT NULL 1555VARIABLE_NAME LARGE_PAGES 1556VARIABLE_SCOPE GLOBAL 1557VARIABLE_TYPE BOOLEAN 1558VARIABLE_COMMENT Enable support for large pages 1559NUMERIC_MIN_VALUE NULL 1560NUMERIC_MAX_VALUE NULL 1561NUMERIC_BLOCK_SIZE NULL 1562ENUM_VALUE_LIST OFF,ON 1563READ_ONLY YES 1564COMMAND_LINE_ARGUMENT OPTIONAL 1565VARIABLE_NAME LARGE_PAGE_SIZE 1566VARIABLE_SCOPE GLOBAL 1567VARIABLE_TYPE INT UNSIGNED 1568VARIABLE_COMMENT If large page support is enabled, this shows the size of memory pages 1569NUMERIC_MIN_VALUE 0 1570NUMERIC_MAX_VALUE 4294967295 1571NUMERIC_BLOCK_SIZE 1 1572ENUM_VALUE_LIST NULL 1573READ_ONLY YES 1574COMMAND_LINE_ARGUMENT NULL 1575VARIABLE_NAME LAST_GTID 1576VARIABLE_SCOPE SESSION ONLY 1577VARIABLE_TYPE VARCHAR 1578VARIABLE_COMMENT The GTID of the last commit (if binlogging was enabled), or the empty string if none. 1579NUMERIC_MIN_VALUE NULL 1580NUMERIC_MAX_VALUE NULL 1581NUMERIC_BLOCK_SIZE NULL 1582ENUM_VALUE_LIST NULL 1583READ_ONLY YES 1584COMMAND_LINE_ARGUMENT NULL 1585VARIABLE_NAME LAST_INSERT_ID 1586VARIABLE_SCOPE SESSION ONLY 1587VARIABLE_TYPE BIGINT UNSIGNED 1588VARIABLE_COMMENT The value to be returned from LAST_INSERT_ID() 1589NUMERIC_MIN_VALUE 0 1590NUMERIC_MAX_VALUE 18446744073709551615 1591NUMERIC_BLOCK_SIZE 1 1592ENUM_VALUE_LIST NULL 1593READ_ONLY NO 1594COMMAND_LINE_ARGUMENT NULL 1595VARIABLE_NAME LC_MESSAGES 1596VARIABLE_SCOPE SESSION 1597VARIABLE_TYPE ENUM 1598VARIABLE_COMMENT Set the language used for the error messages 1599NUMERIC_MIN_VALUE NULL 1600NUMERIC_MAX_VALUE NULL 1601NUMERIC_BLOCK_SIZE NULL 1602ENUM_VALUE_LIST NULL 1603READ_ONLY NO 1604COMMAND_LINE_ARGUMENT NULL 1605VARIABLE_NAME LC_MESSAGES_DIR 1606VARIABLE_SCOPE GLOBAL 1607VARIABLE_TYPE VARCHAR 1608VARIABLE_COMMENT Directory where error messages are 1609NUMERIC_MIN_VALUE NULL 1610NUMERIC_MAX_VALUE NULL 1611NUMERIC_BLOCK_SIZE NULL 1612ENUM_VALUE_LIST NULL 1613READ_ONLY YES 1614COMMAND_LINE_ARGUMENT REQUIRED 1615VARIABLE_NAME LC_TIME_NAMES 1616VARIABLE_SCOPE SESSION 1617VARIABLE_TYPE ENUM 1618VARIABLE_COMMENT Set the language used for the month names and the days of the week 1619NUMERIC_MIN_VALUE NULL 1620NUMERIC_MAX_VALUE NULL 1621NUMERIC_BLOCK_SIZE NULL 1622ENUM_VALUE_LIST NULL 1623READ_ONLY NO 1624COMMAND_LINE_ARGUMENT NULL 1625VARIABLE_NAME LICENSE 1626VARIABLE_SCOPE GLOBAL 1627VARIABLE_TYPE VARCHAR 1628VARIABLE_COMMENT The type of license the server has 1629NUMERIC_MIN_VALUE NULL 1630NUMERIC_MAX_VALUE NULL 1631NUMERIC_BLOCK_SIZE NULL 1632ENUM_VALUE_LIST NULL 1633READ_ONLY YES 1634COMMAND_LINE_ARGUMENT NULL 1635VARIABLE_NAME LOCAL_INFILE 1636VARIABLE_SCOPE GLOBAL 1637VARIABLE_TYPE BOOLEAN 1638VARIABLE_COMMENT Enable LOAD DATA LOCAL INFILE 1639NUMERIC_MIN_VALUE NULL 1640NUMERIC_MAX_VALUE NULL 1641NUMERIC_BLOCK_SIZE NULL 1642ENUM_VALUE_LIST OFF,ON 1643READ_ONLY NO 1644COMMAND_LINE_ARGUMENT OPTIONAL 1645VARIABLE_NAME LOCKED_IN_MEMORY 1646VARIABLE_SCOPE GLOBAL 1647VARIABLE_TYPE BOOLEAN 1648VARIABLE_COMMENT Whether mysqld was locked in memory with --memlock 1649NUMERIC_MIN_VALUE NULL 1650NUMERIC_MAX_VALUE NULL 1651NUMERIC_BLOCK_SIZE NULL 1652ENUM_VALUE_LIST OFF,ON 1653READ_ONLY YES 1654COMMAND_LINE_ARGUMENT NULL 1655VARIABLE_NAME LOCK_WAIT_TIMEOUT 1656VARIABLE_SCOPE SESSION 1657VARIABLE_TYPE BIGINT UNSIGNED 1658VARIABLE_COMMENT Timeout in seconds to wait for a lock before returning an error. 1659NUMERIC_MIN_VALUE 0 1660NUMERIC_MAX_VALUE 31536000 1661NUMERIC_BLOCK_SIZE 1 1662ENUM_VALUE_LIST NULL 1663READ_ONLY NO 1664COMMAND_LINE_ARGUMENT REQUIRED 1665VARIABLE_NAME LOG_BIN 1666VARIABLE_SCOPE GLOBAL 1667VARIABLE_TYPE BOOLEAN 1668VARIABLE_COMMENT Whether the binary log is enabled 1669NUMERIC_MIN_VALUE NULL 1670NUMERIC_MAX_VALUE NULL 1671NUMERIC_BLOCK_SIZE NULL 1672ENUM_VALUE_LIST OFF,ON 1673READ_ONLY YES 1674COMMAND_LINE_ARGUMENT NULL 1675VARIABLE_NAME LOG_BIN_BASENAME 1676VARIABLE_SCOPE GLOBAL 1677VARIABLE_TYPE VARCHAR 1678VARIABLE_COMMENT The full path of the binary log file names, excluding the extension. 1679NUMERIC_MIN_VALUE NULL 1680NUMERIC_MAX_VALUE NULL 1681NUMERIC_BLOCK_SIZE NULL 1682ENUM_VALUE_LIST NULL 1683READ_ONLY YES 1684COMMAND_LINE_ARGUMENT NULL 1685VARIABLE_NAME LOG_BIN_COMPRESS 1686VARIABLE_SCOPE GLOBAL 1687VARIABLE_TYPE BOOLEAN 1688VARIABLE_COMMENT Whether the binary log can be compressed 1689NUMERIC_MIN_VALUE NULL 1690NUMERIC_MAX_VALUE NULL 1691NUMERIC_BLOCK_SIZE NULL 1692ENUM_VALUE_LIST OFF,ON 1693READ_ONLY NO 1694COMMAND_LINE_ARGUMENT OPTIONAL 1695VARIABLE_NAME LOG_BIN_COMPRESS_MIN_LEN 1696VARIABLE_SCOPE GLOBAL 1697VARIABLE_TYPE INT UNSIGNED 1698VARIABLE_COMMENT Minimum length of sql statement(in statement mode) or record(in row mode)that can be compressed. 1699NUMERIC_MIN_VALUE 10 1700NUMERIC_MAX_VALUE 1024 1701NUMERIC_BLOCK_SIZE 1 1702ENUM_VALUE_LIST NULL 1703READ_ONLY NO 1704COMMAND_LINE_ARGUMENT OPTIONAL 1705VARIABLE_NAME LOG_BIN_INDEX 1706VARIABLE_SCOPE GLOBAL 1707VARIABLE_TYPE VARCHAR 1708VARIABLE_COMMENT File that holds the names for last binary log files. 1709NUMERIC_MIN_VALUE NULL 1710NUMERIC_MAX_VALUE NULL 1711NUMERIC_BLOCK_SIZE NULL 1712ENUM_VALUE_LIST NULL 1713READ_ONLY YES 1714COMMAND_LINE_ARGUMENT NULL 1715VARIABLE_NAME LOG_BIN_TRUST_FUNCTION_CREATORS 1716VARIABLE_SCOPE GLOBAL 1717VARIABLE_TYPE BOOLEAN 1718VARIABLE_COMMENT If set to FALSE (the default), then when --log-bin is used, creation of a stored function (or trigger) is allowed only to users having the SUPER privilege and only if this stored function (trigger) may not break binary logging. Note that if ALL connections to this server ALWAYS use row-based binary logging, the security issues do not exist and the binary logging cannot break, so you can safely set this to TRUE 1719NUMERIC_MIN_VALUE NULL 1720NUMERIC_MAX_VALUE NULL 1721NUMERIC_BLOCK_SIZE NULL 1722ENUM_VALUE_LIST OFF,ON 1723READ_ONLY NO 1724COMMAND_LINE_ARGUMENT OPTIONAL 1725VARIABLE_NAME LOG_DISABLED_STATEMENTS 1726VARIABLE_SCOPE SESSION 1727VARIABLE_TYPE SET 1728VARIABLE_COMMENT Don't log certain types of statements to general log 1729NUMERIC_MIN_VALUE NULL 1730NUMERIC_MAX_VALUE NULL 1731NUMERIC_BLOCK_SIZE NULL 1732ENUM_VALUE_LIST slave,sp 1733READ_ONLY NO 1734COMMAND_LINE_ARGUMENT REQUIRED 1735VARIABLE_NAME LOG_ERROR 1736VARIABLE_SCOPE GLOBAL 1737VARIABLE_TYPE VARCHAR 1738VARIABLE_COMMENT Log errors to file (instead of stdout). If file name is not specified then 'datadir'/'log-basename'.err or the 'pid-file' path with extension .err is used 1739NUMERIC_MIN_VALUE NULL 1740NUMERIC_MAX_VALUE NULL 1741NUMERIC_BLOCK_SIZE NULL 1742ENUM_VALUE_LIST NULL 1743READ_ONLY YES 1744COMMAND_LINE_ARGUMENT OPTIONAL 1745VARIABLE_NAME LOG_OUTPUT 1746VARIABLE_SCOPE GLOBAL 1747VARIABLE_TYPE SET 1748VARIABLE_COMMENT How logs should be written 1749NUMERIC_MIN_VALUE NULL 1750NUMERIC_MAX_VALUE NULL 1751NUMERIC_BLOCK_SIZE NULL 1752ENUM_VALUE_LIST NONE,FILE,TABLE 1753READ_ONLY NO 1754COMMAND_LINE_ARGUMENT REQUIRED 1755VARIABLE_NAME LOG_QUERIES_NOT_USING_INDEXES 1756VARIABLE_SCOPE SESSION 1757VARIABLE_TYPE BOOLEAN 1758VARIABLE_COMMENT Log queries that are executed without benefit of any index to the slow log if it is open. Same as log_slow_filter='not_using_index' 1759NUMERIC_MIN_VALUE NULL 1760NUMERIC_MAX_VALUE NULL 1761NUMERIC_BLOCK_SIZE NULL 1762ENUM_VALUE_LIST OFF,ON 1763READ_ONLY NO 1764COMMAND_LINE_ARGUMENT OPTIONAL 1765VARIABLE_NAME LOG_SLAVE_UPDATES 1766VARIABLE_SCOPE GLOBAL 1767VARIABLE_TYPE BOOLEAN 1768VARIABLE_COMMENT Tells the slave to log the updates from the slave thread to the binary log. You will need to turn it on if you plan to daisy-chain the slaves. 1769NUMERIC_MIN_VALUE NULL 1770NUMERIC_MAX_VALUE NULL 1771NUMERIC_BLOCK_SIZE NULL 1772ENUM_VALUE_LIST OFF,ON 1773READ_ONLY YES 1774COMMAND_LINE_ARGUMENT OPTIONAL 1775VARIABLE_NAME LOG_SLOW_ADMIN_STATEMENTS 1776VARIABLE_SCOPE SESSION 1777VARIABLE_TYPE BOOLEAN 1778VARIABLE_COMMENT Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow log if it is open. Resets or sets the option 'admin' in log_slow_disabled_statements 1779NUMERIC_MIN_VALUE NULL 1780NUMERIC_MAX_VALUE NULL 1781NUMERIC_BLOCK_SIZE NULL 1782ENUM_VALUE_LIST OFF,ON 1783READ_ONLY NO 1784COMMAND_LINE_ARGUMENT OPTIONAL 1785VARIABLE_NAME LOG_SLOW_DISABLED_STATEMENTS 1786VARIABLE_SCOPE SESSION 1787VARIABLE_TYPE SET 1788VARIABLE_COMMENT Don't log certain types of statements to slow log 1789NUMERIC_MIN_VALUE NULL 1790NUMERIC_MAX_VALUE NULL 1791NUMERIC_BLOCK_SIZE NULL 1792ENUM_VALUE_LIST admin,call,slave,sp 1793READ_ONLY NO 1794COMMAND_LINE_ARGUMENT REQUIRED 1795VARIABLE_NAME LOG_SLOW_FILTER 1796VARIABLE_SCOPE SESSION 1797VARIABLE_TYPE SET 1798VARIABLE_COMMENT Log only certain types of queries to the slow log. If variable empty alll kind of queries are logged. All types are bound by slow_query_time, except 'not_using_index' which is always logged if enabled 1799NUMERIC_MIN_VALUE NULL 1800NUMERIC_MAX_VALUE NULL 1801NUMERIC_BLOCK_SIZE NULL 1802ENUM_VALUE_LIST admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,not_using_index,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk 1803READ_ONLY NO 1804COMMAND_LINE_ARGUMENT REQUIRED 1805VARIABLE_NAME LOG_SLOW_RATE_LIMIT 1806VARIABLE_SCOPE SESSION 1807VARIABLE_TYPE BIGINT UNSIGNED 1808VARIABLE_COMMENT Write to slow log every #th slow query. Set to 1 to log everything. Increase it to reduce the size of the slow or the performance impact of slow logging 1809NUMERIC_MIN_VALUE 1 1810NUMERIC_MAX_VALUE 4294967295 1811NUMERIC_BLOCK_SIZE 1 1812ENUM_VALUE_LIST NULL 1813READ_ONLY NO 1814COMMAND_LINE_ARGUMENT REQUIRED 1815VARIABLE_NAME LOG_SLOW_SLAVE_STATEMENTS 1816VARIABLE_SCOPE SESSION 1817VARIABLE_TYPE BOOLEAN 1818VARIABLE_COMMENT Log slow statements executed by slave thread to the slow log if it is open. Resets or sets the option 'slave' in log_slow_disabled_statements 1819NUMERIC_MIN_VALUE NULL 1820NUMERIC_MAX_VALUE NULL 1821NUMERIC_BLOCK_SIZE NULL 1822ENUM_VALUE_LIST OFF,ON 1823READ_ONLY NO 1824COMMAND_LINE_ARGUMENT OPTIONAL 1825VARIABLE_NAME LOG_SLOW_VERBOSITY 1826VARIABLE_SCOPE SESSION 1827VARIABLE_TYPE SET 1828VARIABLE_COMMENT Verbosity level for the slow log 1829NUMERIC_MIN_VALUE NULL 1830NUMERIC_MAX_VALUE NULL 1831NUMERIC_BLOCK_SIZE NULL 1832ENUM_VALUE_LIST innodb,query_plan,explain 1833READ_ONLY NO 1834COMMAND_LINE_ARGUMENT REQUIRED 1835VARIABLE_NAME LOG_WARNINGS 1836VARIABLE_SCOPE SESSION 1837VARIABLE_TYPE BIGINT UNSIGNED 1838VARIABLE_COMMENT Log some not critical warnings to the general log file.Value can be between 0 and 11. Higher values mean more verbosity 1839NUMERIC_MIN_VALUE 0 1840NUMERIC_MAX_VALUE 4294967295 1841NUMERIC_BLOCK_SIZE 1 1842ENUM_VALUE_LIST NULL 1843READ_ONLY NO 1844COMMAND_LINE_ARGUMENT OPTIONAL 1845VARIABLE_NAME LONG_QUERY_TIME 1846VARIABLE_SCOPE SESSION 1847VARIABLE_TYPE DOUBLE 1848VARIABLE_COMMENT Log all queries that have taken more than long_query_time seconds to execute to the slow query log file. The argument will be treated as a decimal value with microsecond precision 1849NUMERIC_MIN_VALUE 0 1850NUMERIC_MAX_VALUE 31536000 1851NUMERIC_BLOCK_SIZE NULL 1852ENUM_VALUE_LIST NULL 1853READ_ONLY NO 1854COMMAND_LINE_ARGUMENT REQUIRED 1855VARIABLE_NAME LOWER_CASE_FILE_SYSTEM 1856VARIABLE_SCOPE GLOBAL 1857VARIABLE_TYPE BOOLEAN 1858VARIABLE_COMMENT Case sensitivity of file names on the file system where the data directory is located 1859NUMERIC_MIN_VALUE NULL 1860NUMERIC_MAX_VALUE NULL 1861NUMERIC_BLOCK_SIZE NULL 1862ENUM_VALUE_LIST OFF,ON 1863READ_ONLY YES 1864COMMAND_LINE_ARGUMENT NULL 1865VARIABLE_NAME LOWER_CASE_TABLE_NAMES 1866VARIABLE_SCOPE GLOBAL 1867VARIABLE_TYPE INT UNSIGNED 1868VARIABLE_COMMENT If set to 1 table names are stored in lowercase on disk and table names will be case-insensitive. Should be set to 2 if you are using a case insensitive file system 1869NUMERIC_MIN_VALUE 0 1870NUMERIC_MAX_VALUE 2 1871NUMERIC_BLOCK_SIZE 1 1872ENUM_VALUE_LIST NULL 1873READ_ONLY YES 1874COMMAND_LINE_ARGUMENT OPTIONAL 1875VARIABLE_NAME LOW_PRIORITY_UPDATES 1876VARIABLE_SCOPE SESSION 1877VARIABLE_TYPE BOOLEAN 1878VARIABLE_COMMENT INSERT/DELETE/UPDATE has lower priority than selects 1879NUMERIC_MIN_VALUE NULL 1880NUMERIC_MAX_VALUE NULL 1881NUMERIC_BLOCK_SIZE NULL 1882ENUM_VALUE_LIST OFF,ON 1883READ_ONLY NO 1884COMMAND_LINE_ARGUMENT OPTIONAL 1885VARIABLE_NAME MASTER_VERIFY_CHECKSUM 1886VARIABLE_SCOPE GLOBAL 1887VARIABLE_TYPE BOOLEAN 1888VARIABLE_COMMENT Force checksum verification of logged events in the binary log before sending them to slaves or printing them in the output of SHOW BINLOG EVENTS 1889NUMERIC_MIN_VALUE NULL 1890NUMERIC_MAX_VALUE NULL 1891NUMERIC_BLOCK_SIZE NULL 1892ENUM_VALUE_LIST OFF,ON 1893READ_ONLY NO 1894COMMAND_LINE_ARGUMENT OPTIONAL 1895VARIABLE_NAME MAX_ALLOWED_PACKET 1896VARIABLE_SCOPE SESSION 1897VARIABLE_TYPE BIGINT UNSIGNED 1898VARIABLE_COMMENT Max packet length to send to or receive from the server 1899NUMERIC_MIN_VALUE 1024 1900NUMERIC_MAX_VALUE 1073741824 1901NUMERIC_BLOCK_SIZE 1024 1902ENUM_VALUE_LIST NULL 1903READ_ONLY NO 1904COMMAND_LINE_ARGUMENT REQUIRED 1905VARIABLE_NAME MAX_BINLOG_CACHE_SIZE 1906VARIABLE_SCOPE GLOBAL 1907VARIABLE_TYPE BIGINT UNSIGNED 1908VARIABLE_COMMENT Sets the total size of the transactional cache 1909NUMERIC_MIN_VALUE 4096 1910NUMERIC_MAX_VALUE 18446744073709551615 1911NUMERIC_BLOCK_SIZE 4096 1912ENUM_VALUE_LIST NULL 1913READ_ONLY NO 1914COMMAND_LINE_ARGUMENT REQUIRED 1915VARIABLE_NAME MAX_BINLOG_SIZE 1916VARIABLE_SCOPE GLOBAL 1917VARIABLE_TYPE BIGINT UNSIGNED 1918VARIABLE_COMMENT Binary log will be rotated automatically when the size exceeds this value. 1919NUMERIC_MIN_VALUE 4096 1920NUMERIC_MAX_VALUE 1073741824 1921NUMERIC_BLOCK_SIZE 4096 1922ENUM_VALUE_LIST NULL 1923READ_ONLY NO 1924COMMAND_LINE_ARGUMENT REQUIRED 1925VARIABLE_NAME MAX_BINLOG_STMT_CACHE_SIZE 1926VARIABLE_SCOPE GLOBAL 1927VARIABLE_TYPE BIGINT UNSIGNED 1928VARIABLE_COMMENT Sets the total size of the statement cache 1929NUMERIC_MIN_VALUE 4096 1930NUMERIC_MAX_VALUE 18446744073709551615 1931NUMERIC_BLOCK_SIZE 4096 1932ENUM_VALUE_LIST NULL 1933READ_ONLY NO 1934COMMAND_LINE_ARGUMENT REQUIRED 1935VARIABLE_NAME MAX_CONNECTIONS 1936VARIABLE_SCOPE GLOBAL 1937VARIABLE_TYPE BIGINT UNSIGNED 1938VARIABLE_COMMENT The number of simultaneous clients allowed 1939NUMERIC_MIN_VALUE 10 1940NUMERIC_MAX_VALUE 100000 1941NUMERIC_BLOCK_SIZE 1 1942ENUM_VALUE_LIST NULL 1943READ_ONLY NO 1944COMMAND_LINE_ARGUMENT REQUIRED 1945VARIABLE_NAME MAX_CONNECT_ERRORS 1946VARIABLE_SCOPE GLOBAL 1947VARIABLE_TYPE BIGINT UNSIGNED 1948VARIABLE_COMMENT If there is more than this number of interrupted connections from a host this host will be blocked from further connections 1949NUMERIC_MIN_VALUE 1 1950NUMERIC_MAX_VALUE 4294967295 1951NUMERIC_BLOCK_SIZE 1 1952ENUM_VALUE_LIST NULL 1953READ_ONLY NO 1954COMMAND_LINE_ARGUMENT REQUIRED 1955VARIABLE_NAME MAX_DELAYED_THREADS 1956VARIABLE_SCOPE SESSION 1957VARIABLE_TYPE BIGINT UNSIGNED 1958VARIABLE_COMMENT Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used 1959NUMERIC_MIN_VALUE 0 1960NUMERIC_MAX_VALUE 16384 1961NUMERIC_BLOCK_SIZE 1 1962ENUM_VALUE_LIST NULL 1963READ_ONLY NO 1964COMMAND_LINE_ARGUMENT REQUIRED 1965VARIABLE_NAME MAX_DIGEST_LENGTH 1966VARIABLE_SCOPE GLOBAL 1967VARIABLE_TYPE INT UNSIGNED 1968VARIABLE_COMMENT Maximum length considered for digest text. 1969NUMERIC_MIN_VALUE 0 1970NUMERIC_MAX_VALUE 1048576 1971NUMERIC_BLOCK_SIZE 1 1972ENUM_VALUE_LIST NULL 1973READ_ONLY YES 1974COMMAND_LINE_ARGUMENT REQUIRED 1975VARIABLE_NAME MAX_ERROR_COUNT 1976VARIABLE_SCOPE SESSION 1977VARIABLE_TYPE BIGINT UNSIGNED 1978VARIABLE_COMMENT Max number of errors/warnings to store for a statement 1979NUMERIC_MIN_VALUE 0 1980NUMERIC_MAX_VALUE 65535 1981NUMERIC_BLOCK_SIZE 1 1982ENUM_VALUE_LIST NULL 1983READ_ONLY NO 1984COMMAND_LINE_ARGUMENT REQUIRED 1985VARIABLE_NAME MAX_HEAP_TABLE_SIZE 1986VARIABLE_SCOPE SESSION 1987VARIABLE_TYPE BIGINT UNSIGNED 1988VARIABLE_COMMENT Don't allow creation of heap tables bigger than this 1989NUMERIC_MIN_VALUE 16384 1990NUMERIC_MAX_VALUE 18446744073709551615 1991NUMERIC_BLOCK_SIZE 1024 1992ENUM_VALUE_LIST NULL 1993READ_ONLY NO 1994COMMAND_LINE_ARGUMENT REQUIRED 1995VARIABLE_NAME MAX_INSERT_DELAYED_THREADS 1996VARIABLE_SCOPE SESSION 1997VARIABLE_TYPE BIGINT UNSIGNED 1998VARIABLE_COMMENT Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used 1999NUMERIC_MIN_VALUE 0 2000NUMERIC_MAX_VALUE 16384 2001NUMERIC_BLOCK_SIZE 1 2002ENUM_VALUE_LIST NULL 2003READ_ONLY NO 2004COMMAND_LINE_ARGUMENT NULL 2005VARIABLE_NAME MAX_JOIN_SIZE 2006VARIABLE_SCOPE SESSION 2007VARIABLE_TYPE BIGINT UNSIGNED 2008VARIABLE_COMMENT Joins that are probably going to read more than max_join_size records return an error 2009NUMERIC_MIN_VALUE 1 2010NUMERIC_MAX_VALUE 18446744073709551615 2011NUMERIC_BLOCK_SIZE 1 2012ENUM_VALUE_LIST NULL 2013READ_ONLY NO 2014COMMAND_LINE_ARGUMENT REQUIRED 2015VARIABLE_NAME MAX_LENGTH_FOR_SORT_DATA 2016VARIABLE_SCOPE SESSION 2017VARIABLE_TYPE BIGINT UNSIGNED 2018VARIABLE_COMMENT Max number of bytes in sorted records 2019NUMERIC_MIN_VALUE 4 2020NUMERIC_MAX_VALUE 8388608 2021NUMERIC_BLOCK_SIZE 1 2022ENUM_VALUE_LIST NULL 2023READ_ONLY NO 2024COMMAND_LINE_ARGUMENT REQUIRED 2025VARIABLE_NAME MAX_LONG_DATA_SIZE 2026VARIABLE_SCOPE GLOBAL 2027VARIABLE_TYPE BIGINT UNSIGNED 2028VARIABLE_COMMENT The maximum BLOB length to send to server from mysql_send_long_data API. Deprecated option; use max_allowed_packet instead. 2029NUMERIC_MIN_VALUE 1024 2030NUMERIC_MAX_VALUE 4294967295 2031NUMERIC_BLOCK_SIZE 1 2032ENUM_VALUE_LIST NULL 2033READ_ONLY YES 2034COMMAND_LINE_ARGUMENT REQUIRED 2035VARIABLE_NAME MAX_PASSWORD_ERRORS 2036VARIABLE_SCOPE GLOBAL 2037VARIABLE_TYPE INT UNSIGNED 2038VARIABLE_COMMENT If there is more than this number of failed connect attempts due to invalid password, user will be blocked from further connections until FLUSH_PRIVILEGES. 2039NUMERIC_MIN_VALUE 1 2040NUMERIC_MAX_VALUE 4294967295 2041NUMERIC_BLOCK_SIZE 1 2042ENUM_VALUE_LIST NULL 2043READ_ONLY NO 2044COMMAND_LINE_ARGUMENT REQUIRED 2045VARIABLE_NAME MAX_PREPARED_STMT_COUNT 2046VARIABLE_SCOPE GLOBAL 2047VARIABLE_TYPE INT UNSIGNED 2048VARIABLE_COMMENT Maximum number of prepared statements in the server 2049NUMERIC_MIN_VALUE 0 2050NUMERIC_MAX_VALUE 4294967295 2051NUMERIC_BLOCK_SIZE 1 2052ENUM_VALUE_LIST NULL 2053READ_ONLY NO 2054COMMAND_LINE_ARGUMENT REQUIRED 2055VARIABLE_NAME MAX_RECURSIVE_ITERATIONS 2056VARIABLE_SCOPE SESSION 2057VARIABLE_TYPE BIGINT UNSIGNED 2058VARIABLE_COMMENT Maximum number of iterations when executing recursive queries 2059NUMERIC_MIN_VALUE 0 2060NUMERIC_MAX_VALUE 4294967295 2061NUMERIC_BLOCK_SIZE 1 2062ENUM_VALUE_LIST NULL 2063READ_ONLY NO 2064COMMAND_LINE_ARGUMENT OPTIONAL 2065VARIABLE_NAME MAX_RELAY_LOG_SIZE 2066VARIABLE_SCOPE SESSION 2067VARIABLE_TYPE BIGINT UNSIGNED 2068VARIABLE_COMMENT relay log will be rotated automatically when the size exceeds this value. If 0 at startup, it's set to max_binlog_size 2069NUMERIC_MIN_VALUE 4096 2070NUMERIC_MAX_VALUE 1073741824 2071NUMERIC_BLOCK_SIZE 4096 2072ENUM_VALUE_LIST NULL 2073READ_ONLY NO 2074COMMAND_LINE_ARGUMENT REQUIRED 2075VARIABLE_NAME MAX_ROWID_FILTER_SIZE 2076VARIABLE_SCOPE SESSION 2077VARIABLE_TYPE BIGINT UNSIGNED 2078VARIABLE_COMMENT The maximum size of the container of a rowid filter 2079NUMERIC_MIN_VALUE 1024 2080NUMERIC_MAX_VALUE 18446744073709551615 2081NUMERIC_BLOCK_SIZE 1 2082ENUM_VALUE_LIST NULL 2083READ_ONLY NO 2084COMMAND_LINE_ARGUMENT REQUIRED 2085VARIABLE_NAME MAX_SEEKS_FOR_KEY 2086VARIABLE_SCOPE SESSION 2087VARIABLE_TYPE BIGINT UNSIGNED 2088VARIABLE_COMMENT Limit assumed max number of seeks when looking up rows based on a key 2089NUMERIC_MIN_VALUE 1 2090NUMERIC_MAX_VALUE 4294967295 2091NUMERIC_BLOCK_SIZE 1 2092ENUM_VALUE_LIST NULL 2093READ_ONLY NO 2094COMMAND_LINE_ARGUMENT REQUIRED 2095VARIABLE_NAME MAX_SESSION_MEM_USED 2096VARIABLE_SCOPE SESSION 2097VARIABLE_TYPE BIGINT UNSIGNED 2098VARIABLE_COMMENT Amount of memory a single user session is allowed to allocate. This limits the value of the session variable MEM_USED 2099NUMERIC_MIN_VALUE 8192 2100NUMERIC_MAX_VALUE 18446744073709551615 2101NUMERIC_BLOCK_SIZE 1 2102ENUM_VALUE_LIST NULL 2103READ_ONLY NO 2104COMMAND_LINE_ARGUMENT REQUIRED 2105VARIABLE_NAME MAX_SORT_LENGTH 2106VARIABLE_SCOPE SESSION 2107VARIABLE_TYPE BIGINT UNSIGNED 2108VARIABLE_COMMENT The number of bytes to use when sorting BLOB or TEXT values (only the first max_sort_length bytes of each value are used; the rest are ignored) 2109NUMERIC_MIN_VALUE 64 2110NUMERIC_MAX_VALUE 8388608 2111NUMERIC_BLOCK_SIZE 1 2112ENUM_VALUE_LIST NULL 2113READ_ONLY NO 2114COMMAND_LINE_ARGUMENT REQUIRED 2115VARIABLE_NAME MAX_SP_RECURSION_DEPTH 2116VARIABLE_SCOPE SESSION 2117VARIABLE_TYPE BIGINT UNSIGNED 2118VARIABLE_COMMENT Maximum stored procedure recursion depth 2119NUMERIC_MIN_VALUE 0 2120NUMERIC_MAX_VALUE 255 2121NUMERIC_BLOCK_SIZE 1 2122ENUM_VALUE_LIST NULL 2123READ_ONLY NO 2124COMMAND_LINE_ARGUMENT OPTIONAL 2125VARIABLE_NAME MAX_STATEMENT_TIME 2126VARIABLE_SCOPE SESSION 2127VARIABLE_TYPE DOUBLE 2128VARIABLE_COMMENT A query that has taken more than max_statement_time seconds will be aborted. The argument will be treated as a decimal value with microsecond precision. A value of 0 (default) means no timeout 2129NUMERIC_MIN_VALUE 0 2130NUMERIC_MAX_VALUE 31536000 2131NUMERIC_BLOCK_SIZE NULL 2132ENUM_VALUE_LIST NULL 2133READ_ONLY NO 2134COMMAND_LINE_ARGUMENT REQUIRED 2135VARIABLE_NAME MAX_TMP_TABLES 2136VARIABLE_SCOPE SESSION 2137VARIABLE_TYPE BIGINT UNSIGNED 2138VARIABLE_COMMENT Unused, will be removed. 2139NUMERIC_MIN_VALUE 1 2140NUMERIC_MAX_VALUE 4294967295 2141NUMERIC_BLOCK_SIZE 1 2142ENUM_VALUE_LIST NULL 2143READ_ONLY NO 2144COMMAND_LINE_ARGUMENT REQUIRED 2145VARIABLE_NAME MAX_USER_CONNECTIONS 2146VARIABLE_SCOPE SESSION 2147VARIABLE_TYPE INT 2148VARIABLE_COMMENT The maximum number of active connections for a single user (0 = no limit) 2149NUMERIC_MIN_VALUE -1 2150NUMERIC_MAX_VALUE 2147483647 2151NUMERIC_BLOCK_SIZE 1 2152ENUM_VALUE_LIST NULL 2153READ_ONLY NO 2154COMMAND_LINE_ARGUMENT REQUIRED 2155VARIABLE_NAME MAX_WRITE_LOCK_COUNT 2156VARIABLE_SCOPE GLOBAL 2157VARIABLE_TYPE BIGINT UNSIGNED 2158VARIABLE_COMMENT After this many write locks, allow some read locks to run in between 2159NUMERIC_MIN_VALUE 1 2160NUMERIC_MAX_VALUE 4294967295 2161NUMERIC_BLOCK_SIZE 1 2162ENUM_VALUE_LIST NULL 2163READ_ONLY NO 2164COMMAND_LINE_ARGUMENT REQUIRED 2165VARIABLE_NAME METADATA_LOCKS_CACHE_SIZE 2166VARIABLE_SCOPE GLOBAL 2167VARIABLE_TYPE BIGINT UNSIGNED 2168VARIABLE_COMMENT Unused 2169NUMERIC_MIN_VALUE 1 2170NUMERIC_MAX_VALUE 1048576 2171NUMERIC_BLOCK_SIZE 1 2172ENUM_VALUE_LIST NULL 2173READ_ONLY YES 2174COMMAND_LINE_ARGUMENT REQUIRED 2175VARIABLE_NAME METADATA_LOCKS_HASH_INSTANCES 2176VARIABLE_SCOPE GLOBAL 2177VARIABLE_TYPE BIGINT UNSIGNED 2178VARIABLE_COMMENT Unused 2179NUMERIC_MIN_VALUE 1 2180NUMERIC_MAX_VALUE 1024 2181NUMERIC_BLOCK_SIZE 1 2182ENUM_VALUE_LIST NULL 2183READ_ONLY YES 2184COMMAND_LINE_ARGUMENT REQUIRED 2185VARIABLE_NAME MIN_EXAMINED_ROW_LIMIT 2186VARIABLE_SCOPE SESSION 2187VARIABLE_TYPE BIGINT UNSIGNED 2188VARIABLE_COMMENT Don't write queries to slow log that examine fewer rows than that 2189NUMERIC_MIN_VALUE 0 2190NUMERIC_MAX_VALUE 4294967295 2191NUMERIC_BLOCK_SIZE 1 2192ENUM_VALUE_LIST NULL 2193READ_ONLY NO 2194COMMAND_LINE_ARGUMENT REQUIRED 2195VARIABLE_NAME MRR_BUFFER_SIZE 2196VARIABLE_SCOPE SESSION 2197VARIABLE_TYPE BIGINT UNSIGNED 2198VARIABLE_COMMENT Size of buffer to use when using MRR with range access 2199NUMERIC_MIN_VALUE 8192 2200NUMERIC_MAX_VALUE 2147483647 2201NUMERIC_BLOCK_SIZE 1 2202ENUM_VALUE_LIST NULL 2203READ_ONLY NO 2204COMMAND_LINE_ARGUMENT REQUIRED 2205VARIABLE_NAME MULTI_RANGE_COUNT 2206VARIABLE_SCOPE SESSION 2207VARIABLE_TYPE BIGINT UNSIGNED 2208VARIABLE_COMMENT Ignored. Use mrr_buffer_size instead 2209NUMERIC_MIN_VALUE 1 2210NUMERIC_MAX_VALUE 18446744073709551615 2211NUMERIC_BLOCK_SIZE 1 2212ENUM_VALUE_LIST NULL 2213READ_ONLY NO 2214COMMAND_LINE_ARGUMENT REQUIRED 2215VARIABLE_NAME MYISAM_BLOCK_SIZE 2216VARIABLE_SCOPE GLOBAL 2217VARIABLE_TYPE BIGINT UNSIGNED 2218VARIABLE_COMMENT Block size to be used for MyISAM index pages 2219NUMERIC_MIN_VALUE 1024 2220NUMERIC_MAX_VALUE 16384 2221NUMERIC_BLOCK_SIZE 1024 2222ENUM_VALUE_LIST NULL 2223READ_ONLY YES 2224COMMAND_LINE_ARGUMENT REQUIRED 2225VARIABLE_NAME MYISAM_DATA_POINTER_SIZE 2226VARIABLE_SCOPE GLOBAL 2227VARIABLE_TYPE BIGINT UNSIGNED 2228VARIABLE_COMMENT Default pointer size to be used for MyISAM tables 2229NUMERIC_MIN_VALUE 2 2230NUMERIC_MAX_VALUE 7 2231NUMERIC_BLOCK_SIZE 1 2232ENUM_VALUE_LIST NULL 2233READ_ONLY NO 2234COMMAND_LINE_ARGUMENT REQUIRED 2235VARIABLE_NAME MYISAM_MAX_SORT_FILE_SIZE 2236VARIABLE_SCOPE GLOBAL 2237VARIABLE_TYPE BIGINT UNSIGNED 2238VARIABLE_COMMENT Don't use the fast sort index method to created index if the temporary file would get bigger than this 2239NUMERIC_MIN_VALUE 0 2240NUMERIC_MAX_VALUE 9223372036854775807 2241NUMERIC_BLOCK_SIZE 1048576 2242ENUM_VALUE_LIST NULL 2243READ_ONLY NO 2244COMMAND_LINE_ARGUMENT REQUIRED 2245VARIABLE_NAME MYISAM_MMAP_SIZE 2246VARIABLE_SCOPE GLOBAL 2247VARIABLE_TYPE BIGINT UNSIGNED 2248VARIABLE_COMMENT Restricts the total memory used for memory mapping of MySQL tables 2249NUMERIC_MIN_VALUE 7 2250NUMERIC_MAX_VALUE 18446744073709551615 2251NUMERIC_BLOCK_SIZE 1 2252ENUM_VALUE_LIST NULL 2253READ_ONLY YES 2254COMMAND_LINE_ARGUMENT REQUIRED 2255VARIABLE_NAME MYISAM_RECOVER_OPTIONS 2256VARIABLE_SCOPE GLOBAL 2257VARIABLE_TYPE SET 2258VARIABLE_COMMENT Specifies how corrupted tables should be automatically repaired 2259NUMERIC_MIN_VALUE NULL 2260NUMERIC_MAX_VALUE NULL 2261NUMERIC_BLOCK_SIZE NULL 2262ENUM_VALUE_LIST DEFAULT,BACKUP,FORCE,QUICK,BACKUP_ALL,OFF 2263READ_ONLY YES 2264COMMAND_LINE_ARGUMENT OPTIONAL 2265VARIABLE_NAME MYISAM_REPAIR_THREADS 2266VARIABLE_SCOPE SESSION 2267VARIABLE_TYPE BIGINT UNSIGNED 2268VARIABLE_COMMENT If larger than 1, when repairing a MyISAM table all indexes will be created in parallel, with one thread per index. The value of 1 disables parallel repair 2269NUMERIC_MIN_VALUE 1 2270NUMERIC_MAX_VALUE 18446744073709551615 2271NUMERIC_BLOCK_SIZE 1 2272ENUM_VALUE_LIST NULL 2273READ_ONLY NO 2274COMMAND_LINE_ARGUMENT REQUIRED 2275VARIABLE_NAME MYISAM_SORT_BUFFER_SIZE 2276VARIABLE_SCOPE SESSION 2277VARIABLE_TYPE BIGINT UNSIGNED 2278VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE 2279NUMERIC_MIN_VALUE 4096 2280NUMERIC_MAX_VALUE 18446744073709551615 2281NUMERIC_BLOCK_SIZE 1 2282ENUM_VALUE_LIST NULL 2283READ_ONLY NO 2284COMMAND_LINE_ARGUMENT REQUIRED 2285VARIABLE_NAME MYISAM_STATS_METHOD 2286VARIABLE_SCOPE SESSION 2287VARIABLE_TYPE ENUM 2288VARIABLE_COMMENT Specifies how MyISAM index statistics collection code should treat NULLs. Possible values of name are NULLS_UNEQUAL (default behavior for 4.1 and later), NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED 2289NUMERIC_MIN_VALUE NULL 2290NUMERIC_MAX_VALUE NULL 2291NUMERIC_BLOCK_SIZE NULL 2292ENUM_VALUE_LIST NULLS_UNEQUAL,NULLS_EQUAL,NULLS_IGNORED 2293READ_ONLY NO 2294COMMAND_LINE_ARGUMENT REQUIRED 2295VARIABLE_NAME MYISAM_USE_MMAP 2296VARIABLE_SCOPE GLOBAL 2297VARIABLE_TYPE BOOLEAN 2298VARIABLE_COMMENT Use memory mapping for reading and writing MyISAM tables 2299NUMERIC_MIN_VALUE NULL 2300NUMERIC_MAX_VALUE NULL 2301NUMERIC_BLOCK_SIZE NULL 2302ENUM_VALUE_LIST OFF,ON 2303READ_ONLY NO 2304COMMAND_LINE_ARGUMENT NONE 2305VARIABLE_NAME MYSQL56_TEMPORAL_FORMAT 2306VARIABLE_SCOPE GLOBAL 2307VARIABLE_TYPE BOOLEAN 2308VARIABLE_COMMENT Use MySQL-5.6 (instead of MariaDB-5.3) format for TIME, DATETIME, TIMESTAMP columns. 2309NUMERIC_MIN_VALUE NULL 2310NUMERIC_MAX_VALUE NULL 2311NUMERIC_BLOCK_SIZE NULL 2312ENUM_VALUE_LIST OFF,ON 2313READ_ONLY NO 2314COMMAND_LINE_ARGUMENT OPTIONAL 2315VARIABLE_NAME NET_BUFFER_LENGTH 2316VARIABLE_SCOPE SESSION 2317VARIABLE_TYPE BIGINT UNSIGNED 2318VARIABLE_COMMENT Buffer length for TCP/IP and socket communication 2319NUMERIC_MIN_VALUE 1024 2320NUMERIC_MAX_VALUE 1048576 2321NUMERIC_BLOCK_SIZE 1024 2322ENUM_VALUE_LIST NULL 2323READ_ONLY NO 2324COMMAND_LINE_ARGUMENT REQUIRED 2325VARIABLE_NAME NET_READ_TIMEOUT 2326VARIABLE_SCOPE SESSION 2327VARIABLE_TYPE BIGINT UNSIGNED 2328VARIABLE_COMMENT Number of seconds to wait for more data from a connection before aborting the read 2329NUMERIC_MIN_VALUE 1 2330NUMERIC_MAX_VALUE 31536000 2331NUMERIC_BLOCK_SIZE 1 2332ENUM_VALUE_LIST NULL 2333READ_ONLY NO 2334COMMAND_LINE_ARGUMENT REQUIRED 2335VARIABLE_NAME NET_RETRY_COUNT 2336VARIABLE_SCOPE SESSION 2337VARIABLE_TYPE BIGINT UNSIGNED 2338VARIABLE_COMMENT If a read on a communication port is interrupted, retry this many times before giving up 2339NUMERIC_MIN_VALUE 1 2340NUMERIC_MAX_VALUE 4294967295 2341NUMERIC_BLOCK_SIZE 1 2342ENUM_VALUE_LIST NULL 2343READ_ONLY NO 2344COMMAND_LINE_ARGUMENT REQUIRED 2345VARIABLE_NAME NET_WRITE_TIMEOUT 2346VARIABLE_SCOPE SESSION 2347VARIABLE_TYPE BIGINT UNSIGNED 2348VARIABLE_COMMENT Number of seconds to wait for a block to be written to a connection before aborting the write 2349NUMERIC_MIN_VALUE 1 2350NUMERIC_MAX_VALUE 31536000 2351NUMERIC_BLOCK_SIZE 1 2352ENUM_VALUE_LIST NULL 2353READ_ONLY NO 2354COMMAND_LINE_ARGUMENT REQUIRED 2355VARIABLE_NAME OLD 2356VARIABLE_SCOPE SESSION 2357VARIABLE_TYPE BOOLEAN 2358VARIABLE_COMMENT Use compatible behavior from previous MariaDB version. See also --old-mode 2359NUMERIC_MIN_VALUE NULL 2360NUMERIC_MAX_VALUE NULL 2361NUMERIC_BLOCK_SIZE NULL 2362ENUM_VALUE_LIST OFF,ON 2363READ_ONLY NO 2364COMMAND_LINE_ARGUMENT OPTIONAL 2365VARIABLE_NAME OLD_ALTER_TABLE 2366VARIABLE_SCOPE SESSION 2367VARIABLE_TYPE ENUM 2368VARIABLE_COMMENT Alias for alter_algorithm. Deprecated. Use --alter-algorithm instead. 2369NUMERIC_MIN_VALUE NULL 2370NUMERIC_MAX_VALUE NULL 2371NUMERIC_BLOCK_SIZE NULL 2372ENUM_VALUE_LIST DEFAULT,COPY,INPLACE,NOCOPY,INSTANT 2373READ_ONLY NO 2374COMMAND_LINE_ARGUMENT OPTIONAL 2375VARIABLE_NAME OLD_MODE 2376VARIABLE_SCOPE SESSION 2377VARIABLE_TYPE SET 2378VARIABLE_COMMENT Used to emulate old behavior from earlier MariaDB or MySQL versions 2379NUMERIC_MIN_VALUE NULL 2380NUMERIC_MAX_VALUE NULL 2381NUMERIC_BLOCK_SIZE NULL 2382ENUM_VALUE_LIST NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO,ZERO_DATE_TIME_CAST 2383READ_ONLY NO 2384COMMAND_LINE_ARGUMENT REQUIRED 2385VARIABLE_NAME OLD_PASSWORDS 2386VARIABLE_SCOPE SESSION 2387VARIABLE_TYPE BOOLEAN 2388VARIABLE_COMMENT Use old password encryption method (needed for 4.0 and older clients) 2389NUMERIC_MIN_VALUE NULL 2390NUMERIC_MAX_VALUE NULL 2391NUMERIC_BLOCK_SIZE NULL 2392ENUM_VALUE_LIST OFF,ON 2393READ_ONLY NO 2394COMMAND_LINE_ARGUMENT OPTIONAL 2395VARIABLE_NAME OPEN_FILES_LIMIT 2396VARIABLE_SCOPE GLOBAL 2397VARIABLE_TYPE BIGINT UNSIGNED 2398VARIABLE_COMMENT If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 or autoset then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of file descriptors 2399NUMERIC_MIN_VALUE 0 2400NUMERIC_MAX_VALUE 4294967295 2401NUMERIC_BLOCK_SIZE 1 2402ENUM_VALUE_LIST NULL 2403READ_ONLY YES 2404COMMAND_LINE_ARGUMENT REQUIRED 2405VARIABLE_NAME OPTIMIZER_PRUNE_LEVEL 2406VARIABLE_SCOPE SESSION 2407VARIABLE_TYPE BIGINT UNSIGNED 2408VARIABLE_COMMENT Controls the heuristic(s) applied during query optimization to prune less-promising partial plans from the optimizer search space. Meaning: 0 - do not apply any heuristic, thus perform exhaustive search; 1 - prune plans based on number of retrieved rows 2409NUMERIC_MIN_VALUE 0 2410NUMERIC_MAX_VALUE 1 2411NUMERIC_BLOCK_SIZE 1 2412ENUM_VALUE_LIST NULL 2413READ_ONLY NO 2414COMMAND_LINE_ARGUMENT REQUIRED 2415VARIABLE_NAME OPTIMIZER_SEARCH_DEPTH 2416VARIABLE_SCOPE SESSION 2417VARIABLE_TYPE BIGINT UNSIGNED 2418VARIABLE_COMMENT Maximum depth of search performed by the query optimizer. Values larger than the number of relations in a query result in better query plans, but take longer to compile a query. Values smaller than the number of tables in a relation result in faster optimization, but may produce very bad query plans. If set to 0, the system will automatically pick a reasonable value. 2419NUMERIC_MIN_VALUE 0 2420NUMERIC_MAX_VALUE 62 2421NUMERIC_BLOCK_SIZE 1 2422ENUM_VALUE_LIST NULL 2423READ_ONLY NO 2424COMMAND_LINE_ARGUMENT REQUIRED 2425VARIABLE_NAME OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT 2426VARIABLE_SCOPE SESSION 2427VARIABLE_TYPE BIGINT UNSIGNED 2428VARIABLE_COMMENT Controls number of record samples to check condition selectivity 2429NUMERIC_MIN_VALUE 10 2430NUMERIC_MAX_VALUE 4294967295 2431NUMERIC_BLOCK_SIZE 1 2432ENUM_VALUE_LIST NULL 2433READ_ONLY NO 2434COMMAND_LINE_ARGUMENT REQUIRED 2435VARIABLE_NAME OPTIMIZER_SWITCH 2436VARIABLE_SCOPE SESSION 2437VARIABLE_TYPE FLAGSET 2438VARIABLE_COMMENT Fine-tune the optimizer behavior 2439NUMERIC_MIN_VALUE NULL 2440NUMERIC_MAX_VALUE NULL 2441NUMERIC_BLOCK_SIZE NULL 2442ENUM_VALUE_LIST index_merge,index_merge_union,index_merge_sort_union,index_merge_intersection,index_merge_sort_intersection,engine_condition_pushdown,index_condition_pushdown,derived_merge,derived_with_keys,firstmatch,loosescan,materialization,in_to_exists,semijoin,partial_match_rowid_merge,partial_match_table_scan,subquery_cache,mrr,mrr_cost_based,mrr_sort_keys,outer_join_with_cache,semijoin_with_cache,join_cache_incremental,join_cache_hashed,join_cache_bka,optimize_join_buffer_size,table_elimination,extended_keys,exists_to_in,orderby_uses_equalities,condition_pushdown_for_derived,split_materialized,condition_pushdown_for_subquery,rowid_filter,condition_pushdown_from_having,default 2443READ_ONLY NO 2444COMMAND_LINE_ARGUMENT REQUIRED 2445VARIABLE_NAME OPTIMIZER_TRACE 2446VARIABLE_SCOPE SESSION 2447VARIABLE_TYPE FLAGSET 2448VARIABLE_COMMENT Controls tracing of the Optimizer: optimizer_trace=option=val[,option=val...], where option is one of {enabled} and val is one of {on, off, default} 2449NUMERIC_MIN_VALUE NULL 2450NUMERIC_MAX_VALUE NULL 2451NUMERIC_BLOCK_SIZE NULL 2452ENUM_VALUE_LIST enabled,default 2453READ_ONLY NO 2454COMMAND_LINE_ARGUMENT REQUIRED 2455VARIABLE_NAME OPTIMIZER_TRACE_MAX_MEM_SIZE 2456VARIABLE_SCOPE SESSION 2457VARIABLE_TYPE BIGINT UNSIGNED 2458VARIABLE_COMMENT Maximum allowed size of an optimizer trace 2459NUMERIC_MIN_VALUE 0 2460NUMERIC_MAX_VALUE 18446744073709551615 2461NUMERIC_BLOCK_SIZE 1 2462ENUM_VALUE_LIST NULL 2463READ_ONLY NO 2464COMMAND_LINE_ARGUMENT REQUIRED 2465VARIABLE_NAME OPTIMIZER_USE_CONDITION_SELECTIVITY 2466VARIABLE_SCOPE SESSION 2467VARIABLE_TYPE BIGINT UNSIGNED 2468VARIABLE_COMMENT Controls selectivity of which conditions the optimizer takes into account to calculate cardinality of a partial join when it searches for the best execution plan Meaning: 1 - use selectivity of index backed range conditions to calculate the cardinality of a partial join if the last joined table is accessed by full table scan or an index scan, 2 - use selectivity of index backed range conditions to calculate the cardinality of a partial join in any case, 3 - additionally always use selectivity of range conditions that are not backed by any index to calculate the cardinality of a partial join, 4 - use histograms to calculate selectivity of range conditions that are not backed by any index to calculate the cardinality of a partial join.5 - additionally use selectivity of certain non-range predicates calculated on record samples 2469NUMERIC_MIN_VALUE 1 2470NUMERIC_MAX_VALUE 5 2471NUMERIC_BLOCK_SIZE 1 2472ENUM_VALUE_LIST NULL 2473READ_ONLY NO 2474COMMAND_LINE_ARGUMENT REQUIRED 2475VARIABLE_NAME PERFORMANCE_SCHEMA 2476VARIABLE_SCOPE GLOBAL 2477VARIABLE_TYPE BOOLEAN 2478VARIABLE_COMMENT Enable the performance schema. 2479NUMERIC_MIN_VALUE NULL 2480NUMERIC_MAX_VALUE NULL 2481NUMERIC_BLOCK_SIZE NULL 2482ENUM_VALUE_LIST OFF,ON 2483READ_ONLY YES 2484COMMAND_LINE_ARGUMENT OPTIONAL 2485VARIABLE_NAME PERFORMANCE_SCHEMA_ACCOUNTS_SIZE 2486VARIABLE_SCOPE GLOBAL 2487VARIABLE_TYPE BIGINT 2488VARIABLE_COMMENT Maximum number of instrumented user@host accounts. Use 0 to disable, -1 for automated sizing. 2489NUMERIC_MIN_VALUE -1 2490NUMERIC_MAX_VALUE 1048576 2491NUMERIC_BLOCK_SIZE 1 2492ENUM_VALUE_LIST NULL 2493READ_ONLY YES 2494COMMAND_LINE_ARGUMENT REQUIRED 2495VARIABLE_NAME PERFORMANCE_SCHEMA_DIGESTS_SIZE 2496VARIABLE_SCOPE GLOBAL 2497VARIABLE_TYPE BIGINT 2498VARIABLE_COMMENT Size of the statement digest. Use 0 to disable, -1 for automated sizing. 2499NUMERIC_MIN_VALUE -1 2500NUMERIC_MAX_VALUE 1048576 2501NUMERIC_BLOCK_SIZE 1 2502ENUM_VALUE_LIST NULL 2503READ_ONLY YES 2504COMMAND_LINE_ARGUMENT REQUIRED 2505VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE 2506VARIABLE_SCOPE GLOBAL 2507VARIABLE_TYPE BIGINT 2508VARIABLE_COMMENT Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 2509NUMERIC_MIN_VALUE -1 2510NUMERIC_MAX_VALUE 1048576 2511NUMERIC_BLOCK_SIZE 1 2512ENUM_VALUE_LIST NULL 2513READ_ONLY YES 2514COMMAND_LINE_ARGUMENT REQUIRED 2515VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE 2516VARIABLE_SCOPE GLOBAL 2517VARIABLE_TYPE BIGINT 2518VARIABLE_COMMENT Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0 to disable, -1 for automated sizing. 2519NUMERIC_MIN_VALUE -1 2520NUMERIC_MAX_VALUE 1024 2521NUMERIC_BLOCK_SIZE 1 2522ENUM_VALUE_LIST NULL 2523READ_ONLY YES 2524COMMAND_LINE_ARGUMENT REQUIRED 2525VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE 2526VARIABLE_SCOPE GLOBAL 2527VARIABLE_TYPE BIGINT 2528VARIABLE_COMMENT Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 2529NUMERIC_MIN_VALUE -1 2530NUMERIC_MAX_VALUE 1048576 2531NUMERIC_BLOCK_SIZE 1 2532ENUM_VALUE_LIST NULL 2533READ_ONLY YES 2534COMMAND_LINE_ARGUMENT REQUIRED 2535VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE 2536VARIABLE_SCOPE GLOBAL 2537VARIABLE_TYPE BIGINT 2538VARIABLE_COMMENT Number of rows per thread in EVENTS_STATEMENTS_HISTORY. Use 0 to disable, -1 for automated sizing. 2539NUMERIC_MIN_VALUE -1 2540NUMERIC_MAX_VALUE 1024 2541NUMERIC_BLOCK_SIZE 1 2542ENUM_VALUE_LIST NULL 2543READ_ONLY YES 2544COMMAND_LINE_ARGUMENT REQUIRED 2545VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE 2546VARIABLE_SCOPE GLOBAL 2547VARIABLE_TYPE BIGINT 2548VARIABLE_COMMENT Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. 2549NUMERIC_MIN_VALUE -1 2550NUMERIC_MAX_VALUE 1048576 2551NUMERIC_BLOCK_SIZE 1 2552ENUM_VALUE_LIST NULL 2553READ_ONLY YES 2554COMMAND_LINE_ARGUMENT REQUIRED 2555VARIABLE_NAME PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE 2556VARIABLE_SCOPE GLOBAL 2557VARIABLE_TYPE BIGINT 2558VARIABLE_COMMENT Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing. 2559NUMERIC_MIN_VALUE -1 2560NUMERIC_MAX_VALUE 1024 2561NUMERIC_BLOCK_SIZE 1 2562ENUM_VALUE_LIST NULL 2563READ_ONLY YES 2564COMMAND_LINE_ARGUMENT REQUIRED 2565VARIABLE_NAME PERFORMANCE_SCHEMA_HOSTS_SIZE 2566VARIABLE_SCOPE GLOBAL 2567VARIABLE_TYPE BIGINT 2568VARIABLE_COMMENT Maximum number of instrumented hosts. Use 0 to disable, -1 for automated sizing. 2569NUMERIC_MIN_VALUE -1 2570NUMERIC_MAX_VALUE 1048576 2571NUMERIC_BLOCK_SIZE 1 2572ENUM_VALUE_LIST NULL 2573READ_ONLY YES 2574COMMAND_LINE_ARGUMENT REQUIRED 2575VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_CLASSES 2576VARIABLE_SCOPE GLOBAL 2577VARIABLE_TYPE BIGINT UNSIGNED 2578VARIABLE_COMMENT Maximum number of condition instruments. 2579NUMERIC_MIN_VALUE 0 2580NUMERIC_MAX_VALUE 256 2581NUMERIC_BLOCK_SIZE 1 2582ENUM_VALUE_LIST NULL 2583READ_ONLY YES 2584COMMAND_LINE_ARGUMENT REQUIRED 2585VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_COND_INSTANCES 2586VARIABLE_SCOPE GLOBAL 2587VARIABLE_TYPE BIGINT 2588VARIABLE_COMMENT Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing. 2589NUMERIC_MIN_VALUE -1 2590NUMERIC_MAX_VALUE 1048576 2591NUMERIC_BLOCK_SIZE 1 2592ENUM_VALUE_LIST NULL 2593READ_ONLY YES 2594COMMAND_LINE_ARGUMENT REQUIRED 2595VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH 2596VARIABLE_SCOPE GLOBAL 2597VARIABLE_TYPE BIGINT 2598VARIABLE_COMMENT Maximum length considered for digest text, when stored in performance_schema tables. 2599NUMERIC_MIN_VALUE 0 2600NUMERIC_MAX_VALUE 1048576 2601NUMERIC_BLOCK_SIZE 1 2602ENUM_VALUE_LIST NULL 2603READ_ONLY YES 2604COMMAND_LINE_ARGUMENT REQUIRED 2605VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 2606VARIABLE_SCOPE GLOBAL 2607VARIABLE_TYPE BIGINT UNSIGNED 2608VARIABLE_COMMENT Maximum number of file instruments. 2609NUMERIC_MIN_VALUE 0 2610NUMERIC_MAX_VALUE 256 2611NUMERIC_BLOCK_SIZE 1 2612ENUM_VALUE_LIST NULL 2613READ_ONLY YES 2614COMMAND_LINE_ARGUMENT REQUIRED 2615VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 2616VARIABLE_SCOPE GLOBAL 2617VARIABLE_TYPE BIGINT UNSIGNED 2618VARIABLE_COMMENT Maximum number of opened instrumented files. 2619NUMERIC_MIN_VALUE 0 2620NUMERIC_MAX_VALUE 1048576 2621NUMERIC_BLOCK_SIZE 1 2622ENUM_VALUE_LIST NULL 2623READ_ONLY YES 2624COMMAND_LINE_ARGUMENT REQUIRED 2625VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES 2626VARIABLE_SCOPE GLOBAL 2627VARIABLE_TYPE BIGINT 2628VARIABLE_COMMENT Maximum number of instrumented files. Use 0 to disable, -1 for automated sizing. 2629NUMERIC_MIN_VALUE -1 2630NUMERIC_MAX_VALUE 1048576 2631NUMERIC_BLOCK_SIZE 1 2632ENUM_VALUE_LIST NULL 2633READ_ONLY YES 2634COMMAND_LINE_ARGUMENT REQUIRED 2635VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES 2636VARIABLE_SCOPE GLOBAL 2637VARIABLE_TYPE BIGINT UNSIGNED 2638VARIABLE_COMMENT Maximum number of mutex instruments. 2639NUMERIC_MIN_VALUE 0 2640NUMERIC_MAX_VALUE 256 2641NUMERIC_BLOCK_SIZE 1 2642ENUM_VALUE_LIST NULL 2643READ_ONLY YES 2644COMMAND_LINE_ARGUMENT REQUIRED 2645VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES 2646VARIABLE_SCOPE GLOBAL 2647VARIABLE_TYPE BIGINT 2648VARIABLE_COMMENT Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing. 2649NUMERIC_MIN_VALUE -1 2650NUMERIC_MAX_VALUE 104857600 2651NUMERIC_BLOCK_SIZE 1 2652ENUM_VALUE_LIST NULL 2653READ_ONLY YES 2654COMMAND_LINE_ARGUMENT REQUIRED 2655VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 2656VARIABLE_SCOPE GLOBAL 2657VARIABLE_TYPE BIGINT UNSIGNED 2658VARIABLE_COMMENT Maximum number of rwlock instruments. 2659NUMERIC_MIN_VALUE 0 2660NUMERIC_MAX_VALUE 256 2661NUMERIC_BLOCK_SIZE 1 2662ENUM_VALUE_LIST NULL 2663READ_ONLY YES 2664COMMAND_LINE_ARGUMENT REQUIRED 2665VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES 2666VARIABLE_SCOPE GLOBAL 2667VARIABLE_TYPE BIGINT 2668VARIABLE_COMMENT Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing. 2669NUMERIC_MIN_VALUE -1 2670NUMERIC_MAX_VALUE 104857600 2671NUMERIC_BLOCK_SIZE 1 2672ENUM_VALUE_LIST NULL 2673READ_ONLY YES 2674COMMAND_LINE_ARGUMENT REQUIRED 2675VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES 2676VARIABLE_SCOPE GLOBAL 2677VARIABLE_TYPE BIGINT UNSIGNED 2678VARIABLE_COMMENT Maximum number of socket instruments. 2679NUMERIC_MIN_VALUE 0 2680NUMERIC_MAX_VALUE 256 2681NUMERIC_BLOCK_SIZE 1 2682ENUM_VALUE_LIST NULL 2683READ_ONLY YES 2684COMMAND_LINE_ARGUMENT REQUIRED 2685VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES 2686VARIABLE_SCOPE GLOBAL 2687VARIABLE_TYPE BIGINT 2688VARIABLE_COMMENT Maximum number of opened instrumented sockets. Use 0 to disable, -1 for automated sizing. 2689NUMERIC_MIN_VALUE -1 2690NUMERIC_MAX_VALUE 1048576 2691NUMERIC_BLOCK_SIZE 1 2692ENUM_VALUE_LIST NULL 2693READ_ONLY YES 2694COMMAND_LINE_ARGUMENT REQUIRED 2695VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES 2696VARIABLE_SCOPE GLOBAL 2697VARIABLE_TYPE BIGINT UNSIGNED 2698VARIABLE_COMMENT Maximum number of stage instruments. 2699NUMERIC_MIN_VALUE 0 2700NUMERIC_MAX_VALUE 256 2701NUMERIC_BLOCK_SIZE 1 2702ENUM_VALUE_LIST NULL 2703READ_ONLY YES 2704COMMAND_LINE_ARGUMENT REQUIRED 2705VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES 2706VARIABLE_SCOPE GLOBAL 2707VARIABLE_TYPE BIGINT UNSIGNED 2708VARIABLE_COMMENT Maximum number of statement instruments. 2709NUMERIC_MIN_VALUE 0 2710NUMERIC_MAX_VALUE 256 2711NUMERIC_BLOCK_SIZE 1 2712ENUM_VALUE_LIST NULL 2713READ_ONLY YES 2714COMMAND_LINE_ARGUMENT REQUIRED 2715VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES 2716VARIABLE_SCOPE GLOBAL 2717VARIABLE_TYPE BIGINT 2718VARIABLE_COMMENT Maximum number of opened instrumented tables. Use 0 to disable, -1 for automated sizing. 2719NUMERIC_MIN_VALUE -1 2720NUMERIC_MAX_VALUE 1048576 2721NUMERIC_BLOCK_SIZE 1 2722ENUM_VALUE_LIST NULL 2723READ_ONLY YES 2724COMMAND_LINE_ARGUMENT REQUIRED 2725VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES 2726VARIABLE_SCOPE GLOBAL 2727VARIABLE_TYPE BIGINT 2728VARIABLE_COMMENT Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing. 2729NUMERIC_MIN_VALUE -1 2730NUMERIC_MAX_VALUE 1048576 2731NUMERIC_BLOCK_SIZE 1 2732ENUM_VALUE_LIST NULL 2733READ_ONLY YES 2734COMMAND_LINE_ARGUMENT REQUIRED 2735VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 2736VARIABLE_SCOPE GLOBAL 2737VARIABLE_TYPE BIGINT UNSIGNED 2738VARIABLE_COMMENT Maximum number of thread instruments. 2739NUMERIC_MIN_VALUE 0 2740NUMERIC_MAX_VALUE 256 2741NUMERIC_BLOCK_SIZE 1 2742ENUM_VALUE_LIST NULL 2743READ_ONLY YES 2744COMMAND_LINE_ARGUMENT REQUIRED 2745VARIABLE_NAME PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES 2746VARIABLE_SCOPE GLOBAL 2747VARIABLE_TYPE BIGINT 2748VARIABLE_COMMENT Maximum number of instrumented threads. Use 0 to disable, -1 for automated sizing. 2749NUMERIC_MIN_VALUE -1 2750NUMERIC_MAX_VALUE 1048576 2751NUMERIC_BLOCK_SIZE 1 2752ENUM_VALUE_LIST NULL 2753READ_ONLY YES 2754COMMAND_LINE_ARGUMENT REQUIRED 2755VARIABLE_NAME PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE 2756VARIABLE_SCOPE GLOBAL 2757VARIABLE_TYPE BIGINT 2758VARIABLE_COMMENT Size of session attribute string buffer per thread. Use 0 to disable, -1 for automated sizing. 2759NUMERIC_MIN_VALUE -1 2760NUMERIC_MAX_VALUE 1048576 2761NUMERIC_BLOCK_SIZE 1 2762ENUM_VALUE_LIST NULL 2763READ_ONLY YES 2764COMMAND_LINE_ARGUMENT REQUIRED 2765VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE 2766VARIABLE_SCOPE GLOBAL 2767VARIABLE_TYPE BIGINT UNSIGNED 2768VARIABLE_COMMENT Maximum number of rows in SETUP_ACTORS. 2769NUMERIC_MIN_VALUE 0 2770NUMERIC_MAX_VALUE 1024 2771NUMERIC_BLOCK_SIZE 1 2772ENUM_VALUE_LIST NULL 2773READ_ONLY YES 2774COMMAND_LINE_ARGUMENT REQUIRED 2775VARIABLE_NAME PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE 2776VARIABLE_SCOPE GLOBAL 2777VARIABLE_TYPE BIGINT UNSIGNED 2778VARIABLE_COMMENT Maximum number of rows in SETUP_OBJECTS. 2779NUMERIC_MIN_VALUE 0 2780NUMERIC_MAX_VALUE 1048576 2781NUMERIC_BLOCK_SIZE 1 2782ENUM_VALUE_LIST NULL 2783READ_ONLY YES 2784COMMAND_LINE_ARGUMENT REQUIRED 2785VARIABLE_NAME PERFORMANCE_SCHEMA_USERS_SIZE 2786VARIABLE_SCOPE GLOBAL 2787VARIABLE_TYPE BIGINT 2788VARIABLE_COMMENT Maximum number of instrumented users. Use 0 to disable, -1 for automated sizing. 2789NUMERIC_MIN_VALUE -1 2790NUMERIC_MAX_VALUE 1048576 2791NUMERIC_BLOCK_SIZE 1 2792ENUM_VALUE_LIST NULL 2793READ_ONLY YES 2794COMMAND_LINE_ARGUMENT REQUIRED 2795VARIABLE_NAME PID_FILE 2796VARIABLE_SCOPE GLOBAL 2797VARIABLE_TYPE VARCHAR 2798VARIABLE_COMMENT Pid file used by safe_mysqld 2799NUMERIC_MIN_VALUE NULL 2800NUMERIC_MAX_VALUE NULL 2801NUMERIC_BLOCK_SIZE NULL 2802ENUM_VALUE_LIST NULL 2803READ_ONLY YES 2804COMMAND_LINE_ARGUMENT REQUIRED 2805VARIABLE_NAME PLUGIN_DIR 2806VARIABLE_SCOPE GLOBAL 2807VARIABLE_TYPE VARCHAR 2808VARIABLE_COMMENT Directory for plugins 2809NUMERIC_MIN_VALUE NULL 2810NUMERIC_MAX_VALUE NULL 2811NUMERIC_BLOCK_SIZE NULL 2812ENUM_VALUE_LIST NULL 2813READ_ONLY YES 2814COMMAND_LINE_ARGUMENT REQUIRED 2815VARIABLE_NAME PLUGIN_MATURITY 2816VARIABLE_SCOPE GLOBAL 2817VARIABLE_TYPE ENUM 2818VARIABLE_COMMENT The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded 2819NUMERIC_MIN_VALUE NULL 2820NUMERIC_MAX_VALUE NULL 2821NUMERIC_BLOCK_SIZE NULL 2822ENUM_VALUE_LIST unknown,experimental,alpha,beta,gamma,stable 2823READ_ONLY YES 2824COMMAND_LINE_ARGUMENT REQUIRED 2825VARIABLE_NAME PORT 2826VARIABLE_SCOPE GLOBAL 2827VARIABLE_TYPE INT UNSIGNED 2828VARIABLE_COMMENT Port number to use for connection or 0 to default to, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306), whatever comes first 2829NUMERIC_MIN_VALUE 0 2830NUMERIC_MAX_VALUE 4294967295 2831NUMERIC_BLOCK_SIZE 1 2832ENUM_VALUE_LIST NULL 2833READ_ONLY YES 2834COMMAND_LINE_ARGUMENT REQUIRED 2835VARIABLE_NAME PRELOAD_BUFFER_SIZE 2836VARIABLE_SCOPE SESSION 2837VARIABLE_TYPE BIGINT UNSIGNED 2838VARIABLE_COMMENT The size of the buffer that is allocated when preloading indexes 2839NUMERIC_MIN_VALUE 1024 2840NUMERIC_MAX_VALUE 1073741824 2841NUMERIC_BLOCK_SIZE 1 2842ENUM_VALUE_LIST NULL 2843READ_ONLY NO 2844COMMAND_LINE_ARGUMENT REQUIRED 2845VARIABLE_NAME PROFILING 2846VARIABLE_SCOPE SESSION 2847VARIABLE_TYPE BOOLEAN 2848VARIABLE_COMMENT If set to 1 (0 is default), statement profiling will be enabled. See SHOW PROFILES and SHOW PROFILE. 2849NUMERIC_MIN_VALUE NULL 2850NUMERIC_MAX_VALUE NULL 2851NUMERIC_BLOCK_SIZE NULL 2852ENUM_VALUE_LIST OFF,ON 2853READ_ONLY NO 2854COMMAND_LINE_ARGUMENT NULL 2855VARIABLE_NAME PROFILING_HISTORY_SIZE 2856VARIABLE_SCOPE SESSION 2857VARIABLE_TYPE BIGINT UNSIGNED 2858VARIABLE_COMMENT Number of statements about which profiling information is maintained. If set to 0, no profiles are stored. See SHOW PROFILES. 2859NUMERIC_MIN_VALUE 0 2860NUMERIC_MAX_VALUE 100 2861NUMERIC_BLOCK_SIZE 1 2862ENUM_VALUE_LIST NULL 2863READ_ONLY NO 2864COMMAND_LINE_ARGUMENT REQUIRED 2865VARIABLE_NAME PROGRESS_REPORT_TIME 2866VARIABLE_SCOPE SESSION 2867VARIABLE_TYPE BIGINT UNSIGNED 2868VARIABLE_COMMENT Seconds between sending progress reports to the client for time-consuming statements. Set to 0 to disable progress reporting. 2869NUMERIC_MIN_VALUE 0 2870NUMERIC_MAX_VALUE 4294967295 2871NUMERIC_BLOCK_SIZE 1 2872ENUM_VALUE_LIST NULL 2873READ_ONLY NO 2874COMMAND_LINE_ARGUMENT REQUIRED 2875VARIABLE_NAME PROTOCOL_VERSION 2876VARIABLE_SCOPE GLOBAL 2877VARIABLE_TYPE INT UNSIGNED 2878VARIABLE_COMMENT The version of the client/server protocol used by the MariaDB server 2879NUMERIC_MIN_VALUE 0 2880NUMERIC_MAX_VALUE 4294967295 2881NUMERIC_BLOCK_SIZE 1 2882ENUM_VALUE_LIST NULL 2883READ_ONLY YES 2884COMMAND_LINE_ARGUMENT NULL 2885VARIABLE_NAME PROXY_PROTOCOL_NETWORKS 2886VARIABLE_SCOPE GLOBAL 2887VARIABLE_TYPE VARCHAR 2888VARIABLE_COMMENT Enable proxy protocol for these source networks. The syntax is a comma separated list of IPv4 and IPv6 networks. If the network doesn't contain mask, it is considered to be a single host. "*" represents all networks and must the only directive on the line. String "localhost" represents non-TCP local connections (Unix domain socket, Windows named pipe or shared memory). 2889NUMERIC_MIN_VALUE NULL 2890NUMERIC_MAX_VALUE NULL 2891NUMERIC_BLOCK_SIZE NULL 2892ENUM_VALUE_LIST NULL 2893READ_ONLY NO 2894COMMAND_LINE_ARGUMENT REQUIRED 2895VARIABLE_NAME PROXY_USER 2896VARIABLE_SCOPE SESSION ONLY 2897VARIABLE_TYPE VARCHAR 2898VARIABLE_COMMENT The proxy user account name used when logging in 2899NUMERIC_MIN_VALUE NULL 2900NUMERIC_MAX_VALUE NULL 2901NUMERIC_BLOCK_SIZE NULL 2902ENUM_VALUE_LIST NULL 2903READ_ONLY YES 2904COMMAND_LINE_ARGUMENT NULL 2905VARIABLE_NAME PSEUDO_SLAVE_MODE 2906VARIABLE_SCOPE SESSION ONLY 2907VARIABLE_TYPE BOOLEAN 2908VARIABLE_COMMENT SET pseudo_slave_mode= 0,1 are commands that mysqlbinlog adds to beginning and end of binary log dumps. While zero value indeed disables, the actual enabling of the slave applier execution mode is done implicitly when a Format_description_event is sent through the session. 2909NUMERIC_MIN_VALUE NULL 2910NUMERIC_MAX_VALUE NULL 2911NUMERIC_BLOCK_SIZE NULL 2912ENUM_VALUE_LIST OFF,ON 2913READ_ONLY NO 2914COMMAND_LINE_ARGUMENT NULL 2915VARIABLE_NAME PSEUDO_THREAD_ID 2916VARIABLE_SCOPE SESSION ONLY 2917VARIABLE_TYPE BIGINT UNSIGNED 2918VARIABLE_COMMENT This variable is for internal server use 2919NUMERIC_MIN_VALUE 0 2920NUMERIC_MAX_VALUE 18446744073709551615 2921NUMERIC_BLOCK_SIZE 1 2922ENUM_VALUE_LIST NULL 2923READ_ONLY NO 2924COMMAND_LINE_ARGUMENT NULL 2925VARIABLE_NAME QUERY_ALLOC_BLOCK_SIZE 2926VARIABLE_SCOPE SESSION 2927VARIABLE_TYPE BIGINT UNSIGNED 2928VARIABLE_COMMENT Allocation block size for query parsing and execution 2929NUMERIC_MIN_VALUE 1024 2930NUMERIC_MAX_VALUE 4294967295 2931NUMERIC_BLOCK_SIZE 1024 2932ENUM_VALUE_LIST NULL 2933READ_ONLY NO 2934COMMAND_LINE_ARGUMENT REQUIRED 2935VARIABLE_NAME QUERY_CACHE_LIMIT 2936VARIABLE_SCOPE GLOBAL 2937VARIABLE_TYPE BIGINT UNSIGNED 2938VARIABLE_COMMENT Don't cache results that are bigger than this 2939NUMERIC_MIN_VALUE 0 2940NUMERIC_MAX_VALUE 4294967295 2941NUMERIC_BLOCK_SIZE 1 2942ENUM_VALUE_LIST NULL 2943READ_ONLY NO 2944COMMAND_LINE_ARGUMENT REQUIRED 2945VARIABLE_NAME QUERY_CACHE_MIN_RES_UNIT 2946VARIABLE_SCOPE GLOBAL 2947VARIABLE_TYPE BIGINT UNSIGNED 2948VARIABLE_COMMENT The minimum size for blocks allocated by the query cache 2949NUMERIC_MIN_VALUE 0 2950NUMERIC_MAX_VALUE 4294967295 2951NUMERIC_BLOCK_SIZE 8 2952ENUM_VALUE_LIST NULL 2953READ_ONLY NO 2954COMMAND_LINE_ARGUMENT REQUIRED 2955VARIABLE_NAME QUERY_CACHE_SIZE 2956VARIABLE_SCOPE GLOBAL 2957VARIABLE_TYPE BIGINT UNSIGNED 2958VARIABLE_COMMENT The memory allocated to store results from old queries 2959NUMERIC_MIN_VALUE 0 2960NUMERIC_MAX_VALUE 18446744073709551615 2961NUMERIC_BLOCK_SIZE 1024 2962ENUM_VALUE_LIST NULL 2963READ_ONLY NO 2964COMMAND_LINE_ARGUMENT REQUIRED 2965VARIABLE_NAME QUERY_CACHE_STRIP_COMMENTS 2966VARIABLE_SCOPE SESSION 2967VARIABLE_TYPE BOOLEAN 2968VARIABLE_COMMENT Strip all comments from a query before storing it in the query cache 2969NUMERIC_MIN_VALUE NULL 2970NUMERIC_MAX_VALUE NULL 2971NUMERIC_BLOCK_SIZE NULL 2972ENUM_VALUE_LIST OFF,ON 2973READ_ONLY NO 2974COMMAND_LINE_ARGUMENT OPTIONAL 2975VARIABLE_NAME QUERY_CACHE_TYPE 2976VARIABLE_SCOPE SESSION 2977VARIABLE_TYPE ENUM 2978VARIABLE_COMMENT OFF = Don't cache or retrieve results. ON = Cache all results except SELECT SQL_NO_CACHE ... queries. DEMAND = Cache only SELECT SQL_CACHE ... queries 2979NUMERIC_MIN_VALUE NULL 2980NUMERIC_MAX_VALUE NULL 2981NUMERIC_BLOCK_SIZE NULL 2982ENUM_VALUE_LIST OFF,ON,DEMAND 2983READ_ONLY NO 2984COMMAND_LINE_ARGUMENT REQUIRED 2985VARIABLE_NAME QUERY_CACHE_WLOCK_INVALIDATE 2986VARIABLE_SCOPE SESSION 2987VARIABLE_TYPE BOOLEAN 2988VARIABLE_COMMENT Invalidate queries in query cache on LOCK for write 2989NUMERIC_MIN_VALUE NULL 2990NUMERIC_MAX_VALUE NULL 2991NUMERIC_BLOCK_SIZE NULL 2992ENUM_VALUE_LIST OFF,ON 2993READ_ONLY NO 2994COMMAND_LINE_ARGUMENT OPTIONAL 2995VARIABLE_NAME QUERY_PREALLOC_SIZE 2996VARIABLE_SCOPE SESSION 2997VARIABLE_TYPE BIGINT UNSIGNED 2998VARIABLE_COMMENT Persistent buffer for query parsing and execution 2999NUMERIC_MIN_VALUE 1024 3000NUMERIC_MAX_VALUE 4294967295 3001NUMERIC_BLOCK_SIZE 1024 3002ENUM_VALUE_LIST NULL 3003READ_ONLY NO 3004COMMAND_LINE_ARGUMENT REQUIRED 3005VARIABLE_NAME RAND_SEED1 3006VARIABLE_SCOPE SESSION ONLY 3007VARIABLE_TYPE BIGINT UNSIGNED 3008VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes 3009NUMERIC_MIN_VALUE 0 3010NUMERIC_MAX_VALUE 18446744073709551615 3011NUMERIC_BLOCK_SIZE 1 3012ENUM_VALUE_LIST NULL 3013READ_ONLY NO 3014COMMAND_LINE_ARGUMENT NULL 3015VARIABLE_NAME RAND_SEED2 3016VARIABLE_SCOPE SESSION ONLY 3017VARIABLE_TYPE BIGINT UNSIGNED 3018VARIABLE_COMMENT Sets the internal state of the RAND() generator for replication purposes 3019NUMERIC_MIN_VALUE 0 3020NUMERIC_MAX_VALUE 18446744073709551615 3021NUMERIC_BLOCK_SIZE 1 3022ENUM_VALUE_LIST NULL 3023READ_ONLY NO 3024COMMAND_LINE_ARGUMENT NULL 3025VARIABLE_NAME RANGE_ALLOC_BLOCK_SIZE 3026VARIABLE_SCOPE SESSION 3027VARIABLE_TYPE BIGINT UNSIGNED 3028VARIABLE_COMMENT Allocation block size for storing ranges during optimization 3029NUMERIC_MIN_VALUE 4096 3030NUMERIC_MAX_VALUE 4294967295 3031NUMERIC_BLOCK_SIZE 1024 3032ENUM_VALUE_LIST NULL 3033READ_ONLY NO 3034COMMAND_LINE_ARGUMENT REQUIRED 3035VARIABLE_NAME READ_BINLOG_SPEED_LIMIT 3036VARIABLE_SCOPE GLOBAL 3037VARIABLE_TYPE BIGINT UNSIGNED 3038VARIABLE_COMMENT Maximum speed(KB/s) to read binlog from master (0 = no limit) 3039NUMERIC_MIN_VALUE 0 3040NUMERIC_MAX_VALUE 18446744073709551615 3041NUMERIC_BLOCK_SIZE 1 3042ENUM_VALUE_LIST NULL 3043READ_ONLY NO 3044COMMAND_LINE_ARGUMENT REQUIRED 3045VARIABLE_NAME READ_BUFFER_SIZE 3046VARIABLE_SCOPE SESSION 3047VARIABLE_TYPE BIGINT UNSIGNED 3048VARIABLE_COMMENT Each thread that does a sequential scan allocates a buffer of this size for each table it scans. If you do many sequential scans, you may want to increase this value 3049NUMERIC_MIN_VALUE 8192 3050NUMERIC_MAX_VALUE 2147483647 3051NUMERIC_BLOCK_SIZE 4096 3052ENUM_VALUE_LIST NULL 3053READ_ONLY NO 3054COMMAND_LINE_ARGUMENT REQUIRED 3055VARIABLE_NAME READ_ONLY 3056VARIABLE_SCOPE GLOBAL 3057VARIABLE_TYPE BOOLEAN 3058VARIABLE_COMMENT Make all non-temporary tables read-only, with the exception for replication (slave) threads and users with the SUPER privilege 3059NUMERIC_MIN_VALUE NULL 3060NUMERIC_MAX_VALUE NULL 3061NUMERIC_BLOCK_SIZE NULL 3062ENUM_VALUE_LIST OFF,ON 3063READ_ONLY NO 3064COMMAND_LINE_ARGUMENT OPTIONAL 3065VARIABLE_NAME READ_RND_BUFFER_SIZE 3066VARIABLE_SCOPE SESSION 3067VARIABLE_TYPE BIGINT UNSIGNED 3068VARIABLE_COMMENT When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks 3069NUMERIC_MIN_VALUE 1 3070NUMERIC_MAX_VALUE 2147483647 3071NUMERIC_BLOCK_SIZE 1 3072ENUM_VALUE_LIST NULL 3073READ_ONLY NO 3074COMMAND_LINE_ARGUMENT REQUIRED 3075VARIABLE_NAME RELAY_LOG 3076VARIABLE_SCOPE GLOBAL 3077VARIABLE_TYPE VARCHAR 3078VARIABLE_COMMENT The location and name to use for relay logs. 3079NUMERIC_MIN_VALUE NULL 3080NUMERIC_MAX_VALUE NULL 3081NUMERIC_BLOCK_SIZE NULL 3082ENUM_VALUE_LIST NULL 3083READ_ONLY YES 3084COMMAND_LINE_ARGUMENT REQUIRED 3085VARIABLE_NAME RELAY_LOG_BASENAME 3086VARIABLE_SCOPE GLOBAL 3087VARIABLE_TYPE VARCHAR 3088VARIABLE_COMMENT The full path of the relay log file names, excluding the extension. 3089NUMERIC_MIN_VALUE NULL 3090NUMERIC_MAX_VALUE NULL 3091NUMERIC_BLOCK_SIZE NULL 3092ENUM_VALUE_LIST NULL 3093READ_ONLY YES 3094COMMAND_LINE_ARGUMENT NULL 3095VARIABLE_NAME RELAY_LOG_INDEX 3096VARIABLE_SCOPE GLOBAL 3097VARIABLE_TYPE VARCHAR 3098VARIABLE_COMMENT The location and name to use for the file that keeps a list of the last relay logs. 3099NUMERIC_MIN_VALUE NULL 3100NUMERIC_MAX_VALUE NULL 3101NUMERIC_BLOCK_SIZE NULL 3102ENUM_VALUE_LIST NULL 3103READ_ONLY YES 3104COMMAND_LINE_ARGUMENT NULL 3105VARIABLE_NAME RELAY_LOG_INFO_FILE 3106VARIABLE_SCOPE GLOBAL 3107VARIABLE_TYPE VARCHAR 3108VARIABLE_COMMENT The location and name of the file that remembers where the SQL replication thread is in the relay logs. 3109NUMERIC_MIN_VALUE NULL 3110NUMERIC_MAX_VALUE NULL 3111NUMERIC_BLOCK_SIZE NULL 3112ENUM_VALUE_LIST NULL 3113READ_ONLY YES 3114COMMAND_LINE_ARGUMENT REQUIRED 3115VARIABLE_NAME RELAY_LOG_PURGE 3116VARIABLE_SCOPE GLOBAL 3117VARIABLE_TYPE BOOLEAN 3118VARIABLE_COMMENT if disabled - do not purge relay logs. if enabled - purge them as soon as they are no more needed. 3119NUMERIC_MIN_VALUE NULL 3120NUMERIC_MAX_VALUE NULL 3121NUMERIC_BLOCK_SIZE NULL 3122ENUM_VALUE_LIST OFF,ON 3123READ_ONLY NO 3124COMMAND_LINE_ARGUMENT OPTIONAL 3125VARIABLE_NAME RELAY_LOG_RECOVERY 3126VARIABLE_SCOPE GLOBAL 3127VARIABLE_TYPE BOOLEAN 3128VARIABLE_COMMENT Enables automatic relay log recovery right after the database startup, which means that the IO Thread starts re-fetching from the master right after the last transaction processed. 3129NUMERIC_MIN_VALUE NULL 3130NUMERIC_MAX_VALUE NULL 3131NUMERIC_BLOCK_SIZE NULL 3132ENUM_VALUE_LIST OFF,ON 3133READ_ONLY NO 3134COMMAND_LINE_ARGUMENT OPTIONAL 3135VARIABLE_NAME RELAY_LOG_SPACE_LIMIT 3136VARIABLE_SCOPE GLOBAL 3137VARIABLE_TYPE BIGINT UNSIGNED 3138VARIABLE_COMMENT Maximum space to use for all relay logs 3139NUMERIC_MIN_VALUE 0 3140NUMERIC_MAX_VALUE 18446744073709551615 3141NUMERIC_BLOCK_SIZE 1 3142ENUM_VALUE_LIST NULL 3143READ_ONLY YES 3144COMMAND_LINE_ARGUMENT REQUIRED 3145VARIABLE_NAME REPLICATE_ANNOTATE_ROW_EVENTS 3146VARIABLE_SCOPE GLOBAL 3147VARIABLE_TYPE BOOLEAN 3148VARIABLE_COMMENT Tells the slave to write annotate rows events received from the master to its own binary log. Ignored if log_slave_updates is not set 3149NUMERIC_MIN_VALUE NULL 3150NUMERIC_MAX_VALUE NULL 3151NUMERIC_BLOCK_SIZE NULL 3152ENUM_VALUE_LIST OFF,ON 3153READ_ONLY YES 3154COMMAND_LINE_ARGUMENT OPTIONAL 3155VARIABLE_NAME REPLICATE_DO_DB 3156VARIABLE_SCOPE GLOBAL 3157VARIABLE_TYPE VARCHAR 3158VARIABLE_COMMENT Tell the slave to restrict replication to updates of tables whose names appear in the comma-separated list. For statement-based replication, only the default database (that is, the one selected by USE) is considered, not any explicitly mentioned tables in the query. For row-based replication, the actual names of table(s) being updated are checked. 3159NUMERIC_MIN_VALUE NULL 3160NUMERIC_MAX_VALUE NULL 3161NUMERIC_BLOCK_SIZE NULL 3162ENUM_VALUE_LIST NULL 3163READ_ONLY NO 3164COMMAND_LINE_ARGUMENT NULL 3165VARIABLE_NAME REPLICATE_DO_TABLE 3166VARIABLE_SCOPE GLOBAL 3167VARIABLE_TYPE VARCHAR 3168VARIABLE_COMMENT Tells the slave to restrict replication to tables in the comma-separated list. 3169NUMERIC_MIN_VALUE NULL 3170NUMERIC_MAX_VALUE NULL 3171NUMERIC_BLOCK_SIZE NULL 3172ENUM_VALUE_LIST NULL 3173READ_ONLY NO 3174COMMAND_LINE_ARGUMENT NULL 3175VARIABLE_NAME REPLICATE_EVENTS_MARKED_FOR_SKIP 3176VARIABLE_SCOPE GLOBAL 3177VARIABLE_TYPE ENUM 3178VARIABLE_COMMENT Whether the slave should replicate events that were created with @@skip_replication=1 on the master. Default REPLICATE (no events are skipped). Other values are FILTER_ON_SLAVE (events will be sent by the master but ignored by the slave) and FILTER_ON_MASTER (events marked with @@skip_replication=1 will be filtered on the master and never be sent to the slave). 3179NUMERIC_MIN_VALUE NULL 3180NUMERIC_MAX_VALUE NULL 3181NUMERIC_BLOCK_SIZE NULL 3182ENUM_VALUE_LIST REPLICATE,FILTER_ON_SLAVE,FILTER_ON_MASTER 3183READ_ONLY NO 3184COMMAND_LINE_ARGUMENT REQUIRED 3185VARIABLE_NAME REPLICATE_IGNORE_DB 3186VARIABLE_SCOPE GLOBAL 3187VARIABLE_TYPE VARCHAR 3188VARIABLE_COMMENT Tell the slave to restrict replication to updates of tables whose names do not appear in the comma-separated list. For statement-based replication, only the default database (that is, the one selected by USE) is considered, not any explicitly mentioned tables in the query. For row-based replication, the actual names of table(s) being updated are checked. 3189NUMERIC_MIN_VALUE NULL 3190NUMERIC_MAX_VALUE NULL 3191NUMERIC_BLOCK_SIZE NULL 3192ENUM_VALUE_LIST NULL 3193READ_ONLY NO 3194COMMAND_LINE_ARGUMENT NULL 3195VARIABLE_NAME REPLICATE_IGNORE_TABLE 3196VARIABLE_SCOPE GLOBAL 3197VARIABLE_TYPE VARCHAR 3198VARIABLE_COMMENT Tells the slave thread not to replicate any statement that updates the specified table, even if any other tables might be updated by the same statement. 3199NUMERIC_MIN_VALUE NULL 3200NUMERIC_MAX_VALUE NULL 3201NUMERIC_BLOCK_SIZE NULL 3202ENUM_VALUE_LIST NULL 3203READ_ONLY NO 3204COMMAND_LINE_ARGUMENT NULL 3205VARIABLE_NAME REPLICATE_WILD_DO_TABLE 3206VARIABLE_SCOPE GLOBAL 3207VARIABLE_TYPE VARCHAR 3208VARIABLE_COMMENT Tells the slave thread to restrict replication to statements where any of the updated tables match the specified database and table name patterns. 3209NUMERIC_MIN_VALUE NULL 3210NUMERIC_MAX_VALUE NULL 3211NUMERIC_BLOCK_SIZE NULL 3212ENUM_VALUE_LIST NULL 3213READ_ONLY NO 3214COMMAND_LINE_ARGUMENT NULL 3215VARIABLE_NAME REPLICATE_WILD_IGNORE_TABLE 3216VARIABLE_SCOPE GLOBAL 3217VARIABLE_TYPE VARCHAR 3218VARIABLE_COMMENT Tells the slave thread to not replicate to the tables that match the given wildcard pattern. 3219NUMERIC_MIN_VALUE NULL 3220NUMERIC_MAX_VALUE NULL 3221NUMERIC_BLOCK_SIZE NULL 3222ENUM_VALUE_LIST NULL 3223READ_ONLY NO 3224COMMAND_LINE_ARGUMENT NULL 3225VARIABLE_NAME REPORT_HOST 3226VARIABLE_SCOPE GLOBAL 3227VARIABLE_TYPE VARCHAR 3228VARIABLE_COMMENT Hostname or IP of the slave to be reported to the master during slave registration. Will appear in the output of SHOW SLAVE HOSTS. Leave unset if you do not want the slave to register itself with the master. Note that it is not sufficient for the master to simply read the IP of the slave off the socket once the slave connects. Due to NAT and other routing issues, that IP may not be valid for connecting to the slave from the master or other hosts 3229NUMERIC_MIN_VALUE NULL 3230NUMERIC_MAX_VALUE NULL 3231NUMERIC_BLOCK_SIZE NULL 3232ENUM_VALUE_LIST NULL 3233READ_ONLY YES 3234COMMAND_LINE_ARGUMENT REQUIRED 3235VARIABLE_NAME REPORT_PASSWORD 3236VARIABLE_SCOPE GLOBAL 3237VARIABLE_TYPE VARCHAR 3238VARIABLE_COMMENT The account password of the slave to be reported to the master during slave registration 3239NUMERIC_MIN_VALUE NULL 3240NUMERIC_MAX_VALUE NULL 3241NUMERIC_BLOCK_SIZE NULL 3242ENUM_VALUE_LIST NULL 3243READ_ONLY YES 3244COMMAND_LINE_ARGUMENT REQUIRED 3245VARIABLE_NAME REPORT_PORT 3246VARIABLE_SCOPE GLOBAL 3247VARIABLE_TYPE INT UNSIGNED 3248VARIABLE_COMMENT Port for connecting to slave reported to the master during slave registration. Set it only if the slave is listening on a non-default port or if you have a special tunnel from the master or other clients to the slave. If not sure, leave this option unset 3249NUMERIC_MIN_VALUE 0 3250NUMERIC_MAX_VALUE 4294967295 3251NUMERIC_BLOCK_SIZE 1 3252ENUM_VALUE_LIST NULL 3253READ_ONLY YES 3254COMMAND_LINE_ARGUMENT REQUIRED 3255VARIABLE_NAME REPORT_USER 3256VARIABLE_SCOPE GLOBAL 3257VARIABLE_TYPE VARCHAR 3258VARIABLE_COMMENT The account user name of the slave to be reported to the master during slave registration 3259NUMERIC_MIN_VALUE NULL 3260NUMERIC_MAX_VALUE NULL 3261NUMERIC_BLOCK_SIZE NULL 3262ENUM_VALUE_LIST NULL 3263READ_ONLY YES 3264COMMAND_LINE_ARGUMENT REQUIRED 3265VARIABLE_NAME ROWID_MERGE_BUFF_SIZE 3266VARIABLE_SCOPE SESSION 3267VARIABLE_TYPE BIGINT UNSIGNED 3268VARIABLE_COMMENT The size of the buffers used [NOT] IN evaluation via partial matching 3269NUMERIC_MIN_VALUE 0 3270NUMERIC_MAX_VALUE 9223372036854775807 3271NUMERIC_BLOCK_SIZE 1 3272ENUM_VALUE_LIST NULL 3273READ_ONLY NO 3274COMMAND_LINE_ARGUMENT REQUIRED 3275VARIABLE_NAME RPL_SEMI_SYNC_MASTER_ENABLED 3276VARIABLE_SCOPE GLOBAL 3277VARIABLE_TYPE BOOLEAN 3278VARIABLE_COMMENT Enable semi-synchronous replication master (disabled by default). 3279NUMERIC_MIN_VALUE NULL 3280NUMERIC_MAX_VALUE NULL 3281NUMERIC_BLOCK_SIZE NULL 3282ENUM_VALUE_LIST OFF,ON 3283READ_ONLY NO 3284COMMAND_LINE_ARGUMENT OPTIONAL 3285VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TIMEOUT 3286VARIABLE_SCOPE GLOBAL 3287VARIABLE_TYPE BIGINT UNSIGNED 3288VARIABLE_COMMENT The timeout value (in ms) for semi-synchronous replication in the master 3289NUMERIC_MIN_VALUE 0 3290NUMERIC_MAX_VALUE 18446744073709551615 3291NUMERIC_BLOCK_SIZE 1 3292ENUM_VALUE_LIST NULL 3293READ_ONLY NO 3294COMMAND_LINE_ARGUMENT REQUIRED 3295VARIABLE_NAME RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 3296VARIABLE_SCOPE GLOBAL 3297VARIABLE_TYPE BIGINT UNSIGNED 3298VARIABLE_COMMENT The tracing level for semi-sync replication. 3299NUMERIC_MIN_VALUE 0 3300NUMERIC_MAX_VALUE 18446744073709551615 3301NUMERIC_BLOCK_SIZE 1 3302ENUM_VALUE_LIST NULL 3303READ_ONLY NO 3304COMMAND_LINE_ARGUMENT REQUIRED 3305VARIABLE_NAME RPL_SEMI_SYNC_MASTER_WAIT_NO_SLAVE 3306VARIABLE_SCOPE GLOBAL 3307VARIABLE_TYPE BOOLEAN 3308VARIABLE_COMMENT Wait until timeout when no semi-synchronous replication slave available (enabled by default). 3309NUMERIC_MIN_VALUE NULL 3310NUMERIC_MAX_VALUE NULL 3311NUMERIC_BLOCK_SIZE NULL 3312ENUM_VALUE_LIST OFF,ON 3313READ_ONLY NO 3314COMMAND_LINE_ARGUMENT OPTIONAL 3315VARIABLE_NAME RPL_SEMI_SYNC_MASTER_WAIT_POINT 3316VARIABLE_SCOPE GLOBAL 3317VARIABLE_TYPE ENUM 3318VARIABLE_COMMENT Should transaction wait for semi-sync ack after having synced binlog, or after having committed in storage engine. 3319NUMERIC_MIN_VALUE NULL 3320NUMERIC_MAX_VALUE NULL 3321NUMERIC_BLOCK_SIZE NULL 3322ENUM_VALUE_LIST AFTER_SYNC,AFTER_COMMIT 3323READ_ONLY NO 3324COMMAND_LINE_ARGUMENT REQUIRED 3325VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_DELAY_MASTER 3326VARIABLE_SCOPE GLOBAL 3327VARIABLE_TYPE BOOLEAN 3328VARIABLE_COMMENT Only write master info file when ack is needed. 3329NUMERIC_MIN_VALUE NULL 3330NUMERIC_MAX_VALUE NULL 3331NUMERIC_BLOCK_SIZE NULL 3332ENUM_VALUE_LIST OFF,ON 3333READ_ONLY NO 3334COMMAND_LINE_ARGUMENT OPTIONAL 3335VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_ENABLED 3336VARIABLE_SCOPE GLOBAL 3337VARIABLE_TYPE BOOLEAN 3338VARIABLE_COMMENT Enable semi-synchronous replication slave (disabled by default). 3339NUMERIC_MIN_VALUE NULL 3340NUMERIC_MAX_VALUE NULL 3341NUMERIC_BLOCK_SIZE NULL 3342ENUM_VALUE_LIST OFF,ON 3343READ_ONLY NO 3344COMMAND_LINE_ARGUMENT OPTIONAL 3345VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_KILL_CONN_TIMEOUT 3346VARIABLE_SCOPE GLOBAL 3347VARIABLE_TYPE INT UNSIGNED 3348VARIABLE_COMMENT Timeout for the mysql connection used to kill the slave io_thread's connection on master. This timeout comes into play when stop slave is executed. 3349NUMERIC_MIN_VALUE 0 3350NUMERIC_MAX_VALUE 4294967295 3351NUMERIC_BLOCK_SIZE 1 3352ENUM_VALUE_LIST NULL 3353READ_ONLY NO 3354COMMAND_LINE_ARGUMENT OPTIONAL 3355VARIABLE_NAME RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL 3356VARIABLE_SCOPE GLOBAL 3357VARIABLE_TYPE BIGINT UNSIGNED 3358VARIABLE_COMMENT The tracing level for semi-sync replication. 3359NUMERIC_MIN_VALUE 0 3360NUMERIC_MAX_VALUE 18446744073709551615 3361NUMERIC_BLOCK_SIZE 1 3362ENUM_VALUE_LIST NULL 3363READ_ONLY NO 3364COMMAND_LINE_ARGUMENT REQUIRED 3365VARIABLE_NAME SECURE_AUTH 3366VARIABLE_SCOPE GLOBAL 3367VARIABLE_TYPE BOOLEAN 3368VARIABLE_COMMENT Disallow authentication for accounts that have old (pre-4.1) passwords 3369NUMERIC_MIN_VALUE NULL 3370NUMERIC_MAX_VALUE NULL 3371NUMERIC_BLOCK_SIZE NULL 3372ENUM_VALUE_LIST OFF,ON 3373READ_ONLY NO 3374COMMAND_LINE_ARGUMENT OPTIONAL 3375VARIABLE_NAME SECURE_FILE_PRIV 3376VARIABLE_SCOPE GLOBAL 3377VARIABLE_TYPE VARCHAR 3378VARIABLE_COMMENT Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within specified directory 3379NUMERIC_MIN_VALUE NULL 3380NUMERIC_MAX_VALUE NULL 3381NUMERIC_BLOCK_SIZE NULL 3382ENUM_VALUE_LIST NULL 3383READ_ONLY YES 3384COMMAND_LINE_ARGUMENT REQUIRED 3385VARIABLE_NAME SECURE_TIMESTAMP 3386VARIABLE_SCOPE GLOBAL 3387VARIABLE_TYPE ENUM 3388VARIABLE_COMMENT Restricts direct setting of a session timestamp. Possible levels are: YES - timestamp cannot deviate from the system clock, REPLICATION - replication thread can adjust timestamp to match the master's, SUPER - a user with this privilege and a replication thread can adjust timestamp, NO - historical behavior, anyone can modify session timestamp 3389NUMERIC_MIN_VALUE NULL 3390NUMERIC_MAX_VALUE NULL 3391NUMERIC_BLOCK_SIZE NULL 3392ENUM_VALUE_LIST NO,SUPER,REPLICATION,YES 3393READ_ONLY YES 3394COMMAND_LINE_ARGUMENT REQUIRED 3395VARIABLE_NAME SERVER_ID 3396VARIABLE_SCOPE SESSION 3397VARIABLE_TYPE BIGINT UNSIGNED 3398VARIABLE_COMMENT Uniquely identifies the server instance in the community of replication partners 3399NUMERIC_MIN_VALUE 1 3400NUMERIC_MAX_VALUE 4294967295 3401NUMERIC_BLOCK_SIZE 1 3402ENUM_VALUE_LIST NULL 3403READ_ONLY NO 3404COMMAND_LINE_ARGUMENT REQUIRED 3405VARIABLE_NAME SESSION_TRACK_SCHEMA 3406VARIABLE_SCOPE SESSION 3407VARIABLE_TYPE BOOLEAN 3408VARIABLE_COMMENT Track changes to the default schema. 3409NUMERIC_MIN_VALUE NULL 3410NUMERIC_MAX_VALUE NULL 3411NUMERIC_BLOCK_SIZE NULL 3412ENUM_VALUE_LIST OFF,ON 3413READ_ONLY NO 3414COMMAND_LINE_ARGUMENT OPTIONAL 3415VARIABLE_NAME SESSION_TRACK_STATE_CHANGE 3416VARIABLE_SCOPE SESSION 3417VARIABLE_TYPE BOOLEAN 3418VARIABLE_COMMENT Track changes to the session state. 3419NUMERIC_MIN_VALUE NULL 3420NUMERIC_MAX_VALUE NULL 3421NUMERIC_BLOCK_SIZE NULL 3422ENUM_VALUE_LIST OFF,ON 3423READ_ONLY NO 3424COMMAND_LINE_ARGUMENT OPTIONAL 3425VARIABLE_NAME SESSION_TRACK_SYSTEM_VARIABLES 3426VARIABLE_SCOPE SESSION 3427VARIABLE_TYPE VARCHAR 3428VARIABLE_COMMENT Track changes in registered system variables. 3429NUMERIC_MIN_VALUE NULL 3430NUMERIC_MAX_VALUE NULL 3431NUMERIC_BLOCK_SIZE NULL 3432ENUM_VALUE_LIST NULL 3433READ_ONLY NO 3434COMMAND_LINE_ARGUMENT REQUIRED 3435VARIABLE_NAME SESSION_TRACK_TRANSACTION_INFO 3436VARIABLE_SCOPE SESSION 3437VARIABLE_TYPE ENUM 3438VARIABLE_COMMENT Track changes to the transaction attributes. OFF to disable; STATE to track just transaction state (Is there an active transaction? Does it have any data? etc.); CHARACTERISTICS to track transaction state and report all statements needed to start a transaction with the same characteristics (isolation level, read only/read write,snapshot - but not any work done / data modified within the transaction). 3439NUMERIC_MIN_VALUE NULL 3440NUMERIC_MAX_VALUE NULL 3441NUMERIC_BLOCK_SIZE NULL 3442ENUM_VALUE_LIST OFF,STATE,CHARACTERISTICS 3443READ_ONLY NO 3444COMMAND_LINE_ARGUMENT REQUIRED 3445VARIABLE_NAME SKIP_EXTERNAL_LOCKING 3446VARIABLE_SCOPE GLOBAL 3447VARIABLE_TYPE BOOLEAN 3448VARIABLE_COMMENT Don't use system (external) locking 3449NUMERIC_MIN_VALUE NULL 3450NUMERIC_MAX_VALUE NULL 3451NUMERIC_BLOCK_SIZE NULL 3452ENUM_VALUE_LIST OFF,ON 3453READ_ONLY YES 3454COMMAND_LINE_ARGUMENT NULL 3455VARIABLE_NAME SKIP_NAME_RESOLVE 3456VARIABLE_SCOPE GLOBAL 3457VARIABLE_TYPE BOOLEAN 3458VARIABLE_COMMENT Don't resolve hostnames. All hostnames are IP's or 'localhost'. 3459NUMERIC_MIN_VALUE NULL 3460NUMERIC_MAX_VALUE NULL 3461NUMERIC_BLOCK_SIZE NULL 3462ENUM_VALUE_LIST OFF,ON 3463READ_ONLY YES 3464COMMAND_LINE_ARGUMENT OPTIONAL 3465VARIABLE_NAME SKIP_NETWORKING 3466VARIABLE_SCOPE GLOBAL 3467VARIABLE_TYPE BOOLEAN 3468VARIABLE_COMMENT Don't allow connection with TCP/IP 3469NUMERIC_MIN_VALUE NULL 3470NUMERIC_MAX_VALUE NULL 3471NUMERIC_BLOCK_SIZE NULL 3472ENUM_VALUE_LIST OFF,ON 3473READ_ONLY YES 3474COMMAND_LINE_ARGUMENT OPTIONAL 3475VARIABLE_NAME SKIP_PARALLEL_REPLICATION 3476VARIABLE_SCOPE SESSION ONLY 3477VARIABLE_TYPE BOOLEAN 3478VARIABLE_COMMENT If set when a transaction is written to the binlog, parallel apply of that transaction will be avoided on a slave where slave_parallel_mode is not "aggressive". Can be used to avoid unnecessary rollback and retry for transactions that are likely to cause a conflict if replicated in parallel. 3479NUMERIC_MIN_VALUE NULL 3480NUMERIC_MAX_VALUE NULL 3481NUMERIC_BLOCK_SIZE NULL 3482ENUM_VALUE_LIST OFF,ON 3483READ_ONLY NO 3484COMMAND_LINE_ARGUMENT NULL 3485VARIABLE_NAME SKIP_REPLICATION 3486VARIABLE_SCOPE SESSION ONLY 3487VARIABLE_TYPE BOOLEAN 3488VARIABLE_COMMENT Changes are logged into the binary log with the @@skip_replication flag set. Such events will not be replicated by slaves that run with --replicate-events-marked-for-skip set different from its default of REPLICATE. See Selectively skipping replication of binlog events for more information. 3489NUMERIC_MIN_VALUE NULL 3490NUMERIC_MAX_VALUE NULL 3491NUMERIC_BLOCK_SIZE NULL 3492ENUM_VALUE_LIST OFF,ON 3493READ_ONLY NO 3494COMMAND_LINE_ARGUMENT NULL 3495VARIABLE_NAME SKIP_SHOW_DATABASE 3496VARIABLE_SCOPE GLOBAL 3497VARIABLE_TYPE BOOLEAN 3498VARIABLE_COMMENT Don't allow 'SHOW DATABASE' commands 3499NUMERIC_MIN_VALUE NULL 3500NUMERIC_MAX_VALUE NULL 3501NUMERIC_BLOCK_SIZE NULL 3502ENUM_VALUE_LIST OFF,ON 3503READ_ONLY YES 3504COMMAND_LINE_ARGUMENT OPTIONAL 3505VARIABLE_NAME SLAVE_COMPRESSED_PROTOCOL 3506VARIABLE_SCOPE GLOBAL 3507VARIABLE_TYPE BOOLEAN 3508VARIABLE_COMMENT Use compression on master/slave protocol 3509NUMERIC_MIN_VALUE NULL 3510NUMERIC_MAX_VALUE NULL 3511NUMERIC_BLOCK_SIZE NULL 3512ENUM_VALUE_LIST OFF,ON 3513READ_ONLY NO 3514COMMAND_LINE_ARGUMENT OPTIONAL 3515VARIABLE_NAME SLAVE_DDL_EXEC_MODE 3516VARIABLE_SCOPE GLOBAL 3517VARIABLE_TYPE ENUM 3518VARIABLE_COMMENT How replication events should be executed. Legal values are STRICT and IDEMPOTENT (default). In IDEMPOTENT mode, replication will not stop for DDL operations that are idempotent. This means that CREATE TABLE is treated as CREATE TABLE OR REPLACE and DROP TABLE is treated as DROP TABLE IF EXISTS. 3519NUMERIC_MIN_VALUE NULL 3520NUMERIC_MAX_VALUE NULL 3521NUMERIC_BLOCK_SIZE NULL 3522ENUM_VALUE_LIST STRICT,IDEMPOTENT 3523READ_ONLY NO 3524COMMAND_LINE_ARGUMENT REQUIRED 3525VARIABLE_NAME SLAVE_DOMAIN_PARALLEL_THREADS 3526VARIABLE_SCOPE GLOBAL 3527VARIABLE_TYPE BIGINT UNSIGNED 3528VARIABLE_COMMENT Maximum number of parallel threads to use on slave for events in a single replication domain. When using multiple domains, this can be used to limit a single domain from grabbing all threads and thus stalling other domains. The default of 0 means to allow a domain to grab as many threads as it wants, up to the value of slave_parallel_threads. 3529NUMERIC_MIN_VALUE 0 3530NUMERIC_MAX_VALUE 16383 3531NUMERIC_BLOCK_SIZE 1 3532ENUM_VALUE_LIST NULL 3533READ_ONLY NO 3534COMMAND_LINE_ARGUMENT REQUIRED 3535VARIABLE_NAME SLAVE_EXEC_MODE 3536VARIABLE_SCOPE GLOBAL 3537VARIABLE_TYPE ENUM 3538VARIABLE_COMMENT How replication events should be executed. Legal values are STRICT (default) and IDEMPOTENT. In IDEMPOTENT mode, replication will not stop for operations that are idempotent. For example, in row based replication attempts to delete rows that doesn't exist will be ignored. In STRICT mode, replication will stop on any unexpected difference between the master and the slave. 3539NUMERIC_MIN_VALUE NULL 3540NUMERIC_MAX_VALUE NULL 3541NUMERIC_BLOCK_SIZE NULL 3542ENUM_VALUE_LIST STRICT,IDEMPOTENT 3543READ_ONLY NO 3544COMMAND_LINE_ARGUMENT REQUIRED 3545VARIABLE_NAME SLAVE_LOAD_TMPDIR 3546VARIABLE_SCOPE GLOBAL 3547VARIABLE_TYPE VARCHAR 3548VARIABLE_COMMENT The location where the slave should put its temporary files when replicating a LOAD DATA INFILE command 3549NUMERIC_MIN_VALUE NULL 3550NUMERIC_MAX_VALUE NULL 3551NUMERIC_BLOCK_SIZE NULL 3552ENUM_VALUE_LIST NULL 3553READ_ONLY YES 3554COMMAND_LINE_ARGUMENT REQUIRED 3555VARIABLE_NAME SLAVE_MAX_ALLOWED_PACKET 3556VARIABLE_SCOPE GLOBAL 3557VARIABLE_TYPE BIGINT UNSIGNED 3558VARIABLE_COMMENT The maximum packet length to sent successfully from the master to slave. 3559NUMERIC_MIN_VALUE 1024 3560NUMERIC_MAX_VALUE 1073741824 3561NUMERIC_BLOCK_SIZE 1024 3562ENUM_VALUE_LIST NULL 3563READ_ONLY NO 3564COMMAND_LINE_ARGUMENT REQUIRED 3565VARIABLE_NAME SLAVE_NET_TIMEOUT 3566VARIABLE_SCOPE GLOBAL 3567VARIABLE_TYPE INT UNSIGNED 3568VARIABLE_COMMENT Number of seconds to wait for more data from any master/slave connection before aborting the read 3569NUMERIC_MIN_VALUE 1 3570NUMERIC_MAX_VALUE 31536000 3571NUMERIC_BLOCK_SIZE 1 3572ENUM_VALUE_LIST NULL 3573READ_ONLY NO 3574COMMAND_LINE_ARGUMENT REQUIRED 3575VARIABLE_NAME SLAVE_PARALLEL_MAX_QUEUED 3576VARIABLE_SCOPE GLOBAL 3577VARIABLE_TYPE BIGINT UNSIGNED 3578VARIABLE_COMMENT Limit on how much memory SQL threads should use per parallel replication thread when reading ahead in the relay log looking for opportunities for parallel replication. Only used when --slave-parallel-threads > 0. 3579NUMERIC_MIN_VALUE 0 3580NUMERIC_MAX_VALUE 2147483647 3581NUMERIC_BLOCK_SIZE 1 3582ENUM_VALUE_LIST NULL 3583READ_ONLY NO 3584COMMAND_LINE_ARGUMENT REQUIRED 3585VARIABLE_NAME SLAVE_PARALLEL_MODE 3586VARIABLE_SCOPE GLOBAL 3587VARIABLE_TYPE ENUM 3588VARIABLE_COMMENT Controls what transactions are applied in parallel when using --slave-parallel-threads. Possible values: "optimistic" tries to apply most transactional DML in parallel, and handles any conflicts with rollback and retry. "conservative" limits parallelism in an effort to avoid any conflicts. "aggressive" tries to maximise the parallelism, possibly at the cost of increased conflict rate. "minimal" only parallelizes the commit steps of transactions. "none" disables parallel apply completely. 3589NUMERIC_MIN_VALUE NULL 3590NUMERIC_MAX_VALUE NULL 3591NUMERIC_BLOCK_SIZE NULL 3592ENUM_VALUE_LIST none,minimal,conservative,optimistic,aggressive 3593READ_ONLY NO 3594COMMAND_LINE_ARGUMENT NULL 3595VARIABLE_NAME SLAVE_PARALLEL_THREADS 3596VARIABLE_SCOPE GLOBAL 3597VARIABLE_TYPE BIGINT UNSIGNED 3598VARIABLE_COMMENT If non-zero, number of threads to spawn to apply in parallel events on the slave that were group-committed on the master or were logged with GTID in different replication domains. Note that these threads are in addition to the IO and SQL threads, which are always created by a replication slave 3599NUMERIC_MIN_VALUE 0 3600NUMERIC_MAX_VALUE 16383 3601NUMERIC_BLOCK_SIZE 1 3602ENUM_VALUE_LIST NULL 3603READ_ONLY NO 3604COMMAND_LINE_ARGUMENT REQUIRED 3605VARIABLE_NAME SLAVE_PARALLEL_WORKERS 3606VARIABLE_SCOPE GLOBAL 3607VARIABLE_TYPE BIGINT UNSIGNED 3608VARIABLE_COMMENT Alias for slave_parallel_threads 3609NUMERIC_MIN_VALUE 0 3610NUMERIC_MAX_VALUE 16383 3611NUMERIC_BLOCK_SIZE 1 3612ENUM_VALUE_LIST NULL 3613READ_ONLY NO 3614COMMAND_LINE_ARGUMENT REQUIRED 3615VARIABLE_NAME SLAVE_RUN_TRIGGERS_FOR_RBR 3616VARIABLE_SCOPE GLOBAL 3617VARIABLE_TYPE ENUM 3618VARIABLE_COMMENT Modes for how triggers in row-base replication on slave side will be executed. Legal values are NO (default), YES and LOGGING. NO means that trigger for RBR will not be running on slave. YES and LOGGING means that triggers will be running on slave, if there was not triggers running on the master for the statement. LOGGING also means results of that the executed triggers work will be written to the binlog. 3619NUMERIC_MIN_VALUE NULL 3620NUMERIC_MAX_VALUE NULL 3621NUMERIC_BLOCK_SIZE NULL 3622ENUM_VALUE_LIST NO,YES,LOGGING 3623READ_ONLY NO 3624COMMAND_LINE_ARGUMENT REQUIRED 3625VARIABLE_NAME SLAVE_SKIP_ERRORS 3626VARIABLE_SCOPE GLOBAL 3627VARIABLE_TYPE VARCHAR 3628VARIABLE_COMMENT Tells the slave thread to continue replication when a query event returns an error from the provided list 3629NUMERIC_MIN_VALUE NULL 3630NUMERIC_MAX_VALUE NULL 3631NUMERIC_BLOCK_SIZE NULL 3632ENUM_VALUE_LIST NULL 3633READ_ONLY YES 3634COMMAND_LINE_ARGUMENT REQUIRED 3635VARIABLE_NAME SLAVE_SQL_VERIFY_CHECKSUM 3636VARIABLE_SCOPE GLOBAL 3637VARIABLE_TYPE BOOLEAN 3638VARIABLE_COMMENT Force checksum verification of replication events after reading them from relay log. Note: Events are always checksum-verified by slave on receiving them from the network before writing them to the relay log 3639NUMERIC_MIN_VALUE NULL 3640NUMERIC_MAX_VALUE NULL 3641NUMERIC_BLOCK_SIZE NULL 3642ENUM_VALUE_LIST OFF,ON 3643READ_ONLY NO 3644COMMAND_LINE_ARGUMENT OPTIONAL 3645VARIABLE_NAME SLAVE_TRANSACTION_RETRIES 3646VARIABLE_SCOPE GLOBAL 3647VARIABLE_TYPE BIGINT UNSIGNED 3648VARIABLE_COMMENT Number of times the slave SQL thread will retry a transaction in case it failed with a deadlock, elapsed lock wait timeout or listed in slave_transaction_retry_errors, before giving up and stopping 3649NUMERIC_MIN_VALUE 0 3650NUMERIC_MAX_VALUE 4294967295 3651NUMERIC_BLOCK_SIZE 1 3652ENUM_VALUE_LIST NULL 3653READ_ONLY NO 3654COMMAND_LINE_ARGUMENT REQUIRED 3655VARIABLE_NAME SLAVE_TRANSACTION_RETRY_ERRORS 3656VARIABLE_SCOPE GLOBAL 3657VARIABLE_TYPE VARCHAR 3658VARIABLE_COMMENT Tells the slave thread to retry transaction for replication when a query event returns an error from the provided list. Deadlock error, elapsed lock wait timeout, net read error, net read timeout, net write error, net write timeout, connect error and 2 types of lost connection error are automatically added to this list 3659NUMERIC_MIN_VALUE NULL 3660NUMERIC_MAX_VALUE NULL 3661NUMERIC_BLOCK_SIZE NULL 3662ENUM_VALUE_LIST NULL 3663READ_ONLY YES 3664COMMAND_LINE_ARGUMENT REQUIRED 3665VARIABLE_NAME SLAVE_TRANSACTION_RETRY_INTERVAL 3666VARIABLE_SCOPE GLOBAL 3667VARIABLE_TYPE BIGINT UNSIGNED 3668VARIABLE_COMMENT Interval of the slave SQL thread will retry a transaction in case it failed with a deadlock or elapsed lock wait timeout or listed in slave_transaction_retry_errors 3669NUMERIC_MIN_VALUE 0 3670NUMERIC_MAX_VALUE 3600 3671NUMERIC_BLOCK_SIZE 1 3672ENUM_VALUE_LIST NULL 3673READ_ONLY NO 3674COMMAND_LINE_ARGUMENT REQUIRED 3675VARIABLE_NAME SLAVE_TYPE_CONVERSIONS 3676VARIABLE_SCOPE GLOBAL 3677VARIABLE_TYPE SET 3678VARIABLE_COMMENT Set of slave type conversions that are enabled. If the variable is empty, no conversions are allowed and it is expected that the types match exactly 3679NUMERIC_MIN_VALUE NULL 3680NUMERIC_MAX_VALUE NULL 3681NUMERIC_BLOCK_SIZE NULL 3682ENUM_VALUE_LIST ALL_LOSSY,ALL_NON_LOSSY 3683READ_ONLY NO 3684COMMAND_LINE_ARGUMENT REQUIRED 3685VARIABLE_NAME SLOW_LAUNCH_TIME 3686VARIABLE_SCOPE GLOBAL 3687VARIABLE_TYPE BIGINT UNSIGNED 3688VARIABLE_COMMENT If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented 3689NUMERIC_MIN_VALUE 0 3690NUMERIC_MAX_VALUE 31536000 3691NUMERIC_BLOCK_SIZE 1 3692ENUM_VALUE_LIST NULL 3693READ_ONLY NO 3694COMMAND_LINE_ARGUMENT REQUIRED 3695VARIABLE_NAME SLOW_QUERY_LOG 3696VARIABLE_SCOPE SESSION 3697VARIABLE_TYPE BOOLEAN 3698VARIABLE_COMMENT Log slow queries to a table or log file. Defaults logging to a file 'hostname'-slow.log or a table mysql.slow_log if --log-output=TABLE is used. Must be enabled to activate other slow log options. 3699NUMERIC_MIN_VALUE NULL 3700NUMERIC_MAX_VALUE NULL 3701NUMERIC_BLOCK_SIZE NULL 3702ENUM_VALUE_LIST OFF,ON 3703READ_ONLY NO 3704COMMAND_LINE_ARGUMENT OPTIONAL 3705VARIABLE_NAME SLOW_QUERY_LOG_FILE 3706VARIABLE_SCOPE GLOBAL 3707VARIABLE_TYPE VARCHAR 3708VARIABLE_COMMENT Log slow queries to given log file. Defaults logging to 'hostname'-slow.log. Must be enabled to activate other slow log options 3709NUMERIC_MIN_VALUE NULL 3710NUMERIC_MAX_VALUE NULL 3711NUMERIC_BLOCK_SIZE NULL 3712ENUM_VALUE_LIST NULL 3713READ_ONLY NO 3714COMMAND_LINE_ARGUMENT REQUIRED 3715VARIABLE_NAME SOCKET 3716VARIABLE_SCOPE GLOBAL 3717VARIABLE_TYPE VARCHAR 3718VARIABLE_COMMENT Socket file to use for connection 3719NUMERIC_MIN_VALUE NULL 3720NUMERIC_MAX_VALUE NULL 3721NUMERIC_BLOCK_SIZE NULL 3722ENUM_VALUE_LIST NULL 3723READ_ONLY YES 3724COMMAND_LINE_ARGUMENT REQUIRED 3725VARIABLE_NAME SORT_BUFFER_SIZE 3726VARIABLE_SCOPE SESSION 3727VARIABLE_TYPE BIGINT UNSIGNED 3728VARIABLE_COMMENT Each thread that needs to do a sort allocates a buffer of this size 3729NUMERIC_MIN_VALUE 1024 3730NUMERIC_MAX_VALUE 18446744073709551615 3731NUMERIC_BLOCK_SIZE 1 3732ENUM_VALUE_LIST NULL 3733READ_ONLY NO 3734COMMAND_LINE_ARGUMENT REQUIRED 3735VARIABLE_NAME SQL_AUTO_IS_NULL 3736VARIABLE_SCOPE SESSION 3737VARIABLE_TYPE BOOLEAN 3738VARIABLE_COMMENT If set to 1, the query SELECT * FROM table_name WHERE auto_increment_column IS NULL will return an auto-increment that has just been successfully inserted, the same as the LAST_INSERT_ID() function. Some ODBC programs make use of this IS NULL comparison. 3739NUMERIC_MIN_VALUE NULL 3740NUMERIC_MAX_VALUE NULL 3741NUMERIC_BLOCK_SIZE NULL 3742ENUM_VALUE_LIST OFF,ON 3743READ_ONLY NO 3744COMMAND_LINE_ARGUMENT NULL 3745VARIABLE_NAME SQL_BIG_SELECTS 3746VARIABLE_SCOPE SESSION 3747VARIABLE_TYPE BOOLEAN 3748VARIABLE_COMMENT If set to 0, MariaDB will not perform large SELECTs. See max_join_size for details. If max_join_size is set to anything but DEFAULT, sql_big_selects is automatically set to 0. If sql_big_selects is again set, max_join_size will be ignored. 3749NUMERIC_MIN_VALUE NULL 3750NUMERIC_MAX_VALUE NULL 3751NUMERIC_BLOCK_SIZE NULL 3752ENUM_VALUE_LIST OFF,ON 3753READ_ONLY NO 3754COMMAND_LINE_ARGUMENT NULL 3755VARIABLE_NAME SQL_BUFFER_RESULT 3756VARIABLE_SCOPE SESSION 3757VARIABLE_TYPE BOOLEAN 3758VARIABLE_COMMENT If set to 1 (0 is default), results from SELECT statements are always placed into temporary tables. This can help the server when it takes a long time to send the results to the client by allowing the table locks to be freed early. 3759NUMERIC_MIN_VALUE NULL 3760NUMERIC_MAX_VALUE NULL 3761NUMERIC_BLOCK_SIZE NULL 3762ENUM_VALUE_LIST OFF,ON 3763READ_ONLY NO 3764COMMAND_LINE_ARGUMENT NULL 3765VARIABLE_NAME SQL_LOG_BIN 3766VARIABLE_SCOPE SESSION 3767VARIABLE_TYPE BOOLEAN 3768VARIABLE_COMMENT If set to 0 (1 is the default), no logging to the binary log is done for the client. Only clients with the SUPER privilege can update this variable. Can have unintended consequences if set globally, see SET SQL_LOG_BIN. Starting MariaDB 10.1.7, this variable does not affect the replication of events in a Galera cluster. 3769NUMERIC_MIN_VALUE NULL 3770NUMERIC_MAX_VALUE NULL 3771NUMERIC_BLOCK_SIZE NULL 3772ENUM_VALUE_LIST OFF,ON 3773READ_ONLY NO 3774COMMAND_LINE_ARGUMENT NULL 3775VARIABLE_NAME SQL_LOG_OFF 3776VARIABLE_SCOPE SESSION 3777VARIABLE_TYPE BOOLEAN 3778VARIABLE_COMMENT If set to 1 (0 is the default), no logging to the general query log is done for the client. Only clients with the SUPER privilege can update this variable. 3779NUMERIC_MIN_VALUE NULL 3780NUMERIC_MAX_VALUE NULL 3781NUMERIC_BLOCK_SIZE NULL 3782ENUM_VALUE_LIST OFF,ON 3783READ_ONLY NO 3784COMMAND_LINE_ARGUMENT NULL 3785VARIABLE_NAME SQL_MODE 3786VARIABLE_SCOPE SESSION 3787VARIABLE_TYPE SET 3788VARIABLE_COMMENT Sets the sql mode 3789NUMERIC_MIN_VALUE NULL 3790NUMERIC_MAX_VALUE NULL 3791NUMERIC_BLOCK_SIZE NULL 3792ENUM_VALUE_LIST REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,IGNORE_BAD_TABLE_OPTIONS,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT,TIME_ROUND_FRACTIONAL 3793READ_ONLY NO 3794COMMAND_LINE_ARGUMENT REQUIRED 3795VARIABLE_NAME SQL_NOTES 3796VARIABLE_SCOPE SESSION 3797VARIABLE_TYPE BOOLEAN 3798VARIABLE_COMMENT If set to 1, the default, warning_count is incremented each time a Note warning is encountered. If set to 0, Note warnings are not recorded. mysqldump has outputs to set this variable to 0 so that no unnecessary increments occur when data is reloaded. 3799NUMERIC_MIN_VALUE NULL 3800NUMERIC_MAX_VALUE NULL 3801NUMERIC_BLOCK_SIZE NULL 3802ENUM_VALUE_LIST OFF,ON 3803READ_ONLY NO 3804COMMAND_LINE_ARGUMENT NULL 3805VARIABLE_NAME SQL_QUOTE_SHOW_CREATE 3806VARIABLE_SCOPE SESSION 3807VARIABLE_TYPE BOOLEAN 3808VARIABLE_COMMENT If set to 1, the default, the server will quote identifiers for SHOW CREATE DATABASE, SHOW CREATE TABLE and SHOW CREATE VIEW statements. Quoting is disabled if set to 0. Enable to ensure replications works when identifiers require quoting. 3809NUMERIC_MIN_VALUE NULL 3810NUMERIC_MAX_VALUE NULL 3811NUMERIC_BLOCK_SIZE NULL 3812ENUM_VALUE_LIST OFF,ON 3813READ_ONLY NO 3814COMMAND_LINE_ARGUMENT NULL 3815VARIABLE_NAME SQL_SAFE_UPDATES 3816VARIABLE_SCOPE SESSION 3817VARIABLE_TYPE BOOLEAN 3818VARIABLE_COMMENT If set to 1, UPDATEs and DELETEs need either a key in the WHERE clause, or a LIMIT clause, or else they will aborted. Prevents the common mistake of accidentally deleting or updating every row in a table. 3819NUMERIC_MIN_VALUE NULL 3820NUMERIC_MAX_VALUE NULL 3821NUMERIC_BLOCK_SIZE NULL 3822ENUM_VALUE_LIST OFF,ON 3823READ_ONLY NO 3824COMMAND_LINE_ARGUMENT OPTIONAL 3825VARIABLE_NAME SQL_SELECT_LIMIT 3826VARIABLE_SCOPE SESSION 3827VARIABLE_TYPE BIGINT UNSIGNED 3828VARIABLE_COMMENT The maximum number of rows to return from SELECT statements 3829NUMERIC_MIN_VALUE 0 3830NUMERIC_MAX_VALUE 18446744073709551615 3831NUMERIC_BLOCK_SIZE 1 3832ENUM_VALUE_LIST NULL 3833READ_ONLY NO 3834COMMAND_LINE_ARGUMENT NULL 3835VARIABLE_NAME SQL_SLAVE_SKIP_COUNTER 3836VARIABLE_SCOPE SESSION 3837VARIABLE_TYPE BIGINT UNSIGNED 3838VARIABLE_COMMENT Skip the next N events from the master log 3839NUMERIC_MIN_VALUE 0 3840NUMERIC_MAX_VALUE 4294967295 3841NUMERIC_BLOCK_SIZE 1 3842ENUM_VALUE_LIST NULL 3843READ_ONLY NO 3844COMMAND_LINE_ARGUMENT NULL 3845VARIABLE_NAME SQL_WARNINGS 3846VARIABLE_SCOPE SESSION 3847VARIABLE_TYPE BOOLEAN 3848VARIABLE_COMMENT If set to 1, single-row INSERTs will produce a string containing warning information if a warning occurs. 3849NUMERIC_MIN_VALUE NULL 3850NUMERIC_MAX_VALUE NULL 3851NUMERIC_BLOCK_SIZE NULL 3852ENUM_VALUE_LIST OFF,ON 3853READ_ONLY NO 3854COMMAND_LINE_ARGUMENT NULL 3855VARIABLE_NAME SSL_CA 3856VARIABLE_SCOPE GLOBAL 3857VARIABLE_TYPE VARCHAR 3858VARIABLE_COMMENT CA file in PEM format (check OpenSSL docs, implies --ssl) 3859NUMERIC_MIN_VALUE NULL 3860NUMERIC_MAX_VALUE NULL 3861NUMERIC_BLOCK_SIZE NULL 3862ENUM_VALUE_LIST NULL 3863READ_ONLY YES 3864COMMAND_LINE_ARGUMENT REQUIRED 3865VARIABLE_NAME SSL_CAPATH 3866VARIABLE_SCOPE GLOBAL 3867VARIABLE_TYPE VARCHAR 3868VARIABLE_COMMENT CA directory (check OpenSSL docs, implies --ssl) 3869NUMERIC_MIN_VALUE NULL 3870NUMERIC_MAX_VALUE NULL 3871NUMERIC_BLOCK_SIZE NULL 3872ENUM_VALUE_LIST NULL 3873READ_ONLY YES 3874COMMAND_LINE_ARGUMENT REQUIRED 3875VARIABLE_NAME SSL_CERT 3876VARIABLE_SCOPE GLOBAL 3877VARIABLE_TYPE VARCHAR 3878VARIABLE_COMMENT X509 cert in PEM format (implies --ssl) 3879NUMERIC_MIN_VALUE NULL 3880NUMERIC_MAX_VALUE NULL 3881NUMERIC_BLOCK_SIZE NULL 3882ENUM_VALUE_LIST NULL 3883READ_ONLY YES 3884COMMAND_LINE_ARGUMENT REQUIRED 3885VARIABLE_NAME SSL_CIPHER 3886VARIABLE_SCOPE GLOBAL 3887VARIABLE_TYPE VARCHAR 3888VARIABLE_COMMENT SSL cipher to use (implies --ssl) 3889NUMERIC_MIN_VALUE NULL 3890NUMERIC_MAX_VALUE NULL 3891NUMERIC_BLOCK_SIZE NULL 3892ENUM_VALUE_LIST NULL 3893READ_ONLY YES 3894COMMAND_LINE_ARGUMENT REQUIRED 3895VARIABLE_NAME SSL_CRL 3896VARIABLE_SCOPE GLOBAL 3897VARIABLE_TYPE VARCHAR 3898VARIABLE_COMMENT CRL file in PEM format (check OpenSSL docs, implies --ssl) 3899NUMERIC_MIN_VALUE NULL 3900NUMERIC_MAX_VALUE NULL 3901NUMERIC_BLOCK_SIZE NULL 3902ENUM_VALUE_LIST NULL 3903READ_ONLY YES 3904COMMAND_LINE_ARGUMENT REQUIRED 3905VARIABLE_NAME SSL_CRLPATH 3906VARIABLE_SCOPE GLOBAL 3907VARIABLE_TYPE VARCHAR 3908VARIABLE_COMMENT CRL directory (check OpenSSL docs, implies --ssl) 3909NUMERIC_MIN_VALUE NULL 3910NUMERIC_MAX_VALUE NULL 3911NUMERIC_BLOCK_SIZE NULL 3912ENUM_VALUE_LIST NULL 3913READ_ONLY YES 3914COMMAND_LINE_ARGUMENT REQUIRED 3915VARIABLE_NAME SSL_KEY 3916VARIABLE_SCOPE GLOBAL 3917VARIABLE_TYPE VARCHAR 3918VARIABLE_COMMENT X509 key in PEM format (implies --ssl) 3919NUMERIC_MIN_VALUE NULL 3920NUMERIC_MAX_VALUE NULL 3921NUMERIC_BLOCK_SIZE NULL 3922ENUM_VALUE_LIST NULL 3923READ_ONLY YES 3924COMMAND_LINE_ARGUMENT REQUIRED 3925VARIABLE_NAME STANDARD_COMPLIANT_CTE 3926VARIABLE_SCOPE SESSION 3927VARIABLE_TYPE BOOLEAN 3928VARIABLE_COMMENT Allow only CTEs compliant to SQL standard 3929NUMERIC_MIN_VALUE NULL 3930NUMERIC_MAX_VALUE NULL 3931NUMERIC_BLOCK_SIZE NULL 3932ENUM_VALUE_LIST OFF,ON 3933READ_ONLY NO 3934COMMAND_LINE_ARGUMENT OPTIONAL 3935VARIABLE_NAME STORAGE_ENGINE 3936VARIABLE_SCOPE SESSION 3937VARIABLE_TYPE VARCHAR 3938VARIABLE_COMMENT Alias for @@default_storage_engine. Deprecated 3939NUMERIC_MIN_VALUE NULL 3940NUMERIC_MAX_VALUE NULL 3941NUMERIC_BLOCK_SIZE NULL 3942ENUM_VALUE_LIST NULL 3943READ_ONLY NO 3944COMMAND_LINE_ARGUMENT NULL 3945VARIABLE_NAME STORED_PROGRAM_CACHE 3946VARIABLE_SCOPE GLOBAL 3947VARIABLE_TYPE BIGINT UNSIGNED 3948VARIABLE_COMMENT The soft upper limit for number of cached stored routines for one connection. 3949NUMERIC_MIN_VALUE 0 3950NUMERIC_MAX_VALUE 524288 3951NUMERIC_BLOCK_SIZE 1 3952ENUM_VALUE_LIST NULL 3953READ_ONLY NO 3954COMMAND_LINE_ARGUMENT REQUIRED 3955VARIABLE_NAME STRICT_PASSWORD_VALIDATION 3956VARIABLE_SCOPE GLOBAL 3957VARIABLE_TYPE BOOLEAN 3958VARIABLE_COMMENT When password validation plugins are enabled, reject passwords that cannot be validated (passwords specified as a hash) 3959NUMERIC_MIN_VALUE NULL 3960NUMERIC_MAX_VALUE NULL 3961NUMERIC_BLOCK_SIZE NULL 3962ENUM_VALUE_LIST OFF,ON 3963READ_ONLY NO 3964COMMAND_LINE_ARGUMENT OPTIONAL 3965VARIABLE_NAME SYNC_BINLOG 3966VARIABLE_SCOPE GLOBAL 3967VARIABLE_TYPE INT UNSIGNED 3968VARIABLE_COMMENT Synchronously flush binary log to disk after every #th event. Use 0 (default) to disable synchronous flushing 3969NUMERIC_MIN_VALUE 0 3970NUMERIC_MAX_VALUE 4294967295 3971NUMERIC_BLOCK_SIZE 1 3972ENUM_VALUE_LIST NULL 3973READ_ONLY NO 3974COMMAND_LINE_ARGUMENT REQUIRED 3975VARIABLE_NAME SYNC_FRM 3976VARIABLE_SCOPE GLOBAL 3977VARIABLE_TYPE BOOLEAN 3978VARIABLE_COMMENT Sync .frm files to disk on creation 3979NUMERIC_MIN_VALUE NULL 3980NUMERIC_MAX_VALUE NULL 3981NUMERIC_BLOCK_SIZE NULL 3982ENUM_VALUE_LIST OFF,ON 3983READ_ONLY NO 3984COMMAND_LINE_ARGUMENT OPTIONAL 3985VARIABLE_NAME SYNC_MASTER_INFO 3986VARIABLE_SCOPE GLOBAL 3987VARIABLE_TYPE INT UNSIGNED 3988VARIABLE_COMMENT Synchronously flush master info to disk after every #th event. Use 0 to disable synchronous flushing 3989NUMERIC_MIN_VALUE 0 3990NUMERIC_MAX_VALUE 4294967295 3991NUMERIC_BLOCK_SIZE 1 3992ENUM_VALUE_LIST NULL 3993READ_ONLY NO 3994COMMAND_LINE_ARGUMENT REQUIRED 3995VARIABLE_NAME SYNC_RELAY_LOG 3996VARIABLE_SCOPE GLOBAL 3997VARIABLE_TYPE INT UNSIGNED 3998VARIABLE_COMMENT Synchronously flush relay log to disk after every #th event. Use 0 to disable synchronous flushing 3999NUMERIC_MIN_VALUE 0 4000NUMERIC_MAX_VALUE 4294967295 4001NUMERIC_BLOCK_SIZE 1 4002ENUM_VALUE_LIST NULL 4003READ_ONLY NO 4004COMMAND_LINE_ARGUMENT REQUIRED 4005VARIABLE_NAME SYNC_RELAY_LOG_INFO 4006VARIABLE_SCOPE GLOBAL 4007VARIABLE_TYPE INT UNSIGNED 4008VARIABLE_COMMENT Synchronously flush relay log info to disk after every #th transaction. Use 0 to disable synchronous flushing 4009NUMERIC_MIN_VALUE 0 4010NUMERIC_MAX_VALUE 4294967295 4011NUMERIC_BLOCK_SIZE 1 4012ENUM_VALUE_LIST NULL 4013READ_ONLY NO 4014COMMAND_LINE_ARGUMENT REQUIRED 4015VARIABLE_NAME SYSTEM_TIME_ZONE 4016VARIABLE_SCOPE GLOBAL 4017VARIABLE_TYPE VARCHAR 4018VARIABLE_COMMENT The server system time zone 4019NUMERIC_MIN_VALUE NULL 4020NUMERIC_MAX_VALUE NULL 4021NUMERIC_BLOCK_SIZE NULL 4022ENUM_VALUE_LIST NULL 4023READ_ONLY YES 4024COMMAND_LINE_ARGUMENT NULL 4025VARIABLE_NAME SYSTEM_VERSIONING_ALTER_HISTORY 4026VARIABLE_SCOPE SESSION 4027VARIABLE_TYPE ENUM 4028VARIABLE_COMMENT Versioning ALTER TABLE mode. ERROR: Fail ALTER with error; KEEP: Keep historical system rows and subject them to ALTER 4029NUMERIC_MIN_VALUE NULL 4030NUMERIC_MAX_VALUE NULL 4031NUMERIC_BLOCK_SIZE NULL 4032ENUM_VALUE_LIST ERROR,KEEP 4033READ_ONLY NO 4034COMMAND_LINE_ARGUMENT REQUIRED 4035VARIABLE_NAME SYSTEM_VERSIONING_ASOF 4036VARIABLE_SCOPE SESSION 4037VARIABLE_TYPE VARCHAR 4038VARIABLE_COMMENT Default value for the FOR SYSTEM_TIME AS OF clause 4039NUMERIC_MIN_VALUE NULL 4040NUMERIC_MAX_VALUE NULL 4041NUMERIC_BLOCK_SIZE NULL 4042ENUM_VALUE_LIST NULL 4043READ_ONLY NO 4044COMMAND_LINE_ARGUMENT NULL 4045VARIABLE_NAME TABLE_DEFINITION_CACHE 4046VARIABLE_SCOPE GLOBAL 4047VARIABLE_TYPE BIGINT UNSIGNED 4048VARIABLE_COMMENT The number of cached table definitions 4049NUMERIC_MIN_VALUE 400 4050NUMERIC_MAX_VALUE 2097152 4051NUMERIC_BLOCK_SIZE 1 4052ENUM_VALUE_LIST NULL 4053READ_ONLY NO 4054COMMAND_LINE_ARGUMENT REQUIRED 4055VARIABLE_NAME TABLE_OPEN_CACHE 4056VARIABLE_SCOPE GLOBAL 4057VARIABLE_TYPE BIGINT UNSIGNED 4058VARIABLE_COMMENT The number of cached open tables 4059NUMERIC_MIN_VALUE 10 4060NUMERIC_MAX_VALUE 1048576 4061NUMERIC_BLOCK_SIZE 1 4062ENUM_VALUE_LIST NULL 4063READ_ONLY NO 4064COMMAND_LINE_ARGUMENT REQUIRED 4065VARIABLE_NAME TABLE_OPEN_CACHE_INSTANCES 4066VARIABLE_SCOPE GLOBAL 4067VARIABLE_TYPE INT UNSIGNED 4068VARIABLE_COMMENT Maximum number of table cache instances 4069NUMERIC_MIN_VALUE 1 4070NUMERIC_MAX_VALUE 64 4071NUMERIC_BLOCK_SIZE 1 4072ENUM_VALUE_LIST NULL 4073READ_ONLY YES 4074COMMAND_LINE_ARGUMENT REQUIRED 4075VARIABLE_NAME TCP_KEEPALIVE_INTERVAL 4076VARIABLE_SCOPE GLOBAL 4077VARIABLE_TYPE INT 4078VARIABLE_COMMENT The interval, in seconds, between when successive keep-alive packets are sent if no acknowledgement is received.If set to 0, system dependent default is used. 4079NUMERIC_MIN_VALUE 0 4080NUMERIC_MAX_VALUE 2147483 4081NUMERIC_BLOCK_SIZE 1 4082ENUM_VALUE_LIST NULL 4083READ_ONLY NO 4084COMMAND_LINE_ARGUMENT REQUIRED 4085VARIABLE_NAME TCP_KEEPALIVE_PROBES 4086VARIABLE_SCOPE GLOBAL 4087VARIABLE_TYPE INT 4088VARIABLE_COMMENT The number of unacknowledged probes to send before considering the connection dead and notifying the application layer.If set to 0, system dependent default is used. 4089NUMERIC_MIN_VALUE 0 4090NUMERIC_MAX_VALUE 2147483 4091NUMERIC_BLOCK_SIZE 1 4092ENUM_VALUE_LIST NULL 4093READ_ONLY NO 4094COMMAND_LINE_ARGUMENT REQUIRED 4095VARIABLE_NAME TCP_KEEPALIVE_TIME 4096VARIABLE_SCOPE GLOBAL 4097VARIABLE_TYPE INT 4098VARIABLE_COMMENT Timeout, in seconds, with no activity until the first TCP keep-alive packet is sent.If set to 0, system dependent default is used. 4099NUMERIC_MIN_VALUE 0 4100NUMERIC_MAX_VALUE 2147483 4101NUMERIC_BLOCK_SIZE 1 4102ENUM_VALUE_LIST NULL 4103READ_ONLY NO 4104COMMAND_LINE_ARGUMENT REQUIRED 4105VARIABLE_NAME TCP_NODELAY 4106VARIABLE_SCOPE SESSION 4107VARIABLE_TYPE BOOLEAN 4108VARIABLE_COMMENT Set option TCP_NODELAY (disable Nagle's algorithm) on socket 4109NUMERIC_MIN_VALUE NULL 4110NUMERIC_MAX_VALUE NULL 4111NUMERIC_BLOCK_SIZE NULL 4112ENUM_VALUE_LIST OFF,ON 4113READ_ONLY NO 4114COMMAND_LINE_ARGUMENT OPTIONAL 4115VARIABLE_NAME THREAD_CACHE_SIZE 4116VARIABLE_SCOPE GLOBAL 4117VARIABLE_TYPE BIGINT UNSIGNED 4118VARIABLE_COMMENT How many threads we should keep in a cache for reuse. These are freed after 5 minutes of idle time 4119NUMERIC_MIN_VALUE 0 4120NUMERIC_MAX_VALUE 16384 4121NUMERIC_BLOCK_SIZE 1 4122ENUM_VALUE_LIST NULL 4123READ_ONLY NO 4124COMMAND_LINE_ARGUMENT REQUIRED 4125VARIABLE_NAME THREAD_CONCURRENCY 4126VARIABLE_SCOPE GLOBAL 4127VARIABLE_TYPE BIGINT UNSIGNED 4128VARIABLE_COMMENT Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time.This variable has no effect, and is deprecated. It will be removed in a future release. 4129NUMERIC_MIN_VALUE 1 4130NUMERIC_MAX_VALUE 512 4131NUMERIC_BLOCK_SIZE 1 4132ENUM_VALUE_LIST NULL 4133READ_ONLY YES 4134COMMAND_LINE_ARGUMENT REQUIRED 4135VARIABLE_NAME THREAD_HANDLING 4136VARIABLE_SCOPE GLOBAL 4137VARIABLE_TYPE ENUM 4138VARIABLE_COMMENT Define threads usage for handling queries 4139NUMERIC_MIN_VALUE NULL 4140NUMERIC_MAX_VALUE NULL 4141NUMERIC_BLOCK_SIZE NULL 4142ENUM_VALUE_LIST one-thread-per-connection,no-threads,pool-of-threads 4143READ_ONLY YES 4144COMMAND_LINE_ARGUMENT REQUIRED 4145VARIABLE_NAME THREAD_POOL_IDLE_TIMEOUT 4146VARIABLE_SCOPE GLOBAL 4147VARIABLE_TYPE INT UNSIGNED 4148VARIABLE_COMMENT Timeout in seconds for an idle thread in the thread pool.Worker thread will be shut down after timeout 4149NUMERIC_MIN_VALUE 1 4150NUMERIC_MAX_VALUE 4294967295 4151NUMERIC_BLOCK_SIZE 1 4152ENUM_VALUE_LIST NULL 4153READ_ONLY NO 4154COMMAND_LINE_ARGUMENT REQUIRED 4155VARIABLE_NAME THREAD_POOL_MAX_THREADS 4156VARIABLE_SCOPE GLOBAL 4157VARIABLE_TYPE INT UNSIGNED 4158VARIABLE_COMMENT Maximum allowed number of worker threads in the thread pool 4159NUMERIC_MIN_VALUE 1 4160NUMERIC_MAX_VALUE 65536 4161NUMERIC_BLOCK_SIZE 1 4162ENUM_VALUE_LIST NULL 4163READ_ONLY NO 4164COMMAND_LINE_ARGUMENT REQUIRED 4165VARIABLE_NAME THREAD_POOL_OVERSUBSCRIBE 4166VARIABLE_SCOPE GLOBAL 4167VARIABLE_TYPE INT UNSIGNED 4168VARIABLE_COMMENT How many additional active worker threads in a group are allowed. 4169NUMERIC_MIN_VALUE 1 4170NUMERIC_MAX_VALUE 1000 4171NUMERIC_BLOCK_SIZE 1 4172ENUM_VALUE_LIST NULL 4173READ_ONLY NO 4174COMMAND_LINE_ARGUMENT REQUIRED 4175VARIABLE_NAME THREAD_POOL_PRIORITY 4176VARIABLE_SCOPE SESSION 4177VARIABLE_TYPE ENUM 4178VARIABLE_COMMENT Threadpool priority. High priority connections usually start executing earlier than low priority.If priority set to 'auto', the the actual priority(low or high) is determined based on whether or not connection is inside transaction. 4179NUMERIC_MIN_VALUE NULL 4180NUMERIC_MAX_VALUE NULL 4181NUMERIC_BLOCK_SIZE NULL 4182ENUM_VALUE_LIST high,low,auto 4183READ_ONLY NO 4184COMMAND_LINE_ARGUMENT REQUIRED 4185VARIABLE_NAME THREAD_POOL_PRIO_KICKUP_TIMER 4186VARIABLE_SCOPE GLOBAL 4187VARIABLE_TYPE INT UNSIGNED 4188VARIABLE_COMMENT The number of milliseconds before a dequeued low-priority statement is moved to the high-priority queue 4189NUMERIC_MIN_VALUE 0 4190NUMERIC_MAX_VALUE 4294967295 4191NUMERIC_BLOCK_SIZE 1 4192ENUM_VALUE_LIST NULL 4193READ_ONLY NO 4194COMMAND_LINE_ARGUMENT REQUIRED 4195VARIABLE_NAME THREAD_POOL_SIZE 4196VARIABLE_SCOPE GLOBAL 4197VARIABLE_TYPE INT UNSIGNED 4198VARIABLE_COMMENT Number of thread groups in the pool. This parameter is roughly equivalent to maximum number of concurrently executing threads (threads in a waiting state do not count as executing). 4199NUMERIC_MIN_VALUE 1 4200NUMERIC_MAX_VALUE 100000 4201NUMERIC_BLOCK_SIZE 1 4202ENUM_VALUE_LIST NULL 4203READ_ONLY NO 4204COMMAND_LINE_ARGUMENT REQUIRED 4205VARIABLE_NAME THREAD_POOL_STALL_LIMIT 4206VARIABLE_SCOPE GLOBAL 4207VARIABLE_TYPE INT UNSIGNED 4208VARIABLE_COMMENT Maximum query execution time in milliseconds,before an executing non-yielding thread is considered stalled.If a worker thread is stalled, additional worker thread may be created to handle remaining clients. 4209NUMERIC_MIN_VALUE 10 4210NUMERIC_MAX_VALUE 4294967295 4211NUMERIC_BLOCK_SIZE 1 4212ENUM_VALUE_LIST NULL 4213READ_ONLY NO 4214COMMAND_LINE_ARGUMENT REQUIRED 4215VARIABLE_NAME THREAD_STACK 4216VARIABLE_SCOPE GLOBAL 4217VARIABLE_TYPE BIGINT UNSIGNED 4218VARIABLE_COMMENT The stack size for each thread 4219NUMERIC_MIN_VALUE 131072 4220NUMERIC_MAX_VALUE 18446744073709551615 4221NUMERIC_BLOCK_SIZE 1024 4222ENUM_VALUE_LIST NULL 4223READ_ONLY YES 4224COMMAND_LINE_ARGUMENT REQUIRED 4225VARIABLE_NAME TIMED_MUTEXES 4226VARIABLE_SCOPE GLOBAL 4227VARIABLE_TYPE BOOLEAN 4228VARIABLE_COMMENT Specify whether to time mutexes. Deprecated, has no effect. 4229NUMERIC_MIN_VALUE NULL 4230NUMERIC_MAX_VALUE NULL 4231NUMERIC_BLOCK_SIZE NULL 4232ENUM_VALUE_LIST OFF,ON 4233READ_ONLY NO 4234COMMAND_LINE_ARGUMENT OPTIONAL 4235VARIABLE_NAME TIMESTAMP 4236VARIABLE_SCOPE SESSION ONLY 4237VARIABLE_TYPE DOUBLE 4238VARIABLE_COMMENT Set the time for this client 4239NUMERIC_MIN_VALUE 0 4240NUMERIC_MAX_VALUE 2147483647 4241NUMERIC_BLOCK_SIZE NULL 4242ENUM_VALUE_LIST NULL 4243READ_ONLY NO 4244COMMAND_LINE_ARGUMENT NULL 4245VARIABLE_NAME TIME_FORMAT 4246VARIABLE_SCOPE GLOBAL 4247VARIABLE_TYPE VARCHAR 4248VARIABLE_COMMENT The TIME format (ignored) 4249NUMERIC_MIN_VALUE NULL 4250NUMERIC_MAX_VALUE NULL 4251NUMERIC_BLOCK_SIZE NULL 4252ENUM_VALUE_LIST NULL 4253READ_ONLY YES 4254COMMAND_LINE_ARGUMENT REQUIRED 4255VARIABLE_NAME TIME_ZONE 4256VARIABLE_SCOPE SESSION 4257VARIABLE_TYPE VARCHAR 4258VARIABLE_COMMENT The current time zone, used to initialize the time zone for a client when it connects. Set to SYSTEM by default, in which the client uses the system time zone value. 4259NUMERIC_MIN_VALUE NULL 4260NUMERIC_MAX_VALUE NULL 4261NUMERIC_BLOCK_SIZE NULL 4262ENUM_VALUE_LIST NULL 4263READ_ONLY NO 4264COMMAND_LINE_ARGUMENT NULL 4265VARIABLE_NAME TLS_VERSION 4266VARIABLE_SCOPE GLOBAL 4267VARIABLE_TYPE SET 4268VARIABLE_COMMENT TLS protocol version for secure connections. 4269NUMERIC_MIN_VALUE NULL 4270NUMERIC_MAX_VALUE NULL 4271NUMERIC_BLOCK_SIZE NULL 4272ENUM_VALUE_LIST TLSv1.0,TLSv1.1,TLSv1.2,TLSv1.3 4273READ_ONLY YES 4274COMMAND_LINE_ARGUMENT REQUIRED 4275VARIABLE_NAME TMPDIR 4276VARIABLE_SCOPE GLOBAL 4277VARIABLE_TYPE VARCHAR 4278VARIABLE_COMMENT Path for temporary files. Several paths may be specified, separated by a colon (:), in this case they are used in a round-robin fashion 4279NUMERIC_MIN_VALUE NULL 4280NUMERIC_MAX_VALUE NULL 4281NUMERIC_BLOCK_SIZE NULL 4282ENUM_VALUE_LIST NULL 4283READ_ONLY YES 4284COMMAND_LINE_ARGUMENT REQUIRED 4285VARIABLE_NAME TMP_DISK_TABLE_SIZE 4286VARIABLE_SCOPE SESSION 4287VARIABLE_TYPE BIGINT UNSIGNED 4288VARIABLE_COMMENT Max size for data for an internal temporary on-disk MyISAM or Aria table. 4289NUMERIC_MIN_VALUE 1024 4290NUMERIC_MAX_VALUE 18446744073709551615 4291NUMERIC_BLOCK_SIZE 1 4292ENUM_VALUE_LIST NULL 4293READ_ONLY NO 4294COMMAND_LINE_ARGUMENT REQUIRED 4295VARIABLE_NAME TMP_MEMORY_TABLE_SIZE 4296VARIABLE_SCOPE SESSION 4297VARIABLE_TYPE BIGINT UNSIGNED 4298VARIABLE_COMMENT If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size. 4299NUMERIC_MIN_VALUE 1024 4300NUMERIC_MAX_VALUE 18446744073709551615 4301NUMERIC_BLOCK_SIZE 1 4302ENUM_VALUE_LIST NULL 4303READ_ONLY NO 4304COMMAND_LINE_ARGUMENT REQUIRED 4305VARIABLE_NAME TMP_TABLE_SIZE 4306VARIABLE_SCOPE SESSION 4307VARIABLE_TYPE BIGINT UNSIGNED 4308VARIABLE_COMMENT Alias for tmp_memory_table_size. If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. 4309NUMERIC_MIN_VALUE 1024 4310NUMERIC_MAX_VALUE 18446744073709551615 4311NUMERIC_BLOCK_SIZE 1 4312ENUM_VALUE_LIST NULL 4313READ_ONLY NO 4314COMMAND_LINE_ARGUMENT REQUIRED 4315VARIABLE_NAME TRANSACTION_ALLOC_BLOCK_SIZE 4316VARIABLE_SCOPE SESSION 4317VARIABLE_TYPE BIGINT UNSIGNED 4318VARIABLE_COMMENT Allocation block size for transactions to be stored in binary log 4319NUMERIC_MIN_VALUE 1024 4320NUMERIC_MAX_VALUE 134217728 4321NUMERIC_BLOCK_SIZE 1024 4322ENUM_VALUE_LIST NULL 4323READ_ONLY NO 4324COMMAND_LINE_ARGUMENT REQUIRED 4325VARIABLE_NAME TRANSACTION_PREALLOC_SIZE 4326VARIABLE_SCOPE SESSION 4327VARIABLE_TYPE BIGINT UNSIGNED 4328VARIABLE_COMMENT Persistent buffer for transactions to be stored in binary log 4329NUMERIC_MIN_VALUE 1024 4330NUMERIC_MAX_VALUE 134217728 4331NUMERIC_BLOCK_SIZE 1024 4332ENUM_VALUE_LIST NULL 4333READ_ONLY NO 4334COMMAND_LINE_ARGUMENT REQUIRED 4335VARIABLE_NAME TX_ISOLATION 4336VARIABLE_SCOPE SESSION 4337VARIABLE_TYPE ENUM 4338VARIABLE_COMMENT Default transaction isolation level 4339NUMERIC_MIN_VALUE NULL 4340NUMERIC_MAX_VALUE NULL 4341NUMERIC_BLOCK_SIZE NULL 4342ENUM_VALUE_LIST READ-UNCOMMITTED,READ-COMMITTED,REPEATABLE-READ,SERIALIZABLE 4343READ_ONLY NO 4344COMMAND_LINE_ARGUMENT NULL 4345VARIABLE_NAME TX_READ_ONLY 4346VARIABLE_SCOPE SESSION 4347VARIABLE_TYPE BOOLEAN 4348VARIABLE_COMMENT Default transaction access mode. If set to OFF, the default, access is read/write. If set to ON, access is read-only. The SET TRANSACTION statement can also change the value of this variable. See SET TRANSACTION and START TRANSACTION. 4349NUMERIC_MIN_VALUE NULL 4350NUMERIC_MAX_VALUE NULL 4351NUMERIC_BLOCK_SIZE NULL 4352ENUM_VALUE_LIST OFF,ON 4353READ_ONLY NO 4354COMMAND_LINE_ARGUMENT NULL 4355VARIABLE_NAME UNIQUE_CHECKS 4356VARIABLE_SCOPE SESSION 4357VARIABLE_TYPE BOOLEAN 4358VARIABLE_COMMENT If set to 1, the default, secondary indexes in InnoDB tables are performed. If set to 0, storage engines can (but are not required to) assume that duplicate keys are not present in input data. Set to 0 to speed up imports of large tables to InnoDB. The storage engine will still issue a duplicate key error if it detects one, even if set to 0. 4359NUMERIC_MIN_VALUE NULL 4360NUMERIC_MAX_VALUE NULL 4361NUMERIC_BLOCK_SIZE NULL 4362ENUM_VALUE_LIST OFF,ON 4363READ_ONLY NO 4364COMMAND_LINE_ARGUMENT NULL 4365VARIABLE_NAME UPDATABLE_VIEWS_WITH_LIMIT 4366VARIABLE_SCOPE SESSION 4367VARIABLE_TYPE ENUM 4368VARIABLE_COMMENT YES = Don't issue an error message (warning only) if a VIEW without presence of a key of the underlying table is used in queries with a LIMIT clause for updating. NO = Prohibit update of a VIEW, which does not contain a key of the underlying table and the query uses a LIMIT clause (usually get from GUI tools) 4369NUMERIC_MIN_VALUE NULL 4370NUMERIC_MAX_VALUE NULL 4371NUMERIC_BLOCK_SIZE NULL 4372ENUM_VALUE_LIST NO,YES 4373READ_ONLY NO 4374COMMAND_LINE_ARGUMENT REQUIRED 4375VARIABLE_NAME USERSTAT 4376VARIABLE_SCOPE GLOBAL 4377VARIABLE_TYPE BOOLEAN 4378VARIABLE_COMMENT Enables statistics gathering for USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS and TABLE_STATISTICS tables in the INFORMATION_SCHEMA 4379NUMERIC_MIN_VALUE NULL 4380NUMERIC_MAX_VALUE NULL 4381NUMERIC_BLOCK_SIZE NULL 4382ENUM_VALUE_LIST OFF,ON 4383READ_ONLY NO 4384COMMAND_LINE_ARGUMENT OPTIONAL 4385VARIABLE_NAME USE_STAT_TABLES 4386VARIABLE_SCOPE SESSION 4387VARIABLE_TYPE ENUM 4388VARIABLE_COMMENT Specifies how to use system statistics tables 4389NUMERIC_MIN_VALUE NULL 4390NUMERIC_MAX_VALUE NULL 4391NUMERIC_BLOCK_SIZE NULL 4392ENUM_VALUE_LIST NEVER,COMPLEMENTARY,PREFERABLY,COMPLEMENTARY_FOR_QUERIES,PREFERABLY_FOR_QUERIES 4393READ_ONLY NO 4394COMMAND_LINE_ARGUMENT REQUIRED 4395VARIABLE_NAME VERSION 4396VARIABLE_SCOPE GLOBAL 4397VARIABLE_TYPE VARCHAR 4398VARIABLE_COMMENT Server version number. It may also include a suffix with configuration or build information. -debug indicates debugging support was enabled on the server, and -log indicates at least one of the binary log, general log or slow query log are enabled, for example 10.1.1-MariaDB-mariadb1precise-log. 4399NUMERIC_MIN_VALUE NULL 4400NUMERIC_MAX_VALUE NULL 4401NUMERIC_BLOCK_SIZE NULL 4402ENUM_VALUE_LIST NULL 4403READ_ONLY YES 4404COMMAND_LINE_ARGUMENT NULL 4405VARIABLE_NAME VERSION_COMMENT 4406VARIABLE_SCOPE GLOBAL 4407VARIABLE_TYPE VARCHAR 4408VARIABLE_COMMENT Value of the COMPILATION_COMMENT option specified by CMake when building MariaDB, for example mariadb.org binary distribution. 4409NUMERIC_MIN_VALUE NULL 4410NUMERIC_MAX_VALUE NULL 4411NUMERIC_BLOCK_SIZE NULL 4412ENUM_VALUE_LIST NULL 4413READ_ONLY YES 4414COMMAND_LINE_ARGUMENT NULL 4415VARIABLE_NAME VERSION_COMPILE_MACHINE 4416VARIABLE_SCOPE GLOBAL 4417VARIABLE_TYPE VARCHAR 4418VARIABLE_COMMENT The machine type or architecture MariaDB was built on, for example i686. 4419NUMERIC_MIN_VALUE NULL 4420NUMERIC_MAX_VALUE NULL 4421NUMERIC_BLOCK_SIZE NULL 4422ENUM_VALUE_LIST NULL 4423READ_ONLY YES 4424COMMAND_LINE_ARGUMENT NULL 4425VARIABLE_NAME VERSION_COMPILE_OS 4426VARIABLE_SCOPE GLOBAL 4427VARIABLE_TYPE VARCHAR 4428VARIABLE_COMMENT Operating system that MariaDB was built on, for example debian-linux-gnu. 4429NUMERIC_MIN_VALUE NULL 4430NUMERIC_MAX_VALUE NULL 4431NUMERIC_BLOCK_SIZE NULL 4432ENUM_VALUE_LIST NULL 4433READ_ONLY YES 4434COMMAND_LINE_ARGUMENT NULL 4435VARIABLE_NAME VERSION_MALLOC_LIBRARY 4436VARIABLE_SCOPE GLOBAL 4437VARIABLE_TYPE VARCHAR 4438VARIABLE_COMMENT Version of the used malloc library 4439NUMERIC_MIN_VALUE NULL 4440NUMERIC_MAX_VALUE NULL 4441NUMERIC_BLOCK_SIZE NULL 4442ENUM_VALUE_LIST NULL 4443READ_ONLY YES 4444COMMAND_LINE_ARGUMENT NULL 4445VARIABLE_NAME VERSION_SOURCE_REVISION 4446VARIABLE_SCOPE GLOBAL 4447VARIABLE_TYPE VARCHAR 4448VARIABLE_COMMENT Source control revision id for MariaDB source code 4449NUMERIC_MIN_VALUE NULL 4450NUMERIC_MAX_VALUE NULL 4451NUMERIC_BLOCK_SIZE NULL 4452ENUM_VALUE_LIST NULL 4453READ_ONLY YES 4454COMMAND_LINE_ARGUMENT NULL 4455VARIABLE_NAME VERSION_SSL_LIBRARY 4456VARIABLE_SCOPE GLOBAL 4457VARIABLE_TYPE VARCHAR 4458VARIABLE_COMMENT Version of the used SSL library 4459NUMERIC_MIN_VALUE NULL 4460NUMERIC_MAX_VALUE NULL 4461NUMERIC_BLOCK_SIZE NULL 4462ENUM_VALUE_LIST NULL 4463READ_ONLY YES 4464COMMAND_LINE_ARGUMENT NULL 4465VARIABLE_NAME WAIT_TIMEOUT 4466VARIABLE_SCOPE SESSION 4467VARIABLE_TYPE BIGINT UNSIGNED 4468VARIABLE_COMMENT The number of seconds the server waits for activity on a connection before closing it 4469NUMERIC_MIN_VALUE 1 4470NUMERIC_MAX_VALUE 31536000 4471NUMERIC_BLOCK_SIZE 1 4472ENUM_VALUE_LIST NULL 4473READ_ONLY NO 4474COMMAND_LINE_ARGUMENT REQUIRED 4475VARIABLE_NAME WARNING_COUNT 4476VARIABLE_SCOPE SESSION ONLY 4477VARIABLE_TYPE BIGINT UNSIGNED 4478VARIABLE_COMMENT The number of errors, warnings, and notes that resulted from the last statement that generated messages 4479NUMERIC_MIN_VALUE 0 4480NUMERIC_MAX_VALUE 18446744073709551615 4481NUMERIC_BLOCK_SIZE 1 4482ENUM_VALUE_LIST NULL 4483READ_ONLY YES 4484COMMAND_LINE_ARGUMENT NULL 4485select VARIABLE_NAME, GLOBAL_VALUE_ORIGIN, VARIABLE_SCOPE, VARIABLE_TYPE, VARIABLE_COMMENT, ENUM_VALUE_LIST, READ_ONLY, COMMAND_LINE_ARGUMENT 4486from information_schema.system_variables 4487where variable_name in ( 4488'log_tc_size' 4489 ) 4490order by variable_name; 4491VARIABLE_NAME LOG_TC_SIZE 4492GLOBAL_VALUE_ORIGIN AUTO 4493VARIABLE_SCOPE GLOBAL 4494VARIABLE_TYPE BIGINT UNSIGNED 4495VARIABLE_COMMENT Size of transaction coordinator log. 4496ENUM_VALUE_LIST NULL 4497READ_ONLY YES 4498COMMAND_LINE_ARGUMENT REQUIRED 4499set global div_precision_increment=default; 4500