On Sat, 2016-01-23 at 09:27 -0600, Robert Nichols wrote:
On 01/22/2016 11:02 AM, Ed Heron wrote:
I'm still running CentOS 5 with Xen.
We recently replaced a virtual host system board with an Intel S1400FP4, so the host went from a 4 core Xeon with 32G RAM to a 6 core Xeon with 48G RAM, max 96G. The drives are SSD.
I was recently asked to move an InterBase server from Windows 7 to Windows Server. The database is 30G.
I'm speculating that if I put the database on a 35G virtual disk and mirror it to a 35G RAM disk, the speed of database access might improve.
If that were running under Linux rather than Windows I'd suggest just giving that extra 35GB to its kernel and letting its normal caching keep everything in RAM. Whether Windows (7 or Server) would be clever enough to do that is another question. Of course you could just let the Linux host do the caching, but that runs the risk of other VMs or host activity displacing some of that cache and affecting the performance of your database VM.
Yes... You've got much of my thought process.
The RAM disk mirror pre-loads the database into memory and forces it to stay in RAM.