TPS by Thread Count

TPS by Thread Count - OLTP_RW

MDEV-39364 - updated config binlog

Comparison: TPS

Threads	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
4	193.050	162.807	164.200	192.680
8	341.000	259.040	257.987	341.720
16	595.607	391.850	388.433	576.710
32	1051.137	599.243	600.590	1066.873
64	4261.523	1188.487	1185.373	4009.213
128	7345.620	6431.553	5355.970	7316.730

System Info (per dataset)

Property	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Host	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
CPU Count	20	20	20	20
Core Count	14	14	14	14
Socket Count	1	1	1	1
OS	Linux	Linux	Linux	Linux
RAM	62.33 GB	62.33 GB	62.33 GB	62.33 GB
Disk	unknown	unknown	unknown	unknown

Database Info (per dataset)

Property	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Database Maker	mariadb	mariadb	mariadb	mariadb
Database Version	11.8.6-MariaDB-log	12.3.1-MariaDB-log	13.0.0-MariaDB-log	13.0.1-MariaDB-log
Engine	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.3.1-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-8fd8e810081bbaa9
Config File	/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache_bin_log.cnf
Config Contents	sync_master_info=0 innodb_doublewrite=1 innodb_undo_log_truncate=ON max_connections=200 innodb_read_io_threads=8 innodb_file_per_table=1 sync_binlog=1 default_authentication_plugin=mysql_native_password thread_cache_size=128 sync_relay_log=0 innodb_compression_level=0 default_storage_engine=InnoDB innodb_undo_tablespaces=2 collation_server=utf8mb4_general_ci sync_relay_log_info=0 general_log=OFF innodb_write_io_threads=8 table_open_cache=4000 character_set_server=utf8mb4 performance_schema=OFF innodb_buffer_pool_size=30G slow_query_log=OFF innodb_flush_neighbors=0 innodb_default_row_format=dynamic open_files_limit=65535 innodb_flush_log_at_trx_commit=1 log_bin aria_pagecache_buffer_size=128M tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity_max=4000 innodb_flush_method=O_DIRECT innodb_compression_algorithm=none innodb_log_file_size=8G innodb_io_capacity=2000 aria_sort_buffer_size=128M	sync_master_info=0 innodb_doublewrite=1 innodb_undo_log_truncate=ON max_connections=200 innodb_read_io_threads=8 innodb_file_per_table=1 sync_binlog=1 default_authentication_plugin=mysql_native_password thread_cache_size=128 sync_relay_log=0 innodb_compression_level=0 default_storage_engine=InnoDB innodb_undo_tablespaces=2 collation_server=utf8mb4_general_ci sync_relay_log_info=0 general_log=OFF innodb_write_io_threads=8 table_open_cache=4000 character_set_server=utf8mb4 performance_schema=OFF innodb_buffer_pool_size=30G slow_query_log=OFF innodb_flush_neighbors=0 innodb_default_row_format=dynamic open_files_limit=65535 innodb_flush_log_at_trx_commit=1 log_bin aria_pagecache_buffer_size=128M tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity_max=4000 innodb_flush_method=O_DIRECT innodb_compression_algorithm=none innodb_log_file_size=8G innodb_io_capacity=2000 aria_sort_buffer_size=128M	sync_master_info=0 innodb_doublewrite=1 innodb_undo_log_truncate=ON max_connections=200 innodb_read_io_threads=8 innodb_file_per_table=1 sync_binlog=1 default_authentication_plugin=mysql_native_password thread_cache_size=128 sync_relay_log=0 innodb_compression_level=0 default_storage_engine=InnoDB innodb_undo_tablespaces=2 collation_server=utf8mb4_general_ci sync_relay_log_info=0 general_log=OFF innodb_write_io_threads=8 table_open_cache=4000 character_set_server=utf8mb4 performance_schema=OFF innodb_buffer_pool_size=30G slow_query_log=OFF innodb_flush_neighbors=0 innodb_default_row_format=dynamic open_files_limit=65535 innodb_flush_log_at_trx_commit=1 log_bin aria_pagecache_buffer_size=128M tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity_max=4000 innodb_flush_method=O_DIRECT innodb_compression_algorithm=none innodb_log_file_size=8G innodb_io_capacity=2000 aria_sort_buffer_size=128M	sync_master_info=0 innodb_doublewrite=1 innodb_undo_log_truncate=ON max_connections=200 innodb_read_io_threads=8 innodb_file_per_table=1 sync_binlog=1 default_authentication_plugin=mysql_native_password thread_cache_size=128 sync_relay_log=0 innodb_compression_level=0 default_storage_engine=InnoDB innodb_undo_tablespaces=2 collation_server=utf8mb4_general_ci sync_relay_log_info=0 general_log=OFF innodb_write_io_threads=8 table_open_cache=4000 character_set_server=utf8mb4 performance_schema=OFF innodb_buffer_pool_size=30G slow_query_log=OFF innodb_flush_neighbors=0 innodb_default_row_format=dynamic open_files_limit=65535 innodb_flush_log_at_trx_commit=1 log_bin aria_pagecache_buffer_size=128M tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity_max=4000 innodb_flush_method=O_DIRECT innodb_compression_algorithm=none innodb_log_file_size=8G innodb_io_capacity=2000 aria_sort_buffer_size=128M

