Hi
at the moment this does not really matter to us.
we have even tried to create a temp table with only one field in
order to insert one row for testing, but we are currently not able to
create any temporary tables whatsoever as even the simplest form of
table still gives the same error.
Regards
On 09/10/2012 02:33 PM, Ananda Kumar wrote:
this temp table will hold how many rows, what would be its size.
On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail
<machiel.richa...@gmail.com <mailto:machiel.richa...@gmail.com>> wrote:
Hi,
We confirmed that the /tmp directory permissions is set to
rwxrwxrwxt and is owned by root , the same as all our other servers.
There is also about 60Gb of free space on the filesystem where
/tmp resides.
Regards
On 09/10/2012 01:11 PM, Rik Wasmus wrote:
the message "ERROR 1005 (HY000): Can't create table
'/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
Basics first:
1) Is the /tmp directory write & readable for the user mysql
runs as?
2) Has the /tmp directory enough free space?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
