TPS by Thread Count

TPS by Thread Count - OLTP_RW

MDEV-39364 - orig

Comparison: TPS

Threads	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
4	1335.550	1338.890	1339.077
8	2588.630	2593.817	2591.600
16	4450.700	4615.317	4628.730
32	6141.557	6753.297	6722.047
64	7511.663	7984.727	8004.570
128	7837.700	7725.523	7822.847

System Info (per dataset)

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

Database Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Database Maker	mariadb	mariadb	mariadb
Database Version	11.8.6-MariaDB	12.3.1-MariaDB	13.0.0-MariaDB
Engine	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
Config File	./database_config_files/mariadb/mariadb_simple_2gbp.cnf	./database_config_files/mariadb/mariadb_simple_2gbp.cnf	./database_config_files/mariadb/mariadb_simple_2gbp.cnf
Config Contents	innodb_write_io_threads=4 thread_cache_size=128 innodb_flush_neighbors=0 innodb_log_file_size=512M innodb_read_io_threads=4 open_files_limit=65535 innodb_file_per_table=1 innodb_buffer_pool_size=2G innodb_flush_method=O_DIRECT table_open_cache=2048 max_connections=200 innodb_snapshot_isolation=0	innodb_write_io_threads=4 thread_cache_size=128 innodb_flush_neighbors=0 innodb_log_file_size=512M innodb_read_io_threads=4 open_files_limit=65535 innodb_file_per_table=1 innodb_buffer_pool_size=2G innodb_flush_method=O_DIRECT table_open_cache=2048 max_connections=200 innodb_snapshot_isolation=0	innodb_write_io_threads=4 thread_cache_size=128 innodb_flush_neighbors=0 innodb_log_file_size=512M innodb_read_io_threads=4 open_files_limit=65535 innodb_file_per_table=1 innodb_buffer_pool_size=2G innodb_flush_method=O_DIRECT table_open_cache=2048 max_connections=200 innodb_snapshot_isolation=0

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.3.1-MariaDB

Mariadb 13.0.0-MariaDB

Database Maker

mariadb

Database Version

11.8.6-MariaDB

12.3.1-MariaDB

13.0.0-MariaDB

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

Config File

./database_config_files/mariadb/mariadb_simple_2gbp.cnf

Config Contents

innodb_write_io_threads=4
thread_cache_size=128
innodb_flush_neighbors=0
innodb_log_file_size=512M
innodb_read_io_threads=4
open_files_limit=65535
innodb_file_per_table=1
innodb_buffer_pool_size=2G
innodb_flush_method=O_DIRECT
table_open_cache=2048
max_connections=200
innodb_snapshot_isolation=0

Test Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Test Suite	sysbench-lua	sysbench-lua	sysbench-lua
Test Name	OLTP_RW	OLTP_RW	OLTP_RW
Duration	300	300	300
Iterations	3	3	3
Db driver	mariadb	mariadb	mariadb
Debug sysbench	false	false	false
Intermediate result	2	2	2
Number of rows	1000000	1000000	1000000
Number of tables	8	8	8
Timestamp	2026-4-22 16:31:53	2026-4-23 02:24:50	2026-4-23 20:47:56

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.3.1-MariaDB

Mariadb 13.0.0-MariaDB

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-22 16:31:53

2026-4-23 02:24:50

2026-4-23 20:47:56

Thread Count: 4

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	1335.55	1338.89	1339.08
Max	1352.57	1351.39	1351.59
Min	1315.54	1318.96	1319.51
StdDev	15.26	14.24	14.01
CoV	0.01	0.01	0.01
Median (p50)	1338.54	1346.32	1346.13
p95	1351.17	1350.88	1351.04
p99	1352.29	1351.29	1351.48
Skewness	-0.29	-0.64	-0.63
Iteration 1	1315.54	1318.96	1319.51
Iteration 2	1338.54	1346.32	1346.13
Iteration 3	1352.57	1351.39	1351.59

Thread Count: 8

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	2588.63	2593.82	2591.60
Max	2598.18	2603.96	2604.49
Min	2574.80	2584.27	2576.02
StdDev	10.01	8.05	11.78
CoV	0.00	0.00	0.00
Median (p50)	2592.91	2593.22	2594.29
p95	2597.65	2602.89	2603.47
p99	2598.07	2603.75	2604.29
Skewness	-0.56	0.11	-0.33
Iteration 1	2574.80	2584.27	2576.02
Iteration 2	2592.91	2593.22	2594.29
Iteration 3	2598.18	2603.96	2604.49

Thread Count: 16

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	4450.70	4615.32	4628.73
Max	4601.50	4717.04	4705.15
Min	4251.33	4441.78	4551.50
StdDev	147.02	123.31	62.73
CoV	0.03	0.03	0.01
Median (p50)	4499.27	4687.13	4629.54
p95	4591.28	4714.05	4697.59
p99	4599.46	4716.44	4703.64
Skewness	-0.46	-0.68	-0.02
Iteration 1	4251.33	4441.78	4551.50
Iteration 2	4601.50	4687.13	4629.54
Iteration 3	4499.27	4717.04	4705.15

Thread Count: 32

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	6141.56	6753.30	6722.05
Max	6163.31	6810.01	6804.53
Min	6124.01	6719.40	6664.16
StdDev	16.32	40.36	59.89
CoV	0.00	0.01	0.01
Median (p50)	6137.35	6730.48	6697.45
p95	6160.71	6802.06	6793.82
p99	6162.79	6808.42	6802.39
Skewness	0.37	0.67	0.55
Iteration 1	6124.01	6719.40	6664.16
Iteration 2	6137.35	6810.01	6697.45
Iteration 3	6163.31	6730.48	6804.53

Thread Count: 64

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	7511.66	7984.73	8004.57
Max	7551.01	8049.21	8034.09
Min	7433.00	7933.88	7977.24
StdDev	55.62	48.06	23.26
CoV	0.01	0.01	0.00
Median (p50)	7550.98	7971.09	8002.38
p95	7551.01	8041.40	8030.92
p99	7551.01	8047.65	8033.46
Skewness	-0.71	0.40	0.14
Iteration 1	7433.00	7971.09	7977.24
Iteration 2	7550.98	8049.21	8034.09
Iteration 3	7551.01	7933.88	8002.38

Thread Count: 128

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	7837.70	7725.52	7822.85
Max	7902.37	7756.55	7933.38
Min	7738.91	7687.84	7636.50
StdDev	70.96	28.44	132.53
CoV	0.01	0.00	0.02
Median (p50)	7871.82	7732.18	7898.66
p95	7899.31	7754.11	7929.91
p99	7901.76	7756.06	7932.69
Skewness	-0.61	-0.34	-0.67
Iteration 1	7871.82	7756.55	7933.38
Iteration 2	7902.37	7687.84	7898.66
Iteration 3	7738.91	7732.18	7636.50