Debian Codegraph @

mysql-test/suite/sys_vars/r/sysvars_wsrep.result

raw
1 select * from information_schema.system_variables
2 where variable_name like 'wsrep%'
3 order by variable_name;
4 VARIABLE_NAME WSREP_ALLOWLIST
5 SESSION_VALUE NULL
6 GLOBAL_VALUE
7 GLOBAL_VALUE_ORIGIN COMPILE-TIME
8 DEFAULT_VALUE
9 VARIABLE_SCOPE GLOBAL
10 VARIABLE_TYPE VARCHAR
11 VARIABLE_COMMENT Allowed IP addresses split by comma delimiter
12 NUMERIC_MIN_VALUE NULL
13 NUMERIC_MAX_VALUE NULL
14 NUMERIC_BLOCK_SIZE NULL
15 ENUM_VALUE_LIST NULL
16 READ_ONLY YES
17 COMMAND_LINE_ARGUMENT REQUIRED
18 GLOBAL_VALUE_PATH NULL
19 VARIABLE_NAME WSREP_AUTO_INCREMENT_CONTROL
20 SESSION_VALUE NULL
21 GLOBAL_VALUE ON
22 GLOBAL_VALUE_ORIGIN COMPILE-TIME
23 DEFAULT_VALUE ON
24 VARIABLE_SCOPE GLOBAL
25 VARIABLE_TYPE BOOLEAN
26 VARIABLE_COMMENT To automatically control the assignment of autoincrement variables
27 NUMERIC_MIN_VALUE NULL
28 NUMERIC_MAX_VALUE NULL
29 NUMERIC_BLOCK_SIZE NULL
30 ENUM_VALUE_LIST OFF,ON
31 READ_ONLY NO
32 COMMAND_LINE_ARGUMENT OPTIONAL
33 GLOBAL_VALUE_PATH NULL
34 VARIABLE_NAME WSREP_CERTIFICATION_RULES
35 SESSION_VALUE NULL
36 GLOBAL_VALUE strict
37 GLOBAL_VALUE_ORIGIN COMPILE-TIME
38 DEFAULT_VALUE strict
39 VARIABLE_SCOPE GLOBAL
40 VARIABLE_TYPE ENUM
41 VARIABLE_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
42 NUMERIC_MIN_VALUE NULL
43 NUMERIC_MAX_VALUE NULL
44 NUMERIC_BLOCK_SIZE NULL
45 ENUM_VALUE_LIST strict,optimized
46 READ_ONLY NO
47 COMMAND_LINE_ARGUMENT REQUIRED
48 GLOBAL_VALUE_PATH NULL
49 VARIABLE_NAME WSREP_CERTIFY_NONPK
50 SESSION_VALUE NULL
51 GLOBAL_VALUE ON
52 GLOBAL_VALUE_ORIGIN COMPILE-TIME
53 DEFAULT_VALUE ON
54 VARIABLE_SCOPE GLOBAL
55 VARIABLE_TYPE BOOLEAN
56 VARIABLE_COMMENT Certify tables with no primary key
57 NUMERIC_MIN_VALUE NULL
58 NUMERIC_MAX_VALUE NULL
59 NUMERIC_BLOCK_SIZE NULL
60 ENUM_VALUE_LIST OFF,ON
61 READ_ONLY NO
62 COMMAND_LINE_ARGUMENT OPTIONAL
63 GLOBAL_VALUE_PATH NULL
64 VARIABLE_NAME WSREP_CLUSTER_ADDRESS
65 SESSION_VALUE NULL
66 GLOBAL_VALUE
67 GLOBAL_VALUE_ORIGIN COMPILE-TIME
68 DEFAULT_VALUE
69 VARIABLE_SCOPE GLOBAL
70 VARIABLE_TYPE VARCHAR
71 VARIABLE_COMMENT Address to initially connect to cluster
72 NUMERIC_MIN_VALUE NULL
73 NUMERIC_MAX_VALUE NULL
74 NUMERIC_BLOCK_SIZE NULL
75 ENUM_VALUE_LIST NULL
76 READ_ONLY NO
77 COMMAND_LINE_ARGUMENT REQUIRED
78 GLOBAL_VALUE_PATH NULL
79 VARIABLE_NAME WSREP_CLUSTER_NAME
80 SESSION_VALUE NULL
81 GLOBAL_VALUE my_wsrep_cluster
82 GLOBAL_VALUE_ORIGIN COMPILE-TIME
83 DEFAULT_VALUE my_wsrep_cluster
84 VARIABLE_SCOPE GLOBAL
85 VARIABLE_TYPE VARCHAR
86 VARIABLE_COMMENT Name for the cluster
87 NUMERIC_MIN_VALUE NULL
88 NUMERIC_MAX_VALUE NULL
89 NUMERIC_BLOCK_SIZE NULL
90 ENUM_VALUE_LIST NULL
91 READ_ONLY NO
92 COMMAND_LINE_ARGUMENT REQUIRED
93 GLOBAL_VALUE_PATH NULL
94 VARIABLE_NAME WSREP_CONVERT_LOCK_TO_TRX
95 SESSION_VALUE NULL
96 GLOBAL_VALUE OFF
97 GLOBAL_VALUE_ORIGIN COMPILE-TIME
98 DEFAULT_VALUE OFF
99 VARIABLE_SCOPE GLOBAL
100 VARIABLE_TYPE BOOLEAN
101 VARIABLE_COMMENT To convert locking sessions into transactions
102 NUMERIC_MIN_VALUE NULL
103 NUMERIC_MAX_VALUE NULL
104 NUMERIC_BLOCK_SIZE NULL
105 ENUM_VALUE_LIST OFF,ON
106 READ_ONLY NO
107 COMMAND_LINE_ARGUMENT OPTIONAL
108 GLOBAL_VALUE_PATH NULL
109 VARIABLE_NAME WSREP_DATA_HOME_DIR
110 SESSION_VALUE NULL
111 GLOBAL_VALUE DATADIR
112 GLOBAL_VALUE_ORIGIN COMPILE-TIME
113 DEFAULT_VALUE DATADIR
114 VARIABLE_SCOPE GLOBAL
115 VARIABLE_TYPE VARCHAR
116 VARIABLE_COMMENT home directory for wsrep provider
117 NUMERIC_MIN_VALUE NULL
118 NUMERIC_MAX_VALUE NULL
119 NUMERIC_BLOCK_SIZE NULL
120 ENUM_VALUE_LIST NULL
121 READ_ONLY YES
122 COMMAND_LINE_ARGUMENT REQUIRED
123 GLOBAL_VALUE_PATH NULL
124 VARIABLE_NAME WSREP_DBUG_OPTION
125 SESSION_VALUE NULL
126 GLOBAL_VALUE
127 GLOBAL_VALUE_ORIGIN COMPILE-TIME
128 DEFAULT_VALUE
129 VARIABLE_SCOPE GLOBAL
130 VARIABLE_TYPE VARCHAR
131 VARIABLE_COMMENT DBUG options to provider library
132 NUMERIC_MIN_VALUE NULL
133 NUMERIC_MAX_VALUE NULL
134 NUMERIC_BLOCK_SIZE NULL
135 ENUM_VALUE_LIST NULL
136 READ_ONLY NO
137 COMMAND_LINE_ARGUMENT REQUIRED
138 GLOBAL_VALUE_PATH NULL
139 VARIABLE_NAME WSREP_DEBUG
140 SESSION_VALUE NULL
141 GLOBAL_VALUE NONE
142 GLOBAL_VALUE_ORIGIN COMPILE-TIME
143 DEFAULT_VALUE NONE
144 VARIABLE_SCOPE GLOBAL
145 VARIABLE_TYPE ENUM
146 VARIABLE_COMMENT WSREP debug level logging
147 NUMERIC_MIN_VALUE NULL
148 NUMERIC_MAX_VALUE NULL
149 NUMERIC_BLOCK_SIZE NULL
150 ENUM_VALUE_LIST NONE,SERVER,TRANSACTION,STREAMING,CLIENT
151 READ_ONLY NO
152 COMMAND_LINE_ARGUMENT REQUIRED
153 GLOBAL_VALUE_PATH NULL
154 VARIABLE_NAME WSREP_DESYNC
155 SESSION_VALUE NULL
156 GLOBAL_VALUE OFF
157 GLOBAL_VALUE_ORIGIN COMPILE-TIME
158 DEFAULT_VALUE OFF
159 VARIABLE_SCOPE GLOBAL
160 VARIABLE_TYPE BOOLEAN
161 VARIABLE_COMMENT To desynchronize the node from the cluster
162 NUMERIC_MIN_VALUE NULL
163 NUMERIC_MAX_VALUE NULL
164 NUMERIC_BLOCK_SIZE NULL
165 ENUM_VALUE_LIST OFF,ON
166 READ_ONLY NO
167 COMMAND_LINE_ARGUMENT OPTIONAL
168 GLOBAL_VALUE_PATH NULL
169 VARIABLE_NAME WSREP_DIRTY_READS
170 SESSION_VALUE OFF
171 GLOBAL_VALUE OFF
172 GLOBAL_VALUE_ORIGIN COMPILE-TIME
173 DEFAULT_VALUE OFF
174 VARIABLE_SCOPE SESSION
175 VARIABLE_TYPE BOOLEAN
176 VARIABLE_COMMENT Allow reads even when the node is not in the primary component
177 NUMERIC_MIN_VALUE NULL
178 NUMERIC_MAX_VALUE NULL
179 NUMERIC_BLOCK_SIZE NULL
180 ENUM_VALUE_LIST OFF,ON
181 READ_ONLY NO
182 COMMAND_LINE_ARGUMENT OPTIONAL
183 GLOBAL_VALUE_PATH NULL
184 VARIABLE_NAME WSREP_DRUPAL_282555_WORKAROUND
185 SESSION_VALUE NULL
186 GLOBAL_VALUE OFF
187 GLOBAL_VALUE_ORIGIN COMPILE-TIME
188 DEFAULT_VALUE OFF
189 VARIABLE_SCOPE GLOBAL
190 VARIABLE_TYPE BOOLEAN
191 VARIABLE_COMMENT Enable a workaround to handle the cases where inserting a DEFAULT value into an auto-increment column could fail with duplicate key error
192 NUMERIC_MIN_VALUE NULL
193 NUMERIC_MAX_VALUE NULL
194 NUMERIC_BLOCK_SIZE NULL
195 ENUM_VALUE_LIST OFF,ON
196 READ_ONLY NO
197 COMMAND_LINE_ARGUMENT OPTIONAL
198 GLOBAL_VALUE_PATH NULL
199 VARIABLE_NAME WSREP_FORCED_BINLOG_FORMAT
200 SESSION_VALUE NULL
201 GLOBAL_VALUE NONE
202 GLOBAL_VALUE_ORIGIN COMPILE-TIME
203 DEFAULT_VALUE NONE
204 VARIABLE_SCOPE GLOBAL
205 VARIABLE_TYPE ENUM
206 VARIABLE_COMMENT binlog format to take effect over user's choice
207 NUMERIC_MIN_VALUE NULL
208 NUMERIC_MAX_VALUE NULL
209 NUMERIC_BLOCK_SIZE NULL
210 ENUM_VALUE_LIST MIXED,STATEMENT,ROW,NONE
211 READ_ONLY NO
212 COMMAND_LINE_ARGUMENT REQUIRED
213 GLOBAL_VALUE_PATH NULL
214 VARIABLE_NAME WSREP_GTID_DOMAIN_ID
215 SESSION_VALUE NULL
216 GLOBAL_VALUE 0
217 GLOBAL_VALUE_ORIGIN COMPILE-TIME
218 DEFAULT_VALUE 0
219 VARIABLE_SCOPE GLOBAL
220 VARIABLE_TYPE INT UNSIGNED
221 VARIABLE_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
222 NUMERIC_MIN_VALUE 0
223 NUMERIC_MAX_VALUE 4294967295
224 NUMERIC_BLOCK_SIZE 1
225 ENUM_VALUE_LIST NULL
226 READ_ONLY NO
227 COMMAND_LINE_ARGUMENT REQUIRED
228 GLOBAL_VALUE_PATH NULL
229 VARIABLE_NAME WSREP_GTID_MODE
230 SESSION_VALUE NULL
231 GLOBAL_VALUE OFF
232 GLOBAL_VALUE_ORIGIN COMPILE-TIME
233 DEFAULT_VALUE OFF
234 VARIABLE_SCOPE GLOBAL
235 VARIABLE_TYPE BOOLEAN
236 VARIABLE_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)
237 NUMERIC_MIN_VALUE NULL
238 NUMERIC_MAX_VALUE NULL
239 NUMERIC_BLOCK_SIZE NULL
240 ENUM_VALUE_LIST OFF,ON
241 READ_ONLY NO
242 COMMAND_LINE_ARGUMENT OPTIONAL
243 GLOBAL_VALUE_PATH NULL
244 VARIABLE_NAME WSREP_GTID_SEQ_NO
245 SESSION_VALUE 0
246 GLOBAL_VALUE NULL
247 GLOBAL_VALUE_ORIGIN COMPILE-TIME
248 DEFAULT_VALUE 0
249 VARIABLE_SCOPE SESSION ONLY
250 VARIABLE_TYPE BIGINT UNSIGNED
251 VARIABLE_COMMENT Internal server usage, manually set WSREP GTID seqno
252 NUMERIC_MIN_VALUE 0
253 NUMERIC_MAX_VALUE 18446744073709551615
254 NUMERIC_BLOCK_SIZE 1
255 ENUM_VALUE_LIST NULL
256 READ_ONLY NO
257 COMMAND_LINE_ARGUMENT NULL
258 GLOBAL_VALUE_PATH NULL
259 VARIABLE_NAME WSREP_IGNORE_APPLY_ERRORS
260 SESSION_VALUE NULL
261 GLOBAL_VALUE 7
262 GLOBAL_VALUE_ORIGIN COMPILE-TIME
263 DEFAULT_VALUE 7
264 VARIABLE_SCOPE GLOBAL
265 VARIABLE_TYPE INT UNSIGNED
266 VARIABLE_COMMENT Ignore replication errors
267 NUMERIC_MIN_VALUE 0
268 NUMERIC_MAX_VALUE 7
269 NUMERIC_BLOCK_SIZE 1
270 ENUM_VALUE_LIST NULL
271 READ_ONLY NO
272 COMMAND_LINE_ARGUMENT REQUIRED
273 GLOBAL_VALUE_PATH NULL
274 VARIABLE_NAME WSREP_LOG_CONFLICTS
275 SESSION_VALUE NULL
276 GLOBAL_VALUE OFF
277 GLOBAL_VALUE_ORIGIN COMPILE-TIME
278 DEFAULT_VALUE OFF
279 VARIABLE_SCOPE GLOBAL
280 VARIABLE_TYPE BOOLEAN
281 VARIABLE_COMMENT To log multi-master conflicts
282 NUMERIC_MIN_VALUE NULL
283 NUMERIC_MAX_VALUE NULL
284 NUMERIC_BLOCK_SIZE NULL
285 ENUM_VALUE_LIST OFF,ON
286 READ_ONLY NO
287 COMMAND_LINE_ARGUMENT OPTIONAL
288 GLOBAL_VALUE_PATH NULL
289 VARIABLE_NAME WSREP_MAX_WS_ROWS
290 SESSION_VALUE NULL
291 GLOBAL_VALUE 0
292 GLOBAL_VALUE_ORIGIN COMPILE-TIME
293 DEFAULT_VALUE 0
294 VARIABLE_SCOPE GLOBAL
295 VARIABLE_TYPE BIGINT UNSIGNED
296 VARIABLE_COMMENT Max number of rows in write set
297 NUMERIC_MIN_VALUE 0
298 NUMERIC_MAX_VALUE 1048576
299 NUMERIC_BLOCK_SIZE 1
300 ENUM_VALUE_LIST NULL
301 READ_ONLY NO
302 COMMAND_LINE_ARGUMENT REQUIRED
303 GLOBAL_VALUE_PATH NULL
304 VARIABLE_NAME WSREP_MAX_WS_SIZE
305 SESSION_VALUE NULL
306 GLOBAL_VALUE 2147483647
307 GLOBAL_VALUE_ORIGIN COMPILE-TIME
308 DEFAULT_VALUE 2147483647
309 VARIABLE_SCOPE GLOBAL
310 VARIABLE_TYPE BIGINT UNSIGNED
311 VARIABLE_COMMENT Max write set size (bytes)
312 NUMERIC_MIN_VALUE 1024
313 NUMERIC_MAX_VALUE 2147483647
314 NUMERIC_BLOCK_SIZE 1
315 ENUM_VALUE_LIST NULL
316 READ_ONLY NO
317 COMMAND_LINE_ARGUMENT REQUIRED
318 GLOBAL_VALUE_PATH NULL
319 VARIABLE_NAME WSREP_MODE
320 SESSION_VALUE NULL
321 GLOBAL_VALUE
322 GLOBAL_VALUE_ORIGIN COMPILE-TIME
323 DEFAULT_VALUE
324 VARIABLE_SCOPE GLOBAL
325 VARIABLE_TYPE SET
326 VARIABLE_COMMENT Set of WSREP features that are enabled
327 NUMERIC_MIN_VALUE NULL
328 NUMERIC_MAX_VALUE NULL
329 NUMERIC_BLOCK_SIZE NULL
330 ENUM_VALUE_LIST STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID,BF_ABORT_MARIABACKUP
331 READ_ONLY NO
332 COMMAND_LINE_ARGUMENT REQUIRED
333 GLOBAL_VALUE_PATH NULL
334 VARIABLE_NAME WSREP_MYSQL_REPLICATION_BUNDLE
335 SESSION_VALUE NULL
336 GLOBAL_VALUE 0
337 GLOBAL_VALUE_ORIGIN COMPILE-TIME
338 DEFAULT_VALUE 0
339 VARIABLE_SCOPE GLOBAL
340 VARIABLE_TYPE BIGINT UNSIGNED
341 VARIABLE_COMMENT Number of replication events that are grouped together
342 NUMERIC_MIN_VALUE 0
343 NUMERIC_MAX_VALUE 1000
344 NUMERIC_BLOCK_SIZE 1
345 ENUM_VALUE_LIST NULL
346 READ_ONLY NO
347 COMMAND_LINE_ARGUMENT REQUIRED
348 GLOBAL_VALUE_PATH NULL
349 VARIABLE_NAME WSREP_NODE_ADDRESS
350 SESSION_VALUE NULL
351 GLOBAL_VALUE
352 GLOBAL_VALUE_ORIGIN COMPILE-TIME
353 DEFAULT_VALUE
354 VARIABLE_SCOPE GLOBAL
355 VARIABLE_TYPE VARCHAR
356 VARIABLE_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
357 NUMERIC_MIN_VALUE NULL
358 NUMERIC_MAX_VALUE NULL
359 NUMERIC_BLOCK_SIZE NULL
360 ENUM_VALUE_LIST NULL
361 READ_ONLY NO
362 COMMAND_LINE_ARGUMENT REQUIRED
363 GLOBAL_VALUE_PATH NULL
364 VARIABLE_NAME WSREP_NODE_INCOMING_ADDRESS
365 SESSION_VALUE NULL
366 GLOBAL_VALUE AUTO
367 GLOBAL_VALUE_ORIGIN COMPILE-TIME
368 DEFAULT_VALUE AUTO
369 VARIABLE_SCOPE GLOBAL
370 VARIABLE_TYPE VARCHAR
371 VARIABLE_COMMENT Client connection address
372 NUMERIC_MIN_VALUE NULL
373 NUMERIC_MAX_VALUE NULL
374 NUMERIC_BLOCK_SIZE NULL
375 ENUM_VALUE_LIST NULL
376 READ_ONLY NO
377 COMMAND_LINE_ARGUMENT REQUIRED
378 GLOBAL_VALUE_PATH NULL
379 VARIABLE_NAME WSREP_NODE_NAME
380 SESSION_VALUE NULL
381 GLOBAL_VALUE HOSTNAME
382 GLOBAL_VALUE_ORIGIN COMPILE-TIME
383 DEFAULT_VALUE HOSTNAME
384 VARIABLE_SCOPE GLOBAL
385 VARIABLE_TYPE VARCHAR
386 VARIABLE_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
387 NUMERIC_MIN_VALUE NULL
388 NUMERIC_MAX_VALUE NULL
389 NUMERIC_BLOCK_SIZE NULL
390 ENUM_VALUE_LIST NULL
391 READ_ONLY NO
392 COMMAND_LINE_ARGUMENT REQUIRED
393 GLOBAL_VALUE_PATH NULL
394 VARIABLE_NAME WSREP_NOTIFY_CMD
395 SESSION_VALUE NULL
396 GLOBAL_VALUE
397 GLOBAL_VALUE_ORIGIN COMPILE-TIME
398 DEFAULT_VALUE
399 VARIABLE_SCOPE GLOBAL
400 VARIABLE_TYPE VARCHAR
401 VARIABLE_COMMENT
402 NUMERIC_MIN_VALUE NULL
403 NUMERIC_MAX_VALUE NULL
404 NUMERIC_BLOCK_SIZE NULL
405 ENUM_VALUE_LIST NULL
406 READ_ONLY YES
407 COMMAND_LINE_ARGUMENT REQUIRED
408 GLOBAL_VALUE_PATH NULL
409 VARIABLE_NAME WSREP_ON
410 SESSION_VALUE OFF
411 GLOBAL_VALUE OFF
412 GLOBAL_VALUE_ORIGIN COMPILE-TIME
413 DEFAULT_VALUE OFF
414 VARIABLE_SCOPE SESSION
415 VARIABLE_TYPE BOOLEAN
416 VARIABLE_COMMENT To enable wsrep replication
417 NUMERIC_MIN_VALUE NULL
418 NUMERIC_MAX_VALUE NULL
419 NUMERIC_BLOCK_SIZE NULL
420 ENUM_VALUE_LIST OFF,ON
421 READ_ONLY NO
422 COMMAND_LINE_ARGUMENT OPTIONAL
423 GLOBAL_VALUE_PATH NULL
424 VARIABLE_NAME WSREP_OSU_METHOD
425 SESSION_VALUE TOI
426 GLOBAL_VALUE TOI
427 GLOBAL_VALUE_ORIGIN COMPILE-TIME
428 DEFAULT_VALUE TOI
429 VARIABLE_SCOPE SESSION
430 VARIABLE_TYPE ENUM
431 VARIABLE_COMMENT Method for Online Schema Upgrade
432 NUMERIC_MIN_VALUE NULL
433 NUMERIC_MAX_VALUE NULL
434 NUMERIC_BLOCK_SIZE NULL
435 ENUM_VALUE_LIST TOI,RSU
436 READ_ONLY NO
437 COMMAND_LINE_ARGUMENT OPTIONAL
438 GLOBAL_VALUE_PATH NULL
439 VARIABLE_NAME WSREP_PATCH_VERSION
440 SESSION_VALUE NULL
441 GLOBAL_VALUE wsrep_MAJVER.MINVER
442 GLOBAL_VALUE_ORIGIN COMPILE-TIME
443 DEFAULT_VALUE NULL
444 VARIABLE_SCOPE GLOBAL
445 VARIABLE_TYPE VARCHAR
446 VARIABLE_COMMENT Wsrep patch version, for example wsrep_MAJVER.MINVER
447 NUMERIC_MIN_VALUE NULL
448 NUMERIC_MAX_VALUE NULL
449 NUMERIC_BLOCK_SIZE NULL
450 ENUM_VALUE_LIST NULL
451 READ_ONLY YES
452 COMMAND_LINE_ARGUMENT NULL
453 GLOBAL_VALUE_PATH NULL
454 VARIABLE_NAME WSREP_PROVIDER
455 SESSION_VALUE NULL
456 GLOBAL_VALUE none
457 GLOBAL_VALUE_ORIGIN COMPILE-TIME
458 DEFAULT_VALUE none
459 VARIABLE_SCOPE GLOBAL
460 VARIABLE_TYPE VARCHAR
461 VARIABLE_COMMENT Path to replication provider library
462 NUMERIC_MIN_VALUE NULL
463 NUMERIC_MAX_VALUE NULL
464 NUMERIC_BLOCK_SIZE NULL
465 ENUM_VALUE_LIST NULL
466 READ_ONLY YES
467 COMMAND_LINE_ARGUMENT REQUIRED
468 GLOBAL_VALUE_PATH NULL
469 VARIABLE_NAME WSREP_PROVIDER_OPTIONS
470 SESSION_VALUE NULL
471 GLOBAL_VALUE
472 GLOBAL_VALUE_ORIGIN COMPILE-TIME
473 DEFAULT_VALUE
474 VARIABLE_SCOPE GLOBAL
475 VARIABLE_TYPE VARCHAR
476 VARIABLE_COMMENT Semicolon (;) separated list of wsrep options (see wsrep_provider_options documentation)
477 NUMERIC_MIN_VALUE NULL
478 NUMERIC_MAX_VALUE NULL
479 NUMERIC_BLOCK_SIZE NULL
480 ENUM_VALUE_LIST NULL
481 READ_ONLY NO
482 COMMAND_LINE_ARGUMENT REQUIRED
483 GLOBAL_VALUE_PATH NULL
484 VARIABLE_NAME WSREP_RECOVER
485 SESSION_VALUE NULL
486 GLOBAL_VALUE OFF
487 GLOBAL_VALUE_ORIGIN COMPILE-TIME
488 DEFAULT_VALUE OFF
489 VARIABLE_SCOPE GLOBAL
490 VARIABLE_TYPE BOOLEAN
491 VARIABLE_COMMENT Recover database state after crash and exit
492 NUMERIC_MIN_VALUE NULL
493 NUMERIC_MAX_VALUE NULL
494 NUMERIC_BLOCK_SIZE NULL
495 ENUM_VALUE_LIST OFF,ON
496 READ_ONLY YES
497 COMMAND_LINE_ARGUMENT OPTIONAL
498 GLOBAL_VALUE_PATH NULL
499 VARIABLE_NAME WSREP_REJECT_QUERIES
500 SESSION_VALUE NULL
501 GLOBAL_VALUE NONE
502 GLOBAL_VALUE_ORIGIN COMPILE-TIME
503 DEFAULT_VALUE NONE
504 VARIABLE_SCOPE GLOBAL
505 VARIABLE_TYPE ENUM
506 VARIABLE_COMMENT Variable to set to reject queries
507 NUMERIC_MIN_VALUE NULL
508 NUMERIC_MAX_VALUE NULL
509 NUMERIC_BLOCK_SIZE NULL
510 ENUM_VALUE_LIST NONE,ALL,ALL_KILL
511 READ_ONLY NO
512 COMMAND_LINE_ARGUMENT OPTIONAL
513 GLOBAL_VALUE_PATH NULL
514 VARIABLE_NAME WSREP_RESTART_SLAVE
515 SESSION_VALUE NULL
516 GLOBAL_VALUE OFF
517 GLOBAL_VALUE_ORIGIN COMPILE-TIME
518 DEFAULT_VALUE OFF
519 VARIABLE_SCOPE GLOBAL
520 VARIABLE_TYPE BOOLEAN
521 VARIABLE_COMMENT Should MariaDB slave be restarted automatically, when node joins back to cluster
522 NUMERIC_MIN_VALUE NULL
523 NUMERIC_MAX_VALUE NULL
524 NUMERIC_BLOCK_SIZE NULL
525 ENUM_VALUE_LIST OFF,ON
526 READ_ONLY NO
527 COMMAND_LINE_ARGUMENT OPTIONAL
528 GLOBAL_VALUE_PATH NULL
529 VARIABLE_NAME WSREP_RETRY_AUTOCOMMIT
530 SESSION_VALUE 1
531 GLOBAL_VALUE 1
532 GLOBAL_VALUE_ORIGIN COMPILE-TIME
533 DEFAULT_VALUE 1
534 VARIABLE_SCOPE SESSION
535 VARIABLE_TYPE BIGINT UNSIGNED
536 VARIABLE_COMMENT Max number of times to retry a failed autocommit statement
537 NUMERIC_MIN_VALUE 0
538 NUMERIC_MAX_VALUE 10000
539 NUMERIC_BLOCK_SIZE 1
540 ENUM_VALUE_LIST NULL
541 READ_ONLY NO
542 COMMAND_LINE_ARGUMENT REQUIRED
543 GLOBAL_VALUE_PATH NULL
544 VARIABLE_NAME WSREP_SLAVE_FK_CHECKS
545 SESSION_VALUE NULL
546 GLOBAL_VALUE ON
547 GLOBAL_VALUE_ORIGIN COMPILE-TIME
548 DEFAULT_VALUE ON
549 VARIABLE_SCOPE GLOBAL
550 VARIABLE_TYPE BOOLEAN
551 VARIABLE_COMMENT Should slave thread do foreign key constraint checks (deprecated, has no effect)
552 NUMERIC_MIN_VALUE NULL
553 NUMERIC_MAX_VALUE NULL
554 NUMERIC_BLOCK_SIZE NULL
555 ENUM_VALUE_LIST OFF,ON
556 READ_ONLY NO
557 COMMAND_LINE_ARGUMENT OPTIONAL
558 GLOBAL_VALUE_PATH NULL
559 VARIABLE_NAME WSREP_SLAVE_THREADS
560 SESSION_VALUE NULL
561 GLOBAL_VALUE 1
562 GLOBAL_VALUE_ORIGIN COMPILE-TIME
563 DEFAULT_VALUE 1
564 VARIABLE_SCOPE GLOBAL
565 VARIABLE_TYPE BIGINT UNSIGNED
566 VARIABLE_COMMENT Number of slave appliers to launch
567 NUMERIC_MIN_VALUE 1
568 NUMERIC_MAX_VALUE 512
569 NUMERIC_BLOCK_SIZE 1
570 ENUM_VALUE_LIST NULL
571 READ_ONLY NO
572 COMMAND_LINE_ARGUMENT REQUIRED
573 GLOBAL_VALUE_PATH NULL
574 VARIABLE_NAME WSREP_SLAVE_UK_CHECKS
575 SESSION_VALUE NULL
576 GLOBAL_VALUE OFF
577 GLOBAL_VALUE_ORIGIN COMPILE-TIME
578 DEFAULT_VALUE OFF
579 VARIABLE_SCOPE GLOBAL
580 VARIABLE_TYPE BOOLEAN
581 VARIABLE_COMMENT Should slave thread do secondary index uniqueness checks
582 NUMERIC_MIN_VALUE NULL
583 NUMERIC_MAX_VALUE NULL
584 NUMERIC_BLOCK_SIZE NULL
585 ENUM_VALUE_LIST OFF,ON
586 READ_ONLY NO
587 COMMAND_LINE_ARGUMENT OPTIONAL
588 GLOBAL_VALUE_PATH NULL
589 VARIABLE_NAME WSREP_SR_STORE
590 SESSION_VALUE NULL
591 GLOBAL_VALUE table
592 GLOBAL_VALUE_ORIGIN COMPILE-TIME
593 DEFAULT_VALUE table
594 VARIABLE_SCOPE GLOBAL
595 VARIABLE_TYPE ENUM
596 VARIABLE_COMMENT Storage for streaming replication fragments
597 NUMERIC_MIN_VALUE NULL
598 NUMERIC_MAX_VALUE NULL
599 NUMERIC_BLOCK_SIZE NULL
600 ENUM_VALUE_LIST none,table
601 READ_ONLY YES
602 COMMAND_LINE_ARGUMENT REQUIRED
603 GLOBAL_VALUE_PATH NULL
604 VARIABLE_NAME WSREP_SST_AUTH
605 SESSION_VALUE NULL
606 GLOBAL_VALUE
607 GLOBAL_VALUE_ORIGIN COMPILE-TIME
608 DEFAULT_VALUE
609 VARIABLE_SCOPE GLOBAL
610 VARIABLE_TYPE VARCHAR
611 VARIABLE_COMMENT Authentication for SST connection
612 NUMERIC_MIN_VALUE NULL
613 NUMERIC_MAX_VALUE NULL
614 NUMERIC_BLOCK_SIZE NULL
615 ENUM_VALUE_LIST NULL
616 READ_ONLY NO
617 COMMAND_LINE_ARGUMENT REQUIRED
618 GLOBAL_VALUE_PATH NULL
619 VARIABLE_NAME WSREP_SST_DONOR
620 SESSION_VALUE NULL
621 GLOBAL_VALUE
622 GLOBAL_VALUE_ORIGIN COMPILE-TIME
623 DEFAULT_VALUE
624 VARIABLE_SCOPE GLOBAL
625 VARIABLE_TYPE VARCHAR
626 VARIABLE_COMMENT preferred donor node for the SST
627 NUMERIC_MIN_VALUE NULL
628 NUMERIC_MAX_VALUE NULL
629 NUMERIC_BLOCK_SIZE NULL
630 ENUM_VALUE_LIST NULL
631 READ_ONLY NO
632 COMMAND_LINE_ARGUMENT REQUIRED
633 GLOBAL_VALUE_PATH NULL
634 VARIABLE_NAME WSREP_SST_DONOR_REJECTS_QUERIES
635 SESSION_VALUE NULL
636 GLOBAL_VALUE OFF
637 GLOBAL_VALUE_ORIGIN COMPILE-TIME
638 DEFAULT_VALUE OFF
639 VARIABLE_SCOPE GLOBAL
640 VARIABLE_TYPE BOOLEAN
641 VARIABLE_COMMENT Reject client queries when donating state snapshot transfer
642 NUMERIC_MIN_VALUE NULL
643 NUMERIC_MAX_VALUE NULL
644 NUMERIC_BLOCK_SIZE NULL
645 ENUM_VALUE_LIST OFF,ON
646 READ_ONLY NO
647 COMMAND_LINE_ARGUMENT OPTIONAL
648 GLOBAL_VALUE_PATH NULL
649 VARIABLE_NAME WSREP_SST_METHOD
650 SESSION_VALUE NULL
651 GLOBAL_VALUE rsync
652 GLOBAL_VALUE_ORIGIN COMPILE-TIME
653 DEFAULT_VALUE rsync
654 VARIABLE_SCOPE GLOBAL
655 VARIABLE_TYPE VARCHAR
656 VARIABLE_COMMENT State snapshot transfer method
657 NUMERIC_MIN_VALUE NULL
658 NUMERIC_MAX_VALUE NULL
659 NUMERIC_BLOCK_SIZE NULL
660 ENUM_VALUE_LIST NULL
661 READ_ONLY NO
662 COMMAND_LINE_ARGUMENT REQUIRED
663 GLOBAL_VALUE_PATH NULL
664 VARIABLE_NAME WSREP_SST_RECEIVE_ADDRESS
665 SESSION_VALUE NULL
666 GLOBAL_VALUE AUTO
667 GLOBAL_VALUE_ORIGIN COMPILE-TIME
668 DEFAULT_VALUE AUTO
669 VARIABLE_SCOPE GLOBAL
670 VARIABLE_TYPE VARCHAR
671 VARIABLE_COMMENT Address where node is waiting for SST contact
672 NUMERIC_MIN_VALUE NULL
673 NUMERIC_MAX_VALUE NULL
674 NUMERIC_BLOCK_SIZE NULL
675 ENUM_VALUE_LIST NULL
676 READ_ONLY NO
677 COMMAND_LINE_ARGUMENT REQUIRED
678 GLOBAL_VALUE_PATH NULL
679 VARIABLE_NAME WSREP_START_POSITION
680 SESSION_VALUE NULL
681 GLOBAL_VALUE 00000000-0000-0000-0000-000000000000:-1
682 GLOBAL_VALUE_ORIGIN COMPILE-TIME
683 DEFAULT_VALUE 00000000-0000-0000-0000-000000000000:-1
684 VARIABLE_SCOPE GLOBAL
685 VARIABLE_TYPE VARCHAR
686 VARIABLE_COMMENT global transaction position to start from
687 NUMERIC_MIN_VALUE NULL
688 NUMERIC_MAX_VALUE NULL
689 NUMERIC_BLOCK_SIZE NULL
690 ENUM_VALUE_LIST NULL
691 READ_ONLY NO
692 COMMAND_LINE_ARGUMENT REQUIRED
693 GLOBAL_VALUE_PATH NULL
694 VARIABLE_NAME WSREP_STATUS_FILE
695 SESSION_VALUE NULL
696 GLOBAL_VALUE
697 GLOBAL_VALUE_ORIGIN COMPILE-TIME
698 DEFAULT_VALUE
699 VARIABLE_SCOPE GLOBAL
700 VARIABLE_TYPE VARCHAR
701 VARIABLE_COMMENT wsrep status output filename
702 NUMERIC_MIN_VALUE NULL
703 NUMERIC_MAX_VALUE NULL
704 NUMERIC_BLOCK_SIZE NULL
705 ENUM_VALUE_LIST NULL
706 READ_ONLY YES
707 COMMAND_LINE_ARGUMENT REQUIRED
708 GLOBAL_VALUE_PATH NULL
709 VARIABLE_NAME WSREP_SYNC_WAIT
710 SESSION_VALUE 0
711 GLOBAL_VALUE 0
712 GLOBAL_VALUE_ORIGIN COMPILE-TIME
713 DEFAULT_VALUE 0
714 VARIABLE_SCOPE SESSION
715 VARIABLE_TYPE INT UNSIGNED
716 VARIABLE_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
717 NUMERIC_MIN_VALUE 0
718 NUMERIC_MAX_VALUE 15
719 NUMERIC_BLOCK_SIZE 1
720 ENUM_VALUE_LIST NULL
721 READ_ONLY NO
722 COMMAND_LINE_ARGUMENT OPTIONAL
723 GLOBAL_VALUE_PATH NULL
724 VARIABLE_NAME WSREP_TRX_FRAGMENT_SIZE
725 SESSION_VALUE 0
726 GLOBAL_VALUE 0
727 GLOBAL_VALUE_ORIGIN COMPILE-TIME
728 DEFAULT_VALUE 0
729 VARIABLE_SCOPE SESSION
730 VARIABLE_TYPE BIGINT UNSIGNED
731 VARIABLE_COMMENT Size of transaction fragments for streaming replication (measured in units of 'wsrep_trx_fragment_unit')
732 NUMERIC_MIN_VALUE 0
733 NUMERIC_MAX_VALUE 2147483647
734 NUMERIC_BLOCK_SIZE 1
735 ENUM_VALUE_LIST NULL
736 READ_ONLY NO
737 COMMAND_LINE_ARGUMENT REQUIRED
738 GLOBAL_VALUE_PATH NULL
739 VARIABLE_NAME WSREP_TRX_FRAGMENT_UNIT
740 SESSION_VALUE bytes
741 GLOBAL_VALUE bytes
742 GLOBAL_VALUE_ORIGIN COMPILE-TIME
743 DEFAULT_VALUE bytes
744 VARIABLE_SCOPE SESSION
745 VARIABLE_TYPE ENUM
746 VARIABLE_COMMENT Unit for streaming replication transaction fragments' size: bytes, rows, statements
747 NUMERIC_MIN_VALUE NULL
748 NUMERIC_MAX_VALUE NULL
749 NUMERIC_BLOCK_SIZE NULL
750 ENUM_VALUE_LIST bytes,rows,statements
751 READ_ONLY NO
752 COMMAND_LINE_ARGUMENT REQUIRED
753 GLOBAL_VALUE_PATH NULL