Company
Solutions
Developers
Careers
Search
EN
EN
Ampere Computing Logo
Solutions
Solutions Home
Systems
Solutions
Performance Overview
Workload Briefs Overview
Tuning Guides Overview
Where to Try
Ampere Systems
Ampere Altra
Azure
Equinix
Google Cloud
Oracle
Tencent Cloud
Ampere AIDownloadsHow It WorksFAQs
Developers
Developer CenterDesigning Cloud ApplicationsBuilding Cloud ApplicationsDeploying Cloud ApplicationsUsing Your DataEnabling the Open-Source CommunityAmpere Ready Software
Support
Search
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.

Created At : April 14th 2022, 4:02:53 pm
Last Updated At : August 29th 2022, 3:46:58 pm

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.