Help Center/ TaurusDB/ kerneldesc/ Common Kernel Functions/ Enhanced Partitioned Tables/ Subpartitioning/ Overview
Updated on 2024-12-30 GMT+08:00
View PDF
Share

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.

TaurusDB is compatible with the following MySQL partition types:

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

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

Parent topic: Subpartitioning