# System Variables Added in MariaDB 10.2 This is a list of [system variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables) that have been added in the [MariaDB 10.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/what-is-mariadb-102) series. The list does not include variables that are not part of the default release. | Variable | Added | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------ | | [aria\_recover\_options](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_recover_options) | [MariaDB 10.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.0) | | [eq\_range\_index\_dive\_limit](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#eq_range_index_dive_limit) | [MariaDB 10.2.18](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.18) | | [innodb\_adaptive\_hash\_index\_parts](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_deadlock\_detect](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.6) | | [innodb\_default\_row\_format](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_encrypt\_temporary\_ables](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.26](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.26) | | [innodb\_fill\_factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_flush\_sync](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_lock\_schedule\_algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.3) | | [innodb\_log\_checksums](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_log\_optimize\_ddl](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.17](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.17) | | [innodb\_log\_write\_ahead\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_max\_undo\_log\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_page\_cleaners](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_purge\_rseg\_truncate\_frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [innodb\_safe\_truncate](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.19](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.19) | | [innodb\_stats\_include\_delete\_marked](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.6) | | [innodb\_temp\_data\_file\_path](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [max\_recursive\_iterations](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_recursive_iterations) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [read\_binlog\_speed\_limit](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.2.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.3) | | [session\_track\_schema](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#session_track_schema) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [session\_track\_state\_change](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#session_track_state_change) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [session\_track\_system\_variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#session_track_system_variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [session\_track\_transaction\_info](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#session_track_transaction_info) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [slave\_parallel\_workers](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.0) | | [table\_open\_cache\_instances](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#table_open_cache_instances) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [thread\_pool\_prio\_kickup\_timer](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [thread\_pool\_priority](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables) | [MariaDB 10.2.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.2) | | [tmp\_disk\_table\_size](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#tmp_disk_table_size) | [MariaDB 10.2.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.7) | | [tmp\_memory\_table\_size](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#tmp_memory_table_size) | [MariaDB 10.2.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.7) | | [wsrep\_certification\_rules](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_certification_rules) | [MariaDB 10.2.22](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.2/10.2.22) | ## See Also * [Status Variables Added in MariaDB 10.2](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/status-variables-added-in-mariadb-102) * [System Variables Added in MariaDB 10.3](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-10-3) * [System Variables Added in MariaDB 10.1](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-101) * [System Variables Added in MariaDB 10.0](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release/system-and-status-variables-added-by-major-unmaintained-release/system-variables-added-in-mariadb-100) *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}