DBAtlas · Database operations atlas

1114: The table is full

MySQL

What does it mean?

No more data can be written to the table because a storage limit or the end of available space was reached.

Why does it happen?

Disk full, the max_heap_table_size limit reached for MEMORY tables, tmp_table_size exceeded for temporary tables, a fixed-size tablespace defined by innodb_data_file_path filling up, or file system/table-specific size limits.

How to fix it

First check and free disk space. For MEMORY/temp tables, increase max_heap_table_size and tmp_table_size. For InnoDB, make sure innodb_data_file_path is autoextend or add space. Optimize queries that spill large temporary results to disk. For a permanent fix, increase storage capacity.

Open in DBAtlas →

More from this engine