【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 这串字符是怎么来的?