| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... |
-1 |
1048576 |
1 |
NULL
|
YES |
REQUIRED |
| PERFORMANCE_SCHEMA_MAX_COND_CLASSES |
NULL
|
90 |
COMPILE-TIME |
90 |
GLOBAL |
INT UNSIGNED |
Maximum number of condition instruments. |
0 |
256 |
1 |
NULL
|
YES |
REQUIRED |
| GENERAL_LOG_FILE |
NULL
|
srv.log |
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
Log connections and queries to given file |
NULL
|
NULL
|
NULL
|
NULL
|
NO |
REQUIRED |
| PERFORMANCE_SCHEMA_MAX_COND_INSTANCES |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Maximum number of instrumented condition objects. ... |
-1 |
1048576 |
1 |
NULL
|
YES |
REQUIRED |
| PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES |
NULL
|
40 |
COMPILE-TIME |
40 |
GLOBAL |
INT UNSIGNED |
Maximum number of rwlock instruments. |
0 |
256 |
1 |
NULL
|
YES |
REQUIRED |
| INNODB_FLUSH_LOG_AT_TIMEOUT |
NULL
|
1 |
COMPILE-TIME |
1 |
GLOBAL |
INT UNSIGNED |
Write and flush logs every (n) second. |
0 |
2700 |
0 |
NULL
|
NO |
OPTIONAL |
| MAX_CONNECT_ERRORS |
NULL
|
100 |
COMPILE-TIME |
100 |
GLOBAL |
INT UNSIGNED |
If there is more than this number of interrupted c... |
1 |
4294967295 |
1 |
NULL
|
NO |
REQUIRED |
| READ_BINLOG_SPEED_LIMIT |
NULL
|
0 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT UNSIGNED |
Maximum speed(KB/s) to read binlog from master (0 ... |
0 |
4294967295 |
1 |
NULL
|
NO |
REQUIRED |
| PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Maximum number of instrumented MUTEX objects. Use ... |
-1 |
104857600 |
1 |
NULL
|
YES |
REQUIRED |
| EXTERNAL_USER |
|
NULL
|
COMPILE-TIME |
NULL
|
SESSION ONLY |
VARCHAR |
The external user account used when logging in |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
NULL
|
| PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Maximum number of instrumented RWLOCK objects. Use... |
-1 |
104857600 |
1 |
NULL
|
YES |
REQUIRED |
| PROTOCOL_VERSION |
NULL
|
10 |
COMPILE-TIME |
NULL
|
GLOBAL |
INT UNSIGNED |
The version of the client/server protocol used by ... |
0 |
4294967295 |
1 |
NULL
|
YES |
NULL
|
| PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES |
NULL
|
200 |
COMPILE-TIME |
200 |
GLOBAL |
INT UNSIGNED |
Maximum number of mutex instruments. |
0 |
256 |
1 |
NULL
|
YES |
REQUIRED |
| INNODB_STATS_TRANSIENT_SAMPLE_PAGES |
NULL
|
8 |
COMPILE-TIME |
8 |
GLOBAL |
BIGINT UNSIGNED |
The number of leaf index pages to sample when calc... |
1 |
18446744073709551615 |
0 |
NULL
|
NO |
REQUIRED |
| NET_WRITE_TIMEOUT |
60 |
60 |
COMPILE-TIME |
60 |
SESSION |
INT UNSIGNED |
Number of seconds to wait for a block to be writte... |
1 |
31536000 |
1 |
NULL
|
NO |
REQUIRED |
| SLOW_LAUNCH_TIME |
NULL
|
2 |
COMPILE-TIME |
2 |
GLOBAL |
INT UNSIGNED |
If creating the thread takes longer than this valu... |
0 |
31536000 |
1 |
NULL
|
NO |
REQUIRED |
| PERFORMANCE_SCHEMA_ACCOUNTS_SIZE |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Maximum number of instrumented user@host accounts.... |
-1 |
1048576 |
1 |
NULL
|
YES |
REQUIRED |
| CHARACTER_SET_SERVER |
utf8mb4 |
utf8mb4 |
COMPILE-TIME |
utf8mb4 |
SESSION |
ENUM |
The default character set |
NULL
|
NULL
|
NULL
|
NULL
|
NO |
NULL
|
| INNODB_ADAPTIVE_HASH_INDEX_PARTS |
NULL
|
8 |
COMPILE-TIME |
8 |
GLOBAL |
INT UNSIGNED |
Number of InnoDB Adaptive Hash Index Partitions (d... |
1 |
512 |
0 |
NULL
|
YES |
OPTIONAL |
| PRELOAD_BUFFER_SIZE |
32768 |
32768 |
COMPILE-TIME |
32768 |
SESSION |
INT UNSIGNED |
The size of the buffer that is allocated when prel... |
1024 |
1073741824 |
1 |
NULL
|
NO |
REQUIRED |
| THREAD_POOL_OVERSUBSCRIBE |
NULL
|
3 |
COMPILE-TIME |
3 |
GLOBAL |
INT UNSIGNED |
How many additional active worker threads in a gro... |
1 |
1000 |
1 |
NULL
|
NO |
REQUIRED |
| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Number of rows per thread in EVENTS_WAITS_HISTORY.... |
-1 |
1024 |
1 |
NULL
|
YES |
REQUIRED |
| HAVE_PROFILING |
NULL
|
YES |
COMPILE-TIME |
NULL
|
GLOBAL |
VARCHAR |
If statement profiling is available, will be set t... |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
NULL
|
| PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE |
NULL
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
INT |
Number of rows per thread in EVENTS_STAGES_HISTORY... |
-1 |
1024 |
1 |
NULL
|
YES |
REQUIRED |
| INNODB_FT_NUM_WORD_OPTIMIZE |
NULL
|
2000 |
COMPILE-TIME |
2000 |
GLOBAL |
INT UNSIGNED |
InnoDB Fulltext search number of words to optimize... |
1000 |
10000 |
0 |
NULL
|
NO |
OPTIONAL |