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