sql error

hello ive just transferred my site due to the lack of support on the previous host. I started getting a sql error

Disk full (/dev/shm/#sql_10f11_3.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”) [1021]

My site is only small it was on the host side but because i didnt getting any assistance (there was a lot of these errors in the support forum) i decided to move host. My site is up and running but i still get this error only on the index all other pages are fine so wondered if theres any suggestions. Any help would be very appreciated.