> 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.md).

# Optimization and Tuning

{% columns %}
{% column %}
{% content-ref url="/pages/oc6YMZImRU4pFSu7HgLK" %}
[Buffers, Caches and Threads](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers essential configurations to maximize throughput and responsiveness for your database workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/XDRM6j413DJDksFvVbnW" %}
[MariaDB Internal Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Delves into how the database engine enhances query execution, data storage, and overall performance through its core architecture.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/kx3gMPdei75KaUpZJmaX" %}
[Operating System Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/operating-system-optimizations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers configuring your OS for improved I/O, memory management, and network settings to maximize database efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UfyUtV8YXtkYDhpgaAV2" %}
[Optimization and Indexes](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers index types, creation, and best practices for leveraging them to significantly improve query performance and data retrieval speed.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Wy20ynQf3ooRBMi0pDrJ" %}
[Optimizer Hints](/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Optimizer hints are options available that affect the execution plan.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/E1LL5lWnyGhvvW3CKMSW" %}
[Compression](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-tuning-compression.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Details how to apply data compression at various levels to reduce disk space and improve I/O efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/0bTfuCMxF1nuS6bUgVjn" %}
[Optimizing Data Structure](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-data-structure.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers schema design, data types, and normalization techniques to improve query efficiency and storage utilization.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/A9bkrvEIIEKJEOGJCGG3" %}
[Optimizing Tables](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers various techniques, including proper indexing, data types, and storage engine choices, to improve query speed and efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/YANgUjTZDMEOY843x5xL" %}
[Optimizing Queries](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Provides techniques for writing efficient SQL, understanding query execution plans, and leveraging indexes effectively to speed up your queries.
{% endcolumn %}
{% endcolumns %}

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

{% column %}
Optimize MariaDB Server with system variables, configuring various parameters to fine-tune performance, manage resources, and adapt the database to your specific workload requirements.
{% endcolumn %}
{% endcolumns %}