Partitioning Types
You are viewing an old version of this category. View
the current version here.
This is the main Knowledgebase category for MariaDB.
Follow any of the links below to find information on the topics you are interested in. If you would like to know more about anything that isn't documented, ask a question at the place where the answers should be and we will do our best to provide an answer for it!
-
Partitioning Types Overview
A partition type determines how a partitioned table rows are distributed across partitions -
LIST Partitioning Type
LIST partitioning is used to assign each partition a list of values -
RANGE Partitioning Type
The RANGE partitioning type is used to assign each partition a range of values. -
HASH Partitioning Type
Form of partitioning in which the server takes care of the partition in which to place the data. -
KEY Partitioning Type
Used to have the server assign the distribution of rows across partitions. -
LINEAR HASH Partitioning Type
Form of partitioning, similar to HASH, in which the server takes care of th... -
LINEAR KEY Partitioning Type
Form of partitioning similar to KEY partitioning. -
RANGE COLUMNS and LIST COLUMNS Partitioning Types
Used to assign each partition a range or a list of values
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.