| BINLOG_GTID_INDEX_PAGE_SIZE | | 4096 | COMPILE-TIME | 4096 | GLOBAL | INT UNSIGNED | Page size to use for the binlog GTID index. | 64 | 16777216 | 1 | | NO | REQUIRED | |
| LOG_TC_SIZE | | 24576 | AUTO | 24576 | GLOBAL | BIGINT UNSIGNED | Size of transaction coordinator log. | 12288 | 18446744073709551615 | 4096 | | YES | REQUIRED | |
| SQL_MODE | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | COMPILE-TIME | 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_... | NO | REQUIRED | |
| BINLOG_FORMAT | MIXED | MIXED | COMPILE-TIME | MIXED | SESSION | ENUM | What form of binary logging the master will use: either ROW for row-based binary logging, ... | | | | MIXED,STATEMENT,ROW | NO | REQUIRED | |
| BINLOG_SPACE_LIMIT | | 0 | COMPILE-TIME | 0 | GLOBAL | BIGINT UNSIGNED | Alias for max_binlog_total_size. Compatibility with Percona server. | 0 | 18446744073709551615 | 1 | | NO | REQUIRED | |
| 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 sizi... | -1 | 1024 | 1 | | YES | REQUIRED | |
| AUTOMATIC_SP_PRIVILEGES | | ON | COMPILE-TIME | ON | GLOBAL | BOOLEAN | Creating and dropping stored procedures alters ACLs | | | | OFF,ON | NO | OPTIONAL | |
| PERFORMANCE_SCHEMA_MAX_COND_CLASSES | | 90 | COMPILE-TIME | 90 | GLOBAL | BIGINT UNSIGNED | Maximum number of condition instruments. | 0 | 256 | 1 | | YES | REQUIRED | |
| READ_ONLY | | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Make all non-temporary tables read-only, with the exception for replication (slave) thread... | | | | OFF,ON | NO | OPTIONAL | |
| PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizin... | -1 | 1048576 | 1 | | YES | REQUIRED | |
| INNODB_FLUSH_LOG_AT_TIMEOUT | | 1 | COMPILE-TIME | 1 | GLOBAL | INT UNSIGNED | Write and flush logs every (n) second. | 0 | 2700 | 0 | | NO | OPTIONAL | |
| 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 | |
| INNODB_ENCRYPT_TEMPORARY_TABLES | | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Encrypt the temporary table data. | | | | OFF,ON | YES | OPTIONAL | |
| 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 sca... | -1 | 1048576 | 1 | | YES | REQUIRED | |
| DISCONNECT_ON_EXPIRED_PASSWORD | | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | This variable controls how the server handles clients that are not aware of the sandbox mo... | | | | OFF,ON | NO | OPTIONAL | |
| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | | YES | REQUIRED | |
| GTID_BINLOG_POS | | | COMPILE-TIME | | GLOBAL | VARCHAR | Last GTID logged to the binary log, per replicationdomain | | | | | YES | | |
| 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 | |
| LOG_DISABLED_STATEMENTS | sp | sp | COMPILE-TIME | sp | SESSION | SET | Don't log certain types of statements to general log | | | | slave,sp | NO | REQUIRED | |
| MAX_ALLOWED_PACKET | 16777216 | 16777216 | COMPILE-TIME | 16777216 | SESSION | BIGINT UNSIGNED | Max packet length to send to or receive from the server | 1024 | 1073741824 | 1024 | | NO | REQUIRED | |