A huge table can be split into smaller subsets. Both data and indexes are partitioned.
- Partitioning Overview — A table partitioning overview
- Partitioning Types — A partitioning type determines how a table rows are distributed across partitions.
- Partition Pruning and Selection — Partition pruning is when the optimizer knows which partitions are relevant for the query
- Partition Maintenance — For time series (includes list of PARTITION uses)
- Partitioning Limitations — Limitations applying to partitioning in MariaDB.
- Partitions Files — A partitioned table is stored in multiple files
- Partitions Metadata — How to obtain information about partitions definition