MariaDB 10.6.11 performance 65% slower than MySQL 8.0.32

Server : DELL PowerEdge R7525 - Dual socket AMD EPYC 7543 32-Core Processor (64 core / 128 threads) - RAM : 512GB DDR4 - Storage : SSD SAS (OS) & NVMe (/var/lib) - OS : Ubuntu Server 22.04 ----------------------------------------------------------------------------- Tested DB version : MariaDB 10.6.11 & MySQL 8.0.32 DB Configuration : large_pages=ON skip-log-bin max_connections=4000 table_open_cache=8000 table_open_cache_instances=16 back_log=1500 performance_schema=OFF max_prepared_stmt_count=128000 transaction_isolation=REPEATABLE-READ innodb_file_per_table innodb_log_file_size=1024M innodb_log_files_in_group=32 innodb_open_files=4000 innodb_buffer_pool_size=200G innodb_buffer_pool_instances=16 innodb_log_buffer_size=64M innodb_doublewrite=0 innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=0 innodb_max_dirty_pages_pct=90 innodb_max_dirty_pages_pct_lwm=10 join_buffer_size=32K sort_buffer_size=32K innodb_use_native_aio=1 innodb_stats_persistent=1 innodb_spin_wait_delay=6 innodb_max_purge_lag_delay=300000 innodb_max_purge_lag=0 innodb_flush_method=O_DIRECT_NO_FSYNC innodb_checksum_algorithm=crc32 innodb_io_capacity=4000 innodb_io_capacity_max=20000 innodb_lru_scan_depth=9000 innodb_change_buffering=none innodb_read_only=0 innodb_page_cleaners=4 innodb_undo_log_truncate=off innodb_adaptive_flushing=1 innodb_flush_neighbors=0 innodb_read_io_threads=16 innodb_write_io_threads=16 innodb_purge_threads=4 innodb_adaptive_hash_index=0 ----------------------------------------------------------------------------- Benchmark software : HammerDB-4.6 *HammerDB is running on the same server as the DB. (Generated 800 warehouse) MariaDB run configuration : puts "MariaDB 10.6 Test Started" dbset db maria dbset bm TPC-C diset connection maria_socket /run/mysqld/mysqld.sock diset tpcc maria_driver timed diset tpcc maria_rampup 2 diset tpcc maria_duration 5 vuset logtotemp 1 vuset unique 1 loadscript foreach z {10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 300 310 320} { puts "$z VU test" vuset vu $z vucreate vurun runtimer 480 vudestroy } puts "MariaDB 10.6 Test Complete" MySQL run configuration : puts "Mysql 8 Test Started" dbset db mysql dbset bm TPC-C diset connection mysql_socket /var/run/mysqld/mysqld.sock diset tpcc mysql_driver timed diset tpcc mysql_rampup 2 diset tpcc mysql_duration 5 vuset logtotemp 1 vuset unique 1 loadscript foreach z {10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 300 310 320} { puts "$z VU test" vuset vu $z vucreate vurun runtimer 480 vudestroy } puts "Mysql 8 Test Complete"