tpcc 對mysql 8 的innodb cluster 進行壓測時，我發現一個事物也不能寫入
而 tpcc_load 能夠對資料庫進行初始化加載 ，我加載了 1200萬資料
以下是tpcc 的壓測引數
./tpcc_start -h 172.16.50.187 -P 3310 -d tpcc -u tpcc -ptpcc123 -w 1 -c 5 -r 1 -l 10 -i 1 -f test.t -t t_file > tt.t
***************************************
*** ###easy### TPC-C Load Generator ***
***************************************
option h with value '172.16.50.187'
option P with value '3310'
option d with value 'tpcc'
option u with value 'tpcc'
option p with value 'tpcc123'
option w with value '1'
option c with value '5'
option r with value '1'
option l with value '10'
option i with value '1'
option f with value 'test.t'
option t with value 't_file'
<Parameters>
[server]: 172.16.50.187
[port]: 3310
[DBname]: tpcc
[user]: tpcc
[pass]: tpcc123
[warehouse]: 1
[connection]: 5
[rampup]: 1 (sec.)
[measure]: 10 (sec.)
RAMP-UP TIME.(1 sec.)
MEASURING START.
1, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.458, 0(0):0.000|0.000
2, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
3, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
4, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
5, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
6, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
7, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
8, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
9, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
10, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000, 0(0):0.000|0.000
STOPPING THREADS.....
<Raw Results>
[0] sc:0 lt:0 rt:19438 fl:11
[1] sc:0 lt:0 rt:24489 fl:12
[2] sc:0 lt:0 rt:1999 fl:1
[3] sc:0 lt:0 rt:0 fl:0
[4] sc:0 lt:0 rt:689 fl:1
in 10 sec.
<Raw Results2(sum ver.)>
[0] sc:0 lt:0 rt:19440 fl:11
[1] sc:0 lt:0 rt:24499 fl:12
[2] sc:0 lt:0 rt:1999 fl:1
[3] sc:0 lt:0 rt:0 fl:0
[4] sc:0 lt:0 rt:689 fl:1
<Constraint Check> (all must be [OK])
[transaction percentage]
Payment: -nan% (>=43.0%) [NG] *
Order-Status: -nan% (>= 4.0%) [NG] *
Delivery: -nan% (>= 4.0%) [NG] *
Stock-Level: -nan% (>= 4.0%) [NG] *
[response time (at least 90% passed)]
New-Order: -nan% [NG] *
Payment: -nan% [NG] *
Order-Status: -nan% [NG] *
Delivery: -nan% [NG] *
Stock-Level: -nan% [NG] *
<TpmC>
0.000 TpmC
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/82818.html
標籤：MySQL
上一篇：hbase資料加密