Get Better MySQL Transactional Database Performance with AWS M6i Instances Featuring 3rd Gen Intel® Xeon® Scalable Processors
Transactional databases, which power not only ecommerce sites but also back payroll, trades, hotel reservations, and other such workloads, can process more transactions with the latest processing technology. To get the most out of your cloud-based online transaction processing (OLTP) MySQL databases select AWS M6i Instances enabled by 3rd Gen Intel® Xeon® Scalable processors over M5n instances with older processors.
In tests using a TPROC-C workload from the HammerDB benchmark to assess MySQL database performance, AWS M6i instances featuring 3rd Gen Intel Xeon Scalable processors delivered consistently more transactions per minute (TPM) than M5n instances with previous-generation processors at multiple instance sizes. When your organization selects instances that allow for more trades or hotel reservations at a time, you reduce monthly cloud operating expenses 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 M5n instances, processing 1.33x the MySQL workload TPM.
Comparing MySQL Performance for Medium-Sized Instances with 16 vCPUs
When doubling the vCPU count to 16, AWS M6i instances with 3rd Gen Intel® Xeon® Scalable processors once again improved performance. As Figure 2 shows, M6i instances with 3rd Gen Intel Xeon Scalable processors provided 1.26x the MySQL database performance than M5n instances.
Comparing MySQL Performance for Large Instances with 64 vCPUs
For larger databases with 64 vCPUs, M6i instances with 3rd Gen Intel Xeon Scalable processors provided 1.42x the MySQL database performance than M5n instances (see Figure 3).
Across three different instance sizes, AWS M6i instances with 3rd Gen Intel Xeon Scalable processors offered significantly better transactional database performance than M5n instances with previous-generation processors. When your organization chooses the latest technology for cloud database hosting, you can expect to handle extra hotel reservations, finish payroll faster, or sign up more club members at a time.
To begin running your MySQL database workloads on AWS M6i Instances with 3rd Gen Intel Xeon Scalable processors, visit http://thailand.intel.com/aws.
To learn more about the test results and configurations, visit http://facts.pt/AFo3h25.