MySQL Forums
Forum List  »  Memory Storage Engine

Re: row level locking
Posted by: Barrett Davis
Date: September 08, 2008 06:28PM

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.
Barrett Davis

Edited 1 time(s). Last edit at 09/08/2008 06:31PM by Barrett Davis.

Options: ReplyQuote

Written By
October 04, 2007 03:08PM
October 04, 2007 07:20PM
October 05, 2007 07:20AM
October 11, 2007 01:26AM
July 29, 2008 12:52PM
August 19, 2008 12:53PM
Re: row level locking
September 08, 2008 06:28PM
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.