Will the data in the DDL_JOBS table of TiDB be deleted periodically?

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

Original topic: TiDB的DDL_JOBS表中的数据是否会定期删除?

| username: TIDB救我狗命

Will the data in the DDL_JOBS table of TiDB be deleted periodically?

| username: wuxiangdong | Original post link

This can’t be right.

| username: ShawnYan | Original post link

This question is essentially asking whether there are regular cleanup tasks for DDL_JOBS and what the storage data limit for DDL_JOBS is.

| username: ShawnYan | Original post link

The ddl_jobs was introduced by this PR. It seems that there is no cleanup and row limit, and it includes all DDLs.

| username: alfred | Original post link

Will it be retained permanently?

| username: TIDB救我狗命 | Original post link

Yes, we need to perform regular cleanup tasks ourselves, right?

| username: TIDB救我狗命 | Original post link

Is there a possibility of data explosion? It feels like the amount of data in DDL is too large. Will irregular cleaning cause problems?

| username: cs58_dba | Original post link

As long as the table is created, it can be backed up and cleaned up regularly.

| username: TIDB救我狗命 | Original post link

Understood!

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.