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.
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.