| LICENSE | | GPL | COMPILE-TIME | | GLOBAL | VARCHAR | The type of license the server has | | | | | YES | | |
| PERFORMANCE_SCHEMA | | OFF | COMPILE-TIME | OFF | GLOBAL | BOOLEAN | Enable the performance schema. | | | | OFF,ON | YES | OPTIONAL | |
| 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 | |
| GTID_BINLOG_STATE | | | COMPILE-TIME | | GLOBAL | VARCHAR | The internal GTID state of the binlog, used to keep track of all GTIDs ever logged to the ... | | | | | NO | | |
| 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 | |
| DELAYED_INSERT_LIMIT | | 100 | COMPILE-TIME | 100 | GLOBAL | BIGINT UNSIGNED | After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there ... | 1 | 4294967295 | 1 | | NO | REQUIRED | |
| PERFORMANCE_SCHEMA_MAX_COND_CLASSES | | 90 | COMPILE-TIME | 90 | GLOBAL | BIGINT UNSIGNED | Maximum number of condition instruments. | 0 | 256 | 1 | | YES | REQUIRED | |
| WSREP_TRX_FRAGMENT_SIZE | 0 | 0 | COMPILE-TIME | 0 | SESSION | BIGINT UNSIGNED | Size of transaction fragments for streaming replication (measured in units of 'wsrep_trx_f... | 0 | 2147483647 | 1 | | NO | REQUIRED | |
| 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 | Enrypt 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 | |
| PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | | -1 | COMPILE-TIME | -1 | GLOBAL | BIGINT | Maximum number of instrumented tables. Use 0 to disable, -1 for automated sizing. | -1 | 1048576 | 1 | | YES | REQUIRED | |
| MAX_STATEMENT_TIME | 0.000000 | 0.000000 | COMPILE-TIME | 0.000000 | SESSION | DOUBLE | A query that has taken more than max_statement_time seconds will be aborted. The argument ... | 0 | 31536000 | | | NO | REQUIRED | |
| PROXY_USER | | | COMPILE-TIME | | SESSION ONLY | VARCHAR | The proxy user account name used when logging in | | | | | 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 | |
| SSL_CERT | | | COMPILE-TIME | | GLOBAL | VARCHAR | X509 cert in PEM format (implies --ssl) | | | | | YES | REQUIRED | |
| LONG_QUERY_TIME | 10.000000 | 10.000000 | COMPILE-TIME | 10.000000 | SESSION | DOUBLE | Alias for log_slow_query_time. Log all queries that have taken more than long_query_time s... | 0 | 31536000 | | | NO | REQUIRED | |