DBT2 MySQL SSD Results

2008-02-02 at 05:51 pm Matthew Yonkovit

Ran DBT2 with the following:

[root@localhost scripts]# ./run_workload.sh  -s100 -c 16 -w 20 -t 32 -d 1200 -n

Here are the results ( This beats a lot of other benchmarks I have seen with 8 core machines & regular disk ). This is an innodb test, with the ibdata file on 1 mtron drive and the log files on another. The test does not really show the mtrons ability  though., simply because the dataset is only 20 warehouses they all fit into memory. So far I have seen 18K TPM on a 300 warehouse run which stresses the disk more. Anyways here are the results:

Response Time (s)
Transaction      %    Average :    90th %        Total        Rollbacks      %
------------  -----  ---------------------  -----------  ---------------  -----
Delivery   3.81      0.656 :     0.741        50043                0   0.00
New Order  42.61      0.607 :     0.681       559699             5569   0.99
Order Status   3.79      0.592 :     0.665        49792                0   0.00
Payment  40.76      0.599 :     0.672       535512                0   0.00
Stock Level   3.79      0.594 :     0.668        49786            34125  68.54

26748.03 new-order transactions per minute (NOTPM)
20.7 minute duration
0 total unknown errors
65 second(s) ramping up


mysql, performance RSS 2.0 trackback leave a response

Leave a Reply