Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
On Monday 07 July 2003 15:18, Florian Weimer wrote:
 Konstantin Yotov [EMAIL PROTECTED] writes:
  2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache.
 
  We are going to uprade our server but I'am wondering
  between new Opteron (1.4GHz)and Xeon (2.4).

 Can't you get a machine for testing before you buy it?  Xeon
 processors aren't necessarily a significant win over Pentium 3s, even
 with the noticeable difference in clock speed.

But they are capable of more than 2-way...
Get yourself a quad Xeon-board, and start with two CPUs, adding more as you go 
along...

-- 
Andreas D. Landmark / noXtension


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread William R. Mussatto
 On Monday 07 July 2003 15:18, Florian Weimer wrote:
 Konstantin Yotov [EMAIL PROTECTED] writes:
  2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache.
 
  We are going to uprade our server but I'am wondering
  between new Opteron (1.4GHz)and Xeon (2.4).

 Can't you get a machine for testing before you buy it?  Xeon
 processors aren't necessarily a significant win over Pentium 3s, even
 with the noticeable difference in clock speed.

 But they are capable of more than 2-way...
 Get yourself a quad Xeon-board, and start with two CPUs, adding more as
 you go  along...

 --
 Andreas D. Landmark / noXtension


You mean they have solved the problem of having to used matched CPU's. 
Used to be that you had to throw out the old CPU's and get all new.

William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
On Thursday 10 July 2003 20:38, William R. Mussatto wrote:
  On Monday 07 July 2003 15:18, Florian Weimer wrote:
  Konstantin Yotov [EMAIL PROTECTED] writes:
   2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache.
  
   We are going to uprade our server but I'am wondering
   between new Opteron (1.4GHz)and Xeon (2.4).
 
  Can't you get a machine for testing before you buy it?  Xeon
  processors aren't necessarily a significant win over Pentium 3s, even
  with the noticeable difference in clock speed.
 
  But they are capable of more than 2-way...
  Get yourself a quad Xeon-board, and start with two CPUs, adding more as
  you go  along...
 
  --
  Andreas D. Landmark / noXtension

 You mean they have solved the problem of having to used matched CPU's.
 Used to be that you had to throw out the old CPU's and get all new.


Nope, but even with PPro (i guess the most flimsy CPU ever released) it's easy 
to get a set of four matched ones, even when buying them 2 and 2..

Xeons are easier to match than PPro, so it shouldn't be too hard. A lot of 
Xeonboards also support mixing cache-size (with differing success).

-- 
Andreas D. Landmark / noXtension


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Mysql - Dual Xeon or Dual Opteron

2003-07-07 Thread electroteque
yes i was very impressed with the benchmark on the opteron , frankly i rekon
the opterons are more optimised to a unix environment where xeons are more
optimised for a windoze environment, we just got a dual 2G zeon dell system
for a production box for a project which is doin full text searching on a
large database it seems to do ok in a linux environment under mysql4 , well
its very impressive very fast searches 4000 records in 1s but i havent
personally tried this system on a dual opteron system sadly

-Original Message-
From: Konstantin Yotov [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 9:35 PM
To: [EMAIL PROTECTED]
Subject: Mysql - Dual Xeon or Dual Opteron


Hello! :)

Our server is very heavy loaded:
CPUs states are in 0.0% idle almost all day.
Linux 7.3 running myslq 3.23.56 and apache 1.3.27 on
2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache.
Mysql have around 166 threads and perforn over 400
Queries per second.
We are going to uprade our server but I'am wondering
between new Opteron (1.4GHz)and Xeon (2.4).
We are going to choose Dual Xeon solutions but after
reading article about Opteron and Xeon performance
with Mysql and Linux
http://www.aceshardware.com/read.jsp?id=55000261,
where Opteron is 38% faster on query than Xeon, I am
very confused what to do.

If anybody can help with more information about this,
I would be very appriated.

Kosyo

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Mysql - Dual Xeon or Dual Opteron

2003-07-07 Thread Florian Weimer
Konstantin Yotov [EMAIL PROTECTED] writes:

 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache.

 We are going to uprade our server but I'am wondering
 between new Opteron (1.4GHz)and Xeon (2.4).

Can't you get a machine for testing before you buy it?  Xeon
processors aren't necessarily a significant win over Pentium 3s, even
with the noticeable difference in clock speed.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]