SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_27a0_0.MYI' (Errcode: 28 - No space left on device)

Question

Can anyone help me to resolve this error on my magento website?

There has been an error processing your request

SQLSTATE[HY000]: General error: 1 Can't create/write to file
  '/tmp/#sql_27a0_0.MYI' (Errcode: 28 - No space left on device)

I have a dedicated server with Godaddy with 1TB of space.

My site is inaccessible.

olkuznw · Answer

Problem can be connected with inodes. Maybe you have too many small files and your inodes are full. You can check inode status with df -i.

Or it can be connected with /tmp folder. Please see this answer.

One Answer