MySQL Performance Benchmarking

MySQL Performance Benchmarking

Compare MySQL database performance across Bare Metal Cloud instances.

Benchmarking Bare Metal Cloud

With 20+ available configurations, Bare Metal Cloud helps you optimize your workloads for maximum performance. To identify the best configurations for MySQL workloads, we tested out multiple instances using a simple Sysbench OLTP_RW test. The results are summarized below and should help you pick the right solution for your needs.

All instances leverage the new Intel Xeon Scalable processors (Cascade Lake Refresh), which are designed to provide performance boost for data-intensive workloads such as databases. Based on different thread counts and capacities, we compared 10 different benchmarks: Queries Performed (Read), Queries Performed (Write), Queries Performed (Other), Transaction per Sec, Queries per Sec, Latency (min), Latency (avg), Latency (max), Latency (95%), Latency (sum), Threads fairness (events), and Threads fairness (execution time).

The table below shows the three of those benchmarks that we considered the most relevant for these types of workloads. For the complete list, please contact [email protected].

MySQL Databases

For the purpose of comparing performance of different Bare Metal Cloud (BMC) instances, we tested a 100 GB MySQL database (8x tables with 50-million records, R/W/O of 70/20/10) on 16 Bare Metal Cloud configurations. Below is the summary of the results that should provide a reference for you when choosing your preferred instance.

Database specs:

Size: 100 GB

Ubuntu 18.04 OS

Database version 8.0.25.

Number of DB records: 50000000

70/30 read/write ratio

Benchmark Test Results

Oops! Your browser doesn't support embed PDFs!

Download Instead
Instance Threads Transactions per Second Queries per Second Latency Average Instance Price
s0.d1.small
Single Intel E3-1240v3
(4 cores and 3.4 GHz)
32
128
512
91.91
71.47
63.19
1,838.18
1,429.32
1,263.84
347.97
1,429.32
1,789.30
$0.10/h
$67.00/m
s0.d1.medium
Single Intel E3-1270v3
(4 cores and 3.5 GHz)
32
128
512
163.82
124.10
82.88
3,276.42
2,481.92
1,657.67
195.27
1,030.60
6,132.81
$0.12/h
$80.00/m
s1.c1.small
Single Intel E-2276G
(6 cores and 3.8 GHz)
32
128
512
3,152.36
3,478.44
3,427.43
63,047.25
69,568.79
68,548.53
10.15
36.79
149.35
$0.18/h
$105.00/m
s1.c1.medium
Single Intel E-2276G
(6 cores and 3.8 GHz)
32
128
512
5,803.09
5,707.75
5,755.85
116,061.82
114,154.93
115,117.03
5.51
22.42
88.94
$0.26/h
$164.00/m
s1.c2.large
Single Intel E-2288G
(8 cores and 3.7 GHz)
32
128
512
8,005.24
7,987.05
7,213.76
160,104.82
159,741.06
144,275.19
4.00
16.02
70.97
$0.29/h
$184.00/m
d1.c1.small
Dual Intel Silver 4210R
(20 cores and 2.4 GHz)
32
128
512
11,181.86
13,025.28
8,528.58
223,637.25
260,505.63
170,571.63
2.86
9.82
60.02
$0.44/h
$295.00/m
d1.c2.small
Dual Intel Gold 5218R
(40 cores and 2.1 GHz)
32
128
512
13,026.18
16,997.69
10,204.33
260,523.69
339,953.79
204,086.61
2.45
7.53
50.15
$0.55/h
$378.00/m
d1.c3.small
Dual Intel Gold 6230R
(52 cores and 2.1 GHz)
32
128
512
16,855.14
37,597.18
28,920.26
337,102.82
751,943.62
578,405.13
1.90
3.40
17.69
$0.61/h
$418.00/m
d1.c4.small
Dual Intel Gold 6258R
(56 cores and 2.7 GHz)
32
128
512
16,621.09
37,479.50
23,146.55
332,421.83
749,590.05
462,930.92
1.92
3.41
22.10
$0.68/h
$475.00/m
d1.c1.medium
Dual Intel Silver 4210R
(20 cores and 2.4 GHz)
32
128
512
11,289.05
13,473.23
9,763.50
225,780.97
269,464.61
195,270.00
2.83
9.50
52.42
$0.57/h
$393.00/m
d1.c3.medium
Dual Intel Gold 6230R
(52 cores and 2.1 GHz)
32
128
512
12,300.09
17,085.37
11,743.10
246,001.74
341,707.48
234,862.02
2.60
7.49
43.58
$0.74/h
$516.00/m
d1.c4.medium
Dual Intel Gold 6258R
(56 cores and 2.7 GHz)
32
128
512
17,033.86
38,229.54
34,686.11
340,677.13
764,590.82
693,722.14
1.88
3.35
14.75
$0.82/h
$573.00/m
d1.c1.large
Dual Intel Silver 4210R
(20 cores and 2.4 GHz)
32
128
512
11,586.56
13,491.72
9,883.70
231,731.19
269,834.48
197,673.98
2.76
9.48
51.78
$0.77/h
$539.00/m
d1.c2.large
Dual Intel Gold 5218R
(40 cores and 2.1 GHz)
32
128
512
14,570.80
18,228.96
12,661.13
291,416.08
364,579.18
253,222.58
2.19
7.02
40.42
$0.89/h
$622.00/m
d1.c3.large
Dual Intel Gold 6230R
(52 cores and 2.1 GHz)
32
128
512
13,938.89
16,841.02
12,639.15
278,777.75
336,820.32
252,783.10
2.29
7.60
40.49
$0.94/h
$662.00/m
d1.c4.large
Dual Intel Gold 6258R
(56 cores and 2.7 GHz)
32
128
512
13,697.49
16,194.93
12,049.55
273,949.90
323,898.63
240,990.94
2.33
7.90
42.47
$1.02/h
$719.00/m

Download Full Spec Sheet Contact Sales

Test Methodology

To execute these tests, we used a simple Sysbench OLTP_RW test methodology that involved deploying the designated workload to each instance individually. Eight tables were used, each with 50 million rows (approx. 100GB of data). The load was incrementally increased with each test, starting with a single thread and scaling up to 8, 16, 32, 48, 64, 128, 254, and 512 threads.

Deploy BMC Servers Today

Deploy Now