NOPM by Thread Count

NOPM by Thread Count - TPROCC

TPROC-C test suite without restore between iterations

Comparison: NOPM

Threads	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB
10	45623.000	24846.000
50	106858.333	74792.000
100	111835.333	79971.333
200	111713.667	85147.333
400	113561.667	89376.000

System Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB
Host	hz-bench-jeb	hz-bench-jeb
CPU	13th Gen Intel(R) Core(TM) i5-13500	13th Gen Intel(R) Core(TM) i5-13500
CPU Count	20	20
Core Count	14	14
Socket Count	1	1
OS	Linux	Linux
RAM	62.33 GB	62.33 GB
Disk	unknown	unknown

Database Info (per dataset)

Property	Mariadb 11.8.6--log	Mariadb 13.0.0-MariaDB-log
Database Maker	mariadb	mariadb
Database Version	11.8.6-MariaDB	13.0.0-MariaDB
Engine	InnoDB	InnoDB
Install Dir	/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-prof	/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-prof
Config File	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf
Config Contents	[mysqld] performance_schema=OFF log_bin=OFF sync_binlog=0 general_log=OFF slow_query_log=OFF default_storage_engine=InnoDB default_authentication_plugin=mysql_native_password tls_version = TLSv1.2,TLSv1.3 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci max_connections=200 open_files_limit=65535 table_open_cache=4000 thread_cache_size=128 # Innodb innodb_buffer_pool_size=30G innodb_flush_log_at_trx_commit=1 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_flush_neighbors=0 innodb_log_file_size=8G innodb_undo_tablespaces=2 innodb_undo_log_truncate=ON innodb_io_capacity=2000 innodb_io_capacity_max=4000 innodb_read_io_threads=8 innodb_write_io_threads=8 innodb_file_per_table=1 innodb_default_row_format=dynamic innodb_compression_algorithm=none innodb_compression_level=0 # sync sync_master_info=0 sync_relay_log=0 sync_relay_log_info=0 aria_pagecache_buffer_size = 128M aria_sort_buffer_size = 128M	[mysqld] performance_schema=OFF log_bin=OFF sync_binlog=0 general_log=OFF slow_query_log=OFF default_storage_engine=InnoDB default_authentication_plugin=mysql_native_password tls_version = TLSv1.2,TLSv1.3 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci max_connections=200 open_files_limit=65535 table_open_cache=4000 thread_cache_size=128 # Innodb innodb_buffer_pool_size=30G innodb_flush_log_at_trx_commit=1 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_flush_neighbors=0 innodb_log_file_size=8G innodb_undo_tablespaces=2 innodb_undo_log_truncate=ON innodb_io_capacity=2000 innodb_io_capacity_max=4000 innodb_read_io_threads=8 innodb_write_io_threads=8 innodb_file_per_table=1 innodb_default_row_format=dynamic innodb_compression_algorithm=none innodb_compression_level=0 # sync sync_master_info=0 sync_relay_log=0 sync_relay_log_info=0 aria_pagecache_buffer_size = 128M aria_sort_buffer_size = 128M

Property

Mariadb 11.8.6--log

Mariadb 13.0.0-MariaDB-log

Database Maker

mariadb

Database Version

11.8.6-MariaDB

13.0.0-MariaDB

Engine

InnoDB

Install Dir

/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-prof

/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-prof

Config File

/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf

Config Contents

[mysqld]
performance_schema=OFF
log_bin=OFF
sync_binlog=0
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
max_connections=200
open_files_limit=65535
table_open_cache=4000
thread_cache_size=128

# Innodb
innodb_buffer_pool_size=30G
innodb_flush_log_at_trx_commit=1
innodb_doublewrite=1
innodb_flush_method=O_DIRECT
innodb_flush_neighbors=0
innodb_log_file_size=8G
innodb_undo_tablespaces=2
innodb_undo_log_truncate=ON
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_read_io_threads=8
innodb_write_io_threads=8
innodb_file_per_table=1
innodb_default_row_format=dynamic
innodb_compression_algorithm=none
innodb_compression_level=0

# sync
sync_master_info=0
sync_relay_log=0
sync_relay_log_info=0

