Too Much to Be Deleted by GC

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: GC要删除的太多

| username: TiDBer_bOR8eMEn

[TiDB Usage Environment] Production Environment
[TiDB Version]
[Reproduction Path] What operations were performed when the problem occurred
image
What’s the situation here, is there any solution?

2
| username: DBAER | Original post link

Check if the GC is progressing normally?

3
| username: TiDBer_bOR8eMEn | Original post link

GC is abnormal.

4
| username: TiDBer_bOR8eMEn | Original post link

image
image1155×47 3.47 KB

5
| username: tidb菜鸟一只 | Original post link
  1. Temporary solution: You can disable gc.enable-compaction-filter and restart the cluster.
  2. Permanent solution: Upgrade the TiDB cluster version for a permanent fix.
6
| username: TiDBer_bOR8eMEn | Original post link

How can I check if GC is functioning normally after turning it off?

7
| username: 扬仔_tidb | Original post link

The default GC cycle is 10 minutes. Has this been changed? Is it set too long?

8
| username: TiDBer_bOR8eMEn | Original post link

How can I check the GC modification cycle?

9
| username: 扬仔_tidb | Original post link

False GcWorkerTooBusy caused by incorrect scheduled_tasks · Issue #11903 · tikv/tikv · GitHub, it seems that there is such a bug in the lower version.
Can you take a screenshot of the tikv-detail/gc panel in Grafana?

10
| username: TiDBer_bOR8eMEn | Original post link

The image is not visible. Please provide the text you need translated.

11
| username: TiDBer_bOR8eMEn | Original post link

Hello, after closing, it still hasn’t decreased.

12
| username: 扬仔_tidb | Original post link

Isn’t it supposed to be enabled?
Also, if the GC recovers more data, should the time window be extended? Has there been any change on the business side? Looking at Grafana, it seems that the GC delay started increasing at a certain point in time.

13
| username: zhanggame1 | Original post link

How much data did you delete, and what is the GC interval?

14
| username: zhh_912 | Original post link

Modification cycle

15
| username: 小于同学 | Original post link

Upgrade the version.

16
| username: TiDBer_bOR8eMEn | Original post link

Not upgrading for now.

17
| username: TiDBer_bOR8eMEn | Original post link

What do you mean by “cycle”? I followed the above classmate’s suggestion to disable gc.enable-compaction-filter, but it still hasn’t reduced.

18
| username: TiDBer_bOR8eMEn | Original post link

It is deleted every day. It feels like the accumulated GC interval is the default 10 minutes.

19
| username: shigp_TIDBER | Original post link

The default GC is 10 seconds. Check if it has been modified. If not, it is possible that the GC time is deleting too many objects.

20
| username: TiDBer_bOR8eMEn | Original post link

Mine is 10 minutes.