News for hackers. Stuff that matters.
Re:In-Memory caching: Why we can't just trust the database t... by thwarted on Wednesday November 12, 2008 @02:20AM (#361558)
I wonder how creating a raid1 device composed of a real block device and a ram disk would serve in this regard. Has anyone tested this?
Re:In-Memory caching: Why we can't just trust the database t... by ars on Wednesday November 12, 2008 @03:37AM (#361609)
It would be pointless. Just let linux cache the data and don't worry about it.

If you must, cat all your database tables to null (i.e. read all the data in them) a few times, then you'll be sure they are in memory.

If you used a ramdisk you'll be paying double: once for the data, and again for the cache.

Re:In-Memory caching: Why we can't just trust the database t... by thwarted on Sunday November 16, 2008 @02:35PM (#366212)
Raid1 idea was a suggestion of how to deal with system crashes, not to populate the buffer cache.