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