TPS by Thread Count - POINT

TPS by Thread Count - POINT_SELECT

MDEV-39364 - deeper look

Comparison: TPS

Threads	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
16	302631.992	296652.992	299197.148	297282.082	297404.384	307811.446
32	521026.002	513757.320	519106.542	514801.404	511430.934	515405.868
64	478579.536	470268.402	470705.734	469787.820	466393.646	463327.562
128	370188.986	362277.570	358188.346	359550.168	359467.514	350259.078
256	312079.568	308999.638	309531.930	310516.188	307542.782	303825.084

System Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Host	hz-bench-jeb	hz-bench-jeb	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	13th Gen Intel(R) Core(TM) i5-13500	13th Gen Intel(R) Core(TM) i5-13500
CPU Count	20	20	20	20	20	20
Core Count	14	14	14	14	14	14
Socket Count	1	1	1	1	1	1
OS	Linux	Linux	Linux	Linux	Linux	Linux
RAM	62.33 GB	62.33 GB	62.33 GB	62.33 GB	62.33 GB	62.33 GB
Disk	unknown	unknown	unknown	unknown	unknown	unknown

Database Info (per dataset)

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

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.0.0-MariaDB

Mariadb 12.0.1-MariaDB

Mariadb 12.1.2-MariaDB

Mariadb 12.2.1-MariaDB

Mariadb 12.3.1-MariaDB

Database Maker

mariadb

Database Version

11.8.6-MariaDB

12.0.0-MariaDB

12.0.1-MariaDB

12.1.2-MariaDB

12.2.1-MariaDB

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

/home/jeb/taf-perl/database_software_installs/mariadb-12.0.1-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-12.2.1-linux-systemd-x86_64

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

Config File

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

Config Contents

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

Test Info (per dataset)

Property	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Test Suite	sysbench-lua	sysbench-lua	sysbench-lua	sysbench-lua	sysbench-lua	sysbench-lua
Test Name	POINT_SELECT	POINT_SELECT	POINT_SELECT	POINT_SELECT	POINT_SELECT	POINT_SELECT
Duration	480	480	480	480	480	480
Iterations	5	5	5	5	5	5
Db driver	mariadb	mariadb	mariadb	mariadb	mariadb	mariadb
Debug sysbench	false	false	false	false	false	false
Intermediate result	2	2	2	2	2	2
Number of rows	1000000	1000000	1000000	1000000	1000000	1000000
Number of tables	8	8	8	8	8	8
Timestamp	2026-4-28 15:12:29	2026-4-29 16:01:36	2026-4-30 06:09:26	2026-4-30 20:17:12	2026-5-1 10:24:59	2026-5-2 12:07:42

Property

Mariadb 11.8.6-MariaDB

Mariadb 12.0.0-MariaDB

Mariadb 12.0.1-MariaDB

Mariadb 12.1.2-MariaDB

Mariadb 12.2.1-MariaDB

Mariadb 12.3.1-MariaDB

Test Suite

sysbench-lua

Test Name

POINT_SELECT

Duration

480

Iterations

Db driver

mariadb

Debug sysbench

false

Intermediate result

Number of rows

1000000

Number of tables

Timestamp

2026-4-28 15:12:29

2026-4-29 16:01:36

2026-4-30 06:09:26

2026-4-30 20:17:12

2026-5-1 10:24:59

2026-5-2 12:07:42

Thread Count: 16

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Mean	302631.99	296652.99	299197.15	297282.08	297404.38	307811.45
Max	305841.66	298489.19	300765.08	299294.08	298607.20	316184.39
Min	300982.30	294959.00	298539.30	296376.47	296388.72	305257.21
StdDev	1724.98	1247.92	796.25	1108.70	873.57	4211.03
CoV	0.01	0.00	0.00	0.00	0.00	0.01
Median (p50)	302000.40	296564.39	298880.85	296623.87	297101.83	305732.98
p95	305250.03	298291.86	300399.29	298968.85	298535.60	314255.66
p99	305723.33	298449.72	300691.92	299229.03	298592.88	315798.64
Skewness	1.04	0.12	1.38	0.97	0.26	1.46
Iteration 1	305841.66	298489.19	300765.08	299294.08	298607.20	316184.39
Iteration 2	300982.30	296564.39	298880.85	296623.87	298249.20	305732.98
Iteration 3	302000.40	297502.55	298864.39	296376.47	296674.97	305341.89
Iteration 4	302883.53	294959.00	298936.12	296448.04	297101.83	306540.76
Iteration 5	301452.07	295749.83	298539.30	297667.95	296388.72	305257.21

