PERFORMANCE_SCHEMA |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enable the performance schema. |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
OPTIONAL |
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_CLASSES |
NULL
|
90 |
COMPILE-TIME |
90 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of condition instruments. |
0 |
256 |
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_RWLOCK_CLASSES |
NULL
|
40 |
COMPILE-TIME |
40 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of rwlock instruments. |
0 |
256 |
1 |
NULL
|
YES |
REQUIRED |
INNODB_ENCRYPT_TEMPORARY_TABLES |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enrypt the temporary table data. |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
OPTIONAL |
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 |
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_MAX_MUTEX_CLASSES |
NULL
|
200 |
COMPILE-TIME |
200 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of mutex instruments. |
0 |
256 |
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 |
LC_MESSAGES_DIR |
NULL
|
|
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
Directory where error messages are |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
REQUIRED |
INNODB_ADAPTIVE_HASH_INDEX_PARTS |
NULL
|
8 |
COMPILE-TIME |
8 |
GLOBAL |
BIGINT UNSIGNED |
Number of InnoDB Adaptive Hash Index Partitions (d... |
1 |
512 |
0 |
NULL
|
YES |
OPTIONAL |
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_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 |
ERROR_COUNT |
0 |
NULL
|
COMPILE-TIME |
NULL
|
SESSION ONLY |
BIGINT UNSIGNED |
The number of errors that resulted from the last s... |
0 |
18446744073709551615 |
1 |
NULL
|
YES |
NULL
|
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 |
GTID_BINLOG_POS |
NULL
|
|
COMPILE-TIME |
NULL
|
GLOBAL |
VARCHAR |
Last GTID logged to the binary log, per replicatio... |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
NULL
|
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 |
REPORT_HOST |
NULL
|
|
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
Hostname or IP of the slave to be reported to the ... |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
REQUIRED |
INNODB_SORT_BUFFER_SIZE |
NULL
|
1048576 |
COMPILE-TIME |
1048576 |
GLOBAL |
BIGINT UNSIGNED |
Memory buffer size for index creation |
65536 |
67108864 |
0 |
NULL
|
YES |
REQUIRED |
PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE |
NULL
|
100 |
COMPILE-TIME |
100 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of rows in SETUP_OBJECTS. |
0 |
1048576 |
1 |
NULL
|
YES |
REQUIRED |
LARGE_FILES_SUPPORT |
NULL
|
ON |
COMPILE-TIME |
NULL
|
GLOBAL |
BOOLEAN |
Whether mysqld was compiled with options for large... |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
NULL
|
VERSION_COMPILE_MACHINE |
NULL
|
x86_64 |
COMPILE-TIME |
NULL
|
GLOBAL |
VARCHAR |
The machine type or architecture MariaDB was built... |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
NULL
|
BIND_ADDRESS |
NULL
|
|
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
IP address to bind to. |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
REQUIRED |