List:General Discussion« Previous MessageNext Message »
From:bruce Date:February 25 2012 2:27am
Subject:exclusive write lock for innodb tbl
View as plain text  

trying to get my head around how to create an exclusive read/write lock for
a tblA. tblA is updated by a parent process.

the test system then has multiple children who on a 1st come basis attempt
to read the 1st "unread" row.

something like::

  parentApp >>>> (writes/updates)>>> tblA
childA   ---->>>>>---------------------------------^
childB   ---->>>>>---------------------------------^
childC   ---->>>>>---------------------------------^

so when childA reads, childB/childC need to wait, so they can't read the
same row as childA. childA updates the tblA row with a uniqueID so the
other tbls don't read the row, after childA releases the tblA...

as i understand it, this should be doable using innodb, but none of the
articles i've seen describe how to accomplish this.

the "shared mode" refers to the write process

the exclusive mode might be useful, but i seem to be missing something..

thoughts on this would be useful.


exclusive write lock for innodb tblbruce25 Feb
  • Re: exclusive write lock for innodb tblKaren Abgarian25 Feb