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/