Select AWS EC2 M6i Instances and Support up to 1.38x the Ecommerce Transactions for MySQL Databases vs. AWS EC2 M5 Instances

Title:

  • Process 1.32x the MySQL database TPM on small M6i instances with 3rd Gen Intel® Xeon® Scalable processors vs. M5 instances.

  • Process 1.38x the MySQL TPM on medium-sized M6i instances with 3rd Gen Intel® Xeon® Scalable processors vs. M5 instances.

author-image

By

Handle more transactions per minute with AWS M6i Instances Featuring 3rd Gen Intel® Xeon® Scalable Processors

Increases in ecommerce sales make it vital that organizations running these workloads maximize database performance in their cloud instances to keep up with peak demands. For various sizes of online transaction processing (OLTP) databases, AWS M6i Instances enabled by 3rd Gen Intel® Xeon® Scalable processors provide greater performance than M5 instances with older processors. Using a TPROC-C workload from the HammerDB benchmark to assess MySQL database performance, testing shows that for small (8 vCPU) AWS instances, M6i instances featuring 3rd Gen Intel® Xeon® Scalable processors delivered 1.32x the transactions per minute (TPM) than M5 instances. Medium-sized 16-vCPU AWS M6i instances also offered better OLTP performance than M5 instances, providing 1.38x the TPM. By choosing instances that can accommodate more ecommerce transactions, your organization can keep monthly cloud operating expenses down by doing the same amount of work with fewer instances.

Comparing MySQL Performance for Small Instances with 8 vCPUs

As Figure 1 shows, 8-vCPU M6i instances enabled by 3rd Gen Intel® Xeon® Scalable processors outperformed 8-vCPU M5 instances, processing 1.32x the MySQL workload TPM.

Figure 1. Relative results comparing the MySQL database transactions per minute of 8-vCPU M6i instances with 3rd Gen Intel® Xeon® Scalable processors vs. 8-vCPU M5 instances with older processors.

Comparing MySQL Performance for Medium-Sized Instances with 16 vCPUs

When benchmarking OLTP workload performance on medium-sized instances, the performance gains of the smaller instance sizes held. The AWS m6i.4xlarge instance with 3rd Gen Intel® Xeon® Scalable processors once again increased performance significantly.

As Figure 2 shows, M6i instances with 3rd Gen Intel® Xeon® Scalable processors provided 1.38x the MySQL database performance than M5 instances.

Figure 2. Relative results comparing the MySQL database transactions per minute of 16-vCPU M6i instances with 3rd Gen Intel® Xeon® Scalable processors vs. 16-vCPU M5 instances with older processors.

Learn More

To begin running your MySQL workloads on AWS M6i Instances with 3rd Gen Intel® Xeon® Scalable processors, visit http://intel.com/aws.

To learn more about the test results and configurations, visit http://facts.pt/lpGOWpp.