4 ms·
It essentially will be after everything's paged in. If you want to be sure though, create a RAM disk and stick your data files on there, though then you need t
by wayne 18y ago
It essentially will be after everything's paged in. If you want to be sure though, create a RAM disk and stick your data files on there, though then you need to deal with system crashes on your own.
- thwarted 18y agoI 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?
- ars 18y agoIt 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.
- thwarted 18y agoRaid1 idea was a suggestion of how to deal with system crashes, not to populate the buffer cache.