test-mysqlslap

KVM testing on Ubuntu 20.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2205195-IB-TESTMYSQL13
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
16 x Intel Xeon Gold 6240R - Cirrus Logic GD 5446 -
May 19 2022
  51 Minutes

16 x Intel Xeon Gold 6240R - Cirrus Logic GD 5446 -

Processor: 16 x Intel Xeon Gold 6240R (16 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.13.0-1ubuntu1.1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 16384 MB + 12288 MB RAM, Disk: 43GB QEMU HDD, Graphics: Cirrus Logic GD 5446, Network: Red Hat Virtio device

OS: Ubuntu 20.04, Kernel: 5.4.0-110-generic (x86_64), File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: CPU Microcode: 0x1
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

test-mysqlslapOpenBenchmarking.orgPhoronix Test Suite16 x Intel Xeon Gold 6240R (16 Cores)QEMU Standard PC (i440FX + PIIX 1996) (1.13.0-1ubuntu1.1 BIOS)Intel 440FX 82441FX PMC16384 MB + 12288 MB RAM43GB QEMU HDDCirrus Logic GD 5446Red Hat Virtio deviceUbuntu 20.045.4.0-110-generic (x86_64)ext41024x768KVMProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelFile-SystemScreen ResolutionSystem LayerTest-mysqlslap BenchmarksSystem Logs- Transparent Huge Pages: madvise- CPU Microcode: 0x1- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.8.2Clients: 25616 x Intel Xeon Gold 6240R - Cirrus Logic GD 5446 -4080120160200SE +/- 0.89, N = 31991. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

16 x Intel Xeon Gold 6240R - Cirrus Logic GD 5446 -

Processor: 16 x Intel Xeon Gold 6240R (16 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.13.0-1ubuntu1.1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 16384 MB + 12288 MB RAM, Disk: 43GB QEMU HDD, Graphics: Cirrus Logic GD 5446, Network: Red Hat Virtio device

OS: Ubuntu 20.04, Kernel: 5.4.0-110-generic (x86_64), File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: CPU Microcode: 0x1
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 19 May 2022 17:00 by user root.