# System Variables Added in MariaDB 10.1 This is a list of [system variables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables) that were added in the [MariaDB 10.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1) series. The list excludes the following variables, related to storage engines and plugins included in [MariaDB 10.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1): * [Spider System Variables](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables) | Variable | Added | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------ | | [aria\_encrypt\_tables](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_encrypt_tables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [default\_tmp\_storage\_engine](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#default_tmp_storage_engine) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [encrypt\_binlog](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#encrypt_binlog) | [MariaDB 10.1.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.7) | | [encrypt\_tmp\_disk\_tables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#encrypt_tmp_disk_tables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [encrypt\_tmp\_files](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#encrypt_tmp_files) | [MariaDB 10.1.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.5) | | [enforce\_storage\_engine](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#enforce_storage_engine) | [MariaDB 10.1.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.4) | | [explicit\_defaults\_for\_timestamp](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#explicit_defaults_for_timestamp) | [MariaDB 10.1.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.8) | | [innodb\_background\_scrub\_data\_check\_interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_background\_scrub\_data\_compressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_background\_scrub\_data\_interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_background\_scrub\_data\_uncompressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_buf\_dump\_status\_frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.6) | | [innodb\_compression\_algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [innodb\_default\_encryption\_key\_id](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.4) | | [innodb\_default\_row\_format](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.32](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.32) | | [innodb\_defragment](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_defragment\_fill\_factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_defragment\_fill\_factor\_n\_recs](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_defragment\_frequency](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_defragment\_n\_pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_defragment\_stats\_accuracy](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [innodb\_disallow\_writes](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_encrypt\_log](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_encrypt\_tables](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_encryption\_rotate\_key\_age](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_encryption\_rotation\_iops](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_encryption\_threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_fatal\_semaphore\_wait\_threshold](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.2) | | [innodb\_force\_primary\_key](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [innodb\_idle\_flush\_pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.2) | | [innodb\_immediate\_scrub\_data\_uncompressed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_instrument\_semaphores](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_mtflush\_threads](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [innodb\_prefix\_index\_cluster\_optimization](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.2) | | [innodb\_scrub\_log](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [innodb\_scrub\_log\_speed](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.4) | | [innodb\_use\_mtflush](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [innodb\_use\_trim](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables) | [MariaDB 10.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.0) | | [log\_bin\_basename](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.6) | | [log\_bin\_index](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.6) | | [log\_tc\_size](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#log_tc_size) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [max\_digest\_length](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_digest_length) | [MariaDB 10.1.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.5) | | [max\_session\_mem\_used](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_session_mem_used) | [MariaDB 10.1.21](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.21) | | [max\_statement\_time](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#max_statement_time) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [mysql56\_temporal\_format](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#mysql56_temporal_format) | [MariaDB 10.1.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.2) | | [relay\_log\_basename](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.6) | | [strict\_password\_validation](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#strict_password_validation) | [MariaDB 10.1.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.2) | | [skip\_parallel\_replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [slave\_parallel\_mode](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [slave\_run\_triggers\_for\_rbr](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables) | [MariaDB 10.1.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.1) | | [version\_ssl\_library](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | | [wsrep\_certification\_rules](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_certification_rules) | [MariaDB 10.1.38](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.38) | | [wsrep\_dirty\_reads](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables#wsrep_dirty_reads) | [MariaDB 10.1.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.1/10.1.3) | ## See Also * [Status 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/status-variables-added-in-mariadb-101) * [System 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/system-variables-added-in-mariadb-102) * [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" %}