Resolved “Errcode: 28 - No space left on device”

kumkumsharma

Administrator
Staff member
Error:

MySQL: Error writing file '/rdsdbdata/tmp/MYZJySXi' (Errcode: 28 - No space left on device)

Solution:

If you are getting above error then it means there is no enough space in temp directory for MySQL.

So first you have to check the used space of \tmp partition with below command.

Code:
Df -h
If its using 100% of its space then you have to either clear /tmp folder or you can change different partition to MySQL config, so it can use different temp folder.
 
Top