Comments - ANALYZE TABLE, Error writing file '/tmp/MYdOeJgz' (Errcode: 28 "No space left on device")
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi, did you manage to solve this?
You created table as innodb and you have enough space (so your configuration in `/etc/my.cnf` related to innodb have nothing to do with this), but creating the temporary files (maybe?) fails to write a table for engine-independent table statistics (EITS) that happens to be a MyISAM table (according to the error you are receiving `/tmp/MYdOeJgz`).
What is your `/dev/...` ? Are you sure `/tmp/` is on the right place and did you manage to mount it on the right place? Can you please provide the option file you are using?
Im having the same problem now.
Im running on a vps with 40GB of disk space, and my table has 15 million rows.
To me it seems like my /tmp would
Hints on how to solve it would be appreciated.