List:General Discussion« Previous MessageNext Message »
From:Fredrik Carlsson Date:October 9 2006 2:50pm
Subject:Performance
View as plain text  
Hi,

I'm running FreeBSD 6.1, mysql 5.0.24a(binaries from mysql ab) and are
running some benchmarks using sysbench, what kind of performance should
i expect?
The machine is a Dell poweredge 1800 with the cerc raid controller (two
sata disks in raid1).

sysbench command:
sysbench --test=oltp --mysql-table-engine=innodb
--oltp-table-size=5000000 --num-threads=16
--mysql-socket=/tmp/mysql.sock --mysql-user=abc--mysql-password=def
--oltp-test-mode=complex --max-requests=10000 run


On a single disk (not using the cerc controller) I get the following
results:

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (413.70 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (7860.35 per sec.)
    other operations:                    20000  (827.41 per sec.)

Test execution summary:
    total time:                          24.1719s
    total number of events:              10000
    total time taken by event execution: 384.3010
    per-request statistics:
         min:                            0.0061s
         avg:                            0.0384s
         max:                            0.3780s
         approx.  95 percentile:         0.0752s

Threads fairness:
    events (avg/stddev):           625.0000/16.48
    execution time (avg/stddev):   24.0188/0.01


I guess the disk cache is causing the many transactions/s?


On a raid1 using the cerc hw raid controller:

OLTP test statistics:
    queries performed:
        read:                            140140
        write:                           50023
        other:                           20010
        total:                           210173
    transactions:                        10000  (53.48 per sec.)
    deadlocks:                           10     (0.05 per sec.)
    read/write requests:                 190163 (1016.93 per sec.)
    other operations:                    20010  (107.01 per sec.)

Test execution summary:
    total time:                          186.9973s
    total number of events:              10000
    total time taken by event execution: 2988.9251
    per-request statistics:
         min:                            0.0087s
         avg:                            0.2989s
         max:                            186.9913s
         approx.  95 percentile:         0.0499s


There a quite big difference between the single disk and the raid1,
should i expect more or is this normal?


// Fredrik Carlsson












Thread
PerformanceFredrik Carlsson9 Oct