WSREP_NOTIFY_CMD |
NULL | | COMPILE-TIME |
| GLOBAL |
VARCHAR |
| NULL | NULL | NULL | NULL | NO |
REQUIRED |
INNODB_LOCKING_FAKE_CHANGES |
NULL | ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
###EXPERIMENTAL### if enabled, transactions will g... |
NULL | NULL | NULL | OFF,ON |
NO |
NONE |
INNODB_LOG_BLOCK_SIZE |
NULL | 512 |
COMPILE-TIME |
512 |
GLOBAL |
BIGINT UNSIGNED |
###EXPERIMENTAL###: The log block size of the tran... |
512 |
65536 |
0 |
NULL | YES |
REQUIRED |
FLUSH_TIME |
NULL | 0 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT UNSIGNED |
A dedicated thread is created to flush all tables ... |
0 |
31536000 |
1 |
NULL | NO |
REQUIRED |
INNODB_BUF_DUMP_STATUS_FREQUENCY |
NULL | 0 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT UNSIGNED |
A number between [0, 100] that tells how oftern bu... |
0 |
100 |
0 |
NULL | NO |
REQUIRED |
INNODB_DEFRAGMENT_FILL_FACTOR |
NULL | 0.900000 |
COMPILE-TIME |
0.900000 |
GLOBAL |
DOUBLE |
A number between [0.7, 1] that tells defragmentati... |
0.7 |
1 |
NULL | NULL | NO |
REQUIRED |
MAX_STATEMENT_TIME |
0.000000 |
0.000000 |
COMPILE-TIME |
0.000000 |
SESSION |
DOUBLE |
A query that has taken more than max_statement_tim... |
0 |
31536000 |
NULL | NULL | NO |
REQUIRED |
INNODB_BUFFER_POOL_LOAD_ABORT |
NULL | OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Abort a currently running load of the buffer pool |
NULL | NULL | NULL | OFF,ON |
NO |
REQUIRED |
WSREP_CLUSTER_ADDRESS |
NULL | | COMPILE-TIME |
| GLOBAL |
VARCHAR |
Address to initially connect to cluster |
NULL | NULL | NULL | NULL | NO |
REQUIRED |
WSREP_SST_RECEIVE_ADDRESS |
NULL | AUTO |
COMPILE-TIME |
AUTO |
GLOBAL |
VARCHAR |
Address where node is waiting for SST contact |
NULL | NULL | NULL | NULL | NO |
REQUIRED |
DELAYED_INSERT_LIMIT |
NULL | 100 |
COMPILE-TIME |
100 |
GLOBAL |
BIGINT UNSIGNED |
After inserting delayed_insert_limit rows, the INS... |
1 |
4294967295 |
1 |
NULL | NO |
REQUIRED |
MAX_WRITE_LOCK_COUNT |
NULL | 4294967295 |
COMPILE-TIME |
4294967295 |
GLOBAL |
BIGINT UNSIGNED |
After this many write locks, allow some read locks... |
1 |
4294967295 |
1 |
NULL | NO |
REQUIRED |
STORAGE_ENGINE |
InnoDB |
InnoDB |
COMPILE-TIME |
InnoDB |
SESSION |
VARCHAR |
Alias for @@default_storage_engine. Deprecated |
NULL | NULL | NULL | NULL | NO |
NULL |
QUERY_ALLOC_BLOCK_SIZE |
16384 |
16384 |
COMPILE-TIME |
16384 |
SESSION |
BIGINT UNSIGNED |
Allocation block size for query parsing and execut... |
1024 |
4294967295 |
1024 |
NULL | NO |
REQUIRED |
RANGE_ALLOC_BLOCK_SIZE |
4096 |
4096 |
COMPILE-TIME |
4096 |
SESSION |
BIGINT UNSIGNED |
Allocation block size for storing ranges during op... |
4096 |
4294967295 |
1024 |
NULL | NO |
REQUIRED |
TRANSACTION_ALLOC_BLOCK_SIZE |
8192 |
8192 |
COMPILE-TIME |
8192 |
SESSION |
BIGINT UNSIGNED |
Allocation block size for transactions to be store... |
1024 |
134217728 |
1024 |
NULL | NO |
REQUIRED |
WSREP_DIRTY_READS |
OFF |
OFF |
COMPILE-TIME |
OFF |
SESSION |
BOOLEAN |
Allow reads even when the node is not in the prima... |
NULL | NULL | NULL | OFF,ON |
NO |
OPTIONAL |
MAX_SESSION_MEM_USED |
9223372036854775807 |
9223372036854775807 |
COMPILE-TIME |
9223372036854775807 |
SESSION |
BIGINT UNSIGNED |
Amount of memory a single user session is allowed ... |
8192 |
18446744073709551615 |
1 |
NULL | NO |
REQUIRED |
INNODB_ADAPTIVE_FLUSHING |
NULL | ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
Attempt flushing dirty pages to avoid IO bursts at... |
NULL | NULL | NULL | OFF,ON |
NO |
NONE |
WSREP_SST_AUTH |
NULL | | COMPILE-TIME |
| GLOBAL |
VARCHAR |
Authentication for SST connection |
NULL | NULL | NULL | NULL | NO |
REQUIRED |
AUTO_INCREMENT_INCREMENT |
1 |
1 |
COMPILE-TIME |
1 |
SESSION |
BIGINT UNSIGNED |
Auto-increment columns are incremented by this |
1 |
65535 |
1 |
NULL | NO |
OPTIONAL |
WSREP_GTID_MODE |
NULL | OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Automatically update the (joiner) node's wsrep_gti... |
NULL | NULL | NULL | OFF,ON |
NO |
OPTIONAL |
INNODB_API_BK_COMMIT_INTERVAL |
NULL | 5 |
COMPILE-TIME |
5 |
GLOBAL |
BIGINT UNSIGNED |
Background commit interval in seconds |
1 |
1073741824 |
0 |
NULL | NO |
OPTIONAL |
INNODB_SCRUB_LOG_SPEED |
NULL | 256 |
COMPILE-TIME |
256 |
GLOBAL |
BIGINT UNSIGNED |
Background redo log scrubbing speed in bytes/sec |
1 |
50000 |
0 |
NULL | NO |
OPTIONAL |
MAX_BINLOG_SIZE |
NULL | 1073741824 |
COMPILE-TIME |
1073741824 |
GLOBAL |
BIGINT UNSIGNED |
Binary log will be rotated automatically when the ... |
4096 |
1073741824 |
4096 |
NULL | NO |
REQUIRED |