Skip to content

Latest commit

 

History

History
158 lines (141 loc) · 2.55 KB

README.md

File metadata and controls

158 lines (141 loc) · 2.55 KB
Raw

TPCC on FnckSQL

run cargo run -p tpcc --release to run tpcc

  • i9-13900HX
  • 32.0 GB
  • KIOXIA-EXCERIA PLUS G3 SSD
  • Tips: TPCC currently only supports single thread
|New-Order| sc: 93779  lt: 0  fl: 926
|Payment| sc: 93759  lt: 0  fl: 0
|Order-Status| sc: 9376  lt: 0  fl: 417
|Delivery| sc: 9375  lt: 0  fl: 0
|Stock-Level| sc: 9375  lt: 0  fl: 0
in 720 sec.
<Constraint Check> (all must be [OK])
[transaction percentage]
   Payment: 43.0% (>=43.0%)  [Ok]
   Order-Status: 4.0% (>=4.0%)  [Ok]
   Delivery: 4.0% (>=4.0%)  [Ok]
   Stock-Level: 4.0% (>=4.0%)  [Ok]
[response time (at least 90%% passed)]
   New-Order: 100.0  [OK]
   Payment: 100.0  [OK]
   Order-Status: 100.0  [OK]
   Delivery: 100.0  [OK]
   Stock-Level: 100.0  [OK]
   New-Order Total: 93779
   Payment Total: 93759
   Order-Status Total: 9376
   Delivery Total: 9375
   Stock-Level Total: 9375


<RT Histogram>

1.New-Order

0.001,  20973
0.002,  71372
0.003,   1306
0.004,     15
0.005,      2

2.Payment

0.001,  90277
0.002,   3307
0.003,     11
0.004,      3

3.Order-Status

0.013,     24
0.014,    108
0.015,    189
0.016,    207
0.017,    201
0.018,    207
0.019,    221
0.020,    198
0.021,    187
0.022,    163
0.023,    175
0.024,    259
0.025,    298
0.026,    300
0.027,    239
0.028,    207
0.029,    165
0.030,    142
0.031,    135
0.032,    205
0.033,    303
0.034,    270
0.035,    272
0.036,    170
0.037,    138
0.038,    156
0.039,    175
0.040,    193
0.041,    207
0.042,    211
0.043,    264
0.044,    304
0.045,    265
0.046,    224
0.047,    172
0.048,    176
0.049,    172
0.050,    207
0.051,    238
0.052,    269
0.053,    219
0.054,    242
0.055,    156
0.056,    134
0.057,     94
0.058,     88
0.059,     75
0.060,     49
0.061,     13
0.062,      4
0.063,      1
0.064,      1
0.076,      1
0.080,      1
0.117,      1
0.127,      1
0.150,      1
0.158,      1
0.172,      1
0.176,      1

4.Delivery

0.011,    117
0.012,    483
0.013,    659
0.014,    704
0.015,    790
0.016,    911
0.017,    969
0.018,    974
0.019,    895
0.020,    927
0.021,    782
0.022,    542
0.023,    362
0.024,    209
0.025,     45
0.026,      1
0.027,      3

5.Stock-Level

0.001,   1815
0.002,   3454
0.003,   3646
0.004,    377
0.005,     28

<90th Percentile RT (MaxRT)>
   New-Order : 0.002  (0.004)
     Payment : 0.001  (0.025)
Order-Status : 0.053  (0.175)
    Delivery : 0.022  (0.027)
 Stock-Level : 0.003  (0.019)
<TpmC>
7815 tpmC

Explain

run cargo test -p tpcc explain_tpcc -- --ignored to explain tpcc statements

Tips: after TPCC loaded tables

Refer to