The Relationship Between Partition and Region Storage

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

Original topic: partition与region之间的关系存储

| username: llllllll

May I ask if it is possible to know the relationship between partition and region on the TiDB side, such as which regions are under a partition? Where is this information stored?

| username: Kongdom | Original post link

I remember someone mentioned that partitioned tables and tables are the same. You should be able to see it through show table t regions.

| username: llllllll | Original post link

However, for partitioned tables, the regions displayed by SHOW TABLE t REGIONS are not marked with which partition they belong to, so this question arises.

| username: llllllll | Original post link

Found the method in the code, thanks for the response :+1:

| username: Kongdom | Original post link

:+1: :+1: :+1:

| username: alfred | Original post link

It seems there is a syntax for viewing partition regions.

| username: system | Original post link

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