Re: 要把它換成 FreeBSD 嗎? (跑 mysql) - BBS

沒錯﹐除非你特別偏愛FreeBSD。就效能而言﹐MySQL在Linux上比在FreeBSD上好。
David.Xu正在改進FreeBSD的線程庫﹐可能會對此有幫助。
關於HTT﹐我做了個簡單的測試﹐使用同一台機器編譯kernel﹐明顯沒有HTT快﹕
compiling for up support in UP SYSTEM WITHOUT HTT SUPPORT:
--------------------------------------------------------------
>>> Kernel build for IDELITE completed on Sun May 22 21:25:31 CST 2005
--------------------------------------------------------------
575.559u 76.039s 18:42.56 58.0% 3702+1792k 665+652io 33pf+0w

compiling for smp support in UP SYSTEM WITHOUT HTT SUPPORT:
--------------------------------------------------------------
>>> Kernel build for IDELITE completed on Sun May 22 21:50:54 CST 2005
--------------------------------------------------------------
573.050u 76.472s 20:20.78 53.2% 3697+1787k 416+697io 2pf+0w

compiling for smp support in UP SYSTEM WITH HTT SUPPORT:
--------------------------------------------------------------
>>> Kernel build for IDELITE completed on Sun May 22 22:53:54 CST 2005
--------------------------------------------------------------
578.197u 95.691s 36:07.80 31.0% 3641+1762k 6710+660io 295pf+0w

compiling for up support in UP SYSTEM WITH HTT SUPPORT:
--------------------------------------------------------------
>>> Kernel build for IDELITE completed on Mon May 23 10:21:54 CST 2005
--------------------------------------------------------------
577.514u 98.323s 33:28.62 33.6% 3621+1754k 391+651io 2pf+0w
compiling for up support in UP SYSTEM WITHOUT HTT SUPPORT:
--------------------------------------------------------------
>>> Kernel build for IDELITE completed on Mon May 23 11:14:07 CST 2005
--------------------------------------------------------------
573.431u 72.600s 18:57.37 56.8% 3708+1795k 6671+691io 294pf+0w

※ 引述《[email protected] ()》之銘言：
: 所以建議暫時還是繼續給他跑 Linux 囉?
: ※ 引述《[email protected] (鯉魚)》之銘言：
: > hyperthread在FreeBSD效能低於UP的情況﹐建議禁用hyperthread。
: > MySQL的性能在FreeBSD下的效能低於Linux﹐這也是使用MySQL的SQL-BENCH測試
: > 過。
: > 以上所說的FreeBSD的版本是5.4-RELEASE。
: > MySQL版本是4.1.11。
: > FreeBSD4.x需要跑 linux treads﹐5.X不需要。

--