LINEAR KEY Partitioning Type
Syntax
LINEAR PARTITION BY KEY ([column_names]) [PARTITIONS (number_of_partitions)]
Description
LINEAR KEY partitioning is a form of partitioning, similar to KEY partitioning.
LINEAR KEY partitioning makes use of a powers-of-two algorithm, while KEY partitioning uses modulo arithmetic, to determine the partition number.
Adding, dropping, merging and splitting partitions is much faster than with the KEY partitioning type, however, data is less likely to be evenly distributed over the partitions.
Example
CREATE OR REPLACE TABLE t1 (v1 INT) PARTITION BY LINEAR KEY (v1) PARTITIONS 2;
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.