【TiDB 版本】:5.2.1
表共享region:


t_test_4和t_test_5表的基本信息:
mysql> select TABLE_NAME,tidb_table_id from information_schema.tables where table_name in ('t_test_4','t_test_2','t_test_5');
+------------+---------------+
| TABLE_NAME | tidb_table_id |
+------------+---------------+
| t_test_2   |            81 |
| t_test_4   |            85 |
| t_test_5   |            87 |
+------------+---------------+
3 rows in set (0.02 sec)
mysql> show create table t_test_4 \G
*************************** 1. row ***************************
       Table: t_test_4
Create Table: CREATE TABLE `t_test_4` (
  `id` bigint(20) NOT NULL /*T![auto_rand] AUTO_RANDOM(5) */,
  `name` varchar(200) DEFAULT '',
  `honor` varchar(200) DEFAULT '',
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin /*T![auto_rand_base] AUTO_RANDOM_BASE=1421743 */
1 row in set (0.00 sec)
mysql> show create table t_test_5 \G
*************************** 1. row ***************************
       Table: t_test_5
Create Table: CREATE TABLE `t_test_5` (
  `id` bigint(20) NOT NULL /*T![auto_rand] AUTO_RANDOM(5) */,
  `name` varchar(200) DEFAULT '',
  `honor` varchar(200) DEFAULT '',
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin /*T![auto_rand_base] AUTO_RANDOM_BASE=15130858 */
1 row in set (0.00 sec)
mysql> select min(id),max(id) from t_test_5;
+---------+---------------------+
| min(id) | max(id)             |
+---------+---------------------+
| 8110001 | 8935141660717874064 |
+---------+---------------------+
1 row in set (0.04 sec)
mysql> select min(id),max(id) from t_test_4;
+---------------------+---------------------+
| min(id)             | max(id)             |
+---------------------+---------------------+
| 3170534137668835185 | 7493989779944511344 |
+---------------------+---------------------+
1 row in set (0.01 sec)
查看t_test_4的region信息:
mysql> show table t_test_4 regions;
+-----------+----------------------------+----------------------------+-----------+-----------------+---------------------+------------+---------------+------------+----------------------+------------------+
| REGION_ID | START_KEY                  | END_KEY                    | LEADER_ID | LEADER_STORE_ID | PEERS               | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS |
+-----------+----------------------------+----------------------------+-----------+-----------------+---------------------+------------+---------------+------------+----------------------+------------------+
|     40029 | t_81_5f72fc00000005bf764b  | t_85_r_3170534137669207230 |     40031 |               4 | 40030, 40031, 40032 |          0 |             0 |          0 |                   97 |           547491 |
|     40066 | t_85_r_3170534137669207230 | t_85_r_7407520667098997812 |     40067 |               5 | 40067, 40068, 40069 |          0 |             0 |          0 |                   40 |           224300 |
|      1141 | t_85_r_7407520667098997812 | t_87_5f728400000000272b86  |      1144 |               4 | 1143, 1144, 1687    |          0 |          1453 |          0 |                  100 |           560750 |
+-----------+----------------------------+----------------------------+-----------+-----------------+---------------------+------------+---------------+------------+----------------------+------------------+
3 rows in set (0.00 sec)
验证数据:
mysql> SELECT START_KEY, TIDB_DECODE_KEY(START_KEY),end_key,TIDB_DECODE_KEY(end_key) FROM information_schema.tikv_region_status WHERE table_name='t_test_4' AND REGION_ID=1141 \G
*************************** 1. row ***************************
                 START_KEY: 7480000000000000FF555F72E6CCCCCCCCFFCCE4340000000000FA
TIDB_DECODE_KEY(START_KEY): {"_tidb_rowid":7407520667098997812,"table_id":"85"}
                   end_key: 7480000000000000FF575F728400000000FF272B860000000000FA
  TIDB_DECODE_KEY(end_key): {"_tidb_rowid":288230376154278790,"table_id":"87"}
1 row in set (0.01 sec)
mysql> select * from t_test_5 where id=288230376154278790;
+--------------------+-------------------------------------------------------------+----------------------------------------------------------------------+
| id                 | name                                                        | honor                                                                |
+--------------------+-------------------------------------------------------------+----------------------------------------------------------------------+
| 288230376154278790 | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy |
+--------------------+-------------------------------------------------------------+----------------------------------------------------------------------+
1 row in set (0.01 sec)
发现region_id为1141(t_test_4、t_test_5两个表共享)的region是t_87_5f728400000000272b86,而非正常显示的t_{tableid}r{rowid}.
问题:
1)请问为什么表共享的region endkey表示方式不一样,想标识什么或者区分什么呢?
2) endkey:t_87_5f728400000000272b86  中 5f728400000000272b86 这串字符是怎么来的?

