TPROCC

MDEV-32750 AHI ON FINDING PEAK USER THREADS: 10.4.10 vs 10.11.4 vs 11.8.4

Comparison: PAYMENT_ratio

Threads	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
8	24.500	9.786	22.500
16	23.099	9.642	22.476
24	21.929	9.404	22.463
32	20.705	9.141	22.614
48	18.260	9.535	22.917
64	15.655	10.579	22.973
96	10.503	10.723	22.842
128	14.903	10.459	22.891
256	20.879	10.390	22.465

System Info (per dataset)

Property	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Host	hz-bench-jeb2	hz-bench-jeb2	hz-bench-jeb2
CPU	AMD EPYC 9454 48-Core Processor	AMD EPYC 9454 48-Core Processor	AMD EPYC 9454 48-Core Processor
CPU Count	96	96	96
Core Count	48	48	48
Socket Count	1	1	1
OS	Linux	Linux	Linux
OS Version	AlmaLinux 9.8 (Olive Jaguar)	AlmaLinux 9.8 (Olive Jaguar)	AlmaLinux 9.8 (Olive Jaguar)
OS Kernel	5.14.0-687.29.1.el9_8.x86_64	5.14.0-687.29.1.el9_8.x86_64	5.14.0-687.29.1.el9_8.x86_64
RAM	124.98 GB	124.98 GB	124.98 GB

Database Info (per dataset)

Property	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Database Maker	mariadb	mariadb	mariadb
Database Version	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Engine	InnoDB	InnoDB	InnoDB
Install Dir	mariadb-10.4.10-linux-systemd-x86_64	mariadb-10.11.4	mariadb-11.8.4
DB Config Origin	USER_PROPERTIES_INLINE_BLOCK	USER_PROPERTIES_INLINE_BLOCK	USER_PROPERTIES_INLINE_BLOCK
DB Config Source File	MDEV-32750.tprocc.complex.cfg.ahi_on.properties	MDEV-32750.tprocc.complex.cfg.ahi_on.properties	MDEV-32750.tprocc.complex.cfg.ahi_on.properties
DB Generated Config Run File	mariadb_2026_10_1_00_54_12.cnf	mariadb_2026_10_1_21_12_17.cnf	mariadb_2026_10_2_14_21_18.cnf
Config Contents	slave_parallel_mode=optimistic read_rnd_buffer_size=8M max_connections=2000 thread_handling=pool-of-threads event_scheduler=ON read_buffer_size=8M binlog_stmt_cache_size=512K query_cache_type=0 innodb_flush_log_at_trx_commit=1 innodb_read_io_threads=24 performance_schema_consumer_events_statements_history_long=OFF slave_parallel_threads=24 performance_schema=ON innodb_io_capacity_max=20000 binlog_format=STATEMENT innodb_buffer_pool_instances=1 table_open_cache_instances=1 innodb_io_capacity=2000 innodb_log_file_size=2G innodb_flush_method=O_DIRECT innodb_checksum_algorithm=CRC32 binlog_checksum=NONE binlog_cache_size=512K optimizer_switch=index_merge=on,index_condition_pushdown=on,derived_merge=on,semijoin=on,materialization=on sort_buffer_size=2M table_open_cache=24000 log_slave_updates=ON innodb_buffer_pool_size=64G innodb_file_per_table=ON innodb_buffer_pool_chunk_size=128M sync_binlog=1 join_buffer_size=256K innodb_write_io_threads=24 performance_schema_consumer_events_statements_current=ON innodb_adaptive_hash_index=1 performance_schema_consumer_events_statements_history=OFF query_cache_size=0 table_definition_cache=24000 innodb_log_buffer_size=4G innodb_flush_neighbors=0	slave_parallel_mode=optimistic read_rnd_buffer_size=8M max_connections=2000 thread_handling=pool-of-threads event_scheduler=ON read_buffer_size=8M binlog_stmt_cache_size=512K query_cache_type=0 innodb_flush_log_at_trx_commit=1 innodb_read_io_threads=24 performance_schema_consumer_events_statements_history_long=OFF slave_parallel_threads=24 performance_schema=ON innodb_io_capacity_max=20000 binlog_format=STATEMENT innodb_buffer_pool_instances=1 table_open_cache_instances=1 innodb_io_capacity=2000 innodb_log_file_size=2G innodb_flush_method=O_DIRECT innodb_checksum_algorithm=CRC32 binlog_checksum=NONE binlog_cache_size=512K optimizer_switch=index_merge=on,index_condition_pushdown=on,derived_merge=on,semijoin=on,materialization=on sort_buffer_size=2M table_open_cache=24000 log_slave_updates=ON innodb_buffer_pool_size=64G innodb_file_per_table=ON innodb_buffer_pool_chunk_size=128M sync_binlog=1 join_buffer_size=256K innodb_write_io_threads=24 performance_schema_consumer_events_statements_current=ON innodb_adaptive_hash_index=1 performance_schema_consumer_events_statements_history=OFF query_cache_size=0 table_definition_cache=24000 innodb_log_buffer_size=4G innodb_flush_neighbors=0	slave_parallel_mode=optimistic read_rnd_buffer_size=8M max_connections=2000 thread_handling=pool-of-threads event_scheduler=ON read_buffer_size=8M binlog_stmt_cache_size=512K query_cache_type=0 innodb_flush_log_at_trx_commit=1 innodb_read_io_threads=24 performance_schema_consumer_events_statements_history_long=OFF slave_parallel_threads=24 performance_schema=ON innodb_io_capacity_max=20000 binlog_format=STATEMENT innodb_buffer_pool_instances=1 table_open_cache_instances=1 innodb_io_capacity=2000 innodb_log_file_size=2G innodb_flush_method=O_DIRECT innodb_checksum_algorithm=CRC32 binlog_checksum=NONE binlog_cache_size=512K optimizer_switch=index_merge=on,index_condition_pushdown=on,derived_merge=on,semijoin=on,materialization=on sort_buffer_size=2M table_open_cache=24000 log_slave_updates=ON innodb_buffer_pool_size=64G innodb_file_per_table=ON innodb_buffer_pool_chunk_size=128M sync_binlog=1 join_buffer_size=256K innodb_write_io_threads=24 performance_schema_consumer_events_statements_current=ON innodb_adaptive_hash_index=1 performance_schema_consumer_events_statements_history=OFF query_cache_size=0 table_definition_cache=24000 innodb_log_buffer_size=4G innodb_flush_neighbors=0

