Updated on 2026-08-04 GMT+08:00

Overview

TaurusDB partitioned tables are fully compatible with the syntax and functions of MySQL Community Edition. Compared with MySQL Community Edition, TaurusDB provides more functions in terms of partitioned tables. It supports more partition types and combinations and allows you to use partitioned tables easily and efficiently.

Prerequisites

Supported Partition Types

TaurusDB is compatible with the following MySQL partition types:

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

Composite Partitioning

A composite partition comprises both partitions and subpartitions.

TaurusDB supports the following composite partition types:

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