MySQL returned error

Error Description :

Error No : 1
Description : Can't create/write to file '/tmp/#sql-temptable-138055-35ad8c-4fa.MAI' (Errcode: 28 "No space left on device")

SQL Query
SELECT `product`.* FROM `product` WHERE id!=0 ORDER BY RAND() LIMIT 4