Optimization and Tuning

Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.

Buffers, Caches and Threads

Covers essential configurations to maximize throughput and responsiveness for your database workloads.

MariaDB Internal Optimizations

Delves into how the database engine enhances query execution, data storage, and overall performance through its core architecture.

Operating System Optimizations

Covers configuring your OS for improved I/O, memory management, and network settings to maximize database efficiency.

Optimization and Indexes

Covers index types, creation, and best practices for leveraging them to significantly improve query performance and data retrieval speed.

Optimizer Hints

Optimizer hints are options available that affect the execution plan.

Compression

Details how to apply data compression at various levels to reduce disk space and improve I/O efficiency.

Optimizing Data Structure

Covers schema design, data types, and normalization techniques to improve query efficiency and storage utilization.

Optimizing Tables

Covers various techniques, including proper indexing, data types, and storage engine choices, to improve query speed and efficiency.

Optimizing Queries

Provides techniques for writing efficient SQL, understanding query execution plans, and leveraging indexes effectively to speed up your queries.

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.