Re: row level locking
We have two submissions for this competition.
The first one provides row locking with a copy on write so that read threads are not blocked. The documentation of this submission is still in progress. It came with a prototype implementation, which is promising.
The second submission is a little out-of-the box and I wanted your opinions on it.
Instead of writing or rewriting the Memory Engine, this person specified that we take InnoDB and run it with a RAM implementation of the MySQL File I/O interface. Of course the logging would need to be turned off and the caching would need to be adjusted, but what do you people think? Has anyone had good success with InnoDB and a RAM disk?
Thanks for your time.
Regards,
Barrett Davis
Edited 1 time(s). Last edit at 09/08/2008 06:31PM by Barrett Davis.
Subject
Views
Written By
Posted
12120
October 04, 2007 03:08PM
6563
October 04, 2007 07:20PM
7369
October 05, 2007 07:20AM
7588
October 11, 2007 01:26AM
5443
July 29, 2008 12:52PM
5942
August 19, 2008 12:53PM
Re: row level locking
6208
September 08, 2008 06:28PM
5317
September 09, 2008 07:42PM
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.