Help Center/ GaussDB(for MySQL)/ Kernels/ Common Kernel Functions/ Enhanced Partitioned Tables/ Subpartitioning/ Overview
Updated on 2024-09-06 GMT+08:00
View PDF
Share

Overview

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

GaussDB(for MySQL) 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.

GaussDB(for MySQL) 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