MySQL Forums
Forum List  »  Memory Storage Engine

Re: Error 126 Incorrect key file for table
Posted by: Rick James
Date: November 11, 2012 10:42AM

Change it in my.ini:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_tmpdir
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_tmpdir
If you change the my.ini value, it will take effect when you restart mysql.

But... Is that the real problem? What query were you performing? Did it involve a "temporary" table? Perhaps an ALTER or CREATE statement?

Since you are in the MEMORY forum, I assume you have ENGINE=MEMORY ? I can't see how error 126 would apply, but I will make another guess... The MEMORY table you are trying to build has index(es) and is rather large. If so, you probably need a bigger value for max_heap_table_size
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_heap_table_size

Options: ReplyQuote


Subject
Views
Written By
Posted
6149
November 10, 2012 12:33AM
Re: Error 126 Incorrect key file for table
2566
November 11, 2012 10:42AM


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.