Property

10.4.10-MariaDB

10.11.4-MariaDB

11.8.4-MariaDB

Database Maker

mariadb

Database Version

10.4.10-MariaDB

10.11.4-MariaDB

11.8.4-MariaDB

Engine

InnoDB

Install Dir

mariadb-10.4.10-linux-systemd-x86_64

mariadb-10.11.4

mariadb-11.8.4

DB Config Origin

USER_PROPERTIES_INLINE_BLOCK

DB Config Source File

MDEV-32750.tprocc.complex.cfg.ahi_on.properties

DB Generated Config Run File

mariadb_2026_10_1_00_54_12.cnf

mariadb_2026_10_1_21_12_17.cnf

mariadb_2026_10_2_14_21_18.cnf

Config Contents

slave_parallel_mode=optimistic
read_rnd_buffer_size=8M
max_connections=2000
thread_handling=pool-of-threads
event_scheduler=ON
read_buffer_size=8M
binlog_stmt_cache_size=512K
query_cache_type=0
innodb_flush_log_at_trx_commit=1
innodb_read_io_threads=24
performance_schema_consumer_events_statements_history_long=OFF
slave_parallel_threads=24
performance_schema=ON
innodb_io_capacity_max=20000
binlog_format=STATEMENT
innodb_buffer_pool_instances=1
table_open_cache_instances=1
innodb_io_capacity=2000
innodb_log_file_size=2G
innodb_flush_method=O_DIRECT
innodb_checksum_algorithm=CRC32
binlog_checksum=NONE
binlog_cache_size=512K
optimizer_switch=index_merge=on,index_condition_pushdown=on,derived_merge=on,semijoin=on,materialization=on
sort_buffer_size=2M
table_open_cache=24000
log_slave_updates=ON
innodb_buffer_pool_size=64G
innodb_file_per_table=ON
innodb_buffer_pool_chunk_size=128M
sync_binlog=1
join_buffer_size=256K
innodb_write_io_threads=24
performance_schema_consumer_events_statements_current=ON
innodb_adaptive_hash_index=1
performance_schema_consumer_events_statements_history=OFF
query_cache_size=0
table_definition_cache=24000
innodb_log_buffer_size=4G
innodb_flush_neighbors=0

