alderlake-mysql-mariadb-intel Intel Core i9-12900K testing with a ASUS ROG STRIX Z690-E GAMING WIFI (0811 BIOS) and AMD Radeon RX 6800 XT 16GB on Ubuntu 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2202158-PTS-ALDERLAK91&rdt .
alderlake-mysql-mariadb-intel Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution A AA Intel Core i9-12900K @ 6.50GHz (16 Cores / 24 Threads) ASUS ROG STRIX Z690-E GAMING WIFI (0811 BIOS) Intel Device 7aa7 64GB 1000GB Western Digital WDS100T1X0E-00AFY0 + 2000GB AMD Radeon RX 6800 XT 16GB (2575/1000MHz) Intel Device 7ad0 ASUS VP28U Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 22.04 5.17.0-051700rc3daily20220211-generic (x86_64) GNOME Shell 41.3 X Server + Wayland 4.6 Mesa 22.1.0-devel (git-3d41414 2022-02-13 jammy-oibaf-ppa) (LLVM 13.0.0 DRM 3.44) 1.3.204 GCC 11.2.0 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-O5cEXJ/gcc-11-11.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-O5cEXJ/gcc-11-11.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details - Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x15 - Thermald 2.4.7 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
alderlake-mysql-mariadb-intel mysqlslap: 4096 mysqlslap: 1 mysqlslap: 8 mysqlslap: 16 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 mysqlslap: 512 mysqlslap: 1024 A AA 209 7426 2871 3018 1947 934 456 411 431 193 OpenBenchmarking.org
MariaDB Clients: 4096 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 4096 A 50 100 150 200 250 SE +/- 2.97, N = 3 209 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 1 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 1 AA 1600 3200 4800 6400 8000 SE +/- 18.43, N = 3 7426 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 8 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 8 AA 600 1200 1800 2400 3000 SE +/- 10.95, N = 3 2871 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 16 AA 600 1200 1800 2400 3000 SE +/- 8.02, N = 3 3018 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 32 AA 400 800 1200 1600 2000 SE +/- 17.67, N = 3 1947 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 64 AA 200 400 600 800 1000 SE +/- 2.10, N = 3 934 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 128 AA 100 200 300 400 500 SE +/- 1.38, N = 3 456 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 256 AA 90 180 270 360 450 SE +/- 2.09, N = 3 411 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 512 AA 90 180 270 360 450 SE +/- 1.40, N = 3 431 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 1024 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 1024 AA 40 80 120 160 200 SE +/- 0.58, N = 3 193 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
Phoronix Test Suite v10.8.5