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:
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

Options: ReplyQuote

Written By
November 10, 2012 12:33AM
Re: Error 126 Incorrect key file for table
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.