MySQL Forums
Forum List  »  Memory Storage Engine

Re: Using Memory table as cache in HIGH WRITE environment
Posted by: Ingo Strüwing
Date: January 02, 2007 11:39AM

Hi.

Since the updates on a memory table should be very fast, the locks are taken for a very short time only. I won't expect that they become a bottleneck. But I must admit that I don't have any experiences with applications like this.

If they do indeed become a bottleneck, you could try to use a transactional engine that uses row level locks, like InnoDB. But I guess that the overhead will outweigh the improvements in locking.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using Memory table as cache in HIGH WRITE environment
7498
January 02, 2007 11:39AM


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.