PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented condition objects. ... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented MUTEX objects. Use ... |
-1 |
104857600 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented RWLOCK objects. Use... |
-1 |
104857600 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented user@host accounts.... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows per thread in EVENTS_WAITS_HISTORY.... |
-1 |
1024 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows per thread in EVENTS_STAGES_HISTORY... |
-1 |
1024 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented threads. Use 0 to d... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows in EVENTS_STAGES_HISTORY_LONG. Use ... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH |
NULL | 1024 |
COMPILE-TIME |
1024 |
GLOBAL |
BIGINT |
Maximum length considered for digest text, when st... |
0 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_DIGESTS_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Size of the statement digest. Use 0 to disable, -1... |
-1 |
200 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Size of session attribute string buffer per thread... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows per thread in EVENTS_STATEMENTS_HIS... |
-1 |
1024 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_USERS_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented users. Use 0 to dis... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
INNODB_AUTOINC_LOCK_MODE |
NULL | 1 |
COMPILE-TIME |
1 |
GLOBAL |
BIGINT |
The AUTOINC lock modes supported by InnoDB: ... |
0 |
2 |
0 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented files. Use 0 to dis... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
INNODB_MTFLUSH_THREADS |
NULL | 8 |
COMPILE-TIME |
8 |
GLOBAL |
BIGINT |
Number of multi-threaded flush threads |
1 |
64 |
0 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of opened instrumented sockets. Use... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_HOSTS_SIZE |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented hosts. Use 0 to dis... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
INNODB_LOG_BUFFER_SIZE |
NULL | 8388608 |
CONFIG |
16777216 |
GLOBAL |
BIGINT |
The size of the buffer which InnoDB uses to write ... |
262144 |
9223372036854775807 |
1024 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented tables. Use 0 to di... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
INNODB_MIRRORED_LOG_GROUPS |
NULL | 1 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT |
Number of identical copies of log groups we keep f... |
0 |
10 |
0 |
NULL | YES |
REQUIRED |
INNODB_BUFFER_POOL_INSTANCES |
NULL | 8 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT |
Number of buffer pool instances, set to higher val... |
0 |
64 |
1 |
NULL | YES |
REQUIRED |
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_... |
NULL | -1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. ... |
-1 |
1048576 |
1 |
NULL | YES |
REQUIRED |
INNODB_OPEN_FILES |
NULL | 300 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT |
How many files at the maximum InnoDB keeps open at... |
0 |
9223372036854775807 |
0 |
NULL | YES |
REQUIRED |