sysbench mysql
# ./sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=chaos --mysql-host=127.0.0.1 --mysql-socket=/mysql/mysql.sock --mysql-password=123456 --db-driver=mysql prepare
sysbench 0.4.12:multi-threaded system evaluation benchmark
Creating table 'sbtest'...
Creating 1000000 records in table 'sbtest'...
# ./sysbench --mysql-db=sbtest --max-requests=0 --test=oltp --mysql-engine-trx=yes --mysql-table-engine=innodb --oltp-table-size=1000000 --db-ps-mode=disable--mysql-user=chaos --mysql-host=127.0.0.1 --mysql-socket=/mysql/mysql.sock --mysql-password=123456 --num-threads=16 --max-time=600 run
sysbench 0.4.12:multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 16
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>
Threads started!
Time limit exceeded, exiting...
(last message repeated 15 times)
Done.
OLTP test statistics:
queries performed:
read: 298466
write: 106595
other: 42638
total: 447699
transactions: 21319(35.51 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 405061 (674.64 per sec.)
other operations: 42638(71.01 per sec.)
Test execution summary:
total time: 600.4126s
total number of events: 21319
total time taken by event execution: 9602.9898
per-request statistics:
min: 47.43ms
avg: 450.44ms
max: 897.43ms
approx.95 percentile: 518.83ms
Threads fairness:
events (avg/stddev): 1332.4375/2.09
execution time (avg/stddev): 600.1869/0.12
# ./sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=chaos --mysql-host=127.0.0.1 --mysql-socket=/mysql/mysql.sock --mysql-password=123456 --db-driver=mysql cleanup
sysbench 0.4.12:multi-threaded system evaluation benchmark
Dropping table 'sbtest'...
Done.
页:
[1]