TPS by Thread Count - SELECT_DISTINCT

TPS by Thread Count - SELECT_DISTINCT_RANGES

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	50349.424	50896.648	49999.042	49237.220	50067.446	48164.670
32	57180.972	57713.202	56712.414	55390.224	57439.276	56302.776
64	54327.416	54865.288	53807.074	52660.862	54416.278	53149.556
128	49484.522	49567.174	48880.406	48128.506	49519.786	48549.508
256	48031.322	48272.412	47612.772	46976.492	48214.466	47410.164

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

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

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

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	SELECT_DISTINCT_RANGES	SELECT_DISTINCT_RANGES	SELECT_DISTINCT_RANGES	SELECT_DISTINCT_RANGES	SELECT_DISTINCT_RANGES	SELECT_DISTINCT_RANGES
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-29 12:28:58	2026-4-30 02:36:48	2026-4-30 16:44:35	2026-5-1 06:52:22	2026-5-1 21:00:08	2026-5-2 22:42:51

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

SELECT_DISTINCT_RANGES

Duration

480

Iterations

Db driver

mariadb

Debug sysbench

false

Intermediate result

Number of rows

1000000

Number of tables

Timestamp

2026-4-29 12:28:58

2026-4-30 02:36:48

2026-4-30 16:44:35

2026-5-1 06:52:22

2026-5-1 21:00:08

2026-5-2 22:42:51

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	50349.42	50896.65	49999.04	49237.22	50067.45	48164.67
Max	50948.16	51214.13	50284.54	49420.02	50498.03	48318.61
Min	50052.97	50404.70	49733.76	49145.67	49908.91	47976.35
StdDev	365.82	270.53	190.38	98.97	221.30	128.86
CoV	0.01	0.01	0.00	0.00	0.00	0.00
Median (p50)	50070.37	50961.41	49936.47	49221.72	49966.14	48233.96
p95	50879.87	51177.67	50253.83	49384.91	50408.62	48303.54
p99	50934.50	51206.84	50278.40	49413.00	50480.15	48315.60
Skewness	0.66	-0.85	0.17	0.98	1.31	-0.34
Iteration 1	50948.16	50961.41	49909.47	49154.23	50050.99	48318.61
Iteration 2	50070.37	51214.13	49936.47	49145.67	50498.03	48243.26
Iteration 3	50068.90	51031.82	50284.54	49420.02	49913.16	47976.35
Iteration 4	50606.72	50871.18	50130.97	49221.72	49908.91	48051.17
Iteration 5	50052.97	50404.70	49733.76	49244.46	49966.14	48233.96

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	57180.97	57713.20	56712.41	55390.22	57439.28	56302.78
Max	57325.58	57884.43	56829.64	55512.27	57611.47	56437.64
Min	57100.10	57621.95	56595.78	55271.54	57319.86	55979.60
StdDev	76.49	89.34	79.23	84.63	105.56	174.32
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	57163.03	57688.69	56692.62	55406.20	57406.76	56413.49
p95	57295.02	57846.19	56816.44	55497.23	57589.53	56435.19
p99	57319.47	57876.78	56827.00	55509.26	57607.08	56437.15
Skewness	1.09	1.18	0.05	-0.01	0.52	-1.06
Iteration 1	57100.10	57693.25	56829.64	55271.54	57356.54	56437.64
Iteration 2	57143.35	57688.69	56692.62	55406.20	57406.76	56257.78
Iteration 3	57325.58	57884.43	56595.78	55437.07	57319.86	56425.37
Iteration 4	57172.80	57621.95	56763.65	55324.04	57501.75	56413.49
Iteration 5	57163.03	57677.69	56680.38	55512.27	57611.47	55979.60

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	54327.42	54865.29	53807.07	52660.86	54416.28	53149.56
Max	54508.25	54899.94	53956.21	52744.06	54527.41	53371.01
Min	54164.21	54852.60	53688.73	52555.84	54279.97	53050.64
StdDev	128.56	17.54	108.30	63.65	82.20	117.39
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	54368.21	54857.85	53793.57	52662.16	54410.70	53088.09
p95	54486.21	54892.11	53945.66	52735.94	54515.12	53330.02
p99	54503.84	54898.37	53954.10	52742.44	54524.95	53362.81
Skewness	-0.02	1.41	0.17	-0.40	-0.38	1.14
Iteration 1	54164.21	54852.60	53793.57	52703.45	54397.36	53071.97
Iteration 2	54198.38	54855.27	53688.73	52744.06	54527.41	53050.64
Iteration 3	54368.21	54857.85	53956.21	52638.80	54410.70	53166.07
Iteration 4	54508.25	54899.94	53903.47	52662.16	54465.95	53088.09
Iteration 5	54398.03	54860.78	53693.39	52555.84	54279.97	53371.01

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	49484.52	49567.17	48880.41	48128.51	49519.79	48549.51
Max	49530.31	49648.98	48930.04	48234.64	49598.23	48677.39
Min	49431.81	49494.00	48803.15	48027.95	49408.36	48419.84
StdDev	40.30	57.50	48.73	74.57	78.33	87.85
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	49499.10	49545.29	48910.41	48148.09	49556.86	48531.40
p95	49528.14	49642.79	48927.00	48221.60	49596.78	48663.70
p99	49529.88	49647.74	48929.43	48232.03	49597.94	48674.65
Skewness	-0.25	0.24	-0.55	-0.02	-0.38	0.02
Iteration 1	49499.10	49648.98	48910.41	48148.09	49598.23	48531.40
Iteration 2	49431.81	49529.55	48803.15	48234.64	49444.51	48608.94
Iteration 3	49530.31	49494.00	48914.83	48027.95	49556.86	48677.39
Iteration 4	49519.44	49545.29	48843.60	48062.42	49408.36	48419.84
Iteration 5	49441.95	49618.05	48930.04	48169.43	49590.97	48509.97

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	48031.32	48272.41	47612.77	46976.49	48214.47	47410.16
Max	48091.10	48312.27	47711.12	47033.40	48282.24	47458.51
Min	47946.92	48237.59	47495.64	46911.50	48113.93	47344.54
StdDev	52.16	30.49	84.78	50.74	65.03	46.16
CoV	0.00	0.00	0.00	0.00	0.00	0.00
Median (p50)	48053.33	48270.42	47614.54	46979.12	48231.63	47435.46
p95	48086.36	48310.06	47708.90	47032.95	48281.22	47456.21
p99	48090.15	48311.83	47710.68	47033.31	48282.04	47458.05
Skewness	-0.52	0.09	-0.11	-0.07	-0.41	-0.39
Iteration 1	48091.10	48312.27	47700.02	46979.12	48282.24	47447.00
Iteration 2	48067.40	48237.59	47614.54	47033.40	48231.63	47435.46
Iteration 3	48053.33	48270.42	47711.12	47031.13	48277.15	47344.54
Iteration 4	47946.92	48301.20	47542.54	46927.31	48167.38	47365.31
Iteration 5	47997.86	48240.58	47495.64	46911.50	48113.93	47458.51