Company
Solutions
Support
Search
Ampere Computing Logo
Solutions
SupportBlogCareers
Search
Solutions Home
Systems
Solutions
Performance Overview
Briefs Overview
Where to Try
Ampere Systems
Ampere Altra
Equinix
Google Cloud
Oracle
Tencent Cloud
Ampere AIDownloadsHow It WorksResources FAQs
MySQL Test Notes

MySQL tests were performed on bare-metal single socket servers with equivalent memory, networking and storage configurations for each of the platforms shown. The processors tested here are: AMD EPYC 7763 "Milan"; Intel Xeon 8380 "Ice Lake"; Ampere Altra Q80-30; Ampere Altra Max M128-30

This test was accomplished using the Sysbench multi-threaded benchmark tool. The tool can create database schemas, populate tables with data, and generate multi-thread load (SQL queries) towards the database server.

Six OLTP tests were run which use the following SQL queries:

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

Sysbench was deployed on different CPU sockets with Mysql Server and database connection is through TCP/IP socket interface over loopback IP address.

The Mysql server storage was configured as a RAMdisk filesystem.

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

The above benchmark was run on all platforms and six test cases’ TPS results at P.95 of 1 millisecond were collected and the geomean of those was used as the platform’s final score.

Ampere Computing

4655 Great America Parkway

Suite 601 Santa Clara, CA 95054

Tel: +1-669-770-3700

info[at]amperecomputing.com

About
image
image
image
image
© 2022 Ampere Computing LLC. All rights reserved. Ampere, Altra and the A and Ampere logos are registered trademarks or trademarks of Ampere Computing.