Re: [Virtuoso-users] Needed perfect settings for machine with 32gb ram

2009-10-22 Thread Ivan Mikhailov
Hi Armin, For Linux without accurate tweaks of kernel behavior, it's safer to limit memory for buffers even more, say, 1/2. That is due to noticeable consumption of memory by internal OS buffering. In addition, I should warn you that SSD's lifetime under any database application can be smaller th

Re: [Virtuoso-users] Needed perfect settings for machine with 32gb ram

2009-10-22 Thread Hugh Williams
Hi Armin, But all your system memory ie 32GB will not be available as the system itself and any other processes running on the machine will also require memory to function. In the Virtuoso performance docs it is recommended NumberOffBuffers be set 2/3 to 3/5 of system RAM: http:

[Virtuoso-users] Needed perfect settings for machine with 32gb ram

2009-10-22 Thread Armin Nagel
Hi folks, are there any limitations in numbuffers in virtuoso? I have a machine with 32gb RAM and 8 Cpu cores. 120GB SSD HDD and running 64Bit Suse Linux. I installed Virtuoso OS 5.0.11. My calculation for numbuffers is: 30(gb ram) *1024(in mbyte) *1024(in kbyte) = 31457280K / 8K = 3932160 numb