MySQL Performance: LAMP => Harddisks considerations for better MySQL performance

Harddisks considerations for better MySQL performance [message #343]

Fri, 10 November 2006 15:42

bitrockers
Messages: 11
Registered: November 2006
Location: Germany

Junior Member

Hi all,

currently we're planning to purchase new servers for our website. A rough overview of our mysql-scenario:

665 Mio rows, 25G data, and 55G index files.

Average of 400 queries per seconds, 15% inserts, 9% updates, 1% deletes, 75% selects (on one slave, we're running 4 slaves overall).

We've choosen DELL PowerEdge 2950 machines, 2x dual core Intels (Woodcrest) with 8 GB RAM.

From a performance point of view: What Do you think would be better?

a) 2 x 146 GB SAS 15krpm disks as RAID 1

b) 4 x 73 GB SAS 15krpm disks, where we would put the index files on one partition, and the data files on the other? Would we gain a performance increase from that ? I've read something about that in the docs, but didn't saw any benchmarkings about that ?

c) 5 x 73 GB SAS disks on a RAID 5 ( more spindles) ?

What do you think?

And what is your opinion about the processors? Should we stick to a one-processor server (e.g. instead of 2 x dual core xeon 2.3 GHz -> 1 x dual core xeon 1.6), and invest the money to more RAM? Would that be a better investment?

Greetings
Christian

Report message to a moderator