使用sysbench测试mysql5.5和postgre9.1性能

sysbench版本：0.4.10

机器：my064112.sqa.cm4

1.postgresql9.1 beta

a.准备100W数据

./sysbench  --test=oltp --db-driver=pgsql   --pgsql-user=yinfeng.zwx --pgsql-db=sbtest  --oltp-table-size=1000000 prepare 

b.测试5分钟：

./sysbench --db-driver=pgsql  --pgsql-user=yinfeng.zwx    --oltp-dist-type=special --oltp-table-size=1000000 --oltp-read-only=off --oltp-test-mode=complex --max-requests=0 --max-time=300 --num-threads=64 --test=oltp run

c.测试结果：

Running the test with following options:
Number of threads: 64


Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 63 times)
Done.


OLTP test statistics:
    queries performed:
        read:                            2492560
        write:                           890200
        other:                           356080
        total:                           3738840
    transactions:                        178040 (581.91 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 3382760 (11056.32 per sec.)
    other operations:                    356080 (1163.82 per sec.)


Test execution summary:
    total time:                          305.9572s
    total number of events:              178040
    total time taken by event execution: 19571.3683
    per-request statistics:
         min:                                  3.30ms
         avg:                                109.93ms
         max:                              10809.16ms
         approx.  95 percentile:             171.10ms


Threads fairness:
    events (avg/stddev):           2781.8750/23.16
    execution time (avg/stddev):   305.8026/0.02

2.mysql5.5

a.准备数据

./sysbench  --test=oltp --db-driver=mysql   --mysql-user=root --mysql-port=3366 --mysql-socket=/u01/mysql5-yf/run/mysql.sock --mysql-db=sbtest  --oltp-table-size=1000000 prepare

b.测试5分钟

./sysbench --db-driver=mysql --mysql-table-engine=innodb  --mysql-user=root  --mysql-port=3366 --mysql-socket=/u01/mysql5-yf/run/mysql.sock   --oltp-dist-type=special --oltp-table-size=1000000 --oltp-read-only=off --oltp-test-mode=complex --max-requests=0 --max-time=300 --num-threads=64 --test=oltp run

c.测试结果

sysbench 0.4.10:  multi-threaded system evaluation benchmark


WARNING: Preparing of "BEGIN" is unsupported, using emulation
(last message repeated 63 times)
Running the test with following options:
Number of threads: 64


Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 63 times)
Done.


OLTP test statistics:
    queries performed:
        read:                            1991696
        write:                           711320
        other:                           284528
        total:                           2987544
    transactions:                        142264 (474.10 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 2703016 (9007.81 per sec.)
    other operations:                    284528 (948.19 per sec.)


Test execution summary:
    total time:                          300.0746s
    total number of events:              142264
    total time taken by event execution: 19198.6758
    per-request statistics:
         min:                                 10.99ms
         avg:                                134.95ms
         max:                               1486.86ms
         approx.  95 percentile:             226.09ms


Threads fairness:
    events (avg/stddev):           2222.8750/18.28
    execution time (avg/stddev):   299.9793/0.03