| Property | Value |
|---|---|
| Platform | Linux |
| Release | Ubuntu 24.04 LTS (noble) |
| Kernel | 6.8.0-60-generic |
| Architecture | CPU = 64-bit, OS = 64-bit |
| Processors | physical = 2, cores = 40, virtual = 80, hyperthreading = yes |
| Models | 80x Intel(R) Xeon(R) Gold 6230 CPU @ 2.10GHz |
| Memory Total | 187.5G |
| Parameter | Value |
|---|---|
| Test Type | OLTP Read-Write disabled binlog |
| Tables | 20 |
| Rows per table | 5,000,000 |
| Test duration | 900s (15 min) |
| Scripts and data files | ↗ GitHub |
| Schema | ↓ Download SQL |
| Dimension | Details |
|---|---|
| Primary subject | Investigating the performance difference between Percona Server 8.4.8-8 and MySQL 8.4.8 on OLTP Read-Write workloads across varying thread counts and memory configurations |
| Reference servers | MySQL 8.4.8, MySQL 9.7.0-er2, Percona Server 8.4.8 — included for cross-product context, not the focus of this benchmark |
| Memory tiers (innodb_buffer_pool_size) | 12 GB — moderate buffer pool configuration |
| Buffer pool instances (BP<N>) | Default (2 for 12GB), 4, and 8 instances tested for Percona Server |
| Client threads | 32 and 64 threads |