Re: Please help with configuration

2006-07-13 Thread Daniel Castro
Simon, My server is just for sapdb.So i think it is a good confguration. Best Regards, On 7/13/06, Simon Matter <[EMAIL PROTECTED]> wrote: > Hi Simon, > > Thank you for your attention.I really appreciate your pacience. > > 1) If it will not make it go faster why should I do it? I did this con

Re: Please help with configuration

2006-07-13 Thread Simon Matter
> Hi Simon, > > Thank you for your attention.I really appreciate your pacience. > > 1) If it will not make it go faster why should I do it? I did this config > because I thought that the server should not use swap memory because disk > memory is slower than ram. We all think that our servers sould

Re: Please help with configuration

2006-07-13 Thread Daniel Castro
Hi, I am using 54% of swap area. Can you look at the first message that I sent and evaluate the vmstat output? See, there is no big deal about it. Best regards, On 7/13/06, Jean-Michel OLTRA <[EMAIL PROTECTED]> wrote: bonjour, Le jeudi 13 juillet 2006, Simon Matter a écrit... > 1)

Re: Please help with configuration

2006-07-13 Thread Daniel Castro
Hi Simon, Thank you for your attention.I really appreciate your pacience. 1) If it will not make it go faster why should I do it? I did this config because I thought that the server should not use swap memory because disk memory is slower than ram. 2) My cache_size confg (75% of memory) is not

Re: Please help with configuration

2006-07-13 Thread Jean-Michel OLTRA
bonjour, Le jeudi 13 juillet 2006, Simon Matter a écrit... > 1) It's a good idea to have at least as much swap space than real memory. > I suggest to increase swap to 1-2G in your case. (of course this won't > make your db faster). No, not for this amount of physical memory. It was the ca

Re: Please help with configuration

2006-07-12 Thread Simon Matter
> Simon, > > Memory usage: > total used free sharedbuffers cached > Mem: 1009995 14 0 11168 > -/+ buffers/cache:815194 > Swap: 517294223 1) It's a good idea to have at le

Re: Please help with configuration

2006-07-12 Thread Daniel Castro
Simon, Memory usage: total used free sharedbuffers cached Mem: 1009995 14 0 11168 -/+ buffers/cache:815194 Swap: 517294223 I changed the maxcpu parameter to 1. Lets see

Re: Please help with configuration

2006-07-12 Thread Simon Matter
>> MAXCPU is already with value 2. >> cat /proc/cpuinfo | grep "processor" | wc -l returns 2 processors. You get 2 processors but you also get that with 1 CPU and HT enabled. If you have only 1 single core CPU, set MAYCPU to 1, really. BTW, how is your real memory usage? It looks a bit high for

Re: Please help with configuration

2006-07-12 Thread Daniel Castro
MAXCPU is already with value 2. cat /proc/cpuinfo | grep "processor" | wc -l returns 2 processors. Best regards,

Re: Please help with configuration

2006-07-12 Thread dan
Daniel, Set MAXCPU to the total number of processor cores you have, e.g. single processor/single core MAXCPU=1, single processor/dual core MAXCPU=2, dual processor/single core MAXCPU=2. Hyperthreading does not count as a core. Daniel Quoting Daniel Castro <[EMAIL PROTECTED]>: > Hi guys, > > I

Please help with configuration

2006-07-12 Thread Daniel Castro
Hi guys, I have a 1Gb Server RAM, with a lot of disc free space (92Gb) : processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping: 3 cpu MHz : 3200.787 cache size : 2048 KB physical i