# System Variable Differences Between MariaDB 5.5 and MySQL 5.5

The following is a comparison of variables that either appear only in [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md), or have different default settings in [MariaDB 5.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/mariadb-community-server-release-notes/old-releases/release-notes-mariadb-5-5-series/changes-improvements-in-mariadb-5-5.md), and MySQL 5.5. MariaDB and MySQL 5.5.38, with only default plugins enabled, were used for the comparison.

The most notable differences are that MariaDB includes, by default, the [Aria](/docs/server/server-usage/storage-engines/aria.md) storage engine, uses [Percona's XtraDB instead of Oracle's InnoDB](/docs/server/server-usage/storage-engines/innodb.md), and has a different [thread pool implementation](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md). For this reason, a default implementation of [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md) will use more memory than MySQL 5.5. This can be handled with the following rules of thumb:

* If you are not using [MyISAM](/docs/server/server-usage/storage-engines/myisam-storage-engine.md) and don't plan to use [Aria](/docs/server/server-usage/storage-engines/aria.md):
  * Set [key\_buffer\_size](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#key_buffer_size) to something very low (16K) as it's not used.
  * Set [aria\_pagecache\_buffer\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#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](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#key_buffer_size) (at least 1M).
* If you are using [MyISAM](/docs/server/server-usage/storage-engines/myisam-storage-engine.md) and not planning to use [Aria](/docs/server/server-usage/storage-engines/aria.md):
  * Set [aria\_pagecache\_buffer\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#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](/docs/server/server-usage/storage-engines/aria.md), you should set [aria\_pagecache\_buffer\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#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.

| Variable                                                                                                                                                             | [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md)                     | MySQL 5.5                                            | Notes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [aria\_block\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_block_size)                                                         | 8192                                                                                                                            | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_checkpoint\_interval](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_checkpoint_interval)                                       | 30                                                                                                                              | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_checkpoint\_log\_activity](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_checkpoint_log_activity)                              | 1048576                                                                                                                         | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_force\_start\_after\_recovery\_failures](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_force_start_after_recovery_failures)    | 0                                                                                                                               | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_group\_commit](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_group_commit)                                                     | none                                                                                                                            | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_group\_commit\_interval](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_group_commit_interval)                                  | 0                                                                                                                               | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_log\_file\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_log_file_size)                                                  | 1073741824                                                                                                                      | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_log\_purge\_type](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_log_purge_type)                                                | immediate                                                                                                                       | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_max\_sort\_file\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_max_sort_file_size)                                       | 9223372036853727232                                                                                                             | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_page\_checksum](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_page_checksum)                                                   | ON                                                                                                                              | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_pagecache\_age\_threshold](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_pagecache_age_threshold)                              | 300                                                                                                                             | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_pagecache\_buffer\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_pagecache_buffer_size)                                  | 134217720                                                                                                                       | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_pagecache\_division\_limit](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_pagecache_division_limit)                            | 100                                                                                                                             | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_recover](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_recover)                                                                | NORMAL                                                                                                                          | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_repair\_threads](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_repair_threads)                                                 | 1                                                                                                                               | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_sort\_buffer\_size](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_sort_buffer_size)                                            | 134217728                                                                                                                       | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_stats\_method](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_stats_method)                                                     | nulls-unequal                                                                                                                   | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_sync\_log\_dir](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_sync_log_dir)                                                    | NEWFILE                                                                                                                         | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [aria\_used\_for\_temp\_tables](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#aria_used_for_temp_tables)                                   | ON                                                                                                                              | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [binlog-annotate-row-events](/docs/server/clients-and-utilities/logging-tools/mariadb-binlog/annotate_rows_log_event.md#master-option-binlog-annotate-row-events)    | OFF                                                                                                                             | -                                                    | Introduced in [MariaDB 5.3](/docs/release-notes/community-server/old-releases/5.3/changes-improvements-in-mariadb-5-3.md) 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](/docs/release-notes/community-server/old-releases/5.3/changes-improvements-in-mariadb-5-3.md) and MySQL/[MariaDB 5.1](/docs/release-notes/community-server/old-releases/5.1/changes-improvements-in-mariadb-5-1.md). |
| [binlog\_checksum](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                              | NONE                                                                                                                            | -                                                    | Specifies the type of BINLOG\_CHECKSUM\_ALG for log events in the [binary log](/docs/server/server-management/server-monitoring-logs/binary-log.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [binlog\_optimize\_thread\_scheduling](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                          | ON                                                                                                                              | -                                                    | For optimized kernel thread scheduling.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [deadlock\_search\_depth\_long](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#deadlock_search_depth_long)                                  | 15                                                                                                                              | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [deadlock\_search\_depth\_short](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#deadlock_search_depth_short)                                | 4                                                                                                                               | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [deadlock\_timeout\_long](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#deadlock_timeout_long)                                             | 50000000                                                                                                                        | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [deadlock\_timeout\_short](/docs/server/server-usage/storage-engines/aria/aria-system-variables.md#deadlock_timeout_short)                                           | 10000                                                                                                                           | -                                                    | The Aria storage engine is only available in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| [debug\_no\_thread\_alarm](/docs/server/server-management/variables-and-modes/server-system-variables.md#debug_no_thread_alarm)                                      | OFF                                                                                                                             | -                                                    | Disable system thread alarm calls, for debugging or testing                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [engine\_condition\_pushdown](/docs/server/server-management/variables-and-modes/server-system-variables.md#engine_condition_pushdown)                               | OFF                                                                                                                             | ON                                                   | Controlled by [optimizer\_switch](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_switch)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [expensive\_subquery\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#expensive_subquery_limit)                                 | 100                                                                                                                             | -                                                    | Used for determining expensive queries for optimization.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| [extra\_max\_connections](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)     | 1                                                                                                                               | -                                                    | Introduced in the [MariaDB 5.1 threadpool](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [extra\_port](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)                 | 0                                                                                                                               | -                                                    | Introduced in the [MariaDB 5.1 threadpool](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb-51-53.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| [ignore\_db\_dirs](/docs/server/server-management/variables-and-modes/server-system-variables.md#ignore_db_dirs)                                                     |                                                                                                                                 | -                                                    | Comma-delimited list of directories in the data directory that are not considered as database directories. Only introduced in MySQL 5.6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [in\_transaction](/docs/server/server-management/variables-and-modes/server-system-variables.md#in_transaction)                                                      | 0                                                                                                                               | -                                                    | Set to 1 if you are in a transaction, and 0 if not.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| [join\_buffer\_space\_limit](/docs/server/server-management/variables-and-modes/server-system-variables.md#join_buffer_space_limit)                                  | 2097152                                                                                                                         | -                                                    | Maximum size in bytes of the query buffer. See [block-based join algorithms](broken://spaces/WCInJQ9cmGjq1lsTG91E/pages/VWjZF4UcCaSJJtdMzBO2).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| [join\_cache\_level](/docs/server/server-management/variables-and-modes/server-system-variables.md#join_cache_level)                                                 | 2                                                                                                                               | -                                                    | For determining the join algorithms. See [block-based join algorithms](broken://spaces/WCInJQ9cmGjq1lsTG91E/pages/VWjZF4UcCaSJJtdMzBO2).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| [key\_buffer\_size](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#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](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#key_cache_segments)                                | 0                                                                                                                               | -                                                    | The number of segments in a key cache. See [Segmented Key Cache](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/segmented-key-cache.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| [log\_slow\_filter](/docs/server/server-management/variables-and-modes/server-system-variables.md#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](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_rate_limit)                                          | 1                                                                                                                               | -                                                    | Limits the number of queries logged to the [slow query log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [log\_slow\_verbosity](/docs/server/server-management/variables-and-modes/server-system-variables.md#log_slow_verbosity)                                             | ''                                                                                                                              | -                                                    | Controls information to be added to the [slow query log](/docs/server/server-management/server-monitoring-logs/slow-query-log.md). See also [Slow Query Log Extended Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics.md).                                                                                                                                                                                                                                                                                                                      |
| [master\_verify\_checksum](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                      | OFF                                                                                                                             | -                                                    | Verify binlog checksums when reading events from the binlog on the master.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| [max\_seeks\_for\_key](/docs/server/server-management/variables-and-modes/server-system-variables.md#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](/docs/server/server-management/variables-and-modes/server-system-variables.md#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](/docs/server/server-management/variables-and-modes/server-system-variables.md#mrr_buffer_size)                                                   | 262144                                                                                                                          | -                                                    | Size of buffer to use when using multi-range read with range access. See [Multi Range Read optimization](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/multi-range-read-optimization.md#range-access).                                                                                                                                                                                                                                                                                                                                                                                                             |
| [myisam\_block\_size](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#myisam_block_size)                                  | 1024                                                                                                                            | -                                                    | Block size used for [MyISAM](/docs/server/server-usage/storage-engines/myisam-storage-engine.md) index pages.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| [myisam\_recover\_options](/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables.md#myisam_recover_options)                        | DEFAULT                                                                                                                         | OFF                                                  | MyISAM recovery mode.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| new                                                                                                                                                                  | -                                                                                                                               | OFF                                                  | Used for backward-compatibility with MySQL 4.1, not present in MariaDB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| [old\_mode](/docs/server/server-management/variables-and-modes/server-system-variables.md#old_mode)                                                                  | Empty string                                                                                                                    | -                                                    | Used for getting MariaDB to emulate behavior from an old version of MySQL or MariaDB. See [OLD Mode](/docs/server/server-management/variables-and-modes/old_mode.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [optimizer\_switch](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_switch)                                                  | [See details](/docs/server/server-management/variables-and-modes/server-system-variables.md#optimizer_switch)                   |                                                      | A series of flags for controlling the query optimizer. MariaDB has introduced a number of new settings.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [plugin\_maturity](/docs/server/server-management/variables-and-modes/server-system-variables.md#plugin_maturity)                                                    | unknown                                                                                                                         | -                                                    | Minimum acceptable plugin maturity.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| [progress\_report\_time](/docs/server/server-management/variables-and-modes/server-system-variables.md#progress_report_time)                                         | 5                                                                                                                               | -                                                    | See [Progress reporting](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).                                                                                                                                                                                                                                                                                                                                                              |
| [query\_cache\_strip\_comments](/docs/server/server-management/variables-and-modes/server-system-variables.md#query_cache_strip_comments)                            | OFF                                                                                                                             | -                                                    | Whether to strip any comments from the query before searching to see if it exists in the [query cache](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/query-cache.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| [replicate\_annotate\_row\_events](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                              | OFF                                                                                                                             | -                                                    | Tells the slave to reproduce annotate\_rows\_events received from the master in its own binary log.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| [replicate\_do\_db](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                             | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [replicate\_do\_table](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                          | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [replicate\_events\_marked\_for\_skip](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                          | replicate                                                                                                                       | -                                                    | See [Selectively skipping replication of binlog events](/docs/server/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| [replicate\_ignore\_db](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                         | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [replicate\_ignore\_table](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                      | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [replicate\_wild\_do\_table](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                    | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [replicate\_wild\_ignore\_table](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                | empty string                                                                                                                    | -                                                    | See [Dynamic Replication Variables](/docs/server/ha-and-performance/standard-replication/replication-filters.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| [rowid\_merge\_buff\_size](/docs/server/server-management/variables-and-modes/server-system-variables.md#rowid_merge_buff_size)                                      | 8388608                                                                                                                         | -                                                    | See [Non-semi-join subquery optimizations](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/subquery-optimizations/non-semi-join-subquery-optimizations.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| [skip\_replication](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                             | OFF                                                                                                                             | -                                                    | See [Selectively skipping replication of binlog events](/docs/server/server-management/server-monitoring-logs/binary-log/selectively-skipping-replication-of-binlog-events.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| [slave\_sql\_verify\_checksum](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md)                                  | ON                                                                                                                              | -                                                    | Verify binlog checksums when the slave SQL thread reads events from the relay log.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| [thread\_pool\_idle\_timeout](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md) | 60                                                                                                                              | -                                                    | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [thread\_pool\_max\_threads](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)  | 60                                                                                                                              | -                                                    | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [thread\_pool\_min\_threads](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)  | 60                                                                                                                              | -                                                    | Windows-only. See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| [thread\_pool\_oversubscribe](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md) | 3                                                                                                                               | -                                                    | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [thread\_pool\_size](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)          | Number of processors                                                                                                            | 16\*                                                 | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md). \*Only available in MySQL with a commercial plugin.                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| [thread\_pool\_stall\_limit](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables.md)  | 500                                                                                                                             | 6\*                                                  | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md). \*Only available in MySQL with a commercial plugin.                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| [thread\_stack](/docs/server/server-management/variables-and-modes/server-system-variables.md#thread_stack)                                                          | 294912                                                                                                                          | 196608 or 262144                                     | See [Using the Thread Pool in MariaDB 5.5](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb.md).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| [userstat](/docs/server/server-management/variables-and-modes/server-system-variables.md#userstat)                                                                   | OFF                                                                                                                             | -                                                    | Whether to activate MariaDB's [User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md) implementation, not available in MySQL.                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| Variable                                                                                                                                                             | [MariaDB 5.5](/docs/release-notes/community-server/old-releases/5.5/changes-improvements-in-mariadb-5-5.md)                     | MySQL 5.5                                            | Notes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |

## See Also

* [System Variable Differences Between MariaDB 10.1 and MySQL 5.7](/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-7.md)
* [System Variable Differences Between MariaDB 10.1 and MySQL 5.6](/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.md)
* [System Variable Differences Between MariaDB 10.0 and MySQL 5.6](/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-100-and-mysql-56.md)

{% @marketo/form formid="4316" formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET 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-55-and-mysql-55.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
