xeon mysql

Intel Xeon E-2288G testing with a Supermicro X11SCL-F v1.01 (1.0b BIOS) and ASPEED on AlmaLinux 8.5 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 2202150-NE-XEONMYSQL43
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
A
February 15 2022
  2 Hours, 18 Minutes
B
February 15 2022
  1 Hour, 43 Minutes
C
February 15 2022
  1 Hour, 39 Minutes
D
February 15 2022
  2 Hours, 34 Minutes
Invert Hiding All Results Option
  2 Hours, 3 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):

A

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

B

C

D

Processor: Intel Xeon E-2288G @ 5.00GHz (8 Cores / 16 Threads), Motherboard: Supermicro X11SCL-F v1.01 (1.0b BIOS), Chipset: Intel Cannon Lake PCH, Memory: 4 x 32 GB DDR4-3200MT/s Samsung M391A4G43BB1-CWE, Disk: 2 x 480GB SAMSUNG MZ7L3480, Graphics: ASPEED, Monitor: DELL E207WFP, Network: 2 x Intel I210

OS: AlmaLinux 8.5, Kernel: 4.18.0-348.12.2.el8_5.x86_64 (x86_64), Compiler: GCC 8.5.0 20210514, File-System: ext4, Screen Resolution: 1680x1050

xeon mysqlOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon E-2288G @ 5.00GHz (8 Cores / 16 Threads)Supermicro X11SCL-F v1.01 (1.0b BIOS)Intel Cannon Lake PCH4 x 32 GB DDR4-3200MT/s Samsung M391A4G43BB1-CWE2 x 480GB SAMSUNG MZ7L3480ASPEEDDELL E207WFP2 x Intel I210AlmaLinux 8.54.18.0-348.12.2.el8_5.x86_64 (x86_64)GCC 8.5.0 20210514ext41680x1050ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionXeon Mysql BenchmarksSystem Logs- Transparent Huge Pages: always- --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver - Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea - itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

ABCDResult OverviewPhoronix Test Suite100%102%104%106%MariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDBMariaDB102432168164256128512

