Partitioning Tables
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 |
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/partitioning-tables/