设定总请求数，不设定最大执行时长
--percentile=95 表示设定采样比例，默认是 95%，即丢弃5%的长请求，在剩余的95%里取最大值
可选参数：
--oltp-point-selects：在一个事务里面Point select的数量，默认为10
--oltp-range-size：range查询的范围大小，默认100，应该小于oltp-table-size
--oltp-simple-ranges：在一个事务里面简单range查询的数量，默认1
--oltp-sum-ranges：在一个事务里面SUM range查询的数量，默认1
--oltp-order-ranges：在一个事务里面ORDER range查询的数量，默认1
--oltp-distinct-ranges：在一个事务里面DISTINCT range查询的数量，默认1
注意：我这里将测试中输出信息存放到一个文本文件里，便于用监控展示成图表形式，这样更直观
监控结果：
SSD-IO
![\]()
HDD-IO
![\]()
SSD-TPS
![\]()
HDD-TPS
![\]()
SSD-writes
![\]()
HDD-Writes
![\]()
SSD-reads
![\]()
HDD-Reads
![\]()
SSD-Response-time
![\]()
HDD-Response_time
![\]()
SSD-errors
![\]()
HDD-Errors
![\]()
结论：（监控参数相同的情况下--oltp_tables_count=50 --oltp-table-size=100000000 --num-threads=1000 --oltp-read-only=off --rand-type=uniform ）
TPS：MySQL在SSD上运行是在HDD上运行的5.63倍
writes：MySQL在SSD上运行是在HDD上运行的5.58倍
reads：MySQL在SSD上运行是在HDD上运行的5.55倍
Response_time：MySQL在SSD上运行比在HDD上运行响应时间快44.45倍
Errors：MySQL在SSD上运行是在HDD上运行错误率低83.5倍
2、随机IO测试（这里就不再上图了）
数据准备（创建70G文件）注意：文件大小需要大于内存大小
sysbench --test=fileio --file-total-size=70G --file-test-mode=rndrw --init-rng=on --max-time=300 --max-requests=0 prepare
测试阶段
sysbench --test=fileio --file-total-size=70G --file-test-mode=rndrw --init-rng=on --max-time=300 --max-requests=0 run
清楚测试数据
sysbench --test=fileio --file-total-size=70G --file-test-mode=rndrw --init-rng=on --max-time=300 --max-requests=0 clean
?
随机读写混合
SSD
Operations performed: 1789098 reads, 1192732 writes, 3816704 Other= 6798534 Total
Read 27.299Gb Written 18.2Gb Total transferred 45.499Gb (155.3Mb/sec)
9939.43 Requests/sec executed
?
General statistics:
total time: 300.0001s
total number of events: 2981830
total time taken by event execution: 214.9376s
response time:
min: 0.00ms
avg: 0.07ms
max: 7.26ms
approx. 95 percentile: 0.23ms
?
Threads fairness:
events (avg/stddev): 2981830.0000/0.00
execution time (avg/stddev): 214.9376/0.00
?
HDD
Operations performed: 85851 reads, 57234 writes, 183040 Other =326125 Total
Read 1.31Gb Written 894.28Mb Totaltransferred 2.1833Gb (7.4523Mb/sec)
476.95 Requests/sec executed
?
General statistics:
total time: 300.0024s
total number of events: 143085
total time taken by event execution: 291.8164s
response time:
min: 0.01ms
avg: 2.04ms
max: 170.33ms
approx. 95 percentile: 5.22ms
?
Threads fairness:
events (avg/stddev): 143085.0000/0.00
execution time (avg/stddev): 291.8164/0.00
?
随机写
SSD
Operations performed: 0 reads, 10441500 writes, 13365074 Other =23806574 Total
Read 0b Written 159.32Gb Totaltransferred 159.32Gb (271.91Mb/sec)
17402.24 Requests/sec executed
?
General statistics:
total time: 600.0090s
total number of events: 10441500
total time taken by event execution: 168.8168s
response time:
min: 0.00ms
avg: 0.02ms
max: 0.71ms
approx. 95 percentile: 0.02ms
?
Threads fairness:
events (avg/stddev): 10441500.0000/0.00
execution time(avg/stddev): 168.8168/0.00
?
HDD
Operationsperformed: 0 reads, 427200 writes,546689 Other = 973889 Total
Read 0b Written 6.5186Gb Total transferred 6.5186Gb (11.125Mb/sec)
712.00 Requests/sec executed
?
Generalstatistics:
total time: 600.0002s
total number of events: 427200
total time taken by event execution:10.5053s
response time:
min: 0.01ms
avg: 0.02ms
max: 29.30ms
approx. 95 percentile: 0.03ms
?
Threadsfairness:
events (avg/stddev): 427200.0000/