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

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

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.