> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/system-variables.md).

# System and Status Variables

{% columns %}
{% column %}
{% content-ref url="/pages/5vNNTYdI82eVVDcu1Ak5" %}
[Big Query Settings](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/big-query-settings.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Settings and features aimed at big queries, several of which are disabled by default.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/FLE1gSoKs8sqMw1l7kSU" %}
[Handling Too Many Connections](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/handling-too-many-connections.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to handle and avoid the 'too many connections' error on busy servers.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QI9BZxm1dNf8kEWbdL0B" %}
[MariaDB Optimization for MySQL Users](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/mariadb-optimization-for-mysql-users.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MariaDB optimization options and defaults that differ from MySQL, for users migrating from MySQL.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SEZ6WLL9ndcI3YkIbfmR" %}
[Optimizing key\_buffer\_size](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-key_buffer_size.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Tuning key\_buffer\_size for servers with mostly MyISAM tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/gEIH695EA24kRpr6MVIU" %}
[Optimizing table\_open\_cache](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/optimizing-table_open_cache.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Tuning table\_open\_cache to balance performance against open-file usage.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/l3S8cm9jvywl97NauSTI" %}
[OQGRAPH System and Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/oqgraph-system-and-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
System and status variables for the OQGRAPH storage engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/PCMalHt5wrQB3WEHZVLr" %}
[Sample my.cnf Files](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sample-mycnf-files.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Sample my.cnf configuration files for different memory sizes and storage engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/JtekSmWrFdMcoHl1mxsi" %}
[Segmented Key Cache](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/segmented-key-cache.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Segmented key caches, which split the MyISAM key cache into structures to reduce contention.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/haIWQHKw1q57b1fdnUcR" %}
[Semisynchronous Replication Plugin Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/semisynchronous-replication-plugin-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Status variables for the semisynchronous replication plugin.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UtFKFdr8jsiEoRHi9Sde" %}
[InnoDB Server Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/innodb-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
InnoDB server status variables, viewable with SHOW STATUS.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Qoaks0oIzx8OJppID7VI" %}
[Setting Innodb Buffer Pool Size Dynamically](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/setting-innodb-buffer-pool-size-dynamically.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to resize the InnoDB buffer pool dynamically, in chunks.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/lt8qSBzqdElRjgT1mvuq" %}
[Sphinx Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sphinx-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Status variables for the Sphinx storage engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/AOuGFTwI1jJ5kg1r8NpX" %}
[Spider Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/spider-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Status variables for the Spider storage engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6B0nHu9WT6yH91953NF5" %}
[SQL Error Log System Variables and Options](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/sql-error-log-system-variables-and-options.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
System variables and options for the SQL Error Log plugin.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TIIw9nJyZ57O2CdDh6Xr" %}
[SSL/TLS Status Variables](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/ssltls-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Status variables related to TLS/SSL-encrypted connections.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/KS121h0GEv8YcpQPmwuQ" %}
[System and Status Variables Added By Major Release](/docs/server/ha-and-performance/optimization-and-tuning/system-variables/system-and-status-variables-added-by-major-release.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover system and status variables added by major MariaDB Server releases. This section helps you track new configuration options and monitoring metrics introduced in different versions.
{% endcolumn %}
{% endcolumns %}