MySQL Benchmarking on m3.xlarge and m3.2xlarge Instances

In our last post about MySQL benchmarking, we benchmarked MySQL performance on an m3.large instance using both instance store and different types of Amazon Web Service’s (AWS) Elastic Block Store (EBS) storage.

In this post, we have extended the benchmarks on m3.xlarge and m3.2xlarge. We ran the benchmarks with and without optimizations. We explained the optimization and the rationale behind each of them in a previous post about using Sysbench for benchmarking.

Analyzing AWS m3 Instances for Performance & Bandwidth - Flux7 Blog

Amazon Web Services (AWS) EC2 offers a variety of instance families and types, each serving specific use cases. The instance families include:

Performance Comparison of Wikibench on ‘m3’ Instances

MySQL Benchmarking: Setup, Optimizations & Results Using Sysbench on m3.Large

Throughout the history of our blog, we have shared many posts in regard to benchmarking, such as explaining how to setup and use sysbench for MySQL benchmarking. You can just do a search in the upper right-hand corner for “benchmarking” to find all of these. Today, we are continuing to add to the library!

Using Sysbench to Benchmark MySQL

During our earlier benchmarking activities, we benchmarked applications using wikibench. Remember that wikibench is a web application on a traditional LAMP stack. While analyzing the results, we found that the performance is improved by tuning the MySQL database. This motivated us to benchmark MySQL.

Benchmarking: Network Performance Analysis of r3 Instances

Before now, we have shared a few posts that explore benchmarking and the analysis of the r3 instance family, as well as other instances. You can find any number of those posts here.

Benchmarking: Analysis of r3 Instances Using FIO

Benchmarking: CPU Performance Analysis of r3 instances Using CoreMark

Wikibench Performance on c3 Instances

Today, we explore the performance of wikibench on ‘c3’ instances. The methodology we used is similar to the one we utilized on ‘m3’ instances in this post here.

Benchmarking m3.xlarge with Wikibench

In a recent post, we discussed the basics of the wikibench tool and how it is used for application benchmarking. Today, we’ll discuss how we used the Wikibench tool to benchmark m3.xlarge instance. The operating system used for the purpose of this benchmarking was 64-bit Ubuntu Precise 12.04.

Application Benchmarking on AWS Using WikiBench

Benchmarking: CoreMark Scores & FIO Results between Instance Families for Better Performance

We thought that comparing CoreMark and FIO benchmark results for different instance families would be interesting. Essentially, it gives a good idea, and may help you decide, on which instance type you should use.

Benchmarking: Disk Bandwidth Analysis of c3 Instances using FIO

As in our previous posts on disk bandwidth benchmarking for ‘m’ and ‘i2’ instances (here and here), we used FIO to benchmark the disk performance of ‘c3’ instances.

Benchmarking: CPU Performance Analysis of c3 instances using CoreMark

Exploring Parallelism in IO Operations

In our earlier posts, we have used FIO tool for benchmarking I/O on various EC2 instances. In this post we have tried to explore the effects of parallelism in I/O operation on a single EC2 instance. In other words, we were trying to find the optimum number of parallel processes which are I/O bound and which results in best I/O throughput.

Benchmarking: Network Performance Analysis of i instances using Iperf

In a recent post we discussed our methodology for measuring bandwidth with Iperf and how to use Intel’s hardware virtualization drivers to take full advantage of the network card. Iperf is a popular network-benchmarking tool used for measuring bandwidth, packet loss, and delay jitter for the purpose of network tuning, and for creating TCP/UDP data streams. Read our previous post to learn more about Iperf and its installation and setup.

Benchmarking: Disk Bandwidth analysis of m instances|Part 2 FIO

In a previous post, FIO benchmark was used for four types of IO operations on storage-optimized instances:

Benchmarking: CPU Performance analysis of m instances|Part 1 Coremark

In previous posts we talked about micro-benchmarks that we ran for storage-optimized instances. Here we’ll talk about the same benchmarks run on general-purpose m1 and m3 instances. While the m1 is a previous-generation general-purpose instance type, the m3 is the current-generation version. One major difference between the two instances is that m1’s are based on Intel Xeon processors, while for m3 instances each vCPU is a hardware hyperthread from Intel Xeon E5-2670 processors. An m3 can be launched using both Paravirtual and hardware-assisted virtualization. For this post we used a paravirtual image for both m1’s and m3’s, and we used the Ubuntu 12.04 64-bit OS. Here are the details of all available instance types in the general-purpose category:

Benchmarking: Disk Bandwidth analysis of i instances | Part 2 FIO

In a previous post we discussed CoreMark, an industry standard for benchmarking CPU performance. In this post we’ll run IO benchmarks on i instances using the Flexible IO (FIO) tool.

Little’s Law- An insight on the relation between latency and throughput

I’ve been doing a lot of analysis of latency and throughput recently as a part of benchmarking work on databases. I thought I’d share some insights on how the two are related. For an overview of what these terms mean, check out Aater’s post describing the differences between them here.

Subscribe Here!

Posts by Topic

see all

Recent Posts