Thread Count: 32

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Mean	521026.00	513757.32	519106.54	514801.40	511430.93	515405.87
Max	521886.34	515261.44	520358.91	516335.31	512105.81	516102.47
Min	520164.79	512125.40	518330.93	513295.01	510986.80	514738.96
StdDev	707.84	1126.49	673.01	1177.23	484.89	538.79
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	521065.22	513394.14	518918.89	515388.91	511135.55	515331.06
p95	521853.34	515162.48	520098.34	516155.33	512070.42	516069.14
p99	521879.74	515241.65	520306.80	516299.31	512098.73	516095.80
Skewness	-0.03	-0.01	0.97	-0.16	0.41	0.10
Iteration 1	521721.34	512125.40	520358.91	515388.91	512105.81	515935.80
Iteration 2	521886.34	513394.14	518918.89	516335.31	511928.85	514738.96
Iteration 3	520292.32	513238.98	518867.94	513295.01	511135.55	516102.47
Iteration 4	521065.22	514766.64	519056.04	513552.36	510986.80	515331.06
Iteration 5	520164.79	515261.44	518330.93	515435.43	510997.66	514921.05

Thread Count: 64

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Mean	478579.54	470268.40	470705.73	469787.82	466393.65	463327.56
Max	479600.63	471258.31	471255.82	471711.67	468214.65	464814.43
Min	477743.98	469579.77	470035.89	467544.95	465083.34	461663.25
StdDev	701.58	601.48	463.70	1417.74	1090.42	1204.81
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	478409.72	470271.97	470681.90	470239.11	466007.35	462889.17
p95	479512.43	471108.37	471239.27	471462.40	467960.91	464773.33
p99	479582.99	471228.32	471252.51	471661.82	468163.90	464806.21
Skewness	0.27	0.46	-0.13	-0.30	0.55	0.05
Iteration 1	479600.63	470271.97	471173.09	471711.67	468214.65	464608.95
Iteration 2	479159.61	469723.37	470035.89	468978.07	465083.34	462662.01
Iteration 3	477983.74	471258.31	470381.97	467544.95	466945.94	464814.43
Iteration 4	478409.72	470508.59	471255.82	470239.11	465716.95	461663.25
Iteration 5	477743.98	469579.77	470681.90	470465.30	466007.35	462889.17

Thread Count: 128

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Mean	370188.99	362277.57	358188.35	359550.17	359467.51	350259.08
Max	370892.43	363384.01	359447.92	360715.63	359945.19	353354.93
Min	368611.59	359621.45	356447.56	358806.01	358644.52	347802.04
StdDev	823.18	1365.43	1073.11	686.82	464.29	1828.79
CoV	0.00	0.00	0.00	0.00	0.00	0.01
Median (p50)	370506.50	362791.98	358490.60	359341.46	359664.07	350360.18
p95	370862.06	363335.86	359357.68	360548.50	359914.05	352789.61
p99	370886.36	363374.38	359429.87	360682.20	359938.96	353241.87
Skewness	-1.21	-1.30	-0.48	0.64	-0.82	0.45
Iteration 1	370740.58	363143.26	359447.92	360715.63	359789.51	349249.93
Iteration 2	370892.43	359621.45	358490.60	359007.76	358644.52	350528.31
Iteration 3	370506.50	362447.15	356447.56	358806.01	359945.19	347802.04
Iteration 4	370193.83	362791.98	358996.70	359879.98	359664.07	353354.93
Iteration 5	368611.59	363384.01	357558.95	359341.46	359294.28	350360.18

Thread Count: 256

Metric	Mariadb 11.8.6-MariaDB	Mariadb 12.0.0-MariaDB	Mariadb 12.0.1-MariaDB	Mariadb 12.1.2-MariaDB	Mariadb 12.2.1-MariaDB	Mariadb 12.3.1-MariaDB
Mean	312079.57	308999.64	309531.93	310516.19	307542.78	303825.08
Max	313443.33	309925.84	310455.02	311423.37	308321.94	304425.22
Min	311375.57	308492.14	308894.13	309423.66	306816.64	303349.12
StdDev	776.78	504.61	545.69	640.01	556.52	409.35
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	311648.61	308855.31	309365.50	310600.89	307445.61	303652.53
p95	313242.52	309757.72	310321.01	311271.62	308260.39	304376.39
p99	313403.17	309892.22	310428.22	311393.02	308309.63	304415.45
Skewness	0.83	0.96	0.60	-0.42	0.13	0.35
Iteration 1	313443.33	308855.31	309160.04	310600.89	308014.19	304425.22
Iteration 2	312439.28	308639.65	308894.13	310664.60	306816.64	303517.48
Iteration 3	311648.61	308492.14	309365.50	309423.66	307445.61	303652.53
Iteration 4	311491.05	309085.25	309784.96	310468.42	307115.53	303349.12
Iteration 5	311375.57	309925.84	310455.02	311423.37	308321.94	304181.07