跳至内容

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

已提问 3 年前575 查看次数
1 回答
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
专家
已回答 3 年前
  • 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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。