Evaluating a RAM disk as a MySQL data store
I have a situation with a relatively small set of MySQL data (5GB) and a decently large set of available ECC DDR2 memory (32GB). Therefore, I am evaluating storing the entire MySQL data directory on a ramdisk. Along those lines, here are some initial resources:
12 RAM Disk Software Benchmarked for Fastest Read and Write Speed • Raymond.CChttp://www.raymond.cc/blog/12-ram-disk-software-benchmarked-for-fastest-read-and-write-speed/Memory or RAM is much faster speed than a traditional hard drive. If you require to run a software that is database intensive, you would achieve a faster performance by placing the data into the RAM Disk. We have benchmarked 12 RAM disk software to find the fastest performing driver.
RAMDisk : High-performance RAM Disk for Windowshttp://www.softperfect.com/products/ramdisk/SoftPerfect RAM Disk is a free high-performance RAM disk application that lets you have a disk on your computer entirely stored in its memory. As the memory is much faster than physical hard disks,…
Of course there are drawbacks/risks associated with using volatile memory for data storage, however, with a little forethought those risks can be mitigated. 🙂