Archive for category 有的沒的
benchmarking with sysbench on X3650 M2
手邊剛好有x3650m2的機器
順手測了一下…FreeBSD 7.1 i386 & FreeBSD 8.0 AMD64
學Jeff Roberson弄一下..XD
就沒圖先看數據吧…
CPU: Intel(R) Xeon(R) CPU E5520 @ 2.27GHz (2266.76-MHz 686-class CPU)
real memory = 2137583616 (2038 MB)==>其實這台機器有12G, 不過i386只抓得到2G
avail memory = 2081353728 (1984 MB)
RAID 5 / 四顆 IBM 43W7538 146.8GB 10Krpm SAS
RAID controller MR10i
——————7.1 i386 ———————–
uname -a
FreeBSD ms1.xxx.xxx.xx 7.1-RELEASE-p9 FreeBSD 7.1-RELEASE-p9 #0: Tue Dec 15 15:53:44 CST 2009 root@xxx.xxx.xxx:/usr/obj/usr/src/sys/GENERIC i386
mysql-server-5.0.77
sysbench --test=oltp --num-threads=5 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 6075594
write: 0
other: 867942
total: 6943536
transactions: 433971 (7232.78 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 6075594 (101258.95 per sec.)
other operations: 867942 (14465.56 per sec.)
Test execution summary:
total time: 60.0006s
total number of events: 433971
total time taken by event execution: 293.7474
per-request statistics:
min: 0.47ms
avg: 0.68ms
max: 1.16ms
approx. 95 percentile: 0.79ms
Threads fairness:
events (avg/stddev): 86794.2000/4495.36
execution time (avg/stddev): 58.7495/0.10
sysbench --test=oltp --num-threads=10 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 9777810
write: 0
other: 1396830
total: 11174640
transactions: 698415 (11640.11 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 9777810 (162961.49 per sec.)
other operations: 1396830 (23280.21 per sec.)
Test execution summary:
total time: 60.0007s
total number of events: 698415
total time taken by event execution: 590.1649
per-request statistics:
min: 0.48ms
avg: 0.85ms
max: 205.14ms
approx. 95 percentile: 0.98ms
Threads fairness:
events (avg/stddev): 69841.5000/1335.06
execution time (avg/stddev): 59.0165/0.02
sysbench --test=oltp --num-threads=15 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 12752964
write: 0
other: 1821852
total: 14574816
transactions: 910926 (15181.88 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 12752964 (212546.30 per sec.)
other operations: 1821852 (30363.76 per sec.)
Test execution summary:
total time: 60.0009s
total number of events: 910926
total time taken by event execution: 886.4647
per-request statistics:
min: 0.56ms
avg: 0.97ms
max: 402.33ms
approx. 95 percentile: 1.01ms
Threads fairness:
events (avg/stddev): 60728.4000/606.53
execution time (avg/stddev): 59.0976/0.02
sysbench --test=oltp --num-threads=20 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 13327272
write: 0
other: 1903896
total: 15231168
transactions: 951948 (15865.47 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 13327272 (222116.62 per sec.)
other operations: 1903896 (31730.95 per sec.)
Test execution summary:
total time: 60.0012s
total number of events: 951948
total time taken by event execution: 1186.0876
per-request statistics:
min: 0.64ms
avg: 1.25ms
max: 994.84ms
approx. 95 percentile: 1.99ms
Threads fairness:
events (avg/stddev): 47597.4000/2590.43
execution time (avg/stddev): 59.3044/0.04
sysbench --test=oltp --num-threads=30 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 8234198
write: 0
other: 1176314
total: 9410512
transactions: 588157 (9802.05 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 8234198 (137228.77 per sec.)
other operations: 1176314 (19604.11 per sec.)
Test execution summary:
total time: 60.0034s
total number of events: 588157
total time taken by event execution: 1791.4983
per-request statistics:
min: 0.59ms
avg: 3.05ms
max: 1020.70ms
approx. 95 percentile: 7.91ms
Threads fairness:
events (avg/stddev): 19605.2333/3866.54
execution time (avg/stddev): 59.7166/0.06
sysbench --test=oltp --num-threads=40 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 6483008
write: 0
other: 926144
total: 7409152
transactions: 463072 (7717.23 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 6483008 (108041.20 per sec.)
other operations: 926144 (15434.46 per sec.)
Test execution summary:
total time: 60.0050s
total number of events: 463072
total time taken by event execution: 2393.3892
per-request statistics:
min: 0.62ms
avg: 5.17ms
max: 1218.90ms
approx. 95 percentile: 11.50ms
Threads fairness:
events (avg/stddev): 11576.8000/390.35
execution time (avg/stddev): 59.8347/0.02
——————-8.0 AMD 64—————————-
uname -a
mysql-server-5.1.41
FreeBSD ms2.xxx.xxx.xx 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:02:08 UTC 2009 root@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64
sysbench --test=oltp --num-threads=5 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 6130026
write: 0
other: 875718
total: 7005744
transactions: 437859 (7297.57 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 6130026 (102166.01 per sec.)
other operations: 875718 (14595.14 per sec.)
Test execution summary:
total time: 60.0006s
total number of events: 437859
total time taken by event execution: 296.7323
per-request statistics:
min: 0.51ms
avg: 0.68ms
max: 1.45ms
approx. 95 percentile: 0.77ms
Threads fairness:
events (avg/stddev): 87571.8000/2867.68
execution time (avg/stddev): 59.3465/0.03
sysbench --test=oltp --num-threads=10 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 9962218
write: 0
other: 1423174
total: 11385392
transactions: 711587 (11859.65 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 9962218 (166035.11 per sec.)
other operations: 1423174 (23719.30 per sec.)
Test execution summary:
total time: 60.0007s
total number of events: 711587
total time taken by event execution: 593.2102
per-request statistics:
min: 0.50ms
avg: 0.83ms
max: 2.41ms
approx. 95 percentile: 0.93ms
Threads fairness:
events (avg/stddev): 71158.7000/2261.35
execution time (avg/stddev): 59.3210/0.01
sysbench --test=oltp --num-threads=15 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 13259092
write: 0
other: 1894156
total: 15153248
transactions: 947078 (15784.37 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 13259092 (220981.20 per sec.)
other operations: 1894156 (31568.74 per sec.)
Test execution summary:
total time: 60.0010s
total number of events: 947078
total time taken by event execution: 889.9460
per-request statistics:
min: 0.63ms
avg: 0.94ms
max: 20.56ms
approx. 95 percentile: 1.06ms
Threads fairness:
events (avg/stddev): 63138.5333/1133.73
execution time (avg/stddev): 59.3297/0.01
sysbench --test=oltp --num-threads=20 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 13220214
write: 0
other: 1888602
total: 15108816
transactions: 944301 (15737.99 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 13220214 (220331.79 per sec.)
other operations: 1888602 (31475.97 per sec.)
Test execution summary:
total time: 60.0014s
total number of events: 944301
total time taken by event execution: 1190.1741
per-request statistics:
min: 0.74ms
avg: 1.26ms
max: 563.96ms
approx. 95 percentile: 1.87ms
Threads fairness:
events (avg/stddev): 47215.0500/2867.47
execution time (avg/stddev): 59.5087/0.03
sysbench --test=oltp --num-threads=30 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 13463828
write: 0
other: 1923404
total: 15387232
transactions: 961702 (16027.97 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 13463828 (224391.57 per sec.)
other operations: 1923404 (32055.94 per sec.)
Test execution summary:
total time: 60.0015s
total number of events: 961702
total time taken by event execution: 1789.5202
per-request statistics:
min: 0.81ms
avg: 1.86ms
max: 681.42ms
approx. 95 percentile: 2.84ms
Threads fairness:
events (avg/stddev): 32056.7333/2107.91
execution time (avg/stddev): 59.6507/0.03
sysbench --test=oltp --num-threads=40 --mysql-user=root --max-time=60 --mysql-db=test --max-requests=0 --oltp-read-only=on run
OLTP test statistics:
queries performed:
read: 12487580
write: 0
other: 1783940
total: 14271520
transactions: 891970 (14865.73 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 12487580 (208120.26 per sec.)
other operations: 1783940 (29731.47 per sec.)
Test execution summary:
total time: 60.0018s
total number of events: 891970
total time taken by event execution: 2390.2678
per-request statistics:
min: 0.89ms
avg: 2.68ms
max: 726.19ms
approx. 95 percentile: 3.32ms
Threads fairness:
events (avg/stddev): 22299.2500/1868.45
execution time (avg/stddev): 59.7567/0.02
vim on eclipse
http://www.viplugin.com/viplugin/
挺好用的…..
UPDATE: 2009/11/23
http://vrapper.sourceforge.net/home/
這個不用錢 !!!! 讚
show bom and fileencoding on vim statuline
這樣就看得到了…………..
一直覺得自已不會遇到BOM
不過最近遇到了 ….
~/.vimrc
set ls=2
set statusline=%<%f\ %h%m%r%=%{\"[\".(&fenc==\"\"?&enc:&fenc).((exists(\"+bomb\")\ &&\ &bomb)?\",B\":\"\").\"]\ \"}%k\ %-14.(%l,%c%V%)\ %P
highlight StatusLine ctermfg=blue ctermbg=black
Ref.
http://vim.wikia.com/wiki/Show_fileencoding_and_bomb_in_the_status_line
Couldn’t find ‘UniCNS-UCS2-H’ CMap file for ‘Adobe-CNS1′ collection
ok..
這是因為xpdf 在找對應的檔案 對應錯誤
裝完
/usr/ports/chinese/xpdf
後
會多了
/usr/local/share/xpdf/chinese-traditional
這個目錄
裡面的dot.xpdfrc設定不對…
請把
cMapDir Adobe-CNS1 /usr/local/share/fonts/adobe-cmaps toUnicodeDir /usr/local/share/fonts/adobe-cmaps
換成
cMapDir Adobe-CNS1 /usr/local/share/fonts/adobe-cmaps/ac15/CMap toUnicodeDir /usr/local/share/fonts/adobe-cmaps/ac15/CMap
這樣就對了……
豁然開朗~
最近 在弄 一些報價的事
才感受到 報價 其實不是這麼容易的一件事..(真的很欠學)
簡單來說就是quality, paperwork & differentiation
真的是挺重要的
感謝:
darkhero & 貓哥
FreeBSD Customized CD(Make your own release)
1 make buildworld
1.1 請先做cvsup 更新src(記得先裝cvsup-with-gui 等等會用到)
# cd /usr/ports/net/cvsup-without-gui; make install clean
1.2
# cd /usr/src; make buildworld
2 make release
2.1
# cp /usr/share/examples/cvsup/cvs-supfile /etc
2.2
# mkdir /home/ncvs /home/releng
2.3
# vi /etc/cvs-supfile *default host=cvsup.tw.FreeBSD.org *default prefix=/home/ncvs
2.4 csup 只能check，所以要裝cvsup
# cvsup /etc/cvs-supfile
2.5
# cd /usr/src/release;
2.6 開始做release
# make release RELEASETAG=RELENG_7_1 PORTSRELEASETAG=HEAD \ BUILDNAME=7.1-RELEASE-p3 CHROOTDIR=/home/releng \ CVSROOT=/home/ncvs NODOC=yes
指令說明：
RELEASETAG：
The CVS tag corresponding to the release that is to be built. If undefined, the release will be built from the HEAD of the CVS tree (a “-CURRENT snapshot”).，
PORTSRELEASETAG：
The CVS tag to use when checking out the ports tree. Usually, the head of the ports tree is used by default. If RELEASETAG specifies a release tag, then the associated release version is used as the default instead.
BUILDNAME：
The name of the release to be built. This is used to set the RELEASE value in sys/conf/newvers.sh, which affects the output of uname(1). If not set, a name with the timestamp and the “-SNAP” suffix will be generated.
CHROOTDIR：
The directory to be used as the chroot(8) environment for the entire release build. This file system should have at least 3.2 gigabytes of free space on the i386 architecture.
CVSROOT：
The location of the FreeBSD CVS repository. This path name is in reference to the real system root, not the root of the chroot(8) directory tree.
NODOC：
If defined, the SGML-based documentation from the FreeBSD Documentation Project will not be built. However, the “doc” distribution will still be created with the minimal documentation set providedin src/share/doc.
2.7 放入你想要額外用的檔案
# cp xxx.tgz /home/ releng/R/cdrom/dvd1/7.1-RELEASE-p3
3 加入install.cfg 至 mfsroot
3.1
# cd /home/releng/R/cdrom/dvd1/boot
3.2
# gunzip /home/releng/R/cdrom/dvd1/boot/mfsroot.gz
3.3
# mdconfig -a -t vnode -f /home/ releng/R/cdrom/dvd1/boot/mfsroot -u 0
3.4
# mount /dev/md0 /mnt
3.5
# cp /usr/src/usr.sbin/sysinstall/install.cfg /mnt
3.6
# vi /mnt/install.cfg (依照每台機器修改)
加入or修改以下資訊
# This is a sample installation configuration file for my test machine, # crate.cdrom.com. # It is included here merely as a sort-of-documented example. # # $FreeBSD: src/usr.sbin/sysinstall/install.cfg,v 1.12.6.1 2008/11/25 02:59:29 kensmith Exp $ # Turn on extra debugging. debug=yes ##partition 互動調整硬碟 diskInteractive=yes diskPartitionEditor ##label互動式調整硬碟 diskInteractive=yes diskLabelEditor ############################### # Select which distributions we want. 設定為最小安裝 ##dists=base doc manpages info src sbase ssys kernels GENERIC distSetMinimum # media 從CD-ROM安裝 mediaSetCDROM # OK, everything is set. Do it! installCommit #解壓 xxx.tgz command=touch /tmp/ok system
指令說明：
command 不能斷行，不然在跑指令的時後會有error
command在安裝時的debug輸出訊息會是這樣
setting variable ‘command=我們打的command的內容’
所以在command 須要用到引號的部份最好都用雙引號
3.7 製作ISO檔
sh /usr/src/release/i386/mkisoimages.sh -b FreeBSD7 /home/7.1-RELEASE-p3.iso /home/releng/R/cdrom/dvd1
3.8 參考資料
# man release
# man sysinstall
http://romana.now.ie/writing/customfreebsdiso.html
http://www.sfc.wide.ad.jp/~watari/FreeBSD/boot.html
http://www.bsdunix.ch/public/docu/freebsd_sysinstall.html
這個是寫滿久了….忙一直忘了放上來….
Review 即將離開的這份工作
1.
production & dev 的測試還是不夠..
常常在上線後會出現自已沒測到的bug ….Orz
(這部份還滿嚴重的，貓哥後來才和我說…他背後收到的抱怨實在不少…..，貓哥我對不起你 Orz…..)
這部份的原因，我有想過在以前工作為什麼不會，而在這邊常會這樣…
在之前的工作，公司的流程都是工程師開發完，PM 都會測過一遍，等PM confirm 才會上線，不過在這邊因為PM沒在測的….只有我自已測…常常會有盲點…(不是在推卸責任)，這部份我想到的解法是以後在開發寫程式的時後是不是能朝TDD(Test-Driven Development) 的方式去開發…
至少看能不能把unit test 做上去..這是未來在開發時的一個方向。
2.
在這份工作也學到了不少東西..
因為網站還算滿大的，常遇到以前所碰不到的問題
簡單來講Load balance , mysql tuning , mysql rep, memcached, blah blah ..
3.
和PM 關係搞的很緊張……..(這是我加速我離開的原因)
我的態度還是要再改進…..雖然就以前的工作來說，都沒發生過這種問題
不過畢近每個人都不一樣….要想辦法去和每一種人相處…
雖然他常在我背後靠北我…………..
我還是太淺了，個性還是有點衝….
4.
程式的部份JS的部份 還是很菜……
這部份還須要再加強….
5.
細心的程度還是太低………….
常常因為這樣造成了一些問題
上次最嚴重的就是….
因為在shutdown mysql 時，沒先把ap 給關掉
造成整個環境卡死…….
這一整個就是有白痴到………….
唉…………………….
ok …………………………
唉………………………….
頭很昏，沖個澡，繼續CHECK…………..