为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:Release Version: v3.0.2
- 【问题描述】:1、2020-11-30 12:11:44 执行drop 大表后发现空间未回收
2、查看gc 如下
| tikv_gc_leader_uuid | 5bbe04616500008 |
| tikv_gc_leader_desc | host:tidb-pd3, pid:26129, start at 2019-12-12 11:05:28.223028091 +0800 CST m=+0.101313748 |
| tikv_gc_leader_lease | 20201130-17:03:29 +0800 |
| tikv_gc_run_interval | 10m0s |
| tikv_gc_life_time | 10m |
| tikv_gc_last_run_time | 20201130-12:28:30 +0800 |
| tikv_gc_safe_point | 20201130-12:18:30 +0800 |
| tikv_gc_concurrency | 3 |
| tikv_gc_enable | true |
| tikv_gc_auto_concurrency | true |
| tikv_gc_mode | distributed |
3、查看tidb 日志
[2020/11/30 12:10:31.080 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:11:31.046 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:12:30.353 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:13:30.256 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:14:30.364 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:15:30.362 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:16:30.324 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:16:37.566 +08:00] [INFO] [gc_worker.go:794] ["[gc worker] finish resolve locks"] [uuid=5bbe04616500008] [safePoint=421184533931491328] [regions=295093]
[2020/11/30 12:17:30.487 +08:00] [INFO] [gc_worker.go:246] ["[gc worker] there’s already a gc job running, skipped"] [“leaderTick on”=5bbe04616500008]
[2020/11/30 12:18:17.831 +08:00] [INFO] [gc_worker.go:582] ["[gc worker] start delete"] [uuid=5bbe04616500008] [ranges=0]
[2020/11/30 12:18:17.831 +08:00] [INFO] [gc_worker.go:601] ["[gc worker] finish delete ranges"] [uuid=5bbe04616500008] [“num of ranges”=0] [“cost time”=627ns]
[2020/11/30 12:18:18.131 +08:00] [INFO] [gc_worker.go:624] ["[gc worker] start redo-delete ranges"] [uuid=5bbe04616500008] [“num of ranges”=0]
[2020/11/30 12:18:18.131 +08:00] [INFO] [gc_worker.go:643] ["[gc worker] finish redo-delete ranges"] [uuid=5bbe04616500008] [“num of ranges”=0] [“cost time”=457ns]
[2020/11/30 12:18:18.978 +08:00] [INFO] [gc_worker.go:921] ["[gc worker] sent safe point to PD"] [uuid=5bbe04616500008] [“safe point”=421184533931491328]
[2020/11/30 12:18:31.679 +08:00] [INFO] [gc_worker.go:263] ["[gc worker] another gc job has just finished, skipped."] [“leaderTick on “=5bbe04616500008]
[2020/11/30 12:28:31.265 +08:00] [INFO] [gc_worker.go:277] [”[gc worker] starts the whole job”] [uuid=5bbe04616500008] [safePoint=421189362663292928] [concurrency=6]
[2020/11/30 12:28:31.265 +08:00] [INFO] [gc_worker.go:773] ["[gc worker] start resolve locks"] [uuid=5bbe04616500008] [safePoint=421189362663292928] [concurrency=6]
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出打印结果,请务必全选并复制粘贴上传。