MySQL Forums
Forum List  »  Memory Storage Engine

MEMORY Storage Engine Integrity questions
Posted by: Bhavik Chauhan
Date: December 21, 2006 01:19AM

I have basic questions regarding MEMORY Storage Engine.

Considering that one table TABLE_XYZ having 250K records loaded in MEMORY when server S1 is starting up from back end DB SERVER.
Questions:-
1. if we modify any record in the table TABLE_XYZ, how is it written in DB SERVER?
2. Considering updation synch up complexity, can we execute more than 200 update query in a sec?
3. is there any mechanism of checkpointing by which periodically and asynchronously written to the on-disk as it presents in Oracle TimesTen ?

I could not make out from MySql 5.0 Manual, as it doesn't state it explicitly..

Thanks,
Bhavik



Edited 2 time(s). Last edit at 12/21/2006 08:40AM by Bhavik Chauhan.

Options: ReplyQuote


Subject
Views
Written By
Posted
MEMORY Storage Engine Integrity questions
5784
December 21, 2006 01:19AM


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.