NOPM by Thread Count - TPROCC

bin log on

Comparison: NOPM

ThreadsMariaDB-log 12.3.0-MariaDB-logMariaDB-log 12.3.0-MariaDB-log
1011220.0007828.000

System Info (per dataset)

PropertyMariaDB-log 12.3.0-MariaDB-logMariaDB-log 12.3.0-MariaDB-log
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-log 12.3.0-MariaDB-logMariaDB-log 12.3.0-MariaDB-log
Database MakerMariaDB-logMariaDB-log
Database Version12.3.0-MariaDB-log12.3.0-MariaDB-log
EngineInnoDBInnoDB
Install Dir/home/jeb/taf-perl/database_software_installs/MariaDB-log-d228f237f27/home/jeb/taf-perl/database_software_installs/MariaDB-log-7081f2a58ec
Config File/home/jeb/taf-perl/database_config_files/MariaDB-log_cache_bin_log.cnf/home/jeb/taf-perl/database_config_files/MariaDB-log_cache_bin_log.cnf
Config Contents[mysqld]
performance_schema=OFF
log_bin
sync_binlog=1
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci

[mysqld]
performance_schema=OFF
log_bin
sync_binlog=1
general_log=OFF
slow_query_log=OFF
default_storage_engine=InnoDB
default_authentication_plugin=mysql_native_password
tls_version = TLSv1.2,TLSv1.3
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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci

Test Info (per dataset)

PropertyMariaDB-log 12.3.0-MariaDB-logMariaDB-log 12.3.0-MariaDB-log
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 22:01:242026-4-6 22:13:16

Thread Count: 10

MetricMariaDB-log 12.3.0-MariaDB-logMariaDB-log 12.3.0-MariaDB-logDiff
Mean11220.007828.00-3392.00
Max11220.007828.00-3392.00
Min11220.007828.00-3392.00
StdDev0.000.000.00
CoV0.000.000.00
Median (p50)11220.007828.00-3392.00
p9511220.007828.00-3392.00
p9911220.007828.00-3392.00
Skewness0.000.000.00
Iteration 111220.007828.00-3392.00