Advanced Configuration

Dive into advanced configurations for MariaDB Server performance. This section covers in-depth tuning parameters, optimization strategies, and best practices to maximize speed and efficiency.

Articles of how to setup your MariaDB optimally on different systems

Atomic Write Support

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.

Configuring Linux for MariaDB

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.

Configuring MariaDB for Optimal Performance

Complete MariaDB performance tuning: innodb_buffer_pool_size, aria_pagecache_buffer_size, thread_handling configuration, and SHOW GLOBAL STATUS monitoring.

Configuring Swappiness

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.

Fusion-io

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.

_{This page is licensed: CC BY-SA / Gnu FDL}