# System Variables Added in MariaDB 10.0

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.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) series.

The list excludes the following variables, related to storage engines and plugins included in [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0):

* [Connect System Variables](https://mariadb.com/docs/server/server-usage/storage-engines/connect/connect-system-variables)
* [Galera System Variables](https://app.gitbook.com/s/3VYeeVGUV4AMqrA3zwy7/reference/galera-cluster-system-variables)
* [Mroonga System Variables](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga/mroonga-system-variables)
* [Query Response Time Plugin Variables](https://mariadb.com/docs/server/reference/plugins/other-plugins/query-response-time-plugin)
* [Spider System Variables](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-system-variables)

| Variable                                                                                                                                                                                                                              | Added                                                                                                                                  |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| [aria\_pagecache\_file\_hash\_size](https://mariadb.com/docs/server/server-usage/storage-engines/aria/aria-system-variables#aria_pagecache_file_hash_size)                                                                            | [MariaDB 10.0.13](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.13)                           |
| [binlog\_commit\_wait\_count](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                    | [MariaDB 10.0.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.5)                             |
| [binlog\_commit\_wait\_usec](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                     | [MariaDB 10.0.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.5)                             |
| [default\_master\_connection](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                    | [MariaDB 10.0.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.1)                             |
| [default\_regex\_flags](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#default_regex_flags)                                                                                            | [MariaDB 10.0.11](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.11)                           |
| [gtid\_binlog\_pos](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                     | [MariaDB 10.0.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.3)                             |
| [gtid\_binlog\_state](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                   | [MariaDB 10.0.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.5)                             |
| [gtid\_current\_pos](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                    | [MariaDB 10.0.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.3)                             |
| [gtid\_domain\_id](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                      | [MariaDB 10.0.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.2)                             |
| [gtid\_ignore\_duplicates](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                              | [MariaDB 10.0.10](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.10)                           |
| [gtid\_seq\_no](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                         | [MariaDB 10.0.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.2)                             |
| [gtid\_slave\_pos](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                      | [MariaDB 10.0.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.3)                             |
| [gtid\_strict\_mode](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                    | [MariaDB 10.0.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.3)                             |
| [histogram\_size](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#histogram_size)                                                                                                       | [MariaDB 10.0.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.2)                             |
| [histogram\_type](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#histogram_type)                                                                                                       | [MariaDB 10.0.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.2)                             |
| [innodb\_adaptive\_flushing\_lwm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                        | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_adaptive\_max\_sleep\_delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                    | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_api\_bk\_commit\_interval](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                      | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_api\_disable\_rowlock](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                          | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_api\_enable\_binlog](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                            | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_api\_enable\_mdl](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                               | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_api\_trx\_level](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_dump\_at\_shutdown](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                               | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_dump\_now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                        | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_filename](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                         | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_load\_abort](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                      | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_load\_at\_startup](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_buffer\_pool\_load\_now](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                        | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_change\_buffer\_max\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                      | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_checksum\_algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                            | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_cleaner\_lsn\_age\_factor](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                      | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_cmp\_per\_index\_enabled](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_compression\_failure\_threshold\_pct](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                           | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_compression\_level](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                             | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_compression\_pad\_pct\_max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                     | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_disable\_sort\_file\_cache](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                     | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_empty\_free\_list\_algorithm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                   | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_flush\_neighbors](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                               | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_foreground\_preflush](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                           | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_ft\_aux\_table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                 | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_cache\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_enable\_diag\_print](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                        | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_enable\_stopword](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                           | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_max\_token\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                           | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_min\_token\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                           | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_num\_word\_optimize](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                        | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_result\_cache\_limit](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_ft\_server\_stopword\_table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                    | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_sort\_pll\_degree](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                          | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_ft\_total\_cache\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                         | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_ft\_user\_stopword\_table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                      | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_io\_capacity\_max](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                              | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_log\_arch\_dir](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                 | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_log\_arch\_expire\_sec](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                         | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_log\_archive](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                   | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_log\_compressed\_pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                         | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_max\_dirty\_pages\_pct\_lwm](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                    | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_max\_purge\_lag\_delay](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                         | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_monitor\_disable](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                               | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_monitor\_enable](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_monitor\_reset](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                 | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_monitor\_reset\_all](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                            | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_online\_alter\_log\_max\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                  | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_optimize\_fulltext\_only](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_random\_read\_ahead](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                            | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_read\_only](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                     | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_recovery\_stats](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_sched\_priority\_cleaner](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [innodb\_simulate\_comp\_failures](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0.14](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.14)                           |
| [innodb\_sort\_buffer\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                             | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_stats\_auto\_recalc](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                            | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_stats\_modified\_counter](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                       | [MariaDB 10.0.15](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.15)                           |
| [innodb\_stats\_persistent](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                              | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_stats\_persistent\_sample\_pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                               | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_stats\_traditional](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                             | [MariaDB 10.0.16](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.16)                           |
| [innodb\_stats\_transient\_sample\_pages](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_status\_output](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                 | [MariaDB 10.0.14](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.14)                           |
| [innodb\_status\_output\_locks](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                          | [MariaDB 10.0.14](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.14)                           |
| [innodb\_sync\_array\_size](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                              | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_undo\_directory](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_undo\_logs](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                                     | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [innodb\_undo\_tablespaces](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables)                                                                                                              | [MariaDB 10.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/changes-improvements-in-mariadb-10-0) |
| [key\_cache\_file\_hash\_size](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine/myisam-system-variables#key_cache_file_hash_size)                                                                   | [MariaDB 10.0.13](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.13)                           |
| [last\_gtid](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid)                                                                                                                                            | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [oqgraph\_allow\_create\_integer\_latch](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#oqgraph_allow_create_integer_latch)                                                            | [MariaDB 10.0.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.7)                             |
| [performance\_schema\_accounts\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_accounts_size)                                                | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_digests\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_digests_size)                                                  | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_events\_stages\_history\_long\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_stages_history_long_size)         | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_events\_stages\_history\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_stages_history_size)                    | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_events\_statements\_history\_long\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_statements_history_long_size) | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_events\_statements\_history\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_events_statements_history_size)            | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_hosts\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_hosts_size)                                                      | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_max\_digest\_length](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_digest_length)                                       | [MariaDB 10.0.21](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.21)                           |
| [performance\_schema\_max\_socket\_classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_socket_classes)                                     | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_max\_socket\_instances](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_socket_instances)                                 | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_max\_stage\_classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_stage_classes)                                       | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_max\_statement\_classes](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_max_statement_classes)                               | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_session\_connect\_attrs\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_session_connect_attrs_size)                    | [MariaDB 10.0.4](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.4)                             |
| [performance\_schema\_setup\_actors\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_setup_actors_size)                                       | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_setup\_objects\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_setup_objects_size)                                     | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [performance\_schema\_users\_size](https://mariadb.com/docs/server/reference/system-tables/performance-schema/performance-schema-system-variables#performance_schema_users_size)                                                      | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [slave\_ddl\_exec\_mode](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                         | [MariaDB 10.0.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.8)                             |
| [slave\_domain\_parallel\_threads](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                               | [MariaDB 10.0.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.9)                             |
| [slave\_parallel\_max\_queued](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                   | [MariaDB 10.0.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.5)                             |
| [slave\_parallel\_threads](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables)                                                                                       | [MariaDB 10.0.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.5)                             |
| [ssl\_crl](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables)                                                                                                                    | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [ssl\_crlpath](https://mariadb.com/docs/server/security/encryption/data-in-transit-encryption/ssltls-system-variables)                                                                                                                | [MariaDB 10.0.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.0)                             |
| [use\_stat\_tables](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#use_stat_tables)                                                                                                    | [MariaDB 10.0.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.1)                             |
| [version\_malloc\_library](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#version_malloc_library)                                                                                      | [MariaDB 10.0.1](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.0/10.0.1)                             |

## See Also

* [Status 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/status-variables-added-in-mariadb-100)
* [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)
* [Upgrading from MariaDB 5.5 to MariaDB 10.0](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/upgrading/mariadb-community-server-upgrade-paths/upgrading-to-unmaintained-mariadb-releases/upgrading-from-mariadb-10-4-to-mariadb-10-5)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form 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/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.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.
