Skip navigation links

MySQL Forums :: Memory Storage Engine :: Using Memory table as a cache for InnoDB table


Advanced Search

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 4400 Ya Wi 02/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.