W3cubDocs

/MariaDB

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.

© 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/