TPS by Thread Count - OLTP_RO

TPS by Thread Count - OLTP_RO

MDEV-39364 - orig

Comparison: TPS

Threads	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
4	7318.057	7269.747	7233.183
8	9319.967	9281.480	9275.527
16	9901.103	9966.393	9885.683
32	13702.260	12910.320	12849.170
64	11965.437	11635.907	11504.597
128	10558.987	10088.477	9994.133

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_buffer_pool_size=2G innodb_write_io_threads=4 thread_cache_size=128 innodb_file_per_table=1 table_open_cache=2048 innodb_flush_method=O_DIRECT innodb_flush_neighbors=0 innodb_log_file_size=512M open_files_limit=65535 innodb_read_io_threads=4 innodb_snapshot_isolation=0 max_connections=200	innodb_buffer_pool_size=2G innodb_write_io_threads=4 thread_cache_size=128 innodb_file_per_table=1 table_open_cache=2048 innodb_flush_method=O_DIRECT innodb_flush_neighbors=0 innodb_log_file_size=512M open_files_limit=65535 innodb_read_io_threads=4 innodb_snapshot_isolation=0 max_connections=200	innodb_buffer_pool_size=2G innodb_write_io_threads=4 thread_cache_size=128 innodb_file_per_table=1 table_open_cache=2048 innodb_flush_method=O_DIRECT innodb_flush_neighbors=0 innodb_log_file_size=512M open_files_limit=65535 innodb_read_io_threads=4 innodb_snapshot_isolation=0 max_connections=200

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_RO	OLTP_RO	OLTP_RO
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 14:53:26	2026-4-23 00:46:23	2026-4-23 19:09:30

Thread Count: 4

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	7318.06	7269.75	7233.18
Max	7328.71	7277.85	7241.46
Min	7310.87	7259.35	7220.70
StdDev	7.68	7.72	8.98
CoV	0.00	0.00	0.00
Median (p50)	7314.59	7272.04	7237.39
p95	7327.30	7277.27	7241.05
p99	7328.43	7277.73	7241.38
Skewness	0.58	-0.42	-0.60
Iteration 1	7310.87	7259.35	7220.70
Iteration 2	7328.71	7272.04	7237.39
Iteration 3	7314.59	7277.85	7241.46

Thread Count: 8

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	9319.97	9281.48	9275.53
Max	9327.10	9292.24	9303.42
Min	9312.96	9273.30	9247.95
StdDev	5.77	7.94	22.65
CoV	0.00	0.00	0.00
Median (p50)	9319.84	9278.90	9275.21
p95	9326.37	9290.91	9300.60
p99	9326.95	9291.97	9302.86
Skewness	0.03	0.45	0.02
Iteration 1	9319.84	9278.90	9303.42
Iteration 2	9312.96	9273.30	9247.95
Iteration 3	9327.10	9292.24	9275.21

Thread Count: 16

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	9901.10	9966.39	9885.68
Max	9902.83	9988.57	9923.63
Min	9899.69	9940.00	9842.02
StdDev	1.30	20.05	33.56
CoV	0.00	0.00	0.00
Median (p50)	9900.79	9970.61	9891.40
p95	9902.63	9986.77	9920.41
p99	9902.79	9988.21	9922.99
Skewness	0.35	-0.31	-0.25
Iteration 1	9899.69	9940.00	9891.40
Iteration 2	9902.83	9988.57	9923.63
Iteration 3	9900.79	9970.61	9842.02

Thread Count: 32

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	13702.26	12910.32	12849.17
Max	13841.13	12963.12	12897.19
Min	13470.86	12813.88	12761.27
StdDev	164.71	68.30	62.24
CoV	0.01	0.01	0.00
Median (p50)	13794.79	12953.96	12889.05
p95	13836.50	12962.20	12896.38
p99	13840.20	12962.94	12897.03
Skewness	-0.67	-0.70	-0.70
Iteration 1	13794.79	12953.96	12897.19
Iteration 2	13841.13	12963.12	12889.05
Iteration 3	13470.86	12813.88	12761.27

Thread Count: 64

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	11965.44	11635.91	11504.60
Max	11976.02	11666.57	11524.36
Min	11958.95	11604.23	11493.72
StdDev	7.55	25.46	14.00
CoV	0.00	0.00	0.00
Median (p50)	11961.34	11636.92	11495.71
p95	11974.55	11663.60	11521.50
p99	11975.73	11665.98	11523.79
Skewness	0.65	-0.06	0.70
Iteration 1	11961.34	11666.57	11524.36
Iteration 2	11958.95	11636.92	11493.72
Iteration 3	11976.02	11604.23	11495.71

Thread Count: 128

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	10558.99	10088.48	9994.13
Max	10603.17	10104.87	10011.15
Min	10502.48	10067.70	9965.19
StdDev	42.02	15.49	20.57
CoV	0.00	0.00	0.00
Median (p50)	10571.31	10092.86	10006.06
p95	10599.98	10103.67	10010.64
p99	10602.53	10104.63	10011.05
Skewness	-0.41	-0.40	-0.67
Iteration 1	10571.31	10092.86	9965.19
Iteration 2	10502.48	10104.87	10006.06
Iteration 3	10603.17	10067.70	10011.15