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

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 also

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 application. The

[PERFORM] Hardware spec

2007-09-06 Thread Willo van der Merwe
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 average load of ranging between

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

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 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 networking web

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,

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 swpd

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 sda8

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 opportunity to spec the hardware for a

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