System and Status Variables

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

Big Query Settings

Settings and features aimed at big queries, several of which are disabled by default.

Handling Too Many Connections

How to handle and avoid the 'too many connections' error on busy servers.

MariaDB Optimization for MySQL Users

MariaDB optimization options and defaults that differ from MySQL, for users migrating from MySQL.

Optimizing key_buffer_size

Tuning key_buffer_size for servers with mostly MyISAM tables.

Optimizing table_open_cache

Tuning table_open_cache to balance performance against open-file usage.

OQGRAPH System and Status Variables

System and status variables for the OQGRAPH storage engine.

Sample my.cnf Files

Sample my.cnf configuration files for different memory sizes and storage engines.

Segmented Key Cache

Segmented key caches, which split the MyISAM key cache into structures to reduce contention.

Semisynchronous Replication Plugin Status Variables

Status variables for the semisynchronous replication plugin.

InnoDB Server Status Variables

InnoDB server status variables, viewable with SHOW STATUS.

Setting Innodb Buffer Pool Size Dynamically

How to resize the InnoDB buffer pool dynamically, in chunks.

Sphinx Status Variables

Status variables for the Sphinx storage engine.

Spider Status Variables

Status variables for the Spider storage engine.

SQL Error Log System Variables and Options

System variables and options for the SQL Error Log plugin.

SSL/TLS Status Variables

Status variables related to TLS/SSL-encrypted connections.

System and Status Variables Added By Major Release

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.