MySQL Forums
Forum List  »  Memory Storage Engine

Using Memory table as a cache for InnoDB table
Posted by: Ya Wi
Date: February 19, 2010 10:29AM

Hi all,
I'd like to know if somebody has already successfully implemented following concept :

- an InnoDB table stores some statistics about users ;
- to avoid a lot of updates on it, I maintain a similar memory table and execute update queries again this table instead of real one ;
-every X minutes, I update InnoDB data with Memory data (only 1 update).

I could save many updates on InnoDB table and some IO operations.
But I am afraid about table locking system of Memory table.

Many thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
Using Memory table as a cache for InnoDB table
7269
February 19, 2010 10:29AM


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.