MySQL Forums
Forum List  »  Memory Storage Engine

disable locking on memory/heap table
Posted by: koos alberts
Date: January 05, 2011 06:40AM

I am wondering if it is possible to disable (internal) locking for (a) memory table. i have the following script that does the following tasks in sequential order

insert records into memory table with unique ID
update records into memory table with unique ID

I run like 40 instances of this script at the same time,

script 1 has a uniqe of '1', all then actions (insert and update) are only on records with that ID

script 2 has a uniqe of '2', all then actions (insert and update) are only on records with that ID

so although there are multiple actions going on in the table they are never on the same records.

So there is no reason at all to use locking because the same script instance never reads and updates the same records.

I did not find it in the documentation but does anybody know if it is possible ?

Options: ReplyQuote


Subject
Views
Written By
Posted
disable locking on memory/heap table
5392
January 05, 2011 06:40AM


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.