mysql_milan_latency

mysql_milan_thoughput_rq

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2307108-NE-2307103NE50
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
mysql_milan_thoughput_rq
July 10 2023
  1 Hour, 37 Minutes
Invert Behavior (Only Show Selected Data)
  1 Hour, 43 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

mysql_milan_thoughput_rq

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_irqmysql_milan_thoughput_rqResult 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_irqmysql_milan_thoughput_rq191138442326374376366948350534320365548353752451012623449386262656482541533513126834853382016534815295235071259350534220064147352551549812703452OpenBenchmarking.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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency80160240320400SE +/- 1.06, N = 3SE +/- 1.68, N = 3SE +/- 4.62, N = 3SE +/- 1.23, N = 3SE +/- 2.60, N = 33423383863431911. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency60120180240300SE +/- 0.71, N = 3SE +/- 0.18, N = 2SE +/- 2.25, N = 3SE +/- 0.10, N = 3SE +/- 0.38, N = 32002012622031381. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency140280420560700SE +/- 0.14, N = 3SE +/- 1.11, N = 3SE +/- 2.34, N = 3SE +/- 3.88, N = 3SE +/- 5.52, N = 46416536566554421. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency100200300400500SE +/- 1.46, N = 3SE +/- 1.43, N = 3SE +/- 0.81, N = 3SE +/- 0.59, N = 3SE +/- 1.85, N = 34734814824833261. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency120240360480600SE +/- 0.91, N = 3SE +/- 1.35, N = 3SE +/- 1.95, N = 3SE +/- 3.25, N = 3SE +/- 0.21, N = 35255295415373741. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency120240360480600SE +/- 1.02, N = 3SE +/- 2.51, N = 3SE +/- 2.17, N = 3SE +/- 1.94, N = 3SE +/- 0.50, N = 35155235335243761. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency110220330440550SE +/- 0.22, N = 3SE +/- 1.16, N = 3SE +/- 0.89, N = 3SE +/- 1.73, N = 3SE +/- 0.76, N = 34985075135103661. (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_thoughput_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency30060090012001500SE +/- 8.29, N = 3SE +/- 10.47, N = 3SE +/- 11.51, N = 3SE +/- 12.08, N = 3SE +/- 8.36, N = 312701259126812629481. (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_rqmysql_milan_thoughput_irqmysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency8001600240032004000SE +/- 3.98, N = 3SE +/- 10.81, N = 3SE +/- 21.03, N = 3SE +/- 41.29, N = 3SE +/- 29.34, N = 3345235053485344935051. (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

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 .

mysql_milan_thoughput_rq

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 10 July 2023 03:32 by user .