Re: upgrading, tuning and performance

2003-06-16 Thread Andy Stubbs
Disks are currently 36GB 10kRPM SCSI ultra3 with hardware RAID (PERC 3/DI onboard with 128MB cache) iostat for the DB disk partition is: avg-cpu: %user %nice%sys %idle 8.620.034.62 86.73 Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s avgrq-

Re: upgrading, tuning and performance

2003-06-16 Thread walt
Andy Stubbs wrote: > > Hi, long time listener, first time caller (I think), > > I've got a database which I'm looking to increase performance, either by > buying bigger kit or by somehow optimising current configuration. > > I'm running MySQL-Max-3.23.56-1 from the mysql.com RPMs on a Dell > Pow

Re: upgrading, tuning and performance

2003-06-16 Thread Nils Valentin
Hi Andy, You have many questions, most I cant answer,but upgradng from 3.23-xx to 4.xx will definitely give you a performance boost. I am running on siple boxes ( no replication etc.). So I am unable to say how much speed , but I strong believe that it will be enough to be realised immediately

upgrading, tuning and performance

2003-06-16 Thread Andy Stubbs
Hi, long time listener, first time caller (I think), I've got a database which I'm looking to increase performance, either by buying bigger kit or by somehow optimising current configuration. I'm running MySQL-Max-3.23.56-1 from the mysql.com RPMs on a Dell Poweredge 2500 with dual 1400MHz PIII