| REPORT_PORT |
NULL
|
3306 |
AUTO |
0 |
GLOBAL |
INT UNSIGNED |
Port for connecting to slave reported to the maste... |
0 |
4294967295 |
1 |
NULL
|
YES |
REQUIRED |
| LOWER_CASE_FILE_SYSTEM |
NULL
|
ON |
AUTO |
NULL
|
GLOBAL |
BOOLEAN |
Case sensitivity of file names on the file system ... |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
NULL
|
| CHARACTER_SETS_DIR |
NULL
|
C:\xampp\mysql\share\charsets\ |
AUTO |
|
GLOBAL |
VARCHAR |
Directory where character sets are |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
REQUIRED |
| THREAD_POOL_SIZE |
NULL
|
4 |
AUTO |
8 |
GLOBAL |
INT UNSIGNED |
Number of thread groups in the pool. This paramete... |
1 |
100000 |
1 |
NULL
|
NO |
REQUIRED |
| TABLE_DEFINITION_CACHE |
NULL
|
400 |
AUTO |
400 |
GLOBAL |
INT UNSIGNED |
The number of cached table definitions |
400 |
2097152 |
1 |
NULL
|
NO |
REQUIRED |
| HOST_CACHE_SIZE |
NULL
|
279 |
AUTO |
128 |
GLOBAL |
INT UNSIGNED |
How many host names should be cached to avoid reso... |
0 |
65536 |
1 |
NULL
|
NO |
REQUIRED |
| THREAD_CACHE_SIZE |
NULL
|
151 |
AUTO |
256 |
GLOBAL |
INT UNSIGNED |
How many threads we should keep in a cache for reu... |
0 |
16384 |
1 |
NULL
|
NO |
REQUIRED |
| OPEN_FILES_LIMIT |
NULL
|
34230 |
AUTO |
0 |
GLOBAL |
INT UNSIGNED |
If this is not 0, then mysqld will use this value ... |
0 |
4294967295 |
1 |
NULL
|
YES |
REQUIRED |
| MAX_LONG_DATA_SIZE |
NULL
|
1048576 |
AUTO |
1048576 |
GLOBAL |
INT UNSIGNED |
The maximum BLOB length to send to server from mys... |
1024 |
4294967295 |
1 |
NULL
|
YES |
REQUIRED |
| SLAVE_LOAD_TMPDIR |
NULL
|
C:\xampp\tmp |
AUTO |
|
GLOBAL |
VARCHAR |
The location where the slave should put its tempor... |
NULL
|
NULL
|
NULL
|
NULL
|
YES |
REQUIRED |
| LOG_TC_SIZE |
NULL
|
24576 |
AUTO |
24576 |
GLOBAL |
INT UNSIGNED |
Size of transaction coordinator log. |
12288 |
4294967295 |
4096 |
NULL
|
YES |
REQUIRED |
| MAX_RELAY_LOG_SIZE |
1073741824 |
1073741824 |
AUTO |
1073741824 |
SESSION |
BIGINT UNSIGNED |
relay log will be rotated automatically when the s... |
4096 |
1073741824 |
4096 |
NULL
|
NO |
REQUIRED |
| BACK_LOG |
NULL
|
80 |
AUTO |
150 |
GLOBAL |
INT UNSIGNED |
The number of outstanding connection requests Mari... |
0 |
65535 |
1 |
NULL
|
YES |
REQUIRED |
| INNODB_LOCKS_UNSAFE_FOR_BINLOG |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
DEPRECATED. This option may be removed in future r... |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
NONE |
| 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 |
INT |
Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0... |
-1 |
1048576 |
1 |
NULL
|
YES |
REQUIRED |
| RPL_SEMI_SYNC_SLAVE_ENABLED |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enable semi-synchronous replication slave (disable... |
NULL
|
NULL
|
NULL
|
OFF,ON |
NO |
OPTIONAL |
| 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
|
SERVIDORx1.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 |
| INNODB_BUFFER_POOL_LOAD_AT_STARTUP |
NULL
|
ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
Load the buffer pool from a file named @@innodb_bu... |
NULL
|
NULL
|
NULL
|
OFF,ON |
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 |
| LOG_BIN_COMPRESS |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Whether the binary log can be compressed |
NULL
|
NULL
|
NULL
|
OFF,ON |
NO |
OPTIONAL |
| INNODB_ENCRYPT_TEMPORARY_TABLES |
NULL
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enrypt the temporary table data. |
NULL
|
NULL
|
NULL
|
OFF,ON |
YES |
OPTIONAL |