aria_pagecache_buffer_size = 128M
aria_sort_buffer_size = 128M

Test Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB
Test Suite	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC
Duration	5	5
Iterations	3	3
Checksum after run	true	true
Checksum after setup	true	true
Db type	maria	maria
Include html metrics	true	true
Include html result	true	true
Include html tcount	true	true
Include html timing	true	true
Include json metrics	true	true
Include json result	true	true
Include json tcount	true	true
Include json timing	true	true
Number of warehouses	100	100
Timestamp	2026-4-1 14:03:20	2026-4-1 17:42:21

Property

Mariadb 11.8.6-MariaDB

Mariadb 13.0.0-MariaDB

Test Suite

hammerdb-tprocc

Test Name

TPROCC

Duration

Iterations

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

100

Timestamp

2026-4-1 14:03:20

2026-4-1 17:42:21

Thread Count: 10

Metric	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB	Diff
Mean	45623.00	24846.00	-20777.00
Max	47574.00	25399.00	-22175.00
Min	44244.00	23820.00	-20424.00
StdDev	1418.36	726.23	-692.13
CoV	0.03	0.03	-0.00
Median (p50)	45051.00	25319.00	-19732.00
p95	47321.70	25391.00	-21930.70
p99	47523.54	25397.40	-22126.14
Skewness	0.54	-0.70	-1.24
Iteration 1	45051.00	23820.00	-21231.00
Iteration 2	47574.00	25319.00	-22255.00
Iteration 3	44244.00	25399.00	-18845.00

Thread Count: 50

Metric	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB	Diff
Mean	106858.33	74792.00	-32066.33
Max	118181.00	76827.00	-41354.00
Min	100277.00	72246.00	-28031.00
StdDev	8041.50	1904.77	-6136.72
CoV	0.08	0.03	-0.05
Median (p50)	102117.00	75303.00	-26814.00
p95	116574.60	76674.60	-39900.00
p99	117859.72	76796.52	-41063.20
Skewness	0.68	-0.38	-1.06
Iteration 1	118181.00	75303.00	-42878.00
Iteration 2	100277.00	72246.00	-28031.00
Iteration 3	102117.00	76827.00	-25290.00

Thread Count: 100

Metric	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB	Diff
Mean	111835.33	79971.33	-31864.00
Max	116977.00	86883.00	-30094.00
Min	107464.00	74118.00	-33346.00
StdDev	3921.68	5264.75	1343.07
CoV	0.04	0.07	0.03
Median (p50)	111065.00	78913.00	-32152.00
p95	116385.80	86086.00	-30299.80
p99	116858.76	86723.60	-30135.16
Skewness	0.29	0.29	0.01
Iteration 1	116977.00	78913.00	-38064.00
Iteration 2	111065.00	74118.00	-36947.00
Iteration 3	107464.00	86883.00	-20581.00

Thread Count: 200

Metric	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB	Diff
Mean	111713.67	85147.33	-26566.33
Max	116280.00	89010.00	-27270.00
Min	105927.00	78735.00	-27192.00
StdDev	4313.78	4565.78	252.00
CoV	0.04	0.05	0.02
Median (p50)	112934.00	87697.00	-25237.00
p95	115945.40	88878.70	-27066.70
p99	116213.08	88983.74	-27229.34
Skewness	-0.40	-0.66	-0.26
Iteration 1	112934.00	78735.00	-34199.00
Iteration 2	116280.00	89010.00	-27270.00
Iteration 3	105927.00	87697.00	-18230.00

Thread Count: 400

Metric	Mariadb 11.8.6-MariaDB	Mariadb 13.0.0-MariaDB	Diff
Mean	113561.67	89376.00	-24185.67
Max	117201.00	92465.00	-24736.00
Min	111474.00	87802.00	-23672.00
StdDev	2582.68	2184.39	-398.30
CoV	0.02	0.02	0.00
Median (p50)	112010.00	87861.00	-24149.00
p95	116681.90	92004.60	-24677.30
p99	117097.18	92372.92	-24724.26
Skewness	0.68	0.71	0.02
Iteration 1	112010.00	87802.00	-24208.00
Iteration 2	117201.00	92465.00	-24736.00
Iteration 3	111474.00	87861.00	-23613.00