Saltar al contenido

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

preguntada hace 3 años575 visualizaciones
1 Respuesta
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
EXPERTO
respondido hace 3 años
  • 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.

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.