# System Variable Differences Between MariaDB 10.0 and MySQL 5.6 The following is a comparison of variables that either appear only in [MariaDB 10.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) or MySQL 5.6, or have different default settings in [MariaDB 10.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0), and MySQL 5.6. [MariaDB 10.0.12](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/10.0.12) and MySQL 5.6.20, with only default plugins enabled, were used for the comparison. The most notable differences are that MariaDB includes, by default, the [Aria](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria) storage engine (resulting in extra memory allocation), uses [Percona's XtraDB instead of Oracle's InnoDB](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb), and has a different [thread pool implementation](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). For this reason, a default implementation of [MariaDB 10.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) will use more memory than MySQL 5.6. MariaDB 10 and MySQL 5.6 also have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). MariaDB's extra memory usage can be handled with the following rules of thumb: * If you are not using [MyISAM](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine) and don't plan to use [Aria](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria): * Set [key\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_buffer_size) to something very low (16K) as it's not used. * Set [aria\_pagecache\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_buffer_size) to what you think you need for handling internal tmp tables that didn't fit in memory. * Normally this is what before you had set for [key\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_buffer_size) (at least 1M). * If you are using [MyISAM](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine) and not planning to use [Aria](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria): * Set [aria\_pagecache\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_buffer_size) to what you think you need for handling internal tmp tables that didn't fit in memory. * If you are planning to use [Aria](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria), you should set [aria\_pagecache\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_buffer_size) to something that fits a big part of your normal data + overflow temporary tables. The large number of differences between MySQL's and MariaDB's default innodb\* variables (based upon InnoDB/XtraDB differences) are not listed here. Details can be found on the [MariaDB versus MySQL - Compatibility](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference/README.md) page. ## Comparison Table | Variable | [MariaDB 10.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) | MySQL 5.6 | Notes | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [aria\_\*](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables) | \* | - | The [Aria](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria) storage engine is only available in MariaDB. | | [bind\_address](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#bind_address) | - | 127.0.0.1 | MySQL has the value of the bind-address option as a variable. | | [binlog-annotate-row-events](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/clients-and-utilities/logging-tools/mariadb-binlog/annotate_rows_log_event#master-option-binlog-annotate-row-events) | OFF | - | Introduced in [MariaDB 5.3](https://mariadb.com/docs/release-notes/community-server/old-releases/5.3/changes-improvements-in-mariadb-5-3) for [replicating](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference/README.md) between [MariaDB 5.3](https://mariadb.com/docs/release-notes/community-server/old-releases/5.3/changes-improvements-in-mariadb-5-3) and MySQL/[MariaDB 5.1](https://mariadb.com/docs/release-notes/community-server/old-releases/5.1/changes-improvements-in-mariadb-5-1). | | [binlog\_checksum](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | NONE | CRC32 | Specifies the type of BINLOG\_CHECKSUM\_ALG for log events in the [binary log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/binary-log). | | [binlog\_commit\_wait\_count](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | - | For use in MariaDB's [parallel replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/parallel-replication). | | [binlog\_commit\_wait\_usec](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 100000 | - | For use in MariaDB's [parallel replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/parallel-replication). | | binlog\_max\_flush\_queue\_time | - | 0 | MySQL 5.6-only variable specifying a timeout for reading transactions from the flush queue before continuing with group commit and syncing log to disk. | | [binlog\_optimize\_thread\_scheduling](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | ON | - | For optimized kernel thread scheduling. | | binlog\_order\_commits | - | ON | MySQL 5.6-only variable for determining whether transactions may be committed in parallel. | | binlog\_row\_image | - | ON | MySQL 5.6-only variable permitting partial logging. | | binlog\_rows\_query\_log\_events | - | OFF | MySQL 5.6-only variable for logging extra information in row-based logging. | | binlogging\_impossible\_mode | - | IGNORE\_ERROR | MySQL 5.6-only variable, determines what happens if a write to binlog fails. | | block\_encryption\_mode | - | aes-128-ecb | MySQL 5.6-only variable for controlling the block encryption mode for block-based algorithms. | | core\_file | - | OFF | MySQL 5.6-only variable indicating whether a core file will be written in case of a crash. | | [deadlock\_search\_depth\_long](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_long) | 15 | - | The Aria storage engine is only available in MariaDB | | [deadlock\_search\_depth\_short](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#deadlock_search_depth_short) | 4 | - | The Aria storage engine is only available in MariaDB | | [deadlock\_timeout\_long](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_long) | 50000000 | - | The Aria storage engine is only available in MariaDB | | [deadlock\_timeout\_short](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/aria/aria-system-variables#deadlock_timeout_short) | 10000 | - | The Aria storage engine is only available in MariaDB | | [debug\_no\_thread\_alarm](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#debug_no_thread_alarm) | OFF | - | Disable system thread alarm calls, for debugging or testing | | [default\_master\_connection](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty | - | For use with MariaDB's [multi-source replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/multi-source-replication). | | [default\_regex\_flags](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#default_regex_flags) | empty | - | For handling incompatibilities between MariaDB's [PCRE](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/sql-functions/string-functions/regular-expressions-functions/pcre) and the old regex library. | | [default\_tmp\_storage\_engine](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#default_tmp_storage_engine) | - | InnoDB | Available from [MariaDB 10.1](https://mariadb.com/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1) | | disconnect\_on\_expired\_password | - | ON | MySQL 5.6 permits passwords to be expired. | | end\_markers\_in\_json | - | OFF | MySQL 5.6-only variable for adding end markers to JSON output | | enforce\_gtid\_consistency | - | OFF | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | eq\_range\_index\_dive\_limit | - | 10 | MySQL 5.6-only variable for tuning when the optimizer should switch from using index dives to index statistics for qualifying rows estimation. | | [expensive\_subquery\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#expensive_subquery_limit) | 100 | - | Used for determining expensive queries for optimization. | | explicit\_defaults\_for\_timestamp | - | FALSE | MySQL 5.6-only variable for handling TIMESTAMP defaults in a standard way. | | [extra\_max\_connections](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 1 | - | Introduced in the [MariaDB 5.1 threadpool](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53). | | [extra\_port](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 0 | - | Introduced in the [MariaDB 5.1 threadpool](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53). | | [gtid\_binlog\_pos](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | empty | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_binlog\_state](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | empty | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_current\_pos](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | empty | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_domain\_id](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | 0 | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | gtid\_executed | - | empty | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_ignore\_duplicates](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | OFF | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | gtid\_mode | - | OFF | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | gtid\_next | - | AUTOMATIC | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | gtid\_owned | - | empty | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | gtid\_purged | - | empty | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_seq\_no](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | 0 | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_slave\_pos](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | empty | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [gtid\_strict\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid) | OFF | - | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | [have\_openssl](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/security/encryption/data-in-transit-encryption/ssltls-system-variables) | | | MariaDB's version indicates whether YaSSL or openssl was used. MySQL's is a synonym for have\_ssl. | | [histogram\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#histogram_size) | 0 | - | MariaDB introduced [Histogram-based Statistics](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics). | | [histogram\_type](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#histogram_type) | SINGLE\_PREC\_HB | - | MariaDB introduced [Histogram-based Statistics](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics). | | [host\_cache\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#host_cache_size) | 128 | 279 (autosized) | MySQL increments the value based on the size of [max\_connections](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_connections). | | [in\_transaction](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#in_transaction) | 0 | - | Set to 1 if you are in a transaction, and 0 if not. | | [innodb\_\*](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/innodb/innodb-system-variables) | \* | \* | The large number of differences between MySQL's and MariaDB's default innodb\* variables (based upon InnoDB/XtraDB differences) are not listed here. Details can be found on the [MariaDB versus MySQL - Compatibility](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference/README.md) page. | | [join\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#join_buffer_size) | 131072 (128KB) | 262144 (256KB) | Minimum size of the buffer used for queries that cannot use an index, and instead perform a full table scan. MariaDB's default is sufficient for most users. | | [join\_buffer\_space\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#join_buffer_space_limit) | 2097152 | - | Maximum size in bytes of the query buffer. See [block-based join algorithms](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference). | | [join\_cache\_level](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#join_cache_level) | 2 | - | For determining the join algorithms. See [block-based join algorithms](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference) | | [key\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_buffer_size) | 134217728 | 8388608 | Size of the buffer for the index blocks used by MyISAM tables and shared for all threads. | | [key\_cache\_segments](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_segments) | 0 | - | The number of segments in a key cache. See [Segmented Key Cache](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/system-variables/segmented-key-cache). | | [last\_gtid](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid#last_gtid) | - | empty | MariaDB and MySQL have different [GTID implementations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/gtid). | | log\_bin\_basename | - | empty | MySQL-only variable containing the complete path to the binary log file. | | log\_bin\_index | - | empty | MySQL-only variable containing the index file for binary log file names. | | log\_bin\_use\_v1\_row\_events | - | OFF | MySQL-only variable showing whether or not MySQL's version 2 binary logging format is being used. | | log\_slow\_admin\_statements | - | OFF | MySQL-only variable determining whether or not to include slow admin statements in the slow query log. | | [log\_slow\_filter](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_filter) | admin, filesort, filesort\_on\_disk, full\_join, full\_scan, query\_cache, query\_cache\_miss, tmp\_table, tmp\_table\_on\_disk | - | For slow query log filtering. | | [log\_slow\_rate\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_rate_limit) | 1 | - | Limits the number of queries logged to the [slow query log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/slow-query-log). | | log\_slow\_slave\_statements | - | OFF | MySQL-only variable determining whether or not to include slow slave statements in the slow query log. | | [log\_slow\_verbosity](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#log_slow_verbosity) | empty | - | Controls information to be added to the [slow query log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/slow-query-log). See also [Slow Query Log Extended Statistics](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics). | | log\_throttle\_queries\_not\_using\_indexes | - | 0 | MySQL-only variable for limiting the number of statements without indexes written to the slow query log. | | master\_info\_repository | - | FILE | MySQL-only variable determining whether the slaves log info to file or table. | | [max\_allowed\_packet](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_allowed_packet) | 1048576 | 4194304 | Maximum size in bytes of a packet or a generated/intermediate string. Increased in MySQL 5.6.6 to 4MB. | | [max\_long\_data\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_long_data_size) | 1048576 | - | Maximum size for parameter values sent with mysql\_stmt\_send\_long\_data(). Removed in MySQL 5.6. | | [max\_relay\_log\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 1073741824 | 0 | Can be set by session in MariaDB. | | [max\_seeks\_for\_key](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_seeks_for_key) | 4294967295 | 4294967295 (32-bit) or 18446744073709547520 (64-bit) | The most key seeks required when searching with an index, regardless of the actual index cardinality. If this value is set lower than its default and maximum, indexes will tend to be preferred over table scans. | | [max\_write\_lock\_count](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#max_write_lock_count) | 4294967295 | 4294967295 (32-bit) or 18446744073709547520 (64-bit) | Read lock requests will be permitted for processing after this many write locks. | | [mrr\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#mrr_buffer_size) | 262144 | - | Size of buffer to use when using multi-range read with range access. See [Multi Range Read optimization](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/multi-range-read-optimization#range-access). | | [myisam\_block\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_block_size) | 1024 | - | Block size used for [MyISAM](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine) index pages. | | [myisam\_recover\_options](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_recover_options) | DEFAULT | OFF | MyISAM recovery mode. | | [myisam\_sort\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#myisam_sort_buffer_size) | 134216704 | 8388608 | Size in bytes of the buffer allocated when creating or sorting indexes on a MyISAM table. | | new | - | OFF | Used for backward-compatibility with MySQL 4.1, not present in MariaDB | | [old\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#old_mode) | Empty string | - | Used for getting MariaDB to emulate behavior from an old version of MySQL or MariaDB. See [OLD Mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/old_mode). | | [optimizer\_selectivity\_sampling\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_selectivity_sampling_limit) | 100 | - | Controls number of record samples to check condition selectivity. | | [optimizer\_switch](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_switch) | [See details](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_switch) | | A series of flags for controlling the query optimizer. MariaDB has introduced a number of new settings. | | optimizer\_trace | - | Off by default | MySQL 5.6-only variable for optimizer tracing. | | optimizer\_trace\_features | - | Off by default | MySQL 5.6-only variable for optimizer tracing. | | optimizer\_trace\_limit | - | 1 | MySQL 5.6-only variable for optimizer tracing. | | optimizer\_trace\_max\_mem\_size | - | 16384 | MySQL 5.6-only variable for optimizer tracing. | | optimizer\_trace\_offset | - | -1 | MySQL 5.6-only variable for optimizer tracing. | | [optimizer\_use\_condition\_selectivity](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#optimizer_use_condition_selectivity) | 1 | - | Controls which statistics can be used by the optimizer when looking for the best query execution plan. | | [performance\_schema](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema) | OFF | ON | The [Performance Schema](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/performance-schema) is off by default in MariaDB. | | [performance\_schema\_\*](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/reference/system-tables/performance-schema/performance-schema-system-variables) | | | Many performance schema variables are autoset in MySQL. | | [plugin\_maturity](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#plugin_maturity) | unknown | - | Minimum acceptable plugin maturity. | | [progress\_report\_time](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#progress_report_time) | 5 | - | Time in seconds between sending progress reports to the client for time-consuming statements. | | [query\_cache\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#query_cache_size) | 0 | 1048576 | MySQL and MariaDB disable the query cache by default in different manners. | | [query\_cache\_strip\_comments](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#query_cache_strip_comments) | OFF | - | Whether to strip any comments from the query before searching to see if it exists in the [query cache](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/query-cache). | | [query\_cache\_type](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#query_cache_type) | ON | OFF | MySQL and MariaDB disable the query cache by default in different manners. | | relay\_log\_basename | - | empty | MySQL-only variable containing the complete path to the relay log file. | | relay\_log\_info\_repository | - | FILE | MySQL-only variable determining whether the slave's position in the relay logs is written to a file or table. | | [replicate\_annotate\_row\_events](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | OFF | - | Tells the slave to reproduce annotate\_rows\_events received from the master in its own binary log. | | [replicate\_do\_db](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [replicate\_do\_table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [replicate\_events\_marked\_for\_skip](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | replicate | - | See [Selectively skipping replication of binlog events](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events). | | [replicate\_ignore\_db](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [replicate\_ignore\_table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [replicate\_wild\_do\_table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [replicate\_wild\_ignore\_table](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | empty string | - | See [Dynamic Replication Variables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-filters). | | [rowid\_merge\_buff\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#rowid_merge_buff_size) | 8388608 | - | See [Non-semi-join subquery optimizations](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/non-semi-join-subquery-optimizations). | | [rpl\_recovery\_rank](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#rpl_recovery_rank) | 0 | - | Unused, removed in MySQL 5.6. | | rpl\_stop\_slave\_timeout | - | 31536000 | MySQL-only variable for controlling the time that STOP SLAVE waits before timing out. | | [secure\_auth](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#secure_auth) | OFF | ON | MySQL 5.6 prohibits connections from clients using the old (pre-MySQL 4.1) password format. | | server\_id\_bits | - | server\_id | MySQL-only variable for use in MySQL Cluster. | | server\_uuid | - | UUID | MySQL-only variable containing the UUID. | | [skip\_replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | OFF | - | See [Selectively skipping replication of binlog events](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events). | | slave\_allow\_batching | - | OFF | MySQL-only replication variable. | | slave\_checkpoint\_group | - | 512 | MySQL-only replication variable. | | slave\_checkpoint\_period | - | 300 | MySQL-only replication variable. | | [slave\_ddl\_exec\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | IDEMPOTENT | - | Modes for how replication of DDL events should be executed. | | [slave\_domain\_parallel\_threads](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | - | For configuring [parallel replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/parallel-replication#configuration-variable-slave_domain_parallel_threads). | | [slave\_parallel\_max\_queued](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 131072 | - | For configuring [parallel replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/parallel-replication#configuration-variable-slave_domain_parallel_threads). | | [slave\_parallel\_threads](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | - | For configuring [parallel replication](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/parallel-replication#configuration-variable-slave_domain_parallel_threads). | | slave\_parallel\_workers | - | 0 | MySQL-only replication variable. | | slave\_pending\_jobs\_size\_max | - | 16777216 | MySQL-only replication variable. | | slave\_rows\_search\_algorithms | - | TABLE\_SCAN, INDEX\_SCAN | MySQL-only replication variable. | | [sort\_buffer\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#sort_buffer_size) | 2097152 | 262144 | The default sort buffer allocated has been reduced in MySQL. | | [sql\_mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#sql_mode) | empty | NO\_ENGINE\_SUBSTITUTION | MySQL 5.6 does not permit tables to be created in the default storage engine if the original is not available. See [SQL Mode](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/sql_mode). | | [sync\_master\_info](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | 10000 | MariaDB relies upon the operating system to flush the master.info file to disk. | | [sync\_relay\_log](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | 10000 | MariaDB relies upon the operating system to flush the relay log to disk. | | [sync\_relay\_log\_info](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | 0 | 10000 | MariaDB relies upon the operating system to flush the relay-log.info file to disk. | | [table\_definition\_cache](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#table_definition_cache) | 400 | -1 (autosized) | Number of table definitions that can be cached. | | [table\_open\_cache](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#table_open_cache) | 400 | -1 (autosized) | Number of open tables for all threads. See [Optimizing table\_open\_cache](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/system-variables/optimizing-table_open_cache). | | [table\_open\_cache\_instances](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#table_open_cache_instances) | - | 1 | Removed in MariaDB as similar results achieved in a different way. | | [thread\_cache\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#thread_cache_size) | 0 | -1 (autosized) | MariaDB uses an [improved thread pool](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | [thread\_pool\_idle\_timeout](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 60 | - | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | [thread\_pool\_max\_threads](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 500 | - | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | [thread\_pool\_min\_threads](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 1 | - | Windows-only. See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | [thread\_pool\_oversubscribe](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 3 | - | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | [thread\_pool\_size](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | Number of processors | 16\* | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). \*Only available in MySQL with a commercial plugin. | | [thread\_pool\_stall\_limit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | 500 | 6\* | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). \*Only available in MySQL with a commercial plugin. | | [thread\_stack](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#thread_stack) | 294912 | 196608 or 262144 | See [Using the Thread Pool in MariaDB 5.5](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb). | | transaction\_allow\_batching | - | OFF | MySQL-only variable for enabling batching of statements within the same transaction in MySQL Cluster. | | [use\_stat\_tables](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#use_stat_tables) | NEVER | - | Controls the use of [engine-independent table statistics](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics). | | [userstat](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#userstat) | OFF | - | Whether to activate MariaDB's [User Statistics](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics) implementation, not available in MySQL. | | [version\_malloc\_library](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#version_malloc_library) | bundled\_jemalloc | - | Version of the used malloc library. | | Variable | [MariaDB 10.0](https://mariadb.com/docs/release-notes/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) | MySQL 5.6 | Notes | ## See Also * [System Variable Differences Between MariaDB 10.2 and MySQL 5.6](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/system-variable-differences-between-mariadb-10-2-and-mysql-5-6) * [System Variable Differences Between MariaDB 10.1 and MySQL 5.6](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/system-variable-differences-between-mariadb-10-1-and-mysql-5-6) {% @marketo/form formid="4316" formId="4316" %}