MySQL Forums
Forum List  »  Newbie

Re: Question about merging big tables?
Posted by: H Lee
Date: March 17, 2009 09:59AM

I just found the above error was not from the merging tables but from another SQL right after the merging:

DELETE FROM `my_final_table` WHERE `filed_1` is null;

there are 341 NULL field_1 in about 3,500,000 records and the error is:

ERROR 1206 (HY000) at line 94: The total number of locks exceeds the lock table size

Is there any fix for this issue??? many thanks,

Hao

Options: ReplyQuote


Subject
Written By
Posted
March 16, 2009 12:49PM
Re: Question about merging big tables?
March 17, 2009 09:59AM


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.