A huge table can be split into smaller subsets. Both data and indexes are partitioned.
| Title | Description |
|---|---|
| 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 |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/partitioning-tables/