Ampere Computing Logo
Contact Sales
Ampere Computing Logo
Hero Image

MySQL on AmpereOne

Open-source relational database management system.

Overview

MySQL is the most popular open source Relational Database Management System (“RDBMS”), which is developed, distributed, and supported by Oracle Corporation. It is used by most modern websites and web-based services as a convenient and fast access storage and retrieval solution for large volumes of data. MySQL Database Server is very fast, reliable, scalable, and easy to use.


In this workload brief, we compare AmpereOne® A192-32X to AMD EPYC 9654 and AMD EPYC 9754 processors running MySQL while measuring the throughput and latencies on each of these processors.

MySQL on AmpereOne® A192-32X

AmpereOne® A192-32X is designed to deliver exceptional performance for cloud native applications like MySQL. With an innovative architectural design, operating at consistent frequencies, and using single-threaded cores, applications will be more resistant to noisy neighbor issues. This allows workloads to run in a predictable manner with minimal variance under increasing loads.


The processors are also designed to deliver exceptional energy efficiency. This translates to industry leading performance/watt capabilities and a lower carbon footprint.


Benefits of running MySQL on AmpereOne® A192-32X

  • Cloud Native: Designed from the ground up for 'born in the cloud' workloads like MySQL, AmpereOne® A192-32X can deliver up to 27% higher performance than the best x86 servers

  • Energy Efficiency: With up to 192 energy-efficient Arm cores, AmpereOne® A192-32X can consume lower power while maintaining competitive levels of performance.

  • Lower Carbon Footprint: Industry-leading performance and high energy efficiency result in AmpereOne® A192-32X demonstrating up to 1.8x higher Performance/watt, leading to lower TCO and a smaller carbon footprint.

  • Consistency & Predictability: Singlethreaded cores running at fixed maximum frequencies ensure linear scaling under stringent SLAs and at high loads while running MySQL

Benchmarking Configuration

Sysbench is a multi-threaded benchmark tool. The tool can create a simple database schema, populate database tables with data, and generate multi-thread load (SQL queries) towards the database server.


The Sysbench OLTP load consists of the following seven basic SQL queries:

  • POINT_SELECT
  • SELECT_SIMPLE_RANGES
  • SELECT_SUM_RANGES
  • SELECT_ORDER_RANGES
  • SELECT_DISTINCT_RANGES
  • UPDATE_KEY
  • UPDATE_NO_KEY

We are running six tests which use above SQL queries as follows:

  • sb11-OLTP_RO_10M_8tab-uniform-dst_ranges1-notrx : 5
  • sb11-OLTP_RO_10M_8tab-uniform-notrx : 1+2+3+4+5
  • sb11-OLTP_RO_10M_8tab-uniform-p_sel1-notrx : 1
  • sb11-OLTP_RO_10M_8tab-uniform-s_ranges1-notrx : 2
  • sb11-OLTP_RW_10M_8tab-uniform-notrx : 1+2+3+4+5+6+7
  • sb11-OLTP_RW_10M_8tab-uniform-upd_idx1-notrx : 6

MySQL Server database storage is configured with RAMdisk filesystem and will consume whole socket cpu cores resources to handle request from Sysbench.

Since it is realistic to measure throughput under a specified Service Level Agreement (SLA), we have used a 95th percentile latency (p.95) of 1 millisecond. This ensures that 95 percent of the requests have a response time of 1 ms in the worst case.

We run the benchmark above on each platform and collect six test cases’ TPS results at P.95 of 1 millisecond and calculate GEOMEAN as a platform’s final score.

MySQL Performance and Energy Efficiency
Fig.1: Throughput (Higher is Better)
Fig.2: Performance/Watt (Higher is Better)
Benchmarking Results and Conclusions

As can be seen in the chart above, we observed up to 27% advantage in performance on AmpereOne® A192-32X compared to AMD EPYC 9654 "Genoa", and up to a 14% advantage in performance compared to AMD EPYC 9754 "Bergamo".

For large-scale cloud deployments, performance/Watt (i.e. energy efficiency) is an important metric in addition to raw performance. AmpereOne® A192-32X processors have 1.82x better performance/Watt under a specified SLA than that on AMD EPYC 9654 "Genoa" and 1.52x higher performance/watt compared to that on AMD EPYC 9754 "Bergamo"

MySQL is the most popular Relational Database Management System today. MySQL Database Server is very fast, reliable, scalable, and easy to use. AmpereOne® A192-32X processors are designed to deliver exceptional performance and energy efficiency for cloud native applications. In Ampere’s testing, these processors demonstrated up to 27% performance improvements and achieved up to 1.82x energy efficiency improvements.

Footnotes

All data and information contained herein is for informational purposes only and Ampere reserves the right to change it without notice. This document may contain technical inaccuracies, omissions and typographical errors, and Ampere is under no obligation to update or correct this information. Ampere makes no representations or warranties of any kind, including but not limited to express or implied guarantees of noninfringement, merchantability, or fitness for a particular purpose, and assumes no liability of any kind. All information is provided “AS IS.” This document is not an offer or a binding commitment by Ampere. Use of the products contemplated herein requires the subsequent negotiation and execution of a definitive agreement or is subject to Ampere’s Terms and Conditions for the Sale of Goods.

System configurations, components, software versions, and testing environments that differ from those used in Ampere’s tests may result in different measurements than those obtained by Ampere.

©2024 Ampere Computing. All Rights Reserved. Ampere, Ampere Computing, Altra and the ‘A’ logo are all registered trademarks or trademarks of Ampere Computing. Arm is a registered trademark of Arm Limited (or its subsidiaries). All other product names used in this publication are for identification purposes only and may be trademarks of their respective companies.

Ampere Computing® / 4655 Great America Parkway, Suite 601 / Santa Clara, CA 95054 / amperecomputing.com

Created At : September 6th 2024, 6:20:12 pm
Last Updated At : September 17th 2024, 8:59:05 pm
Ampere Logo

Ampere Computing LLC

4655 Great America Parkway Suite 601

Santa Clara, CA 95054

image
image
image
image
image
 |  |  |  |  |  | 
© 2024 Ampere Computing LLC. All rights reserved. Ampere, Altra and the A and Ampere logos are registered trademarks or trademarks of Ampere Computing.
This site is running on Ampere Altra Processors.