四、进行测试
#使用tpcc_start 进行5个线程的测试,热身时间为120秒, 测试时间为1小时 !
[root@rac1 tpcc-mysql]# tpcc_start -hlocalhost -d tpcc -u root -p '' -w 5 -c 5 -r 120 -l 300 -f tpcc_mysql_20130331.xls *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value 'localhost' option d with value 'tpcc' option u with value 'root' option p with value '' option w with value '5' option c with value '5' option r with value '120' option l with value '300' option f with value 'tpcc_mysql_20130331.xls' <Parameters> [server]: localhost [port]: 3306 [DBname]: tpcc [user]: root [pass]: [warehouse]: 5 [connection]: 5 [rampup]: 120 (sec.) [measure]: 300 (sec.) RAMP-UP TIME.(120 sec.) MEASURING START. ---每隔10s 输出一次结果 10, 812(1):1.509|5.419, 814(0):0.447|1.575, 81(0):0.241|0.539, 82(0):2.270|2.824, 81(0):4.571|6.648 ...... 290, 851(0):1.582|2.949, 849(0):0.441|0.630, 85(0):0.199|0.235, 86(0):1.937|2.000, 85(0):4.178|4.226 300, 820(0):1.451|2.321, 822(0):0.443|0.718, 82(0):0.201|0.284, 81(0):1.922|2.972, 82(0):4.409|5.245 STOPPING THREADS..... <Raw Results> [0] sc:25485 lt:1 rt:0 fl:0 [1] sc:25487 lt:0 rt:0 fl:0 [2] sc:2548 lt:0 rt:0 fl:0 [3] sc:2549 lt:0 rt:0 fl:0 [4] sc:2549 lt:0 rt:0 fl:0 in 300 sec. <Raw Results2(sum ver.)> [0] sc:25485 lt:1 rt:0 fl:0 [1] sc:25487 lt:0 rt:0 fl:0 [2] sc:2548 lt:0 rt:0 fl:0 [3] sc:2549 lt:0 rt:0 fl:0 [4] sc:2549 lt:0 rt:0 fl:0 <Constraint Check> (all must be [OK]) [transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 100.00% [OK] Payment: 100.00% [OK] Order-Status: 100.00% [OK] Delivery: 100.00% [OK] Stock-Level: 100.00% [OK] <TpmC> 5097.200 TpmC |