MySQL Forums
Forum List  »  Quality Assurance

Re: What would cause a table to temporarily locked?
Posted by: Thomas CORBIERE
Date: October 04, 2007 12:43AM

Hello,

I'm not sure I really understand your problem,
but if it has to do with table locking you may try to convert
your table to the InnoDB storage engine (it will take some time for large table).

InnoDB support multi-versionning and row-level locking which may solve your problem.

Regards,

Thomas CORBIERE

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What would cause a table to temporarily locked?
2202
October 04, 2007 12:43AM


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.