Test Info (per dataset)

Property	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Test Suite	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC	TPROCC
Test Case Tag	MDEV32750_10.4.10_AHI_ON_FIND_PEAK_THREAD_COUNT	MDEV32750_10.11.4_AHI_ON_FIND_PEAK_THREAD_COUNT	MDEV32750_11.8.4_AHI_ON_FIND_PEAK_THREAD_COUNT
Duration	10	10	10
Iterations	3	3	3
Timestamp	2026-10-1 03:34:21	2026-10-1 22:03:24	2026-10-2 14:47:13
AutoGen Prop File	hammerdb-tprocc_TAF_AUTO_GEN_2026_10_1_00_54_28.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_10_1_21_12_25.properties	hammerdb-tprocc_TAF_AUTO_GEN_2026_10_2_14_21_30.properties
Checksum after run	true	true	true
Checksum after setup	true	true	true
Db type	maria	maria	maria
Include html metrics	true	true	true
Include html result	true	true	true
Include html tcount	true	true	true
Include html timing	true	true	true
Include json metrics	true	true	true
Include json result	true	true	true
Include json tcount	true	true	true
Include json timing	true	true	true
Number of warehouses	500	500	500
Setup virtual user count	unknown	25	25

Property

10.4.10-MariaDB

10.11.4-MariaDB

11.8.4-MariaDB

Test Suite

hammerdb-tprocc

Test Name

TPROCC

Test Case Tag

MDEV32750_10.4.10_AHI_ON_FIND_PEAK_THREAD_COUNT

MDEV32750_10.11.4_AHI_ON_FIND_PEAK_THREAD_COUNT

MDEV32750_11.8.4_AHI_ON_FIND_PEAK_THREAD_COUNT

Duration

Iterations

Timestamp

2026-10-1 03:34:21

2026-10-1 22:03:24

2026-10-2 14:47:13

AutoGen Prop File

hammerdb-tprocc_TAF_AUTO_GEN_2026_10_1_00_54_28.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_10_1_21_12_25.properties

hammerdb-tprocc_TAF_AUTO_GEN_2026_10_2_14_21_30.properties

Checksum after run

true

Checksum after setup

true

Db type

maria

Include html metrics

true

Include html result

true

Include html tcount

true

Include html timing

true

Include json metrics

true

Include json result

true

Include json tcount

true

Include json timing

true

Number of warehouses

500

Setup virtual user count

unknown

Thread Count: 8

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	24.50	9.79	22.50
Max	24.79	9.97	22.59
Min	24.34	9.63	22.41
StdDev	0.21	0.14	0.07
CoV	0.01	0.01	0.00
Median (p50)	24.36	9.76	22.50
p95	24.75	9.95	22.58
p99	24.78	9.97	22.59
Skewness	0.70	0.31	-0.08
Iteration 1	24.79	9.97	22.50
Iteration 2	24.34	9.76	22.59
Iteration 3	24.36	9.63	22.41

