How to Handle Full Disk in DDL Path

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

Original topic: ddl路径磁盘满了如何处理

| username: l940399478

The disk at /tmp/tidb/tmp_ddl-4001 is full, causing the DDL to fail. How should this be handled in such a situation? Can the contents in this path be directly deleted?

| username: 大飞哥online | Original post link

rm -rf /tmp/tidb/tmp_ddl-4001/*
It can be deleted.

| username: 大飞哥online | Original post link

Deleting files in the temporary directory may interrupt or fail ongoing DDL operations. Therefore, before performing the deletion, please ensure that there are no important DDL operations in progress.

| username: xingzhenxiang | Original post link

Why is there no automatic cleanup mechanism?

| username: zhanggame1 | Original post link

It is recommended to shut down this TiDB service before performing DDL.

| username: l940399478 | Original post link

Deleted, how do I modify this path address? The current path is too small.

| username: h5n1 | Original post link

The default value of tidb_enable_async_commit is OFF, which means that the async commit feature is not enabled by default. You need to manually set it to ON to enable this feature.

| username: 大飞哥online | Original post link

This is temporary. It will appear when running DDL, and it will be cleaned up after completion. Unless an exception occurs or it is killed while running, it will not be cleaned up.

| username: 小龙虾爱大龙虾 | Original post link

DDL should revert to the old version of the txn mode after a fast reorg failure, right? Have you noticed this?

| username: 路在何chu | Original post link

Exception failed, will not clean up.

| username: TiDBer_CQ | Original post link

In environments with large amounts of data, it’s best to make some modifications. I’ve suffered losses here!

| username: 随缘天空 | Original post link

You can delete it, but it’s best to back it up first.

| username: TI表弟 | Original post link

Bro, aren’t you doing monitoring?

| username: dba远航 | Original post link

It can be deleted.

| username: oceanzhang | Original post link

I prefer to use the tidb data path for the tmp path, otherwise, it can easily clog the system unless your system has enough space.

| username: xingzhenxiang | Original post link

I asked how big this path needs to be, but no one can give a clear answer. Can someone from the official team clarify?

| username: 普罗米修斯 | Original post link

The official recommendation for large object DDLs is to use an independent file system and temporary space. TiDB generally recommends 100GB+, without specifying an upper limit, so it still depends on the business needs.

| username: andone | Original post link

By default, it will be cleaned up automatically, but exceptions will not.

| username: system | Original post link

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