MySQL Forums
Forum List  »  MySQL & Storage

One SCSI disk or RAID0 on two SATA disks
Posted by: Anders Anaka
Date: October 13, 2006 08:33AM

Our database servers are now days a bottleneck. System info: 2 Linux servers, replication structure (master=opteron, slave=xeon), 2 GB RAM/server, mysql, 6 databases (100 tables/database, size=6 GB for all databases).

During high traffic on the site the database servers get slow, queries take longer to execute. The tables are indexed, the servers uses caching etc, everything is optimized…

On high traffic the CPU usage is about 15-20 % on the database servers. Low I think…

So the problem must be the I/O to the disks on the servers. Which is best? To run RAID0(2 SATA disks, 7200 rpm) or one SCSI(73GB, 15000 rpm, 300 MB/s)(Know about the risks with RAID0)? Which results in the best performance regarding speed?

Also, which solution is best if we need more speed in the future…



Edited 1 time(s). Last edit at 10/13/2006 08:39AM by Anders Anaka.

Options: ReplyQuote


Subject
Written By
Posted
One SCSI disk or RAID0 on two SATA disks
October 13, 2006 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.