Seeking advice on the relationship between table, partition, and region in TiDB

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 求教，tidb里面table,partition,region之间的对应关系

| username: llllllll

I would like to ask about the relationship between table, partition, and region in TiDB. Does one table correspond to multiple partitions? Is the relationship between partition and region one-to-one or one-to-many? Additionally, does partition come before or after region? Is region the smallest logical storage unit of a table, or are there other storage units?

2
| username: wink | Original post link

Partition and region can have a one-to-many or one-to-one relationship, depending on the size of the sharded data. If it exceeds the size of a region, the region will inevitably split.

A region is the smallest storage unit.

3
| username: llllllll | Original post link

Got it, thank you for your patient explanation. :heart:

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.