# MySQL server has gone away: error 1114 (HY000) The table is full

- **ID:** `aws/rds-storage-full-read-only`
- **Domain:** aws
- **Category:** resource_error
- **Error Code:** `1114`
- **Verification:** ai_generated
- **Fix Rate:** 90%

## Root Cause

RDS instance storage volume is full, preventing write operations and causing MySQL to terminate connections abruptly.

## Version Compatibility

| Version | Status | Introduced | Deprecated |
|---------|--------|------------|------------|
| mysql-8.0.35 | active | — | — |
| aurora-mysql-3.05.0 | active | — | — |
| rds-2024 | active | — | — |

## Workarounds

1. **Increase the allocated storage for the RDS instance via AWS CLI: aws rds modify-db-instance --db-instance-identifier mydb --allocated-storage 200 --apply-immediately. Then wait for modification to complete.** (90% success)
   ```
   Increase the allocated storage for the RDS instance via AWS CLI: aws rds modify-db-instance --db-instance-identifier mydb --allocated-storage 200 --apply-immediately. Then wait for modification to complete.
   ```
2. **If using Aurora, enable storage autoscaling: aws rds modify-db-cluster --db-cluster-identifier mycluster --enable-http-endpoint --auto-minor-version-upgrade --storage-type aurora --allocated-storage 100 --max-allocated-storage 1000** (85% success)
   ```
   If using Aurora, enable storage autoscaling: aws rds modify-db-cluster --db-cluster-identifier mycluster --enable-http-endpoint --auto-minor-version-upgrade --storage-type aurora --allocated-storage 100 --max-allocated-storage 1000
   ```

## Dead Ends

- **** — 重启不会释放存储空间，写入操作会立即再次失败。 (95% fail)
- **** — 删除索引只能释放少量空间，且可能影响查询性能，不足以解决存储满的问题。 (70% fail)