|
# |
VARIABLE_NAME |
SESSION_VALUE |
GLOBAL_VALUE |
GLOBAL_VALUE_ORIGIN |
DEFAULT_VALUE |
VARIABLE_SCOPE |
VARIABLE_TYPE |
VARIABLE_COMMENT |
NUMERIC_MIN_VALUE |
NUMERIC_MAX_VALUE |
NUMERIC_BLOCK_SIZE |
ENUM_VALUE_LIST |
READ_ONLY |
COMMAND_LINE_ARGUMENT |
GLOBAL_VALUE_PATH |
|
1. |
INNODB_LOG_CHECKSUMS |
|
ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
Deprecated parameter with no effect. |
|
|
|
OFF,ON |
NO |
REQUIRED |
|
|
2. |
PERFORMANCE_SCHEMA |
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enable the performance schema. |
|
|
|
OFF,ON |
YES |
OPTIONAL |
|
|
3. |
SQL_MODE |
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
CONFIG |
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
SESSION |
SET |
Sets the sql mode |
|
|
|
REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,IGNORE_BAD_TABLE_OPTIONS,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,POSTGRESQL,ORACLE,MSSQL,DB2,MAXDB,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,MYSQL323,MYSQL40,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT,TIME_ROUND_FRACTIONAL |
NO |
REQUIRED |
|
|
4. |
SYSTEM_VERSIONING_ALTER_HISTORY |
ERROR |
ERROR |
COMPILE-TIME |
ERROR |
SESSION |
ENUM |
Versioning ALTER TABLE mode. ERROR: Fail ALTER with error; KEEP: Keep historical system rows and subject them to ALTER |
|
|
|
ERROR,KEEP |
NO |
REQUIRED |
|
|
5. |
UNIQUE_CHECKS |
ON |
ON |
COMPILE-TIME |
ON |
SESSION |
BOOLEAN |
If set to 1, the default, secondary indexes in InnoDB tables are performed. If set to 0, storage engines can (but are not required to) assume that duplicate keys are not present in input data. Set to 0 to speed up imports of large tables to InnoDB. The storage engine will still issue a duplicate key error if it detects one, even if set to 0. |
|
|
|
OFF,ON |
NO |
|
|
|
6. |
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE |
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0 to disable, -1 for automated sizing. |
-1 |
1024 |
1 |
|
YES |
REQUIRED |
|
|
7. |
MAX_RELAY_LOG_SIZE |
1073741824 |
1073741824 |
AUTO |
1073741824 |
SESSION |
BIGINT UNSIGNED |
relay log will be rotated automatically when the size exceeds this value. If 0 at startup, it's set to max_binlog_size |
4096 |
1073741824 |
4096 |
|
NO |
REQUIRED |
|
|
8. |
PERFORMANCE_SCHEMA_MAX_COND_CLASSES |
|
90 |
COMPILE-TIME |
90 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of condition instruments. |
0 |
256 |
1 |
|
YES |
REQUIRED |
|
|
9. |
HAVE_RTREE_KEYS |
|
YES |
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
If RTREE indexes (used for spatial indexes) are available, will be set to YES, otherwise will be set to NO. |
|
|
|
|
YES |
|
|
|
10. |
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES |
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing. |
-1 |
1048576 |
1 |
|
YES |
REQUIRED |
|
|
11. |
INNODB_FLUSH_LOG_AT_TIMEOUT |
|
1 |
COMPILE-TIME |
1 |
GLOBAL |
INT UNSIGNED |
Write and flush logs every (n) second. |
0 |
2700 |
0 |
|
NO |
OPTIONAL |
|
|
12. |
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES |
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented RWLOCK objects. Use 0 to disable, -1 for automated sizing. |
-1 |
104857600 |
1 |
|
YES |
REQUIRED |
|
|
13. |
INNODB_ENCRYPT_TEMPORARY_TABLES |
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Enrypt the temporary table data. |
|
|
|
OFF,ON |
YES |
OPTIONAL |
|
|
14. |
PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES |
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented prepared statements. Use 0 to disable, -1 for automated scaling. |
-1 |
1048576 |
1 |
|
YES |
REQUIRED |
|
|
15. |
PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES |
|
50 |
COMPILE-TIME |
50 |
GLOBAL |
BIGINT UNSIGNED |
Maximum number of thread instruments. |
0 |
256 |
1 |
|
YES |
REQUIRED |
|
|
16. |
RPL_SEMI_SYNC_SLAVE_TRACE_LEVEL |
|
32 |
COMPILE-TIME |
32 |
GLOBAL |
BIGINT UNSIGNED |
The tracing level for semi-sync replication. |
0 |
18446744073709551615 |
1 |
|
NO |
REQUIRED |
|
|
17. |
SSL_CAPATH |
|
|
COMPILE-TIME |
|
GLOBAL |
VARCHAR |
CA directory (check OpenSSL docs, implies --ssl) |
|
|
|
|
YES |
REQUIRED |
|
|
18. |
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES |
|
-1 |
COMPILE-TIME |
-1 |
GLOBAL |
BIGINT |
Maximum number of instrumented MUTEX objects. Use 0 to disable, -1 for automated sizing. |
-1 |
104857600 |
1 |
|
YES |
REQUIRED |
|
|
19. |
CORE_FILE |
|
OFF |
COMPILE-TIME |
|
GLOBAL |
BOOLEAN |
write a core-file on crashes |
|
|
|
OFF,ON |
YES |
|
|
|
20. |
EVENT_SCHEDULER |
|
OFF |
COMPILE-TIME |
OFF |
GLOBAL |
ENUM |
Enable the event scheduler. Possible values are ON, OFF, and DISABLED (keep the event scheduler completely deactivated, it cannot be activated run-time) |
|
|
|
OFF,ON,DISABLED,ORIGINAL |
NO |
OPTIONAL |
|