Amazon RDS MySQL tmpdir location

Question

We are facing a strange problem. We are running a Magento based store. In our admin, when we try to see orders, we are getting the error:

SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/rdsdbdata/tmp/#sql_20b_0.MYI'; try to repair it

After lot of research, I found that tmp folder has run out of space.

I executed the command: show variables like '%tmpdir%'

And the value of folder was: /rdsdbdata/tmp

I ssh into my server and executed: df -h

This returned:

/dev/xvda1  mounted on  /

tmpfs   mounted on  /dev/shm

/dev/xvdb  mounted on  /mnt/data

But I could not find the location: /rdsdbdata/tmp anywhere

So I'm not able to clear memory.

enter image description here

Answer 1

I ssh into my server

Not really. Your database is on an RDS instance, which can't be accessed over SSH. You must have ssh'ed into your web server, instead.

RDS provides you with a managed server with MySQL -- and nothing else -- running on it. It's not the machine where you were looking. You can't perform any administration on the underlying server. Everything -- including increasing the amount of allocated storage -- is done through the AWS console or API.

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.MySQL.html