MySQL Forums
Forum List  »  Memory Storage Engine

Re: Write-through memory table
Posted by: Imre b
Date: October 05, 2007 02:03PM

We use some sort of write through functionality by the use of an timestamp.
A cronjob driven trigger deletes all entries older then 72 hours.
The same trigger imports new data. (in our case pager messages)

But the first action of this trigger is looking at the memory table, if empty there was a reboot, so it will be filled by an Mylsam table.

If there are new pager calls, is inserts the data in this disk based table, but also in the memory table. In this way the data is always backed up.

The users are acessing only the Memory(heap) table, flying fast!

This principle is only effective if there are no, or little update queries.

Excusses for my poor English.

Imre

Options: ReplyQuote


Subject
Views
Written By
Posted
9235
January 04, 2007 04:30AM
5911
January 10, 2007 05:24AM
5270
June 10, 2007 10:24AM
Re: Write-through memory table
5444
October 05, 2007 02:03PM


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.