有些region信息基本是空的,这些是什么region?

select * from INFORMATION_SCHEMA.TIKV_REGION_STATUS where DB_NAME is null limit 1G 
*************************** 1. row ***************************
       REGION_ID: 10382209
       START_KEY: 748000000000001CFF3C00000000000000F8
         END_KEY: 748000000000001CFF3E00000000000000F8
        TABLE_ID: NULL
         DB_NAME: NULL
      TABLE_NAME: NULL
        IS_INDEX: NULL
        INDEX_ID: NULL
      INDEX_NAME: NULL
  EPOCH_CONF_VER: 23
   EPOCH_VERSION: 7660
   WRITTEN_BYTES: 0
      READ_BYTES: 0
APPROXIMATE_SIZE: 1
APPROXIMATE_KEYS: 0

select DB_NAME,count(*) from INFORMATION_SCHEMA.TIKV_REGION_STATUS where APPROXIMATE_SIZE = 1 group by DB_NAME; 
+----------------------------+----------+
| DB_NAME                    | count(*) |
+----------------------------+----------+
| mysql                      |       30 |
| NULL                       |    35213 |


【 **TiDB 版本** 】
Release Version: v4.0.0-alpha-303-gf792e8d78-dirty
Git Commit Hash: f792e8d7879c13c5ee250c6242269527303369a2
Git Branch: master
UTC Build Time: 2019-09-19 11:41:53
GoVersion: go version go1.12 linux/amd64
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306

表删除

要等GC清理?

+--------------------------+------------------------------------------------------------------------------------------------------------------------+
| VARIABLE_NAME            | VARIABLE_VALUE                                                                                                         |
+--------------------------+------------------------------------------------------------------------------------------------------------------------+
| bootstrapped             | True                                                                                                                   |
| tidb_server_version      | 35                                                                                                                     |
| system_tz                | Asia/Shanghai                                                                                                          |
| tikv_gc_leader_uuid      | 5b5edc621640001                                                                                                        |
| tikv_gc_leader_desc      | host:localhost, pid:190407, start at 2019-09-29 13:15:01.0860662 +0800 CST m=+8.801254342 |
| tikv_gc_leader_lease     | 20190930-15:21:01 +0800                                                                                                |
| tikv_gc_run_interval     | 10m0s                                                                                                                  |
| tikv_gc_life_time        | 10m0s                                                                                                                  |
| tikv_gc_last_run_time    | 20190930-14:04:01 +0800                                                                                                |
| tikv_gc_safe_point       | 20190930-13:54:01 +0800                                                                                                |
| tikv_gc_concurrency      | 5                                                                                                                      |
| tikv_gc_enable           | true                                                                                                                   |
| tikv_gc_auto_concurrency | true                                                                                                                   |
| tikv_gc_mode             | distributed                                                                                                            |
+--------------------------+------------------------------------------------------------------------------------------------------------------------+

  • 得开 region merge,将这类 region 合并即可。