TPS by Thread Count

TPS by Thread Count - OLTP_RW

MariaDB Cached Read-Write and Write Cases

Comparison: TPS

Threads	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log
4	640.220	673.867
8	1125.263	1214.660
16	2328.100	2149.333
32	3337.063	2441.337
64	3766.360	2186.910
128	3930.743	1974.470

System Info (per dataset)

Property	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log
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.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log
Database Maker	mariadb	mariadb
Database Version	11.4.2-MariaDB-log	12.1.2-MariaDB-log
Engine	innodb	innodb
Install Dir	/home/jeb/taf-perl/database_software_installs/mariadb-11.4.2-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-12.1.2-linux-systemd-x86_64
Config File	./database_config_files/mariadb_cache.cnf	./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=2G innodb_log_files_in_group=4 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=2G innodb_log_files_in_group=4 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.4.2-MariaDB-log

Mariadb 12.1.2-MariaDB-log

Database Maker

mariadb

Database Version

11.4.2-MariaDB-log

12.1.2-MariaDB-log

Engine

innodb

Install Dir

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

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

Config File

./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=2G
innodb_log_files_in_group=4
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.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log
Test Suite	sysbench-lua	sysbench-lua
Test Name	OLTP_RW	OLTP_RW
Duration	300	300
Iterations	3	3
Db driver	mariadb	mariadb
Debug sysbench	false	false
Intermediate result	2	2
Number of rows	10000000	10000000
Number of tables	8	8
Timestamp	2026-3-11 13:22:25	2026-3-10 16:38:28

Property

Mariadb 11.4.2-MariaDB-log

Mariadb 12.1.2-MariaDB-log

Test Suite

sysbench-lua

Test Name

OLTP_RW

Duration

300

Iterations

Db driver

mariadb

Debug sysbench

false

Intermediate result

Number of rows

10000000

Number of tables

Timestamp

2026-3-11 13:22:25

2026-3-10 16:38:28

Thread Count: 4

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	640.22	673.87	33.65
Max	663.22	681.99	18.77
Min	617.23	658.42	41.19
StdDev	18.78	10.93	-7.85
CoV	0.03	0.02	-0.01
Median (p50)	640.21	681.19	40.98
p95	660.92	681.91	20.99
p99	662.76	681.97	19.21
Skewness	0.00	-0.70	-0.71
Iteration 1	663.22	658.42	-4.80
Iteration 2	617.23	681.19	63.96
Iteration 3	640.21	681.99	41.78

Thread Count: 8

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	1125.26	1214.66	89.40
Max	1190.06	1229.82	39.76
Min	1042.13	1198.70	156.57
StdDev	61.77	12.72	-49.05
CoV	0.05	0.01	-0.04
Median (p50)	1143.60	1215.46	71.86
p95	1185.41	1228.38	42.97
p99	1189.13	1229.53	40.40
Skewness	-0.42	-0.09	0.33
Iteration 1	1143.60	1198.70	55.10
Iteration 2	1190.06	1215.46	25.40
Iteration 3	1042.13	1229.82	187.69

Thread Count: 16

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	2328.10	2149.33	-178.77
Max	2635.47	2199.78	-435.69
Min	2088.42	2077.93	-10.49
StdDev	228.40	51.91	-176.50
CoV	0.10	0.02	-0.07
Median (p50)	2260.41	2170.29	-90.12
p95	2597.96	2196.83	-401.13
p99	2627.97	2199.19	-428.78
Skewness	0.42	-0.54	-0.96
Iteration 1	2088.42	2077.93	-10.49
Iteration 2	2260.41	2170.29	-90.12
Iteration 3	2635.47	2199.78	-435.69

Thread Count: 32

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	3337.06	2441.34	-895.73
Max	3410.88	2525.33	-885.55
Min	3242.37	2353.09	-889.28
StdDev	70.36	70.38	0.02
CoV	0.02	0.03	0.01
Median (p50)	3357.94	2445.59	-912.35
p95	3405.59	2517.36	-888.23
p99	3409.82	2523.74	-886.09
Skewness	-0.42	-0.09	0.33
Iteration 1	3242.37	2353.09	-889.28
Iteration 2	3410.88	2445.59	-965.29
Iteration 3	3357.94	2525.33	-832.61

Thread Count: 64

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	3766.36	2186.91	-1579.45
Max	3857.99	2239.12	-1618.87
Min	3719.03	2106.83	-1612.20
StdDev	64.80	57.49	-7.31
CoV	0.02	0.03	0.01
Median (p50)	3722.06	2214.78	-1507.28
p95	3844.40	2236.69	-1607.71
p99	3855.27	2238.63	-1616.64
Skewness	0.71	-0.61	-1.32
Iteration 1	3719.03	2106.83	-1612.20
Iteration 2	3722.06	2214.78	-1507.28
Iteration 3	3857.99	2239.12	-1618.87

Thread Count: 128

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Diff
Mean	3930.74	1974.47	-1956.27
Max	3951.43	1980.39	-1971.04
Min	3904.14	1971.02	-1933.12
StdDev	19.75	4.21	-15.55
CoV	0.01	0.00	-0.00
Median (p50)	3936.66	1972.00	-1964.66
p95	3949.95	1979.55	-1970.40
p99	3951.13	1980.22	-1970.91
Skewness	-0.42	0.68	1.10
Iteration 1	3904.14	1971.02	-1933.12
Iteration 2	3936.66	1972.00	-1964.66
Iteration 3	3951.43	1980.39	-1971.04