MySQL Forums
Forum List  »  Optimizer & Parser

Re: fast way to delete records?
Posted by: KimSeong Loh
Date: May 24, 2006 06:43PM

This is due to the table locking in MyISAM, the DELETE will write lock the whole table while it is deleting.

Maybe you can try to run the DELETE more often, so that each DELETE can complete in a shorter time.

Or, you can try INSERT DELAYED, so that the client doing the INSERT will not be blocked, but the data will be buffered to be inserted at a later time.

Another alternative is to try to change to InnoDB if you can, InnoDB has a row level locking that is able to provide concurrent insert and delete.

Options: ReplyQuote


Subject
Views
Written By
Posted
14197
ylu
May 23, 2006 03:35PM
Re: fast way to delete records?
6122
May 24, 2006 06:43PM
4478
June 08, 2006 12:30PM


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.