NOPM by Thread Count - TPROCC

TPROC-C

Comparison: NOPM

ThreadsMariadb 12.3.0-MariaDBMariadb 12.3.0-MariaDB
1046217.00024681.000

System Info (per dataset)

PropertyMariadb 12.3.0-MariaDBMariadb 12.3.0-MariaDB
Hosthz-bench-jebhz-bench-jeb
CPU13th Gen Intel(R) Core(TM) i5-1350013th Gen Intel(R) Core(TM) i5-13500
CPU Count2020
Core Count1414
Socket Count11
OSLinuxLinux
RAM62.33 GB62.33 GB
Diskunknownunknown

Database Info (per dataset)

PropertyMariadb 12.3.0-MariaDBMariadb 12.3.0-MariaDB
Database Makermariadbmariadb
Database Version12.3.0-MariaDB12.3.0-MariaDB
EngineInnoDBInnoDB
Install Dir/home/jeb/taf-perl/database_software_installs/mariadb-d228f237f27/home/jeb/taf-perl/database_software_installs/mariadb-7081f2a58ec
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


Test Info (per dataset)

PropertyMariadb 12.3.0-MariaDBMariadb 12.3.0-MariaDB
Test Suitehammerdb-tprocchammerdb-tprocc
Test NameTPROCCTPROCC
Duration55
Iterations11
Checksum after runtruetrue
Checksum after setuptruetrue
Db typemariamaria
Include html metricsfalsefalse
Include html resultfalsefalse
Include html tcountfalsefalse
Include html timingfalsefalse
Include json metricsfalsefalse
Include json resultfalsefalse
Include json tcountfalsefalse
Include json timingfalsefalse
Number of warehouses100100
Timeprofilefalsefalse
Timestamp2026-4-6 21:43:502026-4-6 18:20:28

Thread Count: 10

MetricMariadb 12.3.0-MariaDBMariadb 12.3.0-MariaDBDiff
Mean46217.0024681.00-21536.00
Max46217.0024681.00-21536.00
Min46217.0024681.00-21536.00
StdDev0.000.000.00
CoV0.000.000.00
Median (p50)46217.0024681.00-21536.00
p9546217.0024681.00-21536.00
p9946217.0024681.00-21536.00
Skewness0.000.000.00
Iteration 146217.0024681.00-21536.00