TPROCC

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

Comparison: NEWORD_ratio

Threads	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
8	53.301	62.356	53.991
16	54.364	62.715	54.025
24	55.150	63.175	54.035
32	55.147	63.705	53.980
48	55.143	63.158	53.730
64	40.997	61.041	53.677
96	26.714	61.017	53.719
128	28.314	61.618	53.765
256	30.250	61.820	53.986

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

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

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

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	53.30	62.36	53.99
Max	53.45	62.74	54.02
Min	53.10	61.94	53.96
StdDev	0.14	0.33	0.03
CoV	0.00	0.01	0.00
Median (p50)	53.35	62.38	53.99
p95	53.44	62.71	54.02
p99	53.44	62.74	54.02
Skewness	-0.49	-0.13	-0.15
Iteration 1	53.10	61.94	54.02
Iteration 2	53.45	62.74	53.96
Iteration 3	53.35	62.38	53.99

Thread Count: 16

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	54.36	62.72	54.03
Max	54.38	63.15	54.04
Min	54.34	62.30	54.01
StdDev	0.02	0.34	0.01
CoV	0.00	0.01	0.00
Median (p50)	54.37	62.70	54.02
p95	54.38	63.10	54.04
p99	54.38	63.14	54.04
Skewness	-0.60	0.08	0.46
Iteration 1	54.34	62.30	54.01
Iteration 2	54.38	63.15	54.02
Iteration 3	54.37	62.70	54.04

Thread Count: 24

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	55.15	63.17	54.03
Max	55.36	63.75	54.06
Min	54.98	62.66	54.01
StdDev	0.16	0.45	0.02
CoV	0.00	0.01	0.00
Median (p50)	55.12	63.11	54.03
p95	55.33	63.69	54.06
p99	55.35	63.74	54.06
Skewness	0.31	0.21	0.20
Iteration 1	55.12	62.66	54.01
Iteration 2	54.98	63.11	54.06
Iteration 3	55.36	63.75	54.03

Thread Count: 32

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	55.15	63.71	53.98
Max	55.21	64.22	54.05
Min	55.04	63.32	53.92
StdDev	0.08	0.38	0.05
CoV	0.00	0.01	0.00
Median (p50)	55.20	63.58	53.98
p95	55.21	64.15	54.04
p99	55.21	64.20	54.04
Skewness	-0.70	0.47	0.07
Iteration 1	55.20	63.58	53.98
Iteration 2	55.21	63.32	53.92
Iteration 3	55.04	64.22	54.05

Thread Count: 48

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	55.14	63.16	53.73
Max	55.46	64.20	53.77
Min	54.88	62.47	53.71
StdDev	0.24	0.75	0.03
CoV	0.00	0.01	0.00
Median (p50)	55.09	62.80	53.72
p95	55.43	64.06	53.76
p99	55.46	64.18	53.77
Skewness	0.33	0.60	0.61
Iteration 1	55.09	64.20	53.72
Iteration 2	55.46	62.47	53.71
Iteration 3	54.88	62.80	53.77

Thread Count: 64

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	41.00	61.04	53.68
Max	41.88	61.13	53.69
Min	40.29	60.94	53.66
StdDev	0.66	0.08	0.01
CoV	0.02	0.00	0.00
Median (p50)	40.82	61.05	53.69
p95	41.77	61.12	53.69
p99	41.86	61.13	53.69
Skewness	0.39	-0.21	-0.67
Iteration 1	40.82	61.05	53.66
Iteration 2	40.29	60.94	53.69
Iteration 3	41.88	61.13	53.69

Thread Count: 96

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	26.71	61.02	53.72
Max	28.23	61.24	53.79
Min	25.50	60.72	53.62
StdDev	1.14	0.22	0.07
CoV	0.04	0.00	0.00
Median (p50)	26.41	61.09	53.75
p95	28.05	61.22	53.78
p99	28.19	61.24	53.79
Skewness	0.38	-0.47	-0.60
Iteration 1	26.41	61.09	53.75
Iteration 2	25.50	60.72	53.79
Iteration 3	28.23	61.24	53.62

Thread Count: 128

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	28.31	61.62	53.76
Max	28.36	61.98	53.83
Min	28.28	61.26	53.71
StdDev	0.03	0.30	0.05
CoV	0.00	0.00	0.00
Median (p50)	28.31	61.61	53.75
p95	28.35	61.95	53.82
p99	28.36	61.98	53.83
Skewness	0.34	0.03	0.33
Iteration 1	28.28	61.26	53.75
Iteration 2	28.36	61.61	53.83
Iteration 3	28.31	61.98	53.71

Thread Count: 256

Metric	10.4.10-MariaDB	10.11.4-MariaDB	11.8.4-MariaDB
Mean	30.25	61.82	53.99
Max	30.32	61.91	54.02
Min	30.12	61.66	53.97
StdDev	0.09	0.12	0.02
CoV	0.00	0.00	0.00
Median (p50)	30.30	61.90	53.97
p95	30.32	61.90	54.01
p99	30.32	61.90	54.02
Skewness	-0.68	-0.70	0.71
Iteration 1	30.30	61.66	53.97
Iteration 2	30.12	61.91	53.97
Iteration 3	30.32	61.90	54.02