MySQL 8 Administrator???s Guide

Subpartitioning

Subpartitioning is also known as composite partitioning, and as the name suggests it is only a division of each partition into a partitioned table itself. See the following statement:

CREATE TABLE trs (trs_id INT, sold DATE)PARTITION BY RANGE ( YEAR(sold) )    SUBPARTITION BY HASH ( TO_DAYS(sold) )    SUBPARTITIONS 2 (        PARTITION p0 VALUES LESS THAN (1991),        PARTITION p1 VALUES LESS THAN (2001),        PARTITION p2 VALUES LESS THAN MAXVALUE);

As you can see in the preceding example statement, table trs has three RANGE partitions and each of the partitions p0, p1, p2 is further divided into two more subpartitions. Effectively, the entire table is divided into six partitions.

Subpartitioning is possible on tables partitioned using RANGE or ...