469,610 Members | 1,554 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Better performance, 1 Xeon 3ghz or 2 P3 1.3ghz?

Right now I run mysql and apache together on a dual p3 1.3ghz box. I
will be moving mysql to a second box, eather an identical dual p3 box
or spending a little more and going for a single Xeon 3Ghz (these are
the only two options I have). I'm thinking of hanging the db box
behind the webserver using a gigabit crossover.

Since I mostly read cached data, I'm leaning towards the dual CPU box
so that when I have a long running query thats hitting the disk, I
most likely will have other queries running on the other CPU reading
from the cache. Is this even what happens? Would the Xeon still be
faster?

Also, I read in the mySQL manual that I'll take a 8-10% hit in
performance when migrating to a second box over using a socket. Having
a dedicated box will allow me to tune mysql to take all the resources
and I assume increase its performance to at least recover the 8-10%,
is that a safe assumption?

I would like some input from wiser people than myself.

Mike
Jul 19 '05 #1
0 1275

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Christian Perthen | last post: by
13 posts views Thread by Shane Wright | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.