mysql_milan_latency

mysql_milan_thoughput_irq

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

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Toggle/Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
mysql_milan_latency
July 06 2023
  2 Hours, 24 Minutes
mysql_milan_thoughput
July 07 2023
  1 Hour, 35 Minutes
mysql_milan_thoughputX2
July 07 2023
  1 Hour, 28 Minutes
mysql_milan_thoughput_irq
July 09 2023
  1 Hour, 32 Minutes
Invert Behavior (Only Show Selected Data)
  1 Hour, 45 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

mysql_milan_latency

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic
Processor Notes: CPU Microcode: 0x1000065
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

mysql_milan_thoughput

mysql_milan_thoughputX2

mysql_milan_thoughput_irq

Processor: AMD EPYC 7T83 64-Core (4 Cores / 8 Threads), Motherboard: Alibaba Cloud ECS (0.1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 2 x 16 GB RAM, Disk: 40GB, Graphics: bochs-drmdrmfb, Network: Red Hat Virtio device

OS: AlibabaCloud 3, Kernel: 5.10.134-13.1.al8.x86_64 (x86_64), Compiler: GCC 10.2.1 20200825, File-System: ext4, Screen Resolution: 1024x768, System Layer: vm-other

mysql_milan_latencyOpenBenchmarking.orgPhoronix Test SuiteAMD EPYC 7T83 64-Core (4 Cores / 8 Threads)Alibaba Cloud ECS (0.1 BIOS)Intel 440FX 82441FX PMC2 x 16 GB RAM40GBbochs-drmdrmfbRed Hat Virtio deviceAlibabaCloud 35.10.134-13.1.al8.x86_64 (x86_64)GCC 10.2.1 20200825ext41024x768vm-otherProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerMysql_milan_latency BenchmarksSystem Logs- Transparent Huge Pages: always- --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic - CPU Microcode: 0x1000065- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

mysql_milan_latencymysql_milan_thoughputmysql_milan_thoughputX2mysql_milan_thoughput_irqResult OverviewPhoronix Test Suite100%126%151%177%202%MariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDB4096819212820482565121024641

mysql_milan_latencymysqlslap: 4096mysqlslap: 8192mysqlslap: 128mysqlslap: 2048mysqlslap: 256mysqlslap: 512mysqlslap: 1024mysqlslap: 64mysqlslap: 1mysql_milan_latencymysql_milan_thoughputmysql_milan_thoughputX2mysql_milan_thoughput_irq1911384423263743763669483505343203655483537524510126234493862626564825415335131268348533820165348152952350712593505OpenBenchmarking.org

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 11.0.1Clients: 4096mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency80160240320400SE +/- 4.62, N = 3SE +/- 1.23, N = 3SE +/- 1.68, N = 3SE +/- 2.60, N = 33863433381911. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 8192mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency60120180240300SE +/- 2.25, N = 3SE +/- 0.10, N = 3SE +/- 0.18, N = 2SE +/- 0.38, N = 32622032011381. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 128mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency140280420560700SE +/- 2.34, N = 3SE +/- 3.88, N = 3SE +/- 1.11, N = 3SE +/- 5.52, N = 46566556534421. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 2048mysql_milan_thoughputmysql_milan_thoughputX2mysql_milan_thoughput_irqmysql_milan_latency100200300400500SE +/- 0.59, N = 3SE +/- 0.81, N = 3SE +/- 1.43, N = 3SE +/- 1.85, N = 34834824813261. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 256mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency120240360480600SE +/- 1.95, N = 3SE +/- 3.25, N = 3SE +/- 1.35, N = 3SE +/- 0.21, N = 35415375293741. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 512mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency120240360480600SE +/- 2.17, N = 3SE +/- 1.94, N = 3SE +/- 2.51, N = 3SE +/- 0.50, N = 35335245233761. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 1024mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency110220330440550SE +/- 0.89, N = 3SE +/- 1.73, N = 3SE +/- 1.16, N = 3SE +/- 0.76, N = 35135105073661. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 64mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_thoughput_irqmysql_milan_latency30060090012001500SE +/- 11.51, N = 3SE +/- 12.08, N = 3SE +/- 10.47, N = 3SE +/- 8.36, N = 31268126212599481. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.0.1Clients: 1mysql_milan_thoughput_irqmysql_milan_latencymysql_milan_thoughputX2mysql_milan_thoughput8001600240032004000SE +/- 10.81, N = 3SE +/- 29.34, N = 3SE +/- 21.03, N = 3SE +/- 41.29, N = 335053505348534491. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

9 Results Shown

MariaDB:
  4096
  8192
  128
  2048
  256
  512
  1024
  64
  1

mysql_milan_latency

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic
Processor Notes: CPU Microcode: 0x1000065
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 6 July 2023 21:19 by user .

mysql_milan_thoughput

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic
Processor Notes: CPU Microcode: 0x1000065
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 7 July 2023 00:53 by user .

mysql_milan_thoughputX2

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic
Processor Notes: CPU Microcode: 0x1000065
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 7 July 2023 02:43 by user .

mysql_milan_thoughput_irq

Processor: AMD EPYC 7T83 64-Core (4 Cores / 8 Threads), Motherboard: Alibaba Cloud ECS (0.1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 2 x 16 GB RAM, Disk: 40GB, Graphics: bochs-drmdrmfb, Network: Red Hat Virtio device

OS: AlibabaCloud 3, Kernel: 5.10.134-13.1.al8.x86_64 (x86_64), Compiler: GCC 10.2.1 20200825, File-System: ext4, Screen Resolution: 1024x768, System Layer: vm-other

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libunwind-exceptions --disable-multilib --enable-__cxa_atexit --enable-bootstrap --enable-cet --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,fortran,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-gcc-major-version-only --with-isl --with-linker-hash-style=gnu --with-tune=generic
Processor Notes: CPU Microcode: 0x1000065
Security Notes: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 9 July 2023 21:46 by user .