前一陣子借測的Tyan S3892+2*Opteron 254(single core 2.8GHz,L2:1M)+2GB RAM(原先是8GB,不過RAM有問題換掉只剩2GB
),裝CentOS4.2 32/64bit版(kernel已update到v2.6.16.20,MySQL的config用my-large.cnf,另切512MB的RAM當RAM disk放DB),跑MySQL所附的benchmark結果如下給大家參考參考....
1:i386(see
http://220.130.4.238/RUN-mysql-Linux_2.6.16.20_i686-cmp)
2:X86-64(see
http://220.130.4.238/RUN-mysql-Linu...6.20_x86_64-cmp)
另附上鵝的SP2500(1.4GHz,L2:256K)+1GB RAM(RAM disk只切256MB)做對照組....
3:X86-64-SP2500(see
http://220.130.4.238/RUN-mysql-Linu...6_64-cmp-sp2500)
看來這個測試並沒真正用到multi thread(前兩項測試中CPU2有很大一部份時間是晾在一旁的
),而且單就CPU取得成本而言Opteron254和SP2500相差約1x倍,但效能比卻只略高於2800/1400,剩下的就只是Opteron support SMP了
....