3218
MariaDBERRORCommonServer / InnoDBMEDIUM confidence
Internal capacity exceeded
Production Risk
High — operation fails mid-execution.
Why it happens
- 1An internal MySQL capacity limit was reached during operation.
- 2Query or DML operation exceeded a hard resource threshold.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered by operations exceeding internal resource caps.
expected output
ERROR 3218 (HY000): Capacity exceeded.
Fix 1
Reduce query complexity or data volume
Reduce query complexity or data volume
-- Break the operation into smaller batches.
Why this works
Smaller operations stay within capacity limits.
Fix 2
Increase relevant server capacity variables
Increase relevant server capacity variables
-- Review and tune max_heap_table_size, tmp_table_size, etc.
Why this works
Raising limits may allow the operation to complete.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3218 ER_CAPACITY_EXCEEDED
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev