sysbench 之一次io测试记录

1，公司本地的虚拟机io 测试记录 ，esxi 6.5 虚拟出来的虚拟机

3221225472 bytes written in 395.65 seconds (7.76 MiB/sec).

File operations:
reads/s: 317.33
writes/s: 211.55
fsyncs/s: 874.71

Throughput:
read, MiB/s: 4.96
written, MiB/s: 3.31

General statistics:
total time: 10.2081s
total number of events: 12283

Latency (ms):
min: 0.00
avg: 13.06
max: 393.04
95th percentile: 94.10
sum: 160381.33

2，线上的库虚拟机 io 测试记录，esxi 6.5 虚拟出来的虚拟机，esxi 物理机做了raid 10 阵列

3221225472 bytes written in 6.93 seconds (443.15 MiB/sec).
 

File operations:
reads/s: 1197.39
writes/s: 797.84
fsyncs/s: 2718.85

Throughput:
read, MiB/s: 18.71
written, MiB/s: 12.47

General statistics:
total time: 11.1866s
total number of events: 54101

Latency (ms):
min: 0.00
avg: 3.09
max: 1351.76
95th percentile: 12.98
sum: 167243.29

Threads fairness:
events (avg/stddev): 3381.3125/299.51
execution time (avg/stddev): 10.4527/0.28

 

3，机房的物理机mysql 服务器 ，做了raid 10 阵列

3221225472 bytes written in 8.38 seconds (366.72 MiB/sec)

File operations:
reads/s: 2536.27
writes/s: 1690.84
fsyncs/s: 5602.46

Throughput:
read, MiB/s: 39.63
written, MiB/s: 26.42

General statistics:
total time: 10.0523s
total number of events: 96780

Latency (ms):
min: 0.00
avg: 1.65
max: 207.75
95th percentile: 12.08
sum: 159843.40

Threads fairness:
events (avg/stddev): 6048.7500/343.89
execution time (avg/stddev): 9.9902/0.01