Re: Error Code: 3. Error writing file (Errcode: 28)
http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_tmpdir
says "Dynamic: no". So look for /etc/my.cnf, add a line (in [mysqld] section):
tmpdir = /... (some suitable place)
and restart mysql
Or... find the query that is blowing out tmpdir and change it. Show us the SELECT, the output from EXPLAIN SELECT..., and SHOW CREATE TABLE; we can probably advise you on a way to rewrite the query to avoid such a large temp table.
Subject
Written By
Posted
Re: Error Code: 3. Error writing file (Errcode: 28)
May 03, 2014 10:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.