Re: fast way to delete records?
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.
Subject
Views
Written By
Posted
14197
May 23, 2006 03:35PM
6708
May 24, 2006 07:29AM
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.