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,
Subject
Views
Written By
Posted
Using Memory table as a cache for InnoDB table
7360
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.