> 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/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations.md).

# Advanced Configuration

Articles of how to setup your MariaDB optimally on different systems

{% columns %}
{% column %}
{% content-ref url="/pages/GiMy5TJHkFKDaS9wGfb6" %}
[Atomic Write Support](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/atomic-write-support.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains the concept of atomic writes in MariaDB, which improve performance and data integrity on SSDs by bypassing the InnoDB doublewrite buffer, supported on devices like Fusion-io and Shannon SSDs.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/aQTHdbZUSgyw8MjE2PbN" %}
[Configuring Linux for MariaDB](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-linux-for-mariadb.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Guidance on tuning Linux kernel settings for MariaDB performance, including I/O schedulers (using `none` or `mq-deadline`), open file limits, and core file sizes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ae7GlSkGQnzgoja8cNQy" %}
[Configuring MariaDB for Optimal Performance](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-mariadb-for-optimal-performance.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete MariaDB performance tuning: innodb\_buffer\_pool\_size, aria\_pagecache\_buffer\_size, thread\_handling configuration, and SHOW GLOBAL STATUS monitoring.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9VksM9lKkOqi1fiySz8G" %}
[Configuring Swappiness](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/configuring-swappiness.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Recommendations for setting the Linux `vm.swappiness` kernel parameter (ideally to 1) to prevent the OS from swapping out MariaDB memory pages, which degrades performance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/BoV96feBkADK24wfhN9J" %}
[Fusion-io](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/mariadb-performance-advanced-configurations/fusion-io.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Introduction to using Fusion-io flash memory cards with MariaDB to significantly boost I/O throughput and reduce latency, including benefits like atomic write support.
{% endcolumn %}
{% endcolumns %}