6
Optimizing Tables
Need help tuning your MariaDB database? Ask the experts!
Contact UsDifferent ways to optimize tables and data on disk
-
OPTIMIZE TABLE
Reclaim unused space and defragment data. -
ANALYZE TABLE
Store key distributions for a table. -
Choosing the Right Storage Engine
Quickly choose the most suitable storage engine for your needs. -
Converting Tables from MyISAM to InnoDB
Issues when converting tables from MyISAM to InnoDB. -
Histogram-Based Statistics
Histogram-based statistics can improve the optimizer query plan in certain situations. -
Defragmenting InnoDB Tablespaces
MariaDB 10.1.1 introduced a feature to defragment InnoDB tablespaces. -
Entity-Attribute-Value Implementation
A common, poorly performing, design pattern (EAV); plus an alternative -
IP Range Table Performance
IP Range Table Performance Improvements
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
