Error inserting into temporary table: the table is full

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

Original topic: 临时表插入报错the table is full

| username: Kongdom

[Test Environment for TiDB]
[TiDB Version] 5.7.25-TiDB-v7.1.0
[Reproduction Path] Insert a large amount of data into a temporary table
[Encountered Problem: Problem Description and Impact]
Error message: The table ‘xxx’ is full

| username: Miracle | Original post link

Is it possible that the disk space is insufficient?

| username: Kongdom | Original post link

Found it, this parameter was limiting it. Increasing it solved the issue.

| username: Fly-bird | Original post link

Mark it: tidb_tmp_table_max_size

| username: Kongdom | Original post link

Yes, it’s this parameter.

| username: zhanggame1 | Original post link

I feel that this default value is too small.

| username: Kongdom | Original post link

The expected use case might be short and quick, with rapid usage and rapid disposal. :thinking:

| username: 路在何chu | Original post link

The same error occurs when MySQL temporary tables are insufficient. It’s all the same.

| username: Kongdom | Original post link

MySQL also has limitations? I haven’t encountered any so far. What is the threshold for MySQL?

| username: 路在何chu | Original post link

MySQL Bugs: #99100: GROUP BY will throw table is full when temptable memory allocation exceed limit, just adjust the parameters.

| username: Kongdom | Original post link

:call_me_hand: :call_me_hand: :call_me_hand: Thank you

| username: Kongdom | Original post link

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