MySQL Forums
Forum List  »  MyISAM

how to avoid lock table, wait online
Posted by: liusz
Date: September 05, 2005 03:41AM

pls give me some advice.

I am using mysql to write a little thing. Two process operate on a same table, one just do insert again and again, each insert operation can take 2 or more seconds( thousands of records ),then sleep one second; another process run per 20seconds,read from this table , do some compute,then delete records have been processed, each process takes more than 8 seconds or even .

what terrible is this two process conflict while one do insert while another do delete, table is locked,so take much long time. How can I avoid locked table?

Options: ReplyQuote


Subject
Views
Written By
Posted
how to avoid lock table, wait online
4765
September 05, 2005 03:41AM
2442
September 05, 2005 01:20PM
2142
September 06, 2005 02:57AM


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.