??? ???TPC?tpmC?
1 TPC
TPC(Transaction Processing Performance Council??????????)???10????????????????????????????????????????????????????????TPC?????????????????????????? ????????????(Benchmark)?????????????????? ???????
TPC?????????????????(http://www.tpc.org)?TPC????????????????????????(Standard Specification)??????????????????????????????(?????????)?????????????????(?????)?????TPC???????(Full Disclosure Report)??????????????????????????????? ????????TPC????????(TPC???????)???????????????????
TPC???????????????TPC?A?TPC?B?TPC?C?TPC?D???A?B???????????TPC?C???????(OLTP)??????TPC?D?????(Decision Support) ??????TPC???TPC?E???????(Enterprise)??????????
2 tpmC
tpmC??????? ????????????????????????tpmC????????? ??????????????????????????????????? ?tpmC???????????tpmC??????????TPM?TPMC?
TPC-C?????????????????????N??????????10???????????3000?????????????10?????????????????????10×N???????????????5????????????????????????????????????????????????? ????N?????????????????N???????????
TPC-C?????????????????TPC-C?????????tpmC?tpm?transactions per minute????C?TPC??C???????????????????????????????????????????????1???????4??? ?????1??????????????????????45???????? ??????1000tpmC???????????????2000???????? ?????????????????????????÷???????/tpmC?
tpmC??: TPC-C????????TPC-C????????????????????????12???
???????????/????/?????
??? TPCC
1 ????
TPCC????????C/S???,??????????????????,????????????TPC?Transaction Processing Corp???,TPC??????????
TPCC???????????????TPCC?????????????,???tpm,(transactions per minute)????????(?????)??TPCC?,????????????,?????????,?????????
??????,TPC-C?????C/S???????,???????????????????,????,??????????????????TPCC?,?????????????TPC?????????????????,??????????TPC???
—————————————————————————————————————
2 ????????
TPC-C
?????????????????????TPC???????TPC-C?TPC-H?TPC-W??????????????????????????????????????????TPC?????????????????????????????????????????????????????????????????
??????TPC???????????????????????????????????????????????????????????????
TPC-C??????????????OLTP?????????????????????????????????????????????????????????????????IT?????TPC-C????“??”OLTP???????????
TPC-C?????????????????????????????tpmC?????????????????????????????????????????????????????????????????????????????????????????????????TPC????????????????????????TPC Web??(http://www.tpc.org)????
3 TPC-C????
TPC-C??????????????OLTP???????????????????????????
TPC-C??????????????????????OLTP????:??????????????????????????????????????10?????????????3000???????????????????10???;??????1%????????????????????????????????
????????????????
New-Order??????????????
Payment:????????????????;
Delivery:??(???????);
Order-Status:????????????
Stock-Level:??????????????????
??????????????????5??????????????????????20????
4????
TPC-C?????????????1992?7?????????OLTP???????????????????TPC-C???????????????????????????????
TPC-C?????????????
?????(Throughput???tpmC)
??TPC????????????????Payment?Order-status?Delivery?Stock-Level???????????????????New-Order????????????????TPC-C????????
??????????
????(Price/Performance???Price/tpmC)
?????????????????????????
????????
????TPCC????????????????
????????????????????????????????????????“?????”?????“????”???????????????????????????????????????????????“????”?????????????????5???????????????????????????????????????????????????????????????????????????????????????????????
1???????? ????
?????????????????????????????(???????????)??? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
2???????????
????????????????????????????????????????????? ?????????????R/3?????????SAP????????????????????????????????????????????????????????????????????????????????????
3????????
???1???2???????????TPC-C???????????????????????? ??tpmC???????????????????
??????????????
???????????????????????????????????????(????????????)????TPC?C??????????????????????????????????1????????????????1????????tpmC????????????
?TPC?????
TPC??????????????????????????????????????“??”???????(????RAID)??????????????????????? ???????????????????????TPC???????????????????1/4???????????????????1/3?????TPC?C??????????180????????????????????????????tpmC???????????????????????TPC??????????????????????????tpmC???????????????????????????
?????????? ????????????????????1GB????50GB??????A?B?C ?????????????tpmC????3000?2800?2600??????????A???????????????????tpmC??????????????????????tpmC?????C??????????????????? ????????tpmC?????????????????
?TPC?????
TPC?C?TPC?D??????????????????????????????????????????????????????????????????TPC?C??? ?????????????????????????????TPC????? ???????????????????????????????????? ??????????????????????????????????????
?????????? ??(??????)?????????????????
??????????????????????????????????
?????????????????????????????????????????????????????????????????????????????????????
“????”?????????????????????????????????????????????????????????????????????????????????
?????????????????????TPC???????TPC-C?TPC-H?TPC-W??????????????????????????????????????????TPC?????????????????????????????????????????????????????????????????
??????TPC???????????????????????????????????????????????????????????????
TPC-C??????????????OLTP?????????????????????????????????????????????????????????????????IT?????TPC-C????“??”OLTP???????????
TPC-C?????????????????????????????tpmC?????????????????????????????????????????????????????????????????????????????????????????????????TPC????????????????????????TPC Web??(http://www.tpc.org)????
??? TPCC????
1??
???TPC-C??SPECjbb2000??????????????????????????????????????????????????????????????????????????????????????????????
???????????????????????????????????????????
1? ?????????????????????????????????????????????????????????????????????CPU????
2? ???????????????????
????????????????????????????????????????????????????????????????????
1? ?????????????????????????????????????????????????????????????????
2? ?????????????????????????????2???????????????????????????????????????????????????????????????
3? WEB???????????????????????????
2??????????
??1
?????????????????????
” ??????????1500??U1??
” ???????????2??????N1??
” ?????????????????????1/3?
” ??????????3????T1??
” ??????????8????T2??
” ??????????13????T3??
” ??????????????5??
” ?????1.6?(??????)
” ???????30?????
????????????
TPC-C=U1*N1*?T1+T2+T3?/3*5*????/????
???????????????
TPC-C= 1500*2*?3+8+13?/3*5*1.6/0.7= 274,285 tpmC
??????????????????????????????????????????????????????TPC-C????28????????????
??2
????????????????????????????????????????
?????1?????????????????????????1??????????????????
1. ????????????5?????????220,000 ????????????????????????????????;
2. ???????=220000/22=10,000 ???? 1???
3. ????????????80%?4????????10000*80%/4=2000??/???
4. ???????2000*2=4000??/???????????????4000??? 67?/?????????????100??????????0.7??
5. ??????????????=20???TPC????????=8?cpu??30%???????????????????????????4 ??????????????????????
? tpmC???
tpmC= 67*20*8*4/(1-30%)= 61257[?????????/??*????????????*??TPC????????*??????????????????/?1- cpu??30%????????
??? ???? = 61257/10000=6.1
???????tpmC= ??????? * 6.1 ?????????????
?????? tpmC = ?????? tpmC *50% ????
?????? tpmC = ?????? tpmC *70% ????????????????