Property

Mariadb 11.8.6-MariaDB-log

Mariadb 12.3.1-MariaDB-log

Mariadb 13.0.0-MariaDB-log

Mariadb 13.0.1-MariaDB-log

Database Maker

mariadb

Database Version

11.8.6-MariaDB-log

12.3.1-MariaDB-log

13.0.0-MariaDB-log

13.0.1-MariaDB-log

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.3.1-linux-systemd-x86_64

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

/home/jeb/taf-perl/database_software_installs/mariadb-8fd8e810081bbaa9

Config File

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

Config Contents

sync_master_info=0
innodb_doublewrite=1
innodb_undo_log_truncate=ON
max_connections=200
innodb_read_io_threads=8
innodb_file_per_table=1
sync_binlog=1
default_authentication_plugin=mysql_native_password
thread_cache_size=128
sync_relay_log=0
innodb_compression_level=0
default_storage_engine=InnoDB
innodb_undo_tablespaces=2
collation_server=utf8mb4_general_ci
sync_relay_log_info=0
general_log=OFF
innodb_write_io_threads=8
table_open_cache=4000
character_set_server=utf8mb4
performance_schema=OFF
innodb_buffer_pool_size=30G
slow_query_log=OFF
innodb_flush_neighbors=0
innodb_default_row_format=dynamic
open_files_limit=65535
innodb_flush_log_at_trx_commit=1
log_bin
aria_pagecache_buffer_size=128M
tls_version=TLSv1.2,TLSv1.3
innodb_io_capacity_max=4000
innodb_flush_method=O_DIRECT
innodb_compression_algorithm=none
innodb_log_file_size=8G
innodb_io_capacity=2000
aria_sort_buffer_size=128M

Test Info (per dataset)

Property	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Test Suite	sysbench-lua	sysbench-lua	sysbench-lua	sysbench-lua
Test Name	OLTP_RW	OLTP_RW	OLTP_RW	OLTP_RW
Duration	300	300	300	300
Iterations	3	3	3	3
Db driver	mariadb	mariadb	mariadb	mariadb
Debug sysbench	false	false	false	false
Intermediate result	2	2	2	2
Number of rows	1000000	1000000	1000000	1000000
Number of tables	8	8	8	8
Timestamp	2026-4-24 13:51:23	2026-4-24 15:31:21	2026-4-24 17:11:05	2026-4-24 19:05:02

Property

Mariadb 11.8.6-MariaDB-log

Mariadb 12.3.1-MariaDB-log

Mariadb 13.0.0-MariaDB-log

Mariadb 13.0.1-MariaDB-log

Test Suite

sysbench-lua

Test Name

OLTP_RW

Duration

300

Iterations

Db driver

mariadb

Debug sysbench

false

Intermediate result

Number of rows

1000000

Number of tables

Timestamp

2026-4-24 13:51:23

2026-4-24 15:31:21

2026-4-24 17:11:05

2026-4-24 19:05:02

