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.
Using 8x72 gig 15,000 rpm U320 scsi drives in raid 5 now, that should be a fast read raid config
no more will fit in the server, and solid state are 70,000 $ it's out of our budget
I optimize the tables every weekened
any other sugestions?
Would it help to defrag? The only way I can do it, is backup every file, wipe out the server, and then restore the files, there's not enough free space to do a proper defrag
Matt
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
