List:General Discussion« Previous MessageNext Message »
From:JW Date:April 4 2002 6:26pm
Subject:More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


DN >In the last episode (Apr 04), JW said:
DN >Heh. plus the maintenence nightmare of managing 48 servers, 96 mirrored
DN >boot disks, 96 power supplies, etc etc..
DN >
DN >A comparable system to the Dell link you pasted is the Sun Fire v880.
DN >For $120k, you get 8x750mhz Ultrasparc III CPUs, 32GB of RAM, and 12
DN >36gb fibrechannel disks.  Those are 64-bit CPUs with 8MB of cache
DN >(compared to the 32bit Xeons w/2M you'd get with the Dell), and should
DN >easily outperform the Dell box.
DN >
DN >http://store.sun.com/catalog/doc/BrowsePage.jhtml?cid=71713

I was already looking at these... Does anyone have any experience with MySQL a v880?
Someone on another list was saying:

"ou've got to remember that in a lot of scenerios, more processors can
degrade preformance instead of enhancing it.  4 Dual processing machines
always beats one 8-way machine as far as network services related things
like File/Web/Print serving.  4-way machines can add benefit in fine-grain
tightly coupled processes like a heavily threaded DB server (like Oracle).
You start to loose I/O performance with most x86 architectures after 4-way."


What do ya'll say to that? Does MySQL performance really go down with more processors?

- -----------
filter bypass: query sql

- -- 

- ----------------------------------------------------
Jonathan Wilson
System Administrator
Clickpatrol.com
Cedar Creek Software     http://www.cedarcreeksoftware.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8rJrCW3F87Q8SQQARAhBJAKDZxvdJEZNFMi/+iEmerwSD/VENcwCfUlpT
5FeCpR8noGhFV/sQ/isp5KU=
=t1aj
-----END PGP SIGNATURE-----

Thread
Best hardware for a very large MySQL server? looking at x86JW4 Apr
  • Re: Best hardware for a very large MySQL server? looking at x86Tod Harter4 Apr
Re: Best hardware for a very large MySQL server? looking at x86JW4 Apr
  • Re: Best hardware for a very large MySQL server? looking at x86Dan Nelson4 Apr
    • More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86JW4 Apr
      • Re: More then 2-way SMP, process threading & Sun Fire v880: Re: Best hardware for a very large MySQL server? looking at x86Dan Nelson4 Apr