Re: [PERFORM] Hardware spec

2007-09-12 Thread Claus Guttesen
> > Get yourself the ability to benchmark your application. This is > > invaluable^W a requirement for any kind of performance tuning. > > > I'm pretty happy with the performance of the database at this stage. > Correct me if I'm wrong, but AFAIK a load of 3.5 on a quad is not > overloading it. It

Re: [PERFORM] Hardware spec

2007-09-12 Thread Willo van der Merwe
Decibel! wrote: On Thu, Sep 06, 2007 at 11:26:46AM +0200, Willo van der Merwe wrote: Richard Huxton wrote: Willo van der Merwe wrote: Hi guys, I'm have the rare opportunity to spec the hardware for a new database server. It's going to replace an older one, driving a social netw

Re: [PERFORM] Hardware spec

2007-09-11 Thread Decibel!
On Thu, Sep 06, 2007 at 11:26:46AM +0200, Willo van der Merwe wrote: > Richard Huxton wrote: > >Willo van der Merwe wrote: > >>Hi guys, > >> > >>I'm have the rare opportunity to spec the hardware for a new database > >>server. It's going to replace an older one, driving a social networking > >>web

Re: [PERFORM] Hardware spec

2007-09-06 Thread Willo van der Merwe
Florian Weimer wrote: You need to run "vmstat 10" (for ten-second averages) and report a couple of lines. procs ---memory-- ---swap-- -io --system-- cpu r b swpd free buff cache si sobibo incs us sy id wa 1 0 61732 47388 27908 343

Re: [PERFORM] Hardware spec]

2007-09-06 Thread Jean-David Beyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Willo van der Merwe wrote: > Jean-David Beyer wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Willo van der Merwe wrote: >> >>> Richard Huxton wrote: >>> Willo van der Merwe wrote: > Hi guys, > > I'm have the rare

Re: [PERFORM] Hardware spec

2007-09-06 Thread Florian Weimer
* Willo van der Merwe: > Florian Weimer wrote: >> You need to run "vmstat 10" (for ten-second averages) and report a >> couple of lines. > 2 80 1 > 5 0 61732 37052 28180 34319560014 987 2320 2021 38 > sda3 3.30 0.0026.40 0264 > sd

Re: [PERFORM] Hardware spec

2007-09-06 Thread Florian Weimer
* Willo van der Merwe: > Good advice. After running a vmstat and iostat, it is clear, to my > mind anyway, that the most likely bottleneck is IO, next is probably > some more RAM. > Here's the output: > procs ---memory-- ---swap-- -io --system-- > cpu > r b swp

Re: [PERFORM] Hardware spec

2007-09-06 Thread Willo van der Merwe
Jean-David Beyer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Willo van der Merwe wrote: Richard Huxton wrote: Willo van der Merwe wrote: Hi guys, I'm have the rare opportunity to spec the hardware for a new database server. It's going to replace an older one, driving

Re: [PERFORM] Hardware spec

2007-09-06 Thread Jean-David Beyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Willo van der Merwe wrote: > Richard Huxton wrote: >> Willo van der Merwe wrote: >>> Hi guys, >>> >>> I'm have the rare opportunity to spec the hardware for a new database >>> server. It's going to replace an older one, driving a social >>> networkin

Re: [PERFORM] Hardware spec

2007-09-06 Thread Willo van der Merwe
Richard Huxton wrote: Willo van der Merwe wrote: Hi guys, I'm have the rare opportunity to spec the hardware for a new database server. It's going to replace an older one, driving a social networking web application. The current server (a quad opteron with 4Gb of RAM and 80Gb fast SCSI RAID10)

Re: [PERFORM] Hardware spec

2007-09-06 Thread Richard Huxton
Willo van der Merwe wrote: Hi guys, I'm have the rare opportunity to spec the hardware for a new database server. It's going to replace an older one, driving a social networking web application. The current server (a quad opteron with 4Gb of RAM and 80Gb fast SCSI RAID10) is coping with an avera