TPS by Thread Count - SELECT_SIMPLE

TPS by Thread Count - SELECT_SIMPLE_RANGES

MDEV-39364 - updated config ro breakout

Comparison: TPS

Threads	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
4	80966.543	81881.657	81693.417
8	106525.057	105811.200	106194.010
16	112778.883	113950.263	112965.153
32	145671.507	142862.810	141767.520
64	123847.560	120211.850	120595.620
128	111130.340	110082.230	110895.703

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	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf	/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf
Config Contents	innodb_undo_log_truncate=ON innodb_doublewrite=1 innodb_io_capacity_max=4000 thread_cache_size=128 innodb_undo_tablespaces=2 default_storage_engine=InnoDB innodb_flush_method=O_DIRECT sync_relay_log_info=0 aria_sort_buffer_size=128M innodb_read_io_threads=8 sync_master_info=0 innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 slow_query_log=OFF innodb_compression_level=0 table_open_cache=4000 max_connections=200 open_files_limit=65535 performance_schema=OFF innodb_write_io_threads=8 tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity=2000 sync_relay_log=0 innodb_compression_algorithm=none character_set_server=utf8mb4 default_authentication_plugin=mysql_native_password general_log=OFF innodb_default_row_format=dynamic collation_server=utf8mb4_general_ci sync_binlog=0 innodb_log_file_size=8G aria_pagecache_buffer_size=128M innodb_flush_neighbors=0 innodb_buffer_pool_size=30G	innodb_undo_log_truncate=ON innodb_doublewrite=1 innodb_io_capacity_max=4000 thread_cache_size=128 innodb_undo_tablespaces=2 default_storage_engine=InnoDB innodb_flush_method=O_DIRECT sync_relay_log_info=0 aria_sort_buffer_size=128M innodb_read_io_threads=8 sync_master_info=0 innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 slow_query_log=OFF innodb_compression_level=0 table_open_cache=4000 max_connections=200 open_files_limit=65535 performance_schema=OFF innodb_write_io_threads=8 tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity=2000 sync_relay_log=0 innodb_compression_algorithm=none character_set_server=utf8mb4 default_authentication_plugin=mysql_native_password general_log=OFF innodb_default_row_format=dynamic collation_server=utf8mb4_general_ci sync_binlog=0 innodb_log_file_size=8G aria_pagecache_buffer_size=128M innodb_flush_neighbors=0 innodb_buffer_pool_size=30G	innodb_undo_log_truncate=ON innodb_doublewrite=1 innodb_io_capacity_max=4000 thread_cache_size=128 innodb_undo_tablespaces=2 default_storage_engine=InnoDB innodb_flush_method=O_DIRECT sync_relay_log_info=0 aria_sort_buffer_size=128M innodb_read_io_threads=8 sync_master_info=0 innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 slow_query_log=OFF innodb_compression_level=0 table_open_cache=4000 max_connections=200 open_files_limit=65535 performance_schema=OFF innodb_write_io_threads=8 tls_version=TLSv1.2,TLSv1.3 innodb_io_capacity=2000 sync_relay_log=0 innodb_compression_algorithm=none character_set_server=utf8mb4 default_authentication_plugin=mysql_native_password general_log=OFF innodb_default_row_format=dynamic collation_server=utf8mb4_general_ci sync_binlog=0 innodb_log_file_size=8G aria_pagecache_buffer_size=128M innodb_flush_neighbors=0 innodb_buffer_pool_size=30G

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

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

Config Contents

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

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	SELECT_SIMPLE_RANGES	SELECT_SIMPLE_RANGES	SELECT_SIMPLE_RANGES
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-26 02:53:24	2026-4-26 09:28:07	2026-4-26 16:02:46

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.3.1-MariaDB

Mariadb 13.0.0-MariaDB

Test Suite

sysbench-lua

Test Name

SELECT_SIMPLE_RANGES

Duration

300

Iterations