Thread Count: 16

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	23.10	9.64	22.48
Max	23.16	9.76	22.54
Min	23.05	9.45	22.40
StdDev	0.05	0.14	0.06
CoV	0.00	0.01	0.00
Median (p50)	23.09	9.72	22.49
p95	23.15	9.75	22.53
p99	23.16	9.76	22.54
Skewness	0.30	-0.68	-0.31
Iteration 1	23.16	9.72	22.40
Iteration 2	23.05	9.45	22.49
Iteration 3	23.09	9.76	22.54

Thread Count: 24

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	21.93	9.40	22.46
Max	22.09	9.50	22.49
Min	21.81	9.27	22.43
StdDev	0.12	0.10	0.02
CoV	0.01	0.01	0.00
Median (p50)	21.90	9.45	22.46
p95	22.07	9.49	22.49
p99	22.08	9.50	22.49
Skewness	0.41	-0.57	-0.09
Iteration 1	21.90	9.45	22.49
Iteration 2	22.09	9.50	22.46
Iteration 3	21.81	9.27	22.43

Thread Count: 32

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	20.71	9.14	22.61
Max	20.88	9.38	22.73
Min	20.50	8.86	22.47
StdDev	0.16	0.21	0.11
CoV	0.01	0.02	0.00
Median (p50)	20.73	9.19	22.64
p95	20.87	9.36	22.73
p99	20.88	9.37	22.73
Skewness	-0.26	-0.30	-0.32
Iteration 1	20.73	9.38	22.47
Iteration 2	20.50	9.19	22.73
Iteration 3	20.88	8.86	22.64

Thread Count: 48

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	18.26	9.53	22.92
Max	18.32	9.92	23.12
Min	18.14	8.96	22.73
StdDev	0.09	0.42	0.16
CoV	0.00	0.04	0.01
Median (p50)	18.32	9.73	22.90
p95	18.32	9.90	23.10
p99	18.32	9.92	23.11
Skewness	-0.71	-0.59	0.16
Iteration 1	18.32	8.96	22.73
Iteration 2	18.14	9.92	22.90
Iteration 3	18.32	9.73	23.12

Thread Count: 64

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	15.66	10.58	22.97
Max	16.09	10.66	23.15
Min	15.43	10.53	22.86
StdDev	0.31	0.06	0.13
CoV	0.02	0.01	0.01
Median (p50)	15.45	10.54	22.91
p95	16.02	10.65	23.12
p99	16.08	10.66	23.14
Skewness	0.70	0.68	0.65
Iteration 1	15.43	10.53	23.15
Iteration 2	15.45	10.66	22.86
Iteration 3	16.09	10.54	22.91

Thread Count: 96

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	10.50	10.72	22.84
Max	11.16	10.87	22.89
Min	10.09	10.63	22.80
StdDev	0.47	0.11	0.04
CoV	0.04	0.01	0.00
Median (p50)	10.26	10.67	22.84
p95	11.07	10.85	22.88
p99	11.14	10.87	22.89
Skewness	0.63	0.62	0.25
Iteration 1	10.26	10.63	22.80
Iteration 2	10.09	10.87	22.89
Iteration 3	11.16	10.67	22.84

Thread Count: 128

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	14.90	10.46	22.89
Max	15.28	10.57	22.94
Min	14.43	10.31	22.79
StdDev	0.35	0.11	0.07
CoV	0.02	0.01	0.00
Median (p50)	14.99	10.49	22.94
p95	15.25	10.57	22.94
p99	15.28	10.57	22.94
Skewness	-0.37	-0.40	-0.71
Iteration 1	14.99	10.57	22.94
Iteration 2	15.28	10.49	22.94
Iteration 3	14.43	10.31	22.79

Thread Count: 256

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	20.88	10.39	22.46
Max	21.07	10.45	22.49
Min	20.55	10.33	22.44
StdDev	0.24	0.05	0.02
CoV	0.01	0.00	0.00
Median (p50)	21.02	10.39	22.47
p95	21.06	10.45	22.48
p99	21.07	10.45	22.49
Skewness	-0.68	0.09	-0.08
Iteration 1	21.02	10.39	22.47
Iteration 2	21.07	10.33	22.44
Iteration 3	20.55	10.45	22.49