Skip navigation links

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.
Regards,
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 10832 Arthur Branham 10/04/2007 03:08PM
Re: row level locking 5725 KimSeong Loh 10/04/2007 07:20PM
Re: row level locking 6415 Arthur Branham 10/05/2007 07:20AM
Re: row level locking 6731 KimSeong Loh 10/11/2007 01:26AM
Re: row level locking 4559 Barrett Davis 07/29/2008 12:52PM
Re: row level locking 4597 Barrett Davis 08/19/2008 12:53PM
Re: row level locking 4767 Barrett Davis 09/08/2008 06:28PM
Re: row level locking 4483 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.