Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Aurora: FreeLocalSorage decreasing after every LOAD DATA FROM S3

0

I'm using 'TRUNCATE TABLE...' followed by 'LOAD DATA FROM S3...' on a nightly basis to replace Aurora MySQL database tables. This morning I was met with errors 'Error writing file /rdsdbdata/tmp/.... (Errcode: 28 - No space left on device)'. When I look at the FreeLocalStorage metric I see that it is decreasing at the same time every night but the free storage is never being replenished. Any clues as to how I can inspect/clear the temporary?? tables/data/cache in the local storage? Thanks

Topics
AnalyticsMigration & ModernizationDatabase
Tags
Amazon Relational Database Service
Language
English
asked 3 years ago554 views
1 Answer
0

Hi There

Quoting from this previous answer here:

The space which is being exhausted is the temp space which is used before data is written to the dynamic persistent storage. See here for temp space and instance type info. There is also some tips there what parameters you could tweak to use less temp storage....in the end it is possible some queries can exhaust memory (and therefore use temp space) and may need tuning into smaller queries. If the queries can't be tuned and you do not want to use a larger instance type you could consider standard mysql rds (not aurora) where you can provision the ebs used for temp space

AWS
EXPERT
answered 3 years ago
  • AWS-User-3715938
    3 years ago

    Thanks for the response. I have actually restored to a larger instance which has twice the amount of local storage however, if the same amount of free space continues to be exhausted every night eventually the free space will still run out - it'll just take a bit longer than on the previous instance.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content