mysql_milan_latency

mysql_milan_thoughputX2

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

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
mysql_milan_thoughputX2
July 07 2023
  1 Hour, 28 Minutes
Invert Hiding All Results Option
  1 Hour, 49 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

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_thoughputX2Result OverviewPhoronix Test Suite100%126%151%177%202%MariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDB4096819212820482565121024641

mysql_milan_latencymysqlslap: 8192mysqlslap: 4096mysqlslap: 2048mysqlslap: 1024mysqlslap: 512mysqlslap: 256mysqlslap: 128mysqlslap: 64mysqlslap: 1mysql_milan_latencymysql_milan_thoughputmysql_milan_thoughputX213819132636637637444294835052033434835105245376551262344926238648251353354165612683485OpenBenchmarking.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: 8192mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency60120180240300SE +/- 2.25, N = 3SE +/- 0.10, N = 3SE +/- 0.38, N = 32622031381. (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_latency50100150200250Min: 259.88 / Avg: 262.46 / Max: 266.95Min: 203.17 / Avg: 203.27 / Max: 203.46Min: 136.95 / Avg: 137.69 / Max: 138.21. (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: 4096mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency80160240320400SE +/- 4.62, N = 3SE +/- 1.23, N = 3SE +/- 2.60, N = 33863431911. (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: 4096mysql_milan_thoughputX2mysql_milan_thoughputmysql_milan_latency70140210280350Min: 376.79 / Avg: 385.96 / Max: 391.54Min: 340.95 / Avg: 343.18 / Max: 345.18Min: 187.23 / Avg: 191.31 / Max: 196.161. (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_thoughputX2mysql_milan_thoughputmysql_milan_latency100200300400500SE +/- 0.81, N = 3SE +/- 0.59, N = 3SE +/- 1.85, N = 34824833261. (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_thoughputX2mysql_milan_thoughputmysql_milan_latency90180270360450Min: 481 / Avg: 482.4 / Max: 483.79Min: 482.16 / Avg: 482.86 / Max: 484.03Min: 322.58 / Avg: 325.93 / Max: 328.951. (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_latency110220330440550SE +/- 0.89, N = 3SE +/- 1.73, N = 3SE +/- 0.76, N = 35135103661. (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_latency90180270360450Min: 511.51 / Avg: 513.26 / Max: 514.4Min: 506.59 / Avg: 510.04 / Max: 511.77Min: 364.96 / Avg: 366.48 / Max: 367.241. (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_latency120240360480600SE +/- 2.17, N = 3SE +/- 1.94, N = 3SE +/- 0.50, N = 35335243761. (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_latency90180270360450Min: 528.54 / Avg: 532.88 / Max: 535.33Min: 520.29 / Avg: 524.12 / Max: 526.59Min: 375.52 / Avg: 376.27 / Max: 377.221. (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_latency120240360480600SE +/- 1.95, N = 3SE +/- 3.25, N = 3SE +/- 0.21, N = 35415373741. (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_latency100200300400500Min: 537.06 / Avg: 540.94 / Max: 543.18Min: 533.62 / Avg: 537.29 / Max: 543.77Min: 373.41 / Avg: 373.83 / Max: 374.111. (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_latency140280420560700SE +/- 2.34, N = 3SE +/- 3.88, N = 3SE +/- 5.52, N = 46566554421. (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_latency120240360480600Min: 651.89 / Avg: 656.47 / Max: 659.63Min: 647.67 / Avg: 655.35 / Max: 660.07Min: 431.03 / Avg: 441.85 / Max: 456.411. (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_latency30060090012001500SE +/- 11.51, N = 3SE +/- 12.08, N = 3SE +/- 8.36, N = 3126812629481. (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_latency2004006008001000Min: 1245.33 / Avg: 1268.17 / Max: 1282.05Min: 1239.16 / Avg: 1261.8 / Max: 1280.41Min: 932.84 / Avg: 948.31 / Max: 961.541. (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_thoughputX2mysql_milan_thoughputmysql_milan_latency8001600240032004000SE +/- 21.03, N = 3SE +/- 41.29, N = 3SE +/- 29.34, N = 33485344935051. (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_thoughputX2mysql_milan_thoughputmysql_milan_latency6001200180024003000Min: 3448.28 / Avg: 3484.57 / Max: 3521.13Min: 3367 / Avg: 3449.28 / Max: 3496.5Min: 3448.28 / Avg: 3505.17 / Max: 3546.11. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

9 Results Shown

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

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 02:43 by user .