3
Partitioning Tables
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 -
Information Schema PARTITIONS Table
Table partition information.
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.