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?
Subject
Views
Written By
Posted
how to avoid lock table, wait online
4765
September 05, 2005 03:41AM
2925
September 05, 2005 04:29AM
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.