Sysbench OLTP Read/Write on Amazon EC2/RDS
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
queries performedread1400000Sysbench command used:

sysbench --db-driver=mysql --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --mysql-user=root --mysql-password=yourpassword run
2
write500000
3
other200000
4
total2100000
5
TypeMySQL pathtransactions per secread/write requests per secother operations per secTest execution total time (s)per-request statistics: min (ms)per-request statistics: avg (ms)per-request statistics: max (ms)per-request statistics: approx. 95 percentileThreads fairness: events (avg/stddev)Threads fairness: execution time (avg/stddev)
6
7
MyPCon my SATA 5200 rpm47490119482104,3733,722333,0273,656250.8750/28.24210.7696/0.00
8
9
EC2 microstandard EBS (filesystem root)72137914513779,89220,383528,08575,796250.0000/61.871377.3694/0.12
10
EC2 microRAID0 4 volumes 1 GB66125713215113,7241,773705,96693,226250.0000/72.221511.0518/0.16
11
EC2 microRAID10 8 volumes 1 GB56106411217848,01285,458023,55656,266250.0000/63.131784.0340/0.21
12
13
EC2 small (1st test)standard EBS (filesystem root)13726102747274,28116,454005,1222,336250.0000/51.33727.8061/0.05
14
EC2 small (2nd test)standard EBS (filesystem root)13626022737304,43116,785436,032216250.0000/70.57729.9030/0.08
15
EC2 small (avg)136,52606273,5728,54,355116,6154720,565221,665
16
17
EC2 medium (1st test)standard EBS (filesystem root)21240424254707,0875,24722,57140,346250.0000/49.50469.9806/0.02
18
EC2 medium (2nd test)standard EBS (filesystem root)21540924304645,6474,284098,89137,186250.0000/55.47464.2356/0.02
19
EC2 medium (avg)213,54067427,54676,3674,744410,73138,76
20
EC2 mediumRAID0 4 volumes 1 GB29556195913384,9554,091441,03107,946250.0000/63.01338.0663/0.01
21
EC2 mediumRAID0 8 volumes 1 GB29956825983344,9353,491422,79106,726250.0000/70.17334.2959/0.02
22
EC2 mediumRAID0 2 volumes 1 GB29556105903384,4854,161414,82107,716250.0000/83.80338.5224/0.05
23
EC2 mediumon external volume (not RAID)28253615643544,8456,692612,84112,626250.0000/49.15354.2848/0.04
24
EC2 mediumon external volume (not RAID) 10GB IOPs = 100121230924382215,47131,619088,05525,556250.0000/25.63822.5795/0.05
25
26
EC2 medium HC (1st test)standard EBS (filesystem root)46087499212174,2434,741796,1877,896250.0625/96.64217.1025/0.01
27
EC2 medium HC (2nd test)standard EBS (filesystem root)45786849142184,09352445,5379,256250.1250/102.44218.7245/0.01
28
EC2 medium HC (avg)458,58716,5917,5217,54,16534,872120,85578,57
29
30
RDS mediumno IOPs/Multi A-Z/5GB152289530465619,98104,97509,44240,396250.0000/21.22656.0576/0.05
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Foglio1