What I would like to do/have is:
Some kind of application/driver that creates a RAM drive/partition that is actually assigned a drive letter (eg. D:). This drive letter should be based on/mirroring a specific directory of a physical directory (eg. C:\MyDBData).
On startup of the application/driver, I would expect the application/driver to read all files in the directory into memory and locking them to prevent writes to those files by other applications. All files are then available on the RAM drive. Each read action can then be done from memory, which I guess would be a major performance boost.. Any writes should be done "write-through" to the physical directory, or maybe with buffer of max 1 second. (So in case of power-loss, losses would be minimal.)
Of course this application/driver would need some RAM of its own, and will create some slight overhead on CPU load. Still, I expect a major performance boost.
What I would like to use it for is:
In order to speed up my 5 GB MySQL DB, I would like to move all tables to my 8 GB RAM.
And even though MySQL does support memory-tables, the limitations are keeping me of achieving this. For example, text/blob fields are not allowed in heap tables.
It's still a guess to me whether 8 GB RAM is enough for a 5 GB RAM drive, the overhead of the mentioned application/driver, the mysqld itsself and the rest of the OS. But I can consider upgrading to 12GB or even 16 GB RAM.
My question is
I assume this technique already exists. What is it called, and where can I find a good implementation of it? (Preferably open source, for Windows)
And even though tips on Mysql vs memory are welcome, and maybe this idea I have isn't the best way to approach the Mysql problem, I would still like to explore the question I have of directory-to-RAM.
EDIT: What I just read in a similar question is that this is called Filesystem Caching, and is present in most modern OS'. But if that is the way to go, how do I instruct my OS to increase the Filesystem Cache, and to specifically keep an entire 5GB directory in that cache at all times?