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 11561 Arthur Branham 10/04/2007 03:08PM
Re: row level locking 6211 KimSeong Loh 10/04/2007 07:20PM
Re: row level locking 6945 Arthur Branham 10/05/2007 07:20AM
Re: row level locking 7234 KimSeong Loh 10/11/2007 01:26AM
Re: row level locking 5042 Barrett Davis 07/29/2008 12:52PM
Re: row level locking 5487 Barrett Davis 08/19/2008 12:53PM
Re: row level locking 5691 Barrett Davis 09/08/2008 06:28PM
Re: row level locking 4935 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.