Different ways to optimize tables and data on disk
| Title | Description |
|---|---|
| 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 |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/optimizing-tables/