mysql_milan_latency

mysql_milan_thoughput

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2307071-NE-2307070NE17
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

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
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
Invert Hiding All Results Option
  2 Hours
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

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_latency vs. mysql_milan_thoughput ComparisonPhoronix Test SuiteBaseline+19.9%+19.9%+39.8%+39.8%+59.7%+59.7%79.6%48.2%48.2%47.1%43.6%39.4%39.3%33.1%409612820488192256512102464MariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBmysql_milan_latencymysql_milan_thoughput

mysql_milan_latencymysqlslap: 4096mysqlslap: 128mysqlslap: 2048mysqlslap: 8192mysqlslap: 256mysqlslap: 512mysqlslap: 1024mysqlslap: 64mysqlslap: 1mysql_milan_latencymysql_milan_thoughput191442326138374376366948350534365548320353752451012623449OpenBenchmarking.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_latencymysql_milan_thoughput70140210280350SE +/- 2.60, N = 3SE +/- 1.23, N = 31913431. (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_latencymysql_milan_thoughput140280420560700SE +/- 5.52, N = 4SE +/- 3.88, N = 34426551. (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_latencymysql_milan_thoughput100200300400500SE +/- 1.85, N = 3SE +/- 0.59, N = 33264831. (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_latencymysql_milan_thoughput4080120160200SE +/- 0.38, N = 3SE +/- 0.10, N = 31382031. (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_latencymysql_milan_thoughput120240360480600SE +/- 0.21, N = 3SE +/- 3.25, N = 33745371. (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_latencymysql_milan_thoughput110220330440550SE +/- 0.50, N = 3SE +/- 1.94, N = 33765241. (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_latencymysql_milan_thoughput110220330440550SE +/- 0.76, N = 3SE +/- 1.73, N = 33665101. (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_latencymysql_milan_thoughput30060090012001500SE +/- 8.36, N = 3SE +/- 12.08, N = 394812621. (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_thoughputmysql_milan_latency8001600240032004000SE +/- 41.29, N = 3SE +/- 29.34, N = 3344935051. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

9 Results Shown

MariaDB:
  4096
  128
  2048
  8192
  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

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 7 July 2023 00:53 by user .