1 Can't create/write to file '/tmp/#sql_17bf_0.MYD' (Errcode: 17)

lxjtian

Registered
Apr 5, 2011
4
0
51
hello:

always happen this problem, How to resolve this complete?

when showing this erro, I login server with root, delete /tmp/#sql_17bf_0.MYD' , anything is fine after delete this file.
1 Can't create/write to file '/tmp/#sql_17bf_0.MYD' (Errcode: 17)
 

d_t

Well-Known Member
Sep 20, 2003
245
3
168
Bucharest
/tmp is usually mount as tmpfs and is limited in site (to shared memory size). If you have very big temporarely files in mysql you can move mysql temp to a distinct folder. Ex:
Code:
mkdir /var/tmpmysql/
chown mysql:mysql /var/tmpmysql/
edit /etc/my.cnf and add
Code:
tmpdir=/var/tmpmysql/
then restart mysql.