默认的参数是:
root@10.101.22.58 08:33:09>show config where name like ‘%tmp%’;
±-----±-------------------±--------------------±-------------------------------------------------------------+
| Type | Instance | Name | Value |
±-----±-------------------±--------------------±-------------------------------------------------------------+
| tidb | 10.101.22.20:4000 | oom-use-tmp-storage | true |
| tidb | 10.101.22.20:4000 | tmp-storage-path | /tmp/0_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage |
| tidb | 10.101.22.20:4000 | tmp-storage-quota | -1 |
| tidb | 10.101.22.195:4000 | oom-use-tmp-storage | true |
| tidb | 10.101.22.195:4000 | tmp-storage-path | /tmp/0_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage |
| tidb | 10.101.22.195:4000 | tmp-storage-quota | -1 |
| tidb | 10.101.22.58:4000 | oom-use-tmp-storage | true |
| tidb | 10.101.22.58:4000 | tmp-storage-path | /tmp/0_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage |
| tidb | 10.101.22.58:4000 | tmp-storage-quota | -1 |
±-----±-------------------±--------------------±-------------------------------------------------------------+
9 rows in set (0.02 sec)
修改成:
tmp-storage-path: /tmp
5.4.0 有生成空的record 文件夹,tidb 4.0.8没有
[root@titb-test-1 tmp-storage]# ls
_dir.lock record
[root@titb-test-1 tmp-storage]# du -sh *
0 _dir.lock
0 record