Description:
InnoDB:
Notice that only new order had rollbacks as expected
Response Time (s)
Transaction % Average : 90th % Total Rollbacks %
---------------------------------------------------------------------------------------------
Delivery 3.97 5.288 : 7.454 478 0 0.00
New Order 44.88 2.730 : 4.252 5399 43 0.80
Order Status 4.19 2.097 : 3.036 504 0 0.00
Payment 43.03 3.220 : 5.139 5177 0 0.00
Stock Level 3.89 2.007 : 3.149 468 0 0.00
NDBD:
Transaction % Average : 90th % Total Rollbacks %
---------------------------------------------------------------------------------------------
Delivery 4.02 47.430 : 57.529 351 269 76.64
New Order 44.68 3.467 : 4.308 3897 98 2.51
Order Status 3.85 3.218 : 3.987 336 74 22.02
Payment 43.60 3.108 : 4.147 3803 1553 40.84
Stock Level 3.84 3.853 : 4.524 335 0 0.00
Calvin asked that I run a 1 warehouse test. These are the results of that testing.
DATABASE NAME: dbt2
DATABASE USER: root
DATABASE PORT: 3306
DATABASE CONNECTIONS: 2
TERMINAL THREADS: 10
SCALE FACTOR(WARHOUSES): 1
TERMINALS PER WAREHOUSE: 10
DURATION OF TEST(in sec): 900
SLEEPY in (msec) 0
ZERO DELAYS MODE: 1
InnoDB:
Transaction % Average : 90th % Total Rollbacks %
---------------------------------------------------------------------------------------------
Delivery 3.93 1.944 : 2.597 458 0 0.00
New Order 45.09 0.725 : 1.292 5251 43 0.82
Order Status 3.92 0.727 : 1.333 457 0 0.00
Payment 43.36 0.715 : 1.251 5049 0 0.00
Stock Level 3.68 0.756 : 1.286 429 0 0.00
NDBD:
Transaction % Average : 90th % Total Rollbacks %
---------------------------------------------------------------------------------------------
Delivery 3.96 9.316 : 9.063 143 46 32.17
New Order 44.74 2.278 : 4.573 1615 17 1.05
Order Status 4.13 2.053 : 4.537 149 6 4.03
Payment 43.85 2.104 : 4.566 1583 114 7.20
Stock Level 3.32 2.360 : 5.038 120 0 0.00
How to repeat:
run a 4 warehouse test with DBT2 using a 2 datanode cluster.
Description: InnoDB: Notice that only new order had rollbacks as expected Response Time (s) Transaction % Average : 90th % Total Rollbacks % --------------------------------------------------------------------------------------------- Delivery 3.97 5.288 : 7.454 478 0 0.00 New Order 44.88 2.730 : 4.252 5399 43 0.80 Order Status 4.19 2.097 : 3.036 504 0 0.00 Payment 43.03 3.220 : 5.139 5177 0 0.00 Stock Level 3.89 2.007 : 3.149 468 0 0.00 NDBD: Transaction % Average : 90th % Total Rollbacks % --------------------------------------------------------------------------------------------- Delivery 4.02 47.430 : 57.529 351 269 76.64 New Order 44.68 3.467 : 4.308 3897 98 2.51 Order Status 3.85 3.218 : 3.987 336 74 22.02 Payment 43.60 3.108 : 4.147 3803 1553 40.84 Stock Level 3.84 3.853 : 4.524 335 0 0.00 Calvin asked that I run a 1 warehouse test. These are the results of that testing. DATABASE NAME: dbt2 DATABASE USER: root DATABASE PORT: 3306 DATABASE CONNECTIONS: 2 TERMINAL THREADS: 10 SCALE FACTOR(WARHOUSES): 1 TERMINALS PER WAREHOUSE: 10 DURATION OF TEST(in sec): 900 SLEEPY in (msec) 0 ZERO DELAYS MODE: 1 InnoDB: Transaction % Average : 90th % Total Rollbacks % --------------------------------------------------------------------------------------------- Delivery 3.93 1.944 : 2.597 458 0 0.00 New Order 45.09 0.725 : 1.292 5251 43 0.82 Order Status 3.92 0.727 : 1.333 457 0 0.00 Payment 43.36 0.715 : 1.251 5049 0 0.00 Stock Level 3.68 0.756 : 1.286 429 0 0.00 NDBD: Transaction % Average : 90th % Total Rollbacks % --------------------------------------------------------------------------------------------- Delivery 3.96 9.316 : 9.063 143 46 32.17 New Order 44.74 2.278 : 4.573 1615 17 1.05 Order Status 4.13 2.053 : 4.537 149 6 4.03 Payment 43.85 2.104 : 4.566 1583 114 7.20 Stock Level 3.32 2.360 : 5.038 120 0 0.00 How to repeat: run a 4 warehouse test with DBT2 using a 2 datanode cluster.