PolarDB:Overview

PolarDB for MySQL is compatible with MySQL partition types of hash, range, list, range-hash, and list-hash. PolarDB 8.0.2.2.0 and later support composite partitions and more partition types. This topic describes the composite partition types supported in PolarDB for MySQL and the usage of these types.

A composite partition comprises both partitions and subpartitions. PolarDB for MySQL 8.0.2.2.0 and later support the following composite partition types:

• RANGE-RANGE
• RANGE-LIST
• LIST-RANGE
• LIST-LIST
• HASH-HASH
• HASH-KEY
• HASH-RANGE
• HASH-LIST
• KEY-HASH
• KEY-KEY
• KEY-RANGE
• KEY-LIST
• LIST DEFAULT HASH