Results from a slightly realistic test , using sysbench 0.4 and POINT_SELECT "unit test"
sysbench --num-threads=10 --test=oltp --oltp-table-size=1000000 --oltp-dist-type=uniform --oltp-table-name=sbtest --init-rng=on --max-requests=0 --max-time=180 --mysql-user=root --mysql-port=3306 --mysql-host=127.0.0.1 --mysql-db=test --myisam-max-rows=1000000 --mysql-table-engine=INNODB --oltp-point-selects=1 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-skip-trx=on --oltp-read-only=on run
5.2.11 transactions: 8351523 (46397.22 per sec.) 5.3.4 transactions: 6961462 (38674.66 per sec.)
Results from a slightly realistic test , using sysbench 0.4 and POINT_SELECT "unit test"
sysbench --num-threads=10 --test=oltp --oltp- table-size= 1000000 --oltp- dist-type= uniform --oltp- table-name= sbtest --init-rng=on --max-requests=0 --max-time=180 --mysql-user=root --mysql-port=3306 --mysql- host=127. 0.0.1 --mysql-db=test --myisam- max-rows= 1000000 --mysql- table-engine= INNODB --oltp- point-selects= 1 --oltp- simple- ranges= 0 --oltp-sum-ranges=0 --oltp- order-ranges= 0 --oltp- distinct- ranges= 0 --oltp-skip-trx=on --oltp-read-only=on run
5.2.11
transactions: 8351523 (46397.22 per sec.)
5.3.4
transactions: 6961462 (38674.66 per sec.)