Optimizing Tables

Optimize tables for enhanced performance. This section covers various techniques, including proper indexing, data types, and storage engine choices, to improve query speed and efficiency.

OPTIMIZE TABLE

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

Defragmenting InnoDB Tablespaces

How to reclaim free space and defragment InnoDB tablespaces after deleting rows.

Entity-Attribute-Value Implementation

Implementing the entity-attribute-value (EAV) model in MariaDB, and its trade-offs.

IP Range Table Performance

Efficiently storing and querying large sets of non-overlapping ranges, such as IP address ranges.

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