Db driver

mariadb

Debug sysbench

false

Intermediate result

Number of rows

1000000

Number of tables

Timestamp

2026-4-26 02:53:24

2026-4-26 09:28:07

2026-4-26 16:02:46

Thread Count: 4

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	80966.54	81881.66	81693.42
Max	81675.61	81968.24	81738.22
Min	80568.64	81777.91	81664.30
StdDev	502.63	78.64	32.15
CoV	0.01	0.00	0.00
Median (p50)	80655.38	81898.82	81677.73
p95	81573.59	81961.30	81732.17
p99	81655.21	81966.85	81737.01
Skewness	0.69	-0.32	0.62
Iteration 1	81675.61	81777.91	81738.22
Iteration 2	80568.64	81968.24	81664.30
Iteration 3	80655.38	81898.82	81677.73

Thread Count: 8

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	106525.06	105811.20	106194.01
Max	107769.55	106603.27	106885.28
Min	105827.95	104810.73	105148.55
StdDev	882.11	746.49	751.95
CoV	0.01	0.01	0.01
Median (p50)	105977.67	106019.60	106548.20
p95	107590.36	106544.90	106851.57
p99	107733.71	106591.60	106878.54
Skewness	0.69	-0.40	-0.60
Iteration 1	107769.55	106603.27	106548.20
Iteration 2	105827.95	104810.73	106885.28
Iteration 3	105977.67	106019.60	105148.55

Thread Count: 16

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	112778.88	113950.26	112965.15
Max	113422.36	114403.60	113170.98
Min	112144.38	113677.11	112748.26
StdDev	521.77	322.80	172.75
CoV	0.00	0.00	0.00
Median (p50)	112769.91	113770.08	112976.22
p95	113357.12	114340.25	113151.50
p99	113409.31	114390.93	113167.08
Skewness	0.03	0.66	-0.10
Iteration 1	112144.38	113677.11	113170.98
Iteration 2	112769.91	113770.08	112748.26
Iteration 3	113422.36	114403.60	112976.22

Thread Count: 32

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	145671.51	142862.81	141767.52
Max	146324.29	143144.30	141931.50
Min	144562.74	142474.05	141617.91
StdDev	788.12	283.95	128.43
CoV	0.01	0.00	0.00
Median (p50)	146127.49	142970.08	141753.15
p95	146304.61	143126.88	141913.67
p99	146320.35	143140.82	141927.93
Skewness	-0.67	-0.51	0.17
Iteration 1	146127.49	142474.05	141617.91
Iteration 2	146324.29	143144.30	141931.50
Iteration 3	144562.74	142970.08	141753.15

Thread Count: 64

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	123847.56	120211.85	120595.62
Max	124148.77	120448.34	122372.88
Min	123420.92	119970.53	119238.96
StdDev	310.10	195.10	1313.53
CoV	0.00	0.00	0.01
Median (p50)	123972.99	120216.68	120175.02
p95	124131.19	120425.17	122153.09
p99	124145.25	120443.71	122328.92
Skewness	-0.54	-0.04	0.45
Iteration 1	123972.99	120216.68	120175.02
Iteration 2	123420.92	119970.53	119238.96
Iteration 3	124148.77	120448.34	122372.88

Thread Count: 128

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.3.1-MariaDB	Mariadb 13.0.0-MariaDB
Mean	111130.34	110082.23	110895.70
Max	111303.57	110868.24	112133.62
Min	111021.77	108569.22	109232.43
StdDev	123.80	1070.13	1222.00
CoV	0.00	0.01	0.01
Median (p50)	111065.68	110809.23	111321.06
p95	111279.78	110862.34	112052.36
p99	111298.81	110867.06	112117.37
Skewness	0.64	-0.71	-0.48
Iteration 1	111021.77	110868.24	112133.62
Iteration 2	111303.57	110809.23	111321.06
Iteration 3	111065.68	108569.22	109232.43