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	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
4	640.220	673.867	604.497	330.690
8	1125.263	1214.660	1140.180	660.637
16	2328.100	2149.333	2009.253	1243.280
32	3337.063	2441.337	2344.550	2201.530
64	3766.360	2186.910	2123.817	3335.863
128	3930.743	1974.470	1938.877	4453.497

System Info (per dataset)

Property	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-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.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Database Maker	mariadb	mariadb	mariadb	mariadb
Database Version	11.4.2-MariaDB-log	12.1.2-MariaDB-log	11.8.6-MariaDB-log	13.0.0-MariaDB-log
Engine	innodb	innodb	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	/home/jeb/taf-perl/database_software_installs/mariadb-11.8.6-linux-systemd-x86_64	/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-linux-systemd-x86_64
Config File	./database_config_files/mariadb_cache.cnf	./database_config_files/mariadb_cache.cnf	./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 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci #character_set_server = utf8mb3 #collation_server = utf8mb3_general_ci	[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 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci #character_set_server = utf8mb3 #collation_server = utf8mb3_general_ci	[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 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci #character_set_server = utf8mb3 #collation_server = utf8mb3_general_ci	[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 character_set_server=utf8mb4 collation_server=utf8mb4_general_ci #character_set_server = utf8mb3 #collation_server = utf8mb3_general_ci

Property

Mariadb 11.4.2-MariaDB-log

Mariadb 12.1.2-MariaDB-log

Mariadb 11.8.6-MariaDB-log

Mariadb 13.0.0-MariaDB-log

Database Maker

mariadb

Database Version

11.4.2-MariaDB-log

12.1.2-MariaDB-log

11.8.6-MariaDB-log

13.0.0-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

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

/home/jeb/taf-perl/database_software_installs/mariadb-13.0.0-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

character_set_server=utf8mb4
collation_server=utf8mb4_general_ci
#character_set_server = utf8mb3
#collation_server = utf8mb3_general_ci

Test Info (per dataset)

Property	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-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	10000000	10000000	10000000	10000000
Number of tables	8	8	8	8
Timestamp	2026-3-11 13:22:25	2026-3-10 16:38:28	2026-3-24 00:00:31	2026-3-24 01:46:09

Property

Mariadb 11.4.2-MariaDB-log

Mariadb 12.1.2-MariaDB-log

Mariadb 11.8.6-MariaDB-log

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

2026-3-24 00:00:31

2026-3-24 01:46:09

Thread Count: 4

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	640.22	673.87	604.50	330.69
Max	663.22	681.99	619.48	361.59
Min	617.23	658.42	596.50	312.29
StdDev	18.78	10.93	10.60	21.98
CoV	0.03	0.02	0.02	0.07
Median (p50)	640.21	681.19	597.51	318.19
p95	660.92	681.91	617.28	357.25
p99	662.76	681.97	619.04	360.72
Skewness	0.00	-0.70	0.70	0.67
Iteration 1	663.22	658.42	597.51	361.59
Iteration 2	617.23	681.19	596.50	312.29
Iteration 3	640.21	681.99	619.48	318.19

Thread Count: 8

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	1125.26	1214.66	1140.18	660.64
Max	1190.06	1229.82	1146.44	713.04
Min	1042.13	1198.70	1131.67	634.06
StdDev	61.77	12.72	6.24	37.06
CoV	0.05	0.01	0.01	0.06
Median (p50)	1143.60	1215.46	1142.43	634.81
p95	1185.41	1228.38	1146.04	705.22
p99	1189.13	1229.53	1146.36	711.48
Skewness	-0.42	-0.09	-0.49	0.71
Iteration 1	1143.60	1198.70	1142.43	713.04
Iteration 2	1190.06	1215.46	1131.67	634.81
Iteration 3	1042.13	1229.82	1146.44	634.06

Thread Count: 16

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	2328.10	2149.33	2009.25	1243.28
Max	2635.47	2199.78	2058.74	1261.83
Min	2088.42	2077.93	1925.09	1227.72
StdDev	228.40	51.91	59.82	14.08
CoV	0.10	0.02	0.03	0.01
Median (p50)	2260.41	2170.29	2043.93	1240.29
p95	2597.96	2196.83	2057.26	1259.68
p99	2627.97	2199.19	2058.44	1261.40
Skewness	0.42	-0.54	-0.67	0.31
Iteration 1	2088.42	2077.93	1925.09	1261.83
Iteration 2	2260.41	2170.29	2043.93	1227.72
Iteration 3	2635.47	2199.78	2058.74	1240.29

Thread Count: 32

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	3337.06	2441.34	2344.55	2201.53
Max	3410.88	2525.33	2444.66	2220.90
Min	3242.37	2353.09	2263.63	2166.29
StdDev	70.36	70.38	75.14	24.96
CoV	0.02	0.03	0.03	0.01
Median (p50)	3357.94	2445.59	2325.36	2217.40
p95	3405.59	2517.36	2432.73	2220.55
p99	3409.82	2523.74	2442.27	2220.83
Skewness	-0.42	-0.09	0.37	-0.70
Iteration 1	3242.37	2353.09	2263.63	2166.29
Iteration 2	3410.88	2445.59	2325.36	2217.40
Iteration 3	3357.94	2525.33	2444.66	2220.90

Thread Count: 64

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	3766.36	2186.91	2123.82	3335.86
Max	3857.99	2239.12	2193.59	3398.45
Min	3719.03	2106.83	2040.46	3247.23
StdDev	64.80	57.49	63.25	64.42
CoV	0.02	0.03	0.03	0.02
Median (p50)	3722.06	2214.78	2137.40	3361.91
p95	3844.40	2236.69	2187.97	3394.80
p99	3855.27	2238.63	2192.47	3397.72
Skewness	0.71	-0.61	-0.31	-0.54
Iteration 1	3719.03	2106.83	2040.46	3247.23
Iteration 2	3722.06	2214.78	2137.40	3361.91
Iteration 3	3857.99	2239.12	2193.59	3398.45

Thread Count: 128

Metric	Mariadb 11.4.2-MariaDB-log	Mariadb 12.1.2-MariaDB-log	Mariadb 11.8.6-MariaDB-log	Mariadb 13.0.0-MariaDB-log
Mean	3930.74	1974.47	1938.88	4453.50
Max	3951.43	1980.39	1959.71	4506.56
Min	3904.14	1971.02	1909.95	4385.73
StdDev	19.75	4.21	21.11	50.41
CoV	0.01	0.00	0.01	0.01
Median (p50)	3936.66	1972.00	1946.97	4468.20
p95	3949.95	1979.55	1958.44	4502.72
p99	3951.13	1980.22	1959.46	4505.79
Skewness	-0.42	0.68	-0.52	-0.41
Iteration 1	3904.14	1971.02	1959.71	4385.73
Iteration 2	3936.66	1972.00	1909.95	4468.20
Iteration 3	3951.43	1980.39	1946.97	4506.56