randyboy <randyboy@stripped> wrote:
> Thanks for all the responses. However, I'm still wondering, in the heap
> method and in the stick-bit copy all into memory method, how does one
> maintain synchronicity between the db on disk and the copy in memory?
One solution using a ramdisk would be to spool update logs to the real
disk. On boot, start a mysql on the real disk's database, push the update
logs through that mysql, bring it back down, copy the real files to the
ramdisk, and then bring up mysql on the ramdisk tables. [Or, copy the real
files to the ramdisk, run the update log, copy the ramdisk files back out
to disk, and then let people start whacking the ramdisk version.
I once actually considered doing this as a cheap variant on using a
solid-state SCSI disk. Unfortunately, my performance concerns all related
to lots of data, and even a 4Gig ramdisk just wouldn't suffice.