MySQL ERROR 1114 (HY000): The table 'x' is full
MySQL couldn’t extend the table — disk full, a size limit, or a MEMORY table hitting max_heap_table_size.
The table is full Meaning
Usually the disk (or the tmpdir) is out of space; for in-memory temporary tables, tmp_table_size/max_heap_table_size limits.
Common causes
- Disk or tmpdir full
- MEMORY table limit
- innodb_data_file_path autoextend disabled
⚡ Quick fix
- Free disk space (df -h)
- Raise tmp_table_size/max_heap_table_size
- Check tmpdir location
Detailed fix by platform
Linux
df -h /var/lib/mysql /tmp
How to diagnose
- Disk — Space left?
- Table — MEMORY or temp table?
🔧 Still not fixed?
Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:
Similar errors
Most viewed in MySQL
Other ways to find it
Where this error sits
Origin: Data. Errors that are often confused with or caused by this one (click to open):
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
💬 What worked for others
No tips yet — did something else fix this for you?
Share what worked for you
Tips are checked by an editor before they appear. Links are removed.
Report a correction or suggest an improvement
Last updated 10 Oct 2026