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
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.