hi,
I am going to use the MySQL version 3.23.47 for as our database.
The issue is which table type to use.
I want that the database should be (memory-resident). I have tried with
the MyISAM tables which doesn't solves my purpose as in this case the
data are stored in the files.
I have also tried with the HEAP tables that uses a hashed index and are
stored in memory. This makes them very fast, but
if MySQL crashes I am loosing all data stored in that. As, I have
created one table as a heap type but when I make my server down and
start it again all rows created nowhere exists.
So, if anybody can suggest me any process by which I can populated HEAP
table(es) from a duplicate table(es) (which is on secondary storage) at
the time of startup. Also, any runtime modifications in the tables will
need to be updated in both the tables (one in memory and another one on
disk).
If any other method by which I can achieve the same.

Thanks and regards,
Chetan Lavti


 



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to