1select * from information_schema.system_variables 2where variable_name like 'wsrep%' 3 order by variable_name; 4VARIABLE_NAME WSREP_AUTO_INCREMENT_CONTROL 5SESSION_VALUE NULL 6GLOBAL_VALUE ON 7GLOBAL_VALUE_ORIGIN COMPILE-TIME 8DEFAULT_VALUE ON 9VARIABLE_SCOPE GLOBAL 10VARIABLE_TYPE BOOLEAN 11VARIABLE_COMMENT To automatically control the assignment of autoincrement variables 12NUMERIC_MIN_VALUE NULL 13NUMERIC_MAX_VALUE NULL 14NUMERIC_BLOCK_SIZE NULL 15ENUM_VALUE_LIST OFF,ON 16READ_ONLY NO 17COMMAND_LINE_ARGUMENT OPTIONAL 18VARIABLE_NAME WSREP_CAUSAL_READS 19SESSION_VALUE OFF 20GLOBAL_VALUE OFF 21GLOBAL_VALUE_ORIGIN COMPILE-TIME 22DEFAULT_VALUE OFF 23VARIABLE_SCOPE SESSION 24VARIABLE_TYPE BOOLEAN 25VARIABLE_COMMENT Setting this variable is equivalent to setting wsrep_sync_wait READ flag 26NUMERIC_MIN_VALUE NULL 27NUMERIC_MAX_VALUE NULL 28NUMERIC_BLOCK_SIZE NULL 29ENUM_VALUE_LIST OFF,ON 30READ_ONLY NO 31COMMAND_LINE_ARGUMENT OPTIONAL 32VARIABLE_NAME WSREP_CERTIFICATION_RULES 33SESSION_VALUE NULL 34GLOBAL_VALUE strict 35GLOBAL_VALUE_ORIGIN COMPILE-TIME 36DEFAULT_VALUE strict 37VARIABLE_SCOPE GLOBAL 38VARIABLE_TYPE ENUM 39VARIABLE_COMMENT Certification rules to use in the cluster. Possible values are: "strict": stricter rules that could result in more certification failures. "optimized": relaxed rules that allow more concurrency and cause less certification failures. 40NUMERIC_MIN_VALUE NULL 41NUMERIC_MAX_VALUE NULL 42NUMERIC_BLOCK_SIZE NULL 43ENUM_VALUE_LIST strict,optimized 44READ_ONLY NO 45COMMAND_LINE_ARGUMENT REQUIRED 46VARIABLE_NAME WSREP_CERTIFY_NONPK 47SESSION_VALUE NULL 48GLOBAL_VALUE ON 49GLOBAL_VALUE_ORIGIN COMPILE-TIME 50DEFAULT_VALUE ON 51VARIABLE_SCOPE GLOBAL 52VARIABLE_TYPE BOOLEAN 53VARIABLE_COMMENT Certify tables with no primary key 54NUMERIC_MIN_VALUE NULL 55NUMERIC_MAX_VALUE NULL 56NUMERIC_BLOCK_SIZE NULL 57ENUM_VALUE_LIST OFF,ON 58READ_ONLY NO 59COMMAND_LINE_ARGUMENT OPTIONAL 60VARIABLE_NAME WSREP_CLUSTER_ADDRESS 61SESSION_VALUE NULL 62GLOBAL_VALUE 63GLOBAL_VALUE_ORIGIN COMPILE-TIME 64DEFAULT_VALUE 65VARIABLE_SCOPE GLOBAL 66VARIABLE_TYPE VARCHAR 67VARIABLE_COMMENT Address to initially connect to cluster 68NUMERIC_MIN_VALUE NULL 69NUMERIC_MAX_VALUE NULL 70NUMERIC_BLOCK_SIZE NULL 71ENUM_VALUE_LIST NULL 72READ_ONLY NO 73COMMAND_LINE_ARGUMENT REQUIRED 74VARIABLE_NAME WSREP_CLUSTER_NAME 75SESSION_VALUE NULL 76GLOBAL_VALUE my_wsrep_cluster 77GLOBAL_VALUE_ORIGIN COMPILE-TIME 78DEFAULT_VALUE my_wsrep_cluster 79VARIABLE_SCOPE GLOBAL 80VARIABLE_TYPE VARCHAR 81VARIABLE_COMMENT Name for the cluster 82NUMERIC_MIN_VALUE NULL 83NUMERIC_MAX_VALUE NULL 84NUMERIC_BLOCK_SIZE NULL 85ENUM_VALUE_LIST NULL 86READ_ONLY NO 87COMMAND_LINE_ARGUMENT REQUIRED 88VARIABLE_NAME WSREP_CONVERT_LOCK_TO_TRX 89SESSION_VALUE NULL 90GLOBAL_VALUE OFF 91GLOBAL_VALUE_ORIGIN COMPILE-TIME 92DEFAULT_VALUE OFF 93VARIABLE_SCOPE GLOBAL 94VARIABLE_TYPE BOOLEAN 95VARIABLE_COMMENT To convert locking sessions into transactions 96NUMERIC_MIN_VALUE NULL 97NUMERIC_MAX_VALUE NULL 98NUMERIC_BLOCK_SIZE NULL 99ENUM_VALUE_LIST OFF,ON 100READ_ONLY NO 101COMMAND_LINE_ARGUMENT OPTIONAL 102VARIABLE_NAME WSREP_DATA_HOME_DIR 103SESSION_VALUE NULL 104GLOBAL_VALUE DATADIR 105GLOBAL_VALUE_ORIGIN COMPILE-TIME 106DEFAULT_VALUE DATADIR 107VARIABLE_SCOPE GLOBAL 108VARIABLE_TYPE VARCHAR 109VARIABLE_COMMENT home directory for wsrep provider 110NUMERIC_MIN_VALUE NULL 111NUMERIC_MAX_VALUE NULL 112NUMERIC_BLOCK_SIZE NULL 113ENUM_VALUE_LIST NULL 114READ_ONLY YES 115COMMAND_LINE_ARGUMENT REQUIRED 116VARIABLE_NAME WSREP_DBUG_OPTION 117SESSION_VALUE NULL 118GLOBAL_VALUE 119GLOBAL_VALUE_ORIGIN COMPILE-TIME 120DEFAULT_VALUE 121VARIABLE_SCOPE GLOBAL 122VARIABLE_TYPE VARCHAR 123VARIABLE_COMMENT DBUG options to provider library 124NUMERIC_MIN_VALUE NULL 125NUMERIC_MAX_VALUE NULL 126NUMERIC_BLOCK_SIZE NULL 127ENUM_VALUE_LIST NULL 128READ_ONLY NO 129COMMAND_LINE_ARGUMENT REQUIRED 130VARIABLE_NAME WSREP_DEBUG 131SESSION_VALUE NULL 132GLOBAL_VALUE OFF 133GLOBAL_VALUE_ORIGIN COMPILE-TIME 134DEFAULT_VALUE OFF 135VARIABLE_SCOPE GLOBAL 136VARIABLE_TYPE BOOLEAN 137VARIABLE_COMMENT To enable debug level logging 138NUMERIC_MIN_VALUE NULL 139NUMERIC_MAX_VALUE NULL 140NUMERIC_BLOCK_SIZE NULL 141ENUM_VALUE_LIST OFF,ON 142READ_ONLY NO 143COMMAND_LINE_ARGUMENT OPTIONAL 144VARIABLE_NAME WSREP_DESYNC 145SESSION_VALUE NULL 146GLOBAL_VALUE OFF 147GLOBAL_VALUE_ORIGIN COMPILE-TIME 148DEFAULT_VALUE OFF 149VARIABLE_SCOPE GLOBAL 150VARIABLE_TYPE BOOLEAN 151VARIABLE_COMMENT To desynchronize the node from the cluster 152NUMERIC_MIN_VALUE NULL 153NUMERIC_MAX_VALUE NULL 154NUMERIC_BLOCK_SIZE NULL 155ENUM_VALUE_LIST OFF,ON 156READ_ONLY NO 157COMMAND_LINE_ARGUMENT OPTIONAL 158VARIABLE_NAME WSREP_DIRTY_READS 159SESSION_VALUE OFF 160GLOBAL_VALUE OFF 161GLOBAL_VALUE_ORIGIN COMPILE-TIME 162DEFAULT_VALUE OFF 163VARIABLE_SCOPE SESSION 164VARIABLE_TYPE BOOLEAN 165VARIABLE_COMMENT Allow reads even when the node is not in the primary component. 166NUMERIC_MIN_VALUE NULL 167NUMERIC_MAX_VALUE NULL 168NUMERIC_BLOCK_SIZE NULL 169ENUM_VALUE_LIST OFF,ON 170READ_ONLY NO 171COMMAND_LINE_ARGUMENT OPTIONAL 172VARIABLE_NAME WSREP_DRUPAL_282555_WORKAROUND 173SESSION_VALUE NULL 174GLOBAL_VALUE OFF 175GLOBAL_VALUE_ORIGIN COMPILE-TIME 176DEFAULT_VALUE OFF 177VARIABLE_SCOPE GLOBAL 178VARIABLE_TYPE BOOLEAN 179VARIABLE_COMMENT Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error 180NUMERIC_MIN_VALUE NULL 181NUMERIC_MAX_VALUE NULL 182NUMERIC_BLOCK_SIZE NULL 183ENUM_VALUE_LIST OFF,ON 184READ_ONLY NO 185COMMAND_LINE_ARGUMENT OPTIONAL 186VARIABLE_NAME WSREP_FORCED_BINLOG_FORMAT 187SESSION_VALUE NULL 188GLOBAL_VALUE NONE 189GLOBAL_VALUE_ORIGIN COMPILE-TIME 190DEFAULT_VALUE NONE 191VARIABLE_SCOPE GLOBAL 192VARIABLE_TYPE ENUM 193VARIABLE_COMMENT binlog format to take effect over user's choice 194NUMERIC_MIN_VALUE NULL 195NUMERIC_MAX_VALUE NULL 196NUMERIC_BLOCK_SIZE NULL 197ENUM_VALUE_LIST MIXED,STATEMENT,ROW,NONE 198READ_ONLY NO 199COMMAND_LINE_ARGUMENT REQUIRED 200VARIABLE_NAME WSREP_GTID_DOMAIN_ID 201SESSION_VALUE NULL 202GLOBAL_VALUE 0 203GLOBAL_VALUE_ORIGIN COMPILE-TIME 204DEFAULT_VALUE 0 205VARIABLE_SCOPE GLOBAL 206VARIABLE_TYPE INT UNSIGNED 207VARIABLE_COMMENT When wsrep_gtid_mode is set, this value is used as gtid_domain_id for galera transactions and also copied to the joiner nodes during state transfer. It is ignored, otherwise. 208NUMERIC_MIN_VALUE 0 209NUMERIC_MAX_VALUE 4294967295 210NUMERIC_BLOCK_SIZE 1 211ENUM_VALUE_LIST NULL 212READ_ONLY NO 213COMMAND_LINE_ARGUMENT REQUIRED 214VARIABLE_NAME WSREP_GTID_MODE 215SESSION_VALUE NULL 216GLOBAL_VALUE OFF 217GLOBAL_VALUE_ORIGIN COMPILE-TIME 218DEFAULT_VALUE OFF 219VARIABLE_SCOPE GLOBAL 220VARIABLE_TYPE BOOLEAN 221VARIABLE_COMMENT Automatically update the (joiner) node's wsrep_gtid_domain_id value with that of donor's (received during state transfer) and use it in place of gtid_domain_id for all galera transactions. When OFF (default), wsrep_gtid_domain_id is simply ignored (backward compatibility). 222NUMERIC_MIN_VALUE NULL 223NUMERIC_MAX_VALUE NULL 224NUMERIC_BLOCK_SIZE NULL 225ENUM_VALUE_LIST OFF,ON 226READ_ONLY NO 227COMMAND_LINE_ARGUMENT OPTIONAL 228VARIABLE_NAME WSREP_LOAD_DATA_SPLITTING 229SESSION_VALUE NULL 230GLOBAL_VALUE ON 231GLOBAL_VALUE_ORIGIN COMPILE-TIME 232DEFAULT_VALUE ON 233VARIABLE_SCOPE GLOBAL 234VARIABLE_TYPE BOOLEAN 235VARIABLE_COMMENT To commit LOAD DATA transaction after every 10K rows inserted 236NUMERIC_MIN_VALUE NULL 237NUMERIC_MAX_VALUE NULL 238NUMERIC_BLOCK_SIZE NULL 239ENUM_VALUE_LIST OFF,ON 240READ_ONLY NO 241COMMAND_LINE_ARGUMENT OPTIONAL 242VARIABLE_NAME WSREP_LOG_CONFLICTS 243SESSION_VALUE NULL 244GLOBAL_VALUE OFF 245GLOBAL_VALUE_ORIGIN COMPILE-TIME 246DEFAULT_VALUE OFF 247VARIABLE_SCOPE GLOBAL 248VARIABLE_TYPE BOOLEAN 249VARIABLE_COMMENT To log multi-master conflicts 250NUMERIC_MIN_VALUE NULL 251NUMERIC_MAX_VALUE NULL 252NUMERIC_BLOCK_SIZE NULL 253ENUM_VALUE_LIST OFF,ON 254READ_ONLY NO 255COMMAND_LINE_ARGUMENT OPTIONAL 256VARIABLE_NAME WSREP_MAX_WS_ROWS 257SESSION_VALUE NULL 258GLOBAL_VALUE 0 259GLOBAL_VALUE_ORIGIN COMPILE-TIME 260DEFAULT_VALUE 0 261VARIABLE_SCOPE GLOBAL 262VARIABLE_TYPE BIGINT UNSIGNED 263VARIABLE_COMMENT Max number of rows in write set 264NUMERIC_MIN_VALUE 0 265NUMERIC_MAX_VALUE 1048576 266NUMERIC_BLOCK_SIZE 1 267ENUM_VALUE_LIST NULL 268READ_ONLY NO 269COMMAND_LINE_ARGUMENT REQUIRED 270VARIABLE_NAME WSREP_MAX_WS_SIZE 271SESSION_VALUE NULL 272GLOBAL_VALUE 2147483647 273GLOBAL_VALUE_ORIGIN COMPILE-TIME 274DEFAULT_VALUE 2147483647 275VARIABLE_SCOPE GLOBAL 276VARIABLE_TYPE BIGINT UNSIGNED 277VARIABLE_COMMENT Max write set size (bytes) 278NUMERIC_MIN_VALUE 1024 279NUMERIC_MAX_VALUE 2147483647 280NUMERIC_BLOCK_SIZE 1 281ENUM_VALUE_LIST NULL 282READ_ONLY NO 283COMMAND_LINE_ARGUMENT REQUIRED 284VARIABLE_NAME WSREP_MYSQL_REPLICATION_BUNDLE 285SESSION_VALUE NULL 286GLOBAL_VALUE 0 287GLOBAL_VALUE_ORIGIN COMPILE-TIME 288DEFAULT_VALUE 0 289VARIABLE_SCOPE GLOBAL 290VARIABLE_TYPE BIGINT UNSIGNED 291VARIABLE_COMMENT mysql replication group commit 292NUMERIC_MIN_VALUE 0 293NUMERIC_MAX_VALUE 1000 294NUMERIC_BLOCK_SIZE 1 295ENUM_VALUE_LIST NULL 296READ_ONLY NO 297COMMAND_LINE_ARGUMENT REQUIRED 298VARIABLE_NAME WSREP_NODE_ADDRESS 299SESSION_VALUE NULL 300GLOBAL_VALUE 301GLOBAL_VALUE_ORIGIN COMPILE-TIME 302DEFAULT_VALUE 303VARIABLE_SCOPE GLOBAL 304VARIABLE_TYPE VARCHAR 305VARIABLE_COMMENT Specifies the node's network address, in the format ip address[:port]. Used in situations where autoguessing is not reliable. As of MariaDB 10.1.8, supports IPv6. 306NUMERIC_MIN_VALUE NULL 307NUMERIC_MAX_VALUE NULL 308NUMERIC_BLOCK_SIZE NULL 309ENUM_VALUE_LIST NULL 310READ_ONLY NO 311COMMAND_LINE_ARGUMENT REQUIRED 312VARIABLE_NAME WSREP_NODE_INCOMING_ADDRESS 313SESSION_VALUE NULL 314GLOBAL_VALUE AUTO 315GLOBAL_VALUE_ORIGIN COMPILE-TIME 316DEFAULT_VALUE AUTO 317VARIABLE_SCOPE GLOBAL 318VARIABLE_TYPE VARCHAR 319VARIABLE_COMMENT Client connection address 320NUMERIC_MIN_VALUE NULL 321NUMERIC_MAX_VALUE NULL 322NUMERIC_BLOCK_SIZE NULL 323ENUM_VALUE_LIST NULL 324READ_ONLY NO 325COMMAND_LINE_ARGUMENT REQUIRED 326VARIABLE_NAME WSREP_NODE_NAME 327SESSION_VALUE NULL 328GLOBAL_VALUE HOSTNAME 329GLOBAL_VALUE_ORIGIN COMPILE-TIME 330DEFAULT_VALUE HOSTNAME 331VARIABLE_SCOPE GLOBAL 332VARIABLE_TYPE VARCHAR 333VARIABLE_COMMENT Name of this node. This name can be used in wsrep_sst_donor as a preferred donor. Note that multiple nodes in a cluster can have the same name. 334NUMERIC_MIN_VALUE NULL 335NUMERIC_MAX_VALUE NULL 336NUMERIC_BLOCK_SIZE NULL 337ENUM_VALUE_LIST NULL 338READ_ONLY NO 339COMMAND_LINE_ARGUMENT REQUIRED 340VARIABLE_NAME WSREP_NOTIFY_CMD 341SESSION_VALUE NULL 342GLOBAL_VALUE 343GLOBAL_VALUE_ORIGIN COMPILE-TIME 344DEFAULT_VALUE 345VARIABLE_SCOPE GLOBAL 346VARIABLE_TYPE VARCHAR 347VARIABLE_COMMENT 348NUMERIC_MIN_VALUE NULL 349NUMERIC_MAX_VALUE NULL 350NUMERIC_BLOCK_SIZE NULL 351ENUM_VALUE_LIST NULL 352READ_ONLY YES 353COMMAND_LINE_ARGUMENT REQUIRED 354VARIABLE_NAME WSREP_ON 355SESSION_VALUE OFF 356GLOBAL_VALUE OFF 357GLOBAL_VALUE_ORIGIN COMPILE-TIME 358DEFAULT_VALUE OFF 359VARIABLE_SCOPE SESSION 360VARIABLE_TYPE BOOLEAN 361VARIABLE_COMMENT To enable wsrep replication 362NUMERIC_MIN_VALUE NULL 363NUMERIC_MAX_VALUE NULL 364NUMERIC_BLOCK_SIZE NULL 365ENUM_VALUE_LIST OFF,ON 366READ_ONLY NO 367COMMAND_LINE_ARGUMENT OPTIONAL 368VARIABLE_NAME WSREP_OSU_METHOD 369SESSION_VALUE TOI 370GLOBAL_VALUE TOI 371GLOBAL_VALUE_ORIGIN COMPILE-TIME 372DEFAULT_VALUE TOI 373VARIABLE_SCOPE SESSION 374VARIABLE_TYPE ENUM 375VARIABLE_COMMENT Method for Online Schema Upgrade 376NUMERIC_MIN_VALUE NULL 377NUMERIC_MAX_VALUE NULL 378NUMERIC_BLOCK_SIZE NULL 379ENUM_VALUE_LIST TOI,RSU 380READ_ONLY NO 381COMMAND_LINE_ARGUMENT OPTIONAL 382VARIABLE_NAME WSREP_PATCH_VERSION 383SESSION_VALUE NULL 384GLOBAL_VALUE wsrep_MAJVER.MINVER 385GLOBAL_VALUE_ORIGIN COMPILE-TIME 386DEFAULT_VALUE NULL 387VARIABLE_SCOPE GLOBAL 388VARIABLE_TYPE VARCHAR 389VARIABLE_COMMENT Wsrep patch version, for example wsrep_MAJVER.MINVER. 390NUMERIC_MIN_VALUE NULL 391NUMERIC_MAX_VALUE NULL 392NUMERIC_BLOCK_SIZE NULL 393ENUM_VALUE_LIST NULL 394READ_ONLY YES 395COMMAND_LINE_ARGUMENT NULL 396VARIABLE_NAME WSREP_PROVIDER 397SESSION_VALUE NULL 398GLOBAL_VALUE none 399GLOBAL_VALUE_ORIGIN COMPILE-TIME 400DEFAULT_VALUE none 401VARIABLE_SCOPE GLOBAL 402VARIABLE_TYPE VARCHAR 403VARIABLE_COMMENT Path to replication provider library 404NUMERIC_MIN_VALUE NULL 405NUMERIC_MAX_VALUE NULL 406NUMERIC_BLOCK_SIZE NULL 407ENUM_VALUE_LIST NULL 408READ_ONLY YES 409COMMAND_LINE_ARGUMENT REQUIRED 410VARIABLE_NAME WSREP_PROVIDER_OPTIONS 411SESSION_VALUE NULL 412GLOBAL_VALUE 413GLOBAL_VALUE_ORIGIN COMPILE-TIME 414DEFAULT_VALUE 415VARIABLE_SCOPE GLOBAL 416VARIABLE_TYPE VARCHAR 417VARIABLE_COMMENT Semicolon (;) separated list of wsrep options (see wsrep_provider_options documentation). 418NUMERIC_MIN_VALUE NULL 419NUMERIC_MAX_VALUE NULL 420NUMERIC_BLOCK_SIZE NULL 421ENUM_VALUE_LIST NULL 422READ_ONLY NO 423COMMAND_LINE_ARGUMENT REQUIRED 424VARIABLE_NAME WSREP_RECOVER 425SESSION_VALUE NULL 426GLOBAL_VALUE OFF 427GLOBAL_VALUE_ORIGIN COMPILE-TIME 428DEFAULT_VALUE OFF 429VARIABLE_SCOPE GLOBAL 430VARIABLE_TYPE BOOLEAN 431VARIABLE_COMMENT Recover database state after crash and exit 432NUMERIC_MIN_VALUE NULL 433NUMERIC_MAX_VALUE NULL 434NUMERIC_BLOCK_SIZE NULL 435ENUM_VALUE_LIST OFF,ON 436READ_ONLY YES 437COMMAND_LINE_ARGUMENT OPTIONAL 438VARIABLE_NAME WSREP_REJECT_QUERIES 439SESSION_VALUE NULL 440GLOBAL_VALUE NONE 441GLOBAL_VALUE_ORIGIN COMPILE-TIME 442DEFAULT_VALUE NONE 443VARIABLE_SCOPE GLOBAL 444VARIABLE_TYPE ENUM 445VARIABLE_COMMENT Variable to set to reject queries 446NUMERIC_MIN_VALUE NULL 447NUMERIC_MAX_VALUE NULL 448NUMERIC_BLOCK_SIZE NULL 449ENUM_VALUE_LIST NONE,ALL,ALL_KILL 450READ_ONLY NO 451COMMAND_LINE_ARGUMENT OPTIONAL 452VARIABLE_NAME WSREP_REPLICATE_MYISAM 453SESSION_VALUE NULL 454GLOBAL_VALUE OFF 455GLOBAL_VALUE_ORIGIN COMPILE-TIME 456DEFAULT_VALUE OFF 457VARIABLE_SCOPE GLOBAL 458VARIABLE_TYPE BOOLEAN 459VARIABLE_COMMENT To enable myisam replication 460NUMERIC_MIN_VALUE NULL 461NUMERIC_MAX_VALUE NULL 462NUMERIC_BLOCK_SIZE NULL 463ENUM_VALUE_LIST OFF,ON 464READ_ONLY NO 465COMMAND_LINE_ARGUMENT OPTIONAL 466VARIABLE_NAME WSREP_RESTART_SLAVE 467SESSION_VALUE NULL 468GLOBAL_VALUE OFF 469GLOBAL_VALUE_ORIGIN COMPILE-TIME 470DEFAULT_VALUE OFF 471VARIABLE_SCOPE GLOBAL 472VARIABLE_TYPE BOOLEAN 473VARIABLE_COMMENT Should MariaDB slave be restarted automatically, when node joins back to cluster 474NUMERIC_MIN_VALUE NULL 475NUMERIC_MAX_VALUE NULL 476NUMERIC_BLOCK_SIZE NULL 477ENUM_VALUE_LIST OFF,ON 478READ_ONLY NO 479COMMAND_LINE_ARGUMENT OPTIONAL 480VARIABLE_NAME WSREP_RETRY_AUTOCOMMIT 481SESSION_VALUE 1 482GLOBAL_VALUE 1 483GLOBAL_VALUE_ORIGIN COMPILE-TIME 484DEFAULT_VALUE 1 485VARIABLE_SCOPE SESSION 486VARIABLE_TYPE BIGINT UNSIGNED 487VARIABLE_COMMENT Max number of times to retry a failed autocommit statement 488NUMERIC_MIN_VALUE 0 489NUMERIC_MAX_VALUE 10000 490NUMERIC_BLOCK_SIZE 1 491ENUM_VALUE_LIST NULL 492READ_ONLY NO 493COMMAND_LINE_ARGUMENT REQUIRED 494VARIABLE_NAME WSREP_SLAVE_FK_CHECKS 495SESSION_VALUE NULL 496GLOBAL_VALUE ON 497GLOBAL_VALUE_ORIGIN COMPILE-TIME 498DEFAULT_VALUE ON 499VARIABLE_SCOPE GLOBAL 500VARIABLE_TYPE BOOLEAN 501VARIABLE_COMMENT Should slave thread do foreign key constraint checks 502NUMERIC_MIN_VALUE NULL 503NUMERIC_MAX_VALUE NULL 504NUMERIC_BLOCK_SIZE NULL 505ENUM_VALUE_LIST OFF,ON 506READ_ONLY NO 507COMMAND_LINE_ARGUMENT OPTIONAL 508VARIABLE_NAME WSREP_SLAVE_THREADS 509SESSION_VALUE NULL 510GLOBAL_VALUE 1 511GLOBAL_VALUE_ORIGIN COMPILE-TIME 512DEFAULT_VALUE 1 513VARIABLE_SCOPE GLOBAL 514VARIABLE_TYPE BIGINT UNSIGNED 515VARIABLE_COMMENT Number of slave appliers to launch 516NUMERIC_MIN_VALUE 1 517NUMERIC_MAX_VALUE 512 518NUMERIC_BLOCK_SIZE 1 519ENUM_VALUE_LIST NULL 520READ_ONLY NO 521COMMAND_LINE_ARGUMENT REQUIRED 522VARIABLE_NAME WSREP_SLAVE_UK_CHECKS 523SESSION_VALUE NULL 524GLOBAL_VALUE OFF 525GLOBAL_VALUE_ORIGIN COMPILE-TIME 526DEFAULT_VALUE OFF 527VARIABLE_SCOPE GLOBAL 528VARIABLE_TYPE BOOLEAN 529VARIABLE_COMMENT Should slave thread do secondary index uniqueness checks 530NUMERIC_MIN_VALUE NULL 531NUMERIC_MAX_VALUE NULL 532NUMERIC_BLOCK_SIZE NULL 533ENUM_VALUE_LIST OFF,ON 534READ_ONLY NO 535COMMAND_LINE_ARGUMENT OPTIONAL 536VARIABLE_NAME WSREP_SST_AUTH 537SESSION_VALUE NULL 538GLOBAL_VALUE 539GLOBAL_VALUE_ORIGIN COMPILE-TIME 540DEFAULT_VALUE 541VARIABLE_SCOPE GLOBAL 542VARIABLE_TYPE VARCHAR 543VARIABLE_COMMENT Authentication for SST connection 544NUMERIC_MIN_VALUE NULL 545NUMERIC_MAX_VALUE NULL 546NUMERIC_BLOCK_SIZE NULL 547ENUM_VALUE_LIST NULL 548READ_ONLY NO 549COMMAND_LINE_ARGUMENT REQUIRED 550VARIABLE_NAME WSREP_SST_DONOR 551SESSION_VALUE NULL 552GLOBAL_VALUE 553GLOBAL_VALUE_ORIGIN COMPILE-TIME 554DEFAULT_VALUE 555VARIABLE_SCOPE GLOBAL 556VARIABLE_TYPE VARCHAR 557VARIABLE_COMMENT preferred donor node for the SST 558NUMERIC_MIN_VALUE NULL 559NUMERIC_MAX_VALUE NULL 560NUMERIC_BLOCK_SIZE NULL 561ENUM_VALUE_LIST NULL 562READ_ONLY NO 563COMMAND_LINE_ARGUMENT REQUIRED 564VARIABLE_NAME WSREP_SST_DONOR_REJECTS_QUERIES 565SESSION_VALUE NULL 566GLOBAL_VALUE OFF 567GLOBAL_VALUE_ORIGIN COMPILE-TIME 568DEFAULT_VALUE OFF 569VARIABLE_SCOPE GLOBAL 570VARIABLE_TYPE BOOLEAN 571VARIABLE_COMMENT Reject client queries when donating state snapshot transfer 572NUMERIC_MIN_VALUE NULL 573NUMERIC_MAX_VALUE NULL 574NUMERIC_BLOCK_SIZE NULL 575ENUM_VALUE_LIST OFF,ON 576READ_ONLY NO 577COMMAND_LINE_ARGUMENT OPTIONAL 578VARIABLE_NAME WSREP_SST_METHOD 579SESSION_VALUE NULL 580GLOBAL_VALUE rsync 581GLOBAL_VALUE_ORIGIN COMPILE-TIME 582DEFAULT_VALUE rsync 583VARIABLE_SCOPE GLOBAL 584VARIABLE_TYPE VARCHAR 585VARIABLE_COMMENT State snapshot transfer method 586NUMERIC_MIN_VALUE NULL 587NUMERIC_MAX_VALUE NULL 588NUMERIC_BLOCK_SIZE NULL 589ENUM_VALUE_LIST NULL 590READ_ONLY NO 591COMMAND_LINE_ARGUMENT REQUIRED 592VARIABLE_NAME WSREP_SST_RECEIVE_ADDRESS 593SESSION_VALUE NULL 594GLOBAL_VALUE AUTO 595GLOBAL_VALUE_ORIGIN COMPILE-TIME 596DEFAULT_VALUE AUTO 597VARIABLE_SCOPE GLOBAL 598VARIABLE_TYPE VARCHAR 599VARIABLE_COMMENT Address where node is waiting for SST contact 600NUMERIC_MIN_VALUE NULL 601NUMERIC_MAX_VALUE NULL 602NUMERIC_BLOCK_SIZE NULL 603ENUM_VALUE_LIST NULL 604READ_ONLY NO 605COMMAND_LINE_ARGUMENT REQUIRED 606VARIABLE_NAME WSREP_START_POSITION 607SESSION_VALUE NULL 608GLOBAL_VALUE 00000000-0000-0000-0000-000000000000:-1 609GLOBAL_VALUE_ORIGIN COMPILE-TIME 610DEFAULT_VALUE 00000000-0000-0000-0000-000000000000:-1 611VARIABLE_SCOPE GLOBAL 612VARIABLE_TYPE VARCHAR 613VARIABLE_COMMENT global transaction position to start from 614NUMERIC_MIN_VALUE NULL 615NUMERIC_MAX_VALUE NULL 616NUMERIC_BLOCK_SIZE NULL 617ENUM_VALUE_LIST NULL 618READ_ONLY NO 619COMMAND_LINE_ARGUMENT REQUIRED 620VARIABLE_NAME WSREP_SYNC_WAIT 621SESSION_VALUE 0 622GLOBAL_VALUE 0 623GLOBAL_VALUE_ORIGIN COMPILE-TIME 624DEFAULT_VALUE 0 625VARIABLE_SCOPE SESSION 626VARIABLE_TYPE INT UNSIGNED 627VARIABLE_COMMENT Ensure "synchronous" read view before executing an operation of the type specified by bitmask: 1 - READ(includes SELECT, SHOW and BEGIN/START TRANSACTION); 2 - UPDATE and DELETE; 4 - INSERT and REPLACE 628NUMERIC_MIN_VALUE 0 629NUMERIC_MAX_VALUE 15 630NUMERIC_BLOCK_SIZE 1 631ENUM_VALUE_LIST NULL 632READ_ONLY NO 633COMMAND_LINE_ARGUMENT OPTIONAL 634