MySQL Forums :: Memory Storage Engine :: row level locking

Advanced Search

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

Subject Views Written By Posted
row level locking 11504 Arthur Branham 10/04/2007 03:08PM
Re: row level locking 6182 KimSeong Loh 10/04/2007 07:20PM
Re: row level locking 6902 Arthur Branham 10/05/2007 07:20AM
Re: row level locking 7194 KimSeong Loh 10/11/2007 01:26AM
Re: row level locking 5022 Barrett Davis 07/29/2008 12:52PM
Re: row level locking 5444 Barrett Davis 08/19/2008 12:53PM
Re: row level locking 5632 Barrett Davis 09/08/2008 06:28PM
Re: row level locking 4912 KimSeong Loh 09/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.