Errcode: 28 - No space left on device

[Anonymous]

I have a big quiery and I cannot get data or refresh data since:

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

What should I do?

Thanks

[v-yingjl · Accepted solution]

Hi @Anonymous ,

The error means that you dont have enough space to create temp files needed by MySQL.

You can use df -h to check whether \tmp is in its own partition, and how much space is allocated to it.

If it is in its own partition and short of space, you can either:

• modify /tmp so that its parition has more space (either by reallocating or moving it to the main partition - e.g. see here)
• changing MySql config so that it uses a different temp folder on a different partition, e.g. /var/tmp

You can refer this simliar issue: MySQL/Writing file error (Errcode 28) 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[pranit828]

HI @Anonymous 

What is your RAM size. your systems disc space is maxing out. Either you have to clean your temp folder or increase your memory size.

I don't like losing data but the last resort for me will be to import required columns and filter the rows based on the requirement(Dates, project, type etc...)

[Fowmy]

@Anonymous 

I think this is a duplicated question, please keep one. I answered in the first question thread:
https://community.powerbi.com/t5/Power-Query/Errcode-28-No-space-left-on-device/m-p/1317038#M41674

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[UlisesEspinoza]

Those answers imply people are using Linux OS. So are useless to Windows or iOS users.

[Anonymous]

Yes I saw this.

But I did not understand here what should I do to make this:

"Step 1 - Login to your server using SSH, you can use Putty "

I downloaded Putty... I don't see here what should I do

and then where should I enter the commands?