以下是我使用sysbench测试出来的结果,你看看:Running the test with following options: Number of threads: 100Doing 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 Maximum number of requests for OLTP test is limited to 10000 Threads started! Done.OLTP test statistics: queries performed: read: 140000 write: 50000 other: 20000 total: 210000 transactions: 10000 (175.26 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 190000 (3330.00 per sec.) other operations: 20000 (350.53 per sec.)Test execution summary: total time: 57.0570s total number of events: 10000 total time taken by event execution: 5689.2504 per-request statistics: min: 4.92ms avg: 568.93ms max: 3507.23ms approx. 95 percentile: 1551.32msThreads fairness: events (avg/stddev): 100.0000/6.59 execution time (avg/stddev): 56.8925/0.08 是这样的结果吧
Number of threads: 100Doing 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (175.26 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (3330.00 per sec.)
other operations: 20000 (350.53 per sec.)Test execution summary:
total time: 57.0570s
total number of events: 10000
total time taken by event execution: 5689.2504
per-request statistics:
min: 4.92ms
avg: 568.93ms
max: 3507.23ms
approx. 95 percentile: 1551.32msThreads fairness:
events (avg/stddev): 100.0000/6.59
execution time (avg/stddev): 56.8925/0.08 是这样的结果吧
3330.00 per sec最重要的就是这俩了
第二个是读写请求,也是越高越好吗?而且貌似是读写请求是在一起的,能否分开?比如说每秒读多少,写多少?
还有一个问题,如果我要插入以G为单位的数据,用sysbench如何插入?
write: 50000
这个就是读写的比例
就是说整个读写操作是每秒3330 那这个性能貌似不算很好吧