xeon mysqlmysqlslap: 1mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512mysqlslap: 1024ABCD110725792508539841794826713707255111125683503439331811829716709258111545716506537891784825713705275109545704494438561784824707707275OpenBenchmarking.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 10.8.2Clients: 1ABCD2K4K6K8K10KSE +/- 107.54, N = 3SE +/- 71.29, N = 3SE +/- 82.31, N = 3SE +/- 157.60, N = 3110721111211154109541. (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 10.8.2Clients: 1ABCD2K4K6K8K10KMin: 10869.57 / Avg: 11072.21 / Max: 11235.96Min: 10989.01 / Avg: 11112.03 / Max: 11235.96Min: 10989.01 / Avg: 11153.64 / Max: 11235.96Min: 10638.3 / Avg: 10953.51 / Max: 11111.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 10.8.2Clients: 8ABCD12002400360048006000SE +/- 29.67, N = 3SE +/- 48.96, N = 3SE +/- 64.58, N = 3SE +/- 28.61, N = 357925683571657041. (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 10.8.2Clients: 8ABCD10002000300040005000Min: 5747.13 / Avg: 5791.81 / Max: 5847.95Min: 5586.59 / Avg: 5682.67 / Max: 5747.13Min: 5586.59 / Avg: 5715.76 / Max: 5780.35Min: 5649.72 / Avg: 5703.71 / Max: 5747.131. (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 10.8.2Clients: 16ABCD11002200330044005500SE +/- 8.63, N = 3SE +/- 34.36, N = 13SE +/- 35.03, N = 13SE +/- 57.30, N = 350855034506549441. (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 10.8.2Clients: 16ABCD9001800270036004500Min: 5076.14 / Avg: 5084.78 / Max: 5102.04Min: 4784.69 / Avg: 5033.79 / Max: 5235.6Min: 4854.37 / Avg: 5065.24 / Max: 5235.6Min: 4854.37 / Avg: 4943.66 / Max: 5050.511. (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 10.8.2Clients: 32ABCD9001800270036004500SE +/- 35.99, N = 7SE +/- 40.16, N = 5SE +/- 49.77, N = 3SE +/- 13.09, N = 339843933378938561. (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 10.8.2Clients: 32ABCD7001400210028003500Min: 3846.15 / Avg: 3983.76 / Max: 4115.23Min: 3773.58 / Avg: 3932.51 / Max: 3984.06Min: 3690.04 / Avg: 3789.2 / Max: 3846.15Min: 3831.42 / Avg: 3856.13 / Max: 3875.971. (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 10.8.2Clients: 64ABCD400800120016002000SE +/- 9.37, N = 3SE +/- 4.76, N = 3SE +/- 2.81, N = 3SE +/- 9.10, N = 317941811178417841. (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 10.8.2Clients: 64ABCD30060090012001500Min: 1779.36 / Avg: 1794.36 / Max: 1811.59Min: 1801.8 / Avg: 1810.53 / Max: 1818.18Min: 1779.36 / Avg: 1783.6 / Max: 1788.91Min: 1773.05 / Avg: 1783.68 / Max: 1801.81. (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 10.8.2Clients: 128ABCD2004006008001000SE +/- 1.04, N = 3SE +/- 2.63, N = 3SE +/- 0.91, N = 3SE +/- 3.95, N = 38268298258241. (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 10.8.2Clients: 128ABCD150300450600750Min: 824.4 / Avg: 825.77 / Max: 827.81Min: 823.72 / Avg: 828.98 / Max: 831.95Min: 824.4 / Avg: 825.31 / Max: 827.13Min: 816.33 / Avg: 824.21 / Max: 828.51. (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 10.8.2Clients: 256ABCD150300450600750SE +/- 3.98, N = 3SE +/- 5.75, N = 3SE +/- 4.48, N = 3SE +/- 1.36, N = 37137167137071. (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 10.8.2Clients: 256ABCD130260390520650Min: 705.72 / Avg: 713.48 / Max: 718.91Min: 704.72 / Avg: 715.74 / Max: 724.11Min: 703.73 / Avg: 712.65 / Max: 717.88Min: 704.23 / Avg: 706.89 / Max: 708.721. (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 10.8.2Clients: 512ABCD150300450600750SE +/- 3.53, N = 3SE +/- 1.85, N = 3SE +/- 1.58, N = 3SE +/- 0.88, N = 37077097057071. (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 10.8.2Clients: 512ABCD120240360480600Min: 701.26 / Avg: 706.58 / Max: 713.27Min: 706.71 / Avg: 708.56 / Max: 712.25Min: 702.25 / Avg: 705.06 / Max: 707.71Min: 705.72 / Avg: 707.05 / Max: 708.721. (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 10.8.2Clients: 1024ABCD60120180240300SE +/- 6.67, N = 6SE +/- 1.88, N = 3SE +/- 3.26, N = 3SE +/- 6.15, N = 82552582752751. (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 10.8.2Clients: 1024ABCD50100150200250Min: 224.77 / Avg: 254.73 / Max: 268.17Min: 254.45 / Avg: 258 / Max: 260.82Min: 269.54 / Avg: 275.18 / Max: 280.82Min: 250.94 / Avg: 274.75 / Max: 297.711. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lpcre2-8 -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

9 Results Shown

MariaDB:
  1
  8
  16
  32
  64
  128
  256
  512
  1024

A

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

Testing initiated at 15 February 2022 11:09 by user .

B

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

Testing initiated at 15 February 2022 14:20 by user .

C

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

Testing initiated at 15 February 2022 16:12 by user .

D

Processor: Intel Xeon E-2288G @ 5.00GHz (8 Cores / 16 Threads), Motherboard: Supermicro X11SCL-F v1.01 (1.0b BIOS), Chipset: Intel Cannon Lake PCH, Memory: 4 x 32 GB DDR4-3200MT/s Samsung M391A4G43BB1-CWE, Disk: 2 x 480GB SAMSUNG MZ7L3480, Graphics: ASPEED, Monitor: DELL E207WFP, Network: 2 x Intel I210

OS: AlmaLinux 8.5, Kernel: 4.18.0-348.12.2.el8_5.x86_64 (x86_64), Compiler: GCC 8.5.0 20210514, File-System: ext4, Screen Resolution: 1680x1050

Kernel Notes: Transparent Huge Pages: always
Compiler Notes: --build=x86_64-redhat-linux --disable-libmpx --disable-libunwind-exceptions --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-multilib --enable-offload-targets=nvptx-none --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 --without-cuda-driver
Processor Notes: Scaling Governor: intel_pstate performance (EPP: performance) - CPU Microcode: 0xea
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + 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: Mitigation of TSX disabled + tsx_async_abort: Mitigation of TSX disabled

Testing initiated at 15 February 2022 19:33 by user .