?????? ?????

?????????????

cdtpcc-mysql/src
!!!!make?????????src????makefile??mysql_config
make
[root@rac1src]#make
cc-w-O2-g-I.`mysql_config--include`-cload.c
cc-w-O2-g-I.`mysql_config--include`-csupport.c
ccload.osupport.o`mysql_config--libs_r`-lrt-o../tpcc_load
cc-w-O2-g-I.`mysql_config--include`-cmain.c
cc-w-O2-g-I.`mysql_config--include`-cspt_proc.c
cc-w-O2-g-I.`mysql_config--include`-cdriver.c
cc-w-O2-g-I.`mysql_config--include`-csequence.c
cc-w-O2-g-I.`mysql_config--include`-crthist.c
cc-w-O2-g-I.`mysql_config--include`-cneword.c
cc-w-O2-g-I.`mysql_config--include`-cpayment.c
cc-w-O2-g-I.`mysql_config--include`-cordstat.c
cc-w-O2-g-I.`mysql_config--include`-cdelivery.c
cc-w-O2-g-I.`mysql_config--include`-cslev.c
ccmain.ospt_proc.odriver.osupport.osequence.orthist.oneword.opayment.oordstat.odelivery.oslev.o`mysql_config--libs_r`-lrt-o../tpcc_start

?????? ????????????

????make???????tpcc-mysql???????? tpcc ?????й??? tpcc_load ??tpcc_start

????tpcc_load  ???????????????

????tpcc_start ???????????

?????÷?:

# ./tpcc_load –help
tpcc_load [server] [DB] [user] [pass] [warehouse]
server :    ????????
DB     :    ???????
user   :    ?????
pass   :    ????
warehouse: ????????
# ./tpcc_start –help
tpcc_start -h server_host -P port -d database_name -u mysql_user -p mysql_password -w warehouses -c connections -r warmup_time -l running_time -i report_interval -f report_file

?????????????????????÷?

-h server_host:      ????????
-P port :             ?????????3306
-d database_name:     ???????
-u mysql_user :        ?????
-p mysql_password :    ????
-w warehouses:        ????????
-c connections :       ???????????1
-r warmup_time :       ?????????λ:s??????10s ??????????????????????檔
-l running_time:      ?????????λ:s??????20s
-i report_interval     ???????????????
-f report_file :       ????????????

???????

????tpcc ??????/var/lib/mysql/mysql.sock ???socketλ?????????????????mysql socket???????·????????????????????????????TCP/IP??????????????????

?????????????

????mysqladmin  -uroot -h127.0.0.1 create tpcc          # ????????????????

????mysql -uroot -h127.0.0.1  tpcc < create_table.sql   # ????????????

????mysql -uroot -h127.0.0.1  tpcc < add_fkey_idx.sql   # ????FK??????

????1 ?????????????

./tpcc_load  127.0.0.1 tpcc root "" 5
*************************************
*** ###easy### TPC-C Data Loader  ***
*************************************
<Parameters>
[server]: 127.0.0.1
[port]: 3306
[DBname]: tpcc
[user]: root
[pass]:
[warehouse]: 5
TPCC Data Load Started...
Loading Item
.................................................. 5000
.................................................. 10000

?????????????????