Thread Count: 4

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	193.05	162.81	164.20	192.68
Max	203.66	178.54	179.58	203.87
Min	176.89	138.62	142.76	176.25
StdDev	11.61	17.36	15.63	11.87
CoV	0.06	0.11	0.10	0.06
Median (p50)	198.60	171.26	170.26	197.92
p95	203.15	177.81	178.65	203.28
p99	203.56	178.39	179.39	203.75
Skewness	-0.61	-0.61	-0.52	-0.58
Iteration 1	176.89	138.62	142.76	176.25
Iteration 2	198.60	171.26	170.26	197.92
Iteration 3	203.66	178.54	179.58	203.87

Thread Count: 8

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	341.00	259.04	257.99	341.72
Max	342.73	262.47	261.35	343.34
Min	339.78	254.78	254.53	339.81
StdDev	1.26	3.19	2.79	1.46
CoV	0.00	0.01	0.01	0.00
Median (p50)	340.49	259.87	258.08	342.01
p95	342.51	262.21	261.02	343.21
p99	342.69	262.42	261.28	343.31
Skewness	0.54	-0.37	-0.05	-0.29
Iteration 1	339.78	254.78	254.53	339.81
Iteration 2	340.49	259.87	258.08	342.01
Iteration 3	342.73	262.47	261.35	343.34

Thread Count: 16

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	595.61	391.85	388.43	576.71
Max	618.83	395.02	391.39	587.60
Min	555.76	388.18	386.58	560.49
StdDev	28.30	2.81	2.11	11.69
CoV	0.05	0.01	0.01	0.02
Median (p50)	612.23	392.35	387.33	582.04
p95	618.17	394.75	390.98	587.04
p99	618.70	394.97	391.31	587.49
Skewness	-0.68	-0.26	0.64	-0.59
Iteration 1	555.76	388.18	386.58	587.60
Iteration 2	618.83	392.35	387.33	560.49
Iteration 3	612.23	395.02	391.39	582.04

Thread Count: 32

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	1051.14	599.24	600.59	1066.87
Max	1113.72	607.71	611.35	1090.69
Min	1009.87	594.72	594.19	1054.65
StdDev	45.00	5.99	7.65	16.84
CoV	0.04	0.01	0.01	0.02
Median (p50)	1029.82	595.30	596.23	1055.28
p95	1105.33	606.47	609.84	1087.15
p99	1112.04	607.46	611.05	1089.98
Skewness	0.60	0.70	0.67	0.71
Iteration 1	1029.82	595.30	596.23	1054.65
Iteration 2	1113.72	594.72	594.19	1090.69
Iteration 3	1009.87	607.71	611.35	1055.28

Thread Count: 64

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	4261.52	1188.49	1185.37	4009.21
Max	4821.94	1192.76	1189.96	4530.30
Min	3216.42	1184.65	1180.03	3017.28
StdDev	739.65	3.33	4.09	701.70
CoV	0.17	0.00	0.00	0.18
Median (p50)	4746.21	1188.05	1186.13	4480.06
p95	4814.37	1192.29	1189.58	4525.28
p99	4820.43	1192.67	1189.88	4529.30
Skewness	-0.70	0.19	-0.27	-0.70
Iteration 1	3216.42	1188.05	1186.13	3017.28
Iteration 2	4821.94	1192.76	1189.96	4530.30
Iteration 3	4746.21	1184.65	1180.03	4480.06

Thread Count: 128

Metric	Mariadb 11.8.6-MariaDB-log	Mariadb 12.3.1-MariaDB-log	Mariadb 13.0.0-MariaDB-log	Mariadb 13.0.1-MariaDB-log
Mean	7345.62	6431.55	5355.97	7316.73
Max	7440.84	6667.49	6618.94	7448.82
Min	7160.72	6211.63	4350.63	7061.18
StdDev	130.76	186.45	943.78	180.74
CoV	0.02	0.03	0.18	0.02
Median (p50)	7435.30	6415.54	5098.34	7440.19
p95	7440.29	6642.30	6466.88	7447.96
p99	7440.73	6662.45	6588.53	7448.65
Skewness	-0.71	0.13	0.39	-0.71
Iteration 1	7435.30	6211.63	5098.34	7440.19
Iteration 2	7440.84	6415.54	4350.63	7061.18
Iteration 3	7160.72	6667.49	6618.94	7448.82