yugabyte / tpcc

Repo to run TPCC benchmarks against YugabyteDB
Other
24 stars 21 forks source link

Enhance the output of TPCC execution results #89

Closed robertsami closed 3 years ago

robertsami commented 3 years ago

This PR makes a few changes:

  1. Track "pipeline" of retry/failure for each Procedure type
  2. Display percentage failure
  3. Tabulate the format of the output data

Sample output:

23:56:04,861 (DBWorkload.java:949) INFO  -
================RESULTS================
             TPM-C |           24878.30
        Efficiency |             96.73%
Throughput (req/s) |             933.67

23:56:05,433 (DBWorkload.java:976) INFO  -
================LATENCIES===============
 Operation  | Avg. Latency | P99 Latency
   NewOrder |        68.44 |      408.00
    Payment |        41.20 |      218.12
OrderStatus |        22.78 |      167.98
   Delivery |       194.94 |     1255.64
 StockLevel |       106.25 |      392.52

23:56:05,445 (DBWorkload.java:1022) INFO  -
====================RETRIES===================
   Operation   | Total Created | Retry Number 1 | Retry Number 2 |     Failures
      NewOrder |        762023 | 13077 ( 1.72%) |  4432 ( 0.58%) |  8888 ( 1.17%)
       Payment |        736313 | 11215 ( 1.52%) |  6625 ( 0.90%) |  3686 ( 0.50%)
   OrderStatus |         68687 |     0 ( 0.00%) |     0 ( 0.00%) |     0 ( 0.00%)
      Delivery |         68683 |   396 ( 0.58%) |   272 ( 0.40%) |   200 ( 0.29%)
    StockLevel |         68291 |     0 ( 0.00%) |     0 ( 0.00%) |     0 ( 0.00%)
psudheer21 commented 3 years ago

Awesome work here @robertsami.. The output looks really good. :)