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 合并即可。
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。