On Thursday, July 15, 2004, 9:10:43 AM, matt wrote: mr> Justin Swanhart wrote:
>>Indexes can generate vast amounts of random i/o. >>Because of rotational latency, random i/o can really >>slow you down, especially if you are using IDE or SATA >>disks because they can't do tagged queueing like SCSI >>disks can. >> >>If you have the budget for it, I would consider >>getting some solid state disks. Because they have >>extremely low latency you will be able to get full i/o >>bandwidth on your reads. If you can't afford those, >>consider adding more disks to your RAID array so that >>you can spread the reads over more spindles, which >>will help performance. mr> Using 8x72 gig 15,000 rpm U320 scsi drives in raid 5 now, that should be mr> a fast read raid config mr> no more will fit in the server, and solid state are 70,000 $ it's out of mr> our budget mr> I optimize the tables every weekened mr> any other sugestions? Consider moving to a raid 10 configuration + adding additional drives externally on alternate scsi chains. Consider additional ram. Consider replicating to some slave servers and dividing reads among them. Hope this helps, _M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
