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.
Seen on:
MySQL
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 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.
Was this page helpful?
Report a correction or suggest an improvement
Last updated 2 Oct 2026