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 12.2.2-MariaDB	Mariadb 12.3.0-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
10	45301.000	43719.000	23603.000	24386.000	24538.000

System Info (per dataset)

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

Database Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 12.2.2-MariaDB	Mariadb 12.3.0-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Database Maker	mariadb	mariadb	mariadb	mariadb	mariadb
Database Version	11.8.6-MariaDB	12.2.2-MariaDB	12.3.0-MariaDB	12.3.1-MariaDB	13.0.0-MariaDB
Engine	InnoDB	InnoDB	InnoDB	InnoDB	InnoDB
Install Dir	/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-12.2.2-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-12.3.0-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64
Config File	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/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	[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	[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-MariaDB

Mariadb 12.2.2-MariaDB

Mariadb 12.3.0-MariaDB

Mariadb 12.3.1-MariaDB

Mariadb 13.0.0-MariaDB

Database Maker

mariadb

Database Version

11.8.6-MariaDB

12.2.2-MariaDB

12.3.0-MariaDB

12.3.1-MariaDB

13.0.0-MariaDB

Engine

InnoDB

Install Dir

/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-linux-systemd-x86_64

/home/jeb/taf-perl/database_software_installs/mariadb-12.2.2-linux-systemd-x86_64

/home/jeb/taf-perl/database_software_installs/mariadb-12.3.0-linux-systemd-x86_64

/home/jeb/taf-perl/database_software_installs/mariadb-12.3.1-linux-systemd-x86_64

/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64

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 12.2.2-MariaDB	Mariadb 12.3.0-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Test Suite	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc	hammerdb-tprocc
Test Name	TPROCC	TPROCC	TPROCC	TPROCC	TPROCC
Duration	5	5	5	5	5
Iterations	1	1	1	1	1
Checksum after run	true	true	true	true	true
Checksum after setup	true	true	true	true	true
Db type	maria	maria	maria	maria	maria
Include html metrics	false	false	false	false	false
Include html result	false	false	false	false	false
Include html tcount	false	false	false	false	false
Include html timing	false	false	false	false	false
Include json metrics	false	false	false	false	false
Include json result	false	false	false	false	false
Include json tcount	false	false	false	false	false
Include json timing	false	false	false	false	false
Number of warehouses	100	100	100	100	100
Timeprofile	false	false	false	false	false
Timestamp	2026-4-5 15:08:55	2026-4-6 00:00:57	2026-4-6 00:12:58	2026-4-5 18:14:58	2026-4-5 15:20:55

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.2.2-MariaDB

Mariadb 12.3.0-MariaDB

Mariadb 12.3.1-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

false

Include html result

false

Include html tcount

false

Include html timing

false

Include json metrics

false

Include json result

false

Include json tcount

false

Include json timing

false

Number of warehouses

100

Timeprofile

false

Timestamp

2026-4-5 15:08:55

2026-4-6 00:00:57

2026-4-6 00:12:58

2026-4-5 18:14:58

2026-4-5 15:20:55

Thread Count: 10

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.2.2-MariaDB	Mariadb 12.3.0-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	45301.00	43719.00	23603.00	24386.00	24538.00
Max	45301.00	43719.00	23603.00	24386.00	24538.00
Min	45301.00	43719.00	23603.00	24386.00	24538.00
StdDev	0.00	0.00	0.00	0.00	0.00
CoV	0.00	0.00	0.00	0.00	0.00
Median (p50)	45301.00	43719.00	23603.00	24386.00	24538.00
p95	45301.00	43719.00	23603.00	24386.00	24538.00
p99	45301.00	43719.00	23603.00	24386.00	24538.00
Skewness	0.00	0.00	0.00	0.00	0.00
Iteration 1	45301.00	43719.00	23603.00	24386.00	24538.00