TPS by Thread Count - POINT_SELECT

MDEV-39364 - updated config

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
4238671.587254255.377251119.797
8264261.897294402.390293893.567
16305301.290312102.467306147.937
32521627.727519449.257506585.023
64479019.637467352.190463955.987
128373735.700350305.287361969.187

System Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Hosthz-bench-jebhz-bench-jebhz-bench-jeb
CPU13th Gen Intel(R) Core(TM) i5-1350013th Gen Intel(R) Core(TM) i5-1350013th Gen Intel(R) Core(TM) i5-13500
CPU Count202020
Core Count141414
Socket Count111
OSLinuxLinuxLinux
RAM62.33 GB62.33 GB62.33 GB
Diskunknownunknownunknown

Database Info (per dataset)

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

Test Info (per dataset)

PropertyMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Test Suitesysbench-luasysbench-luasysbench-lua
Test NamePOINT_SELECTPOINT_SELECTPOINT_SELECT
Duration300300300
Iterations333
Db drivermariadbmariadbmariadb
Debug sysbenchfalsefalsefalse
Intermediate result222
Number of rows100000010000001000000
Number of tables888
Timestamp2026-4-22 18:11:372026-4-23 12:34:442026-4-23 22:27:40

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean238671.59254255.38251119.80
Max240820.60260139.91252632.86
Min237595.09251262.24250353.93
StdDev1519.584161.201069.92
CoV0.010.020.00
Median (p50)237599.07251363.98250372.60
p95240498.45259262.32252406.83
p99240756.17259964.39252587.65
Skewness0.710.710.71
Iteration 1240820.60260139.91252632.86
Iteration 2237599.07251363.98250372.60
Iteration 3237595.09251262.24250353.93

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean264261.90294402.39293893.57
Max265209.66294879.61294926.36
Min263192.68293481.24293194.09
StdDev827.90651.49745.44
CoV0.000.000.00
Median (p50)264383.35294846.32293560.25
p95265127.03294876.28294789.75
p99265193.13294878.94294899.04
Skewness-0.22-0.710.58
Iteration 1265209.66293481.24294926.36
Iteration 2263192.68294846.32293560.25
Iteration 3264383.35294879.61293194.09

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean305301.29312102.47306147.94
Max305831.11312816.12306481.33
Min304617.35311008.17305559.98
StdDev507.36785.64416.99
CoV0.000.000.00
Median (p50)305455.41312483.11306402.50
p95305793.54312782.82306473.45
p99305823.60312809.46306479.75
Skewness-0.43-0.61-0.69
Iteration 1304617.35311008.17305559.98
Iteration 2305455.41312483.11306402.50
Iteration 3305831.11312816.12306481.33

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean521627.73519449.26506585.02
Max522069.00520160.75507925.73
Min520866.82518678.75504975.45
StdDev540.33606.461219.36
CoV0.000.000.00
Median (p50)521947.36519508.27506853.89
p95522056.84520095.50507818.55
p99522066.57520147.70507904.29
Skewness-0.68-0.15-0.32
Iteration 1520866.82518678.75504975.45
Iteration 2522069.00519508.27506853.89
Iteration 3521947.36520160.75507925.73

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean479019.64467352.19463955.99
Max479691.47468923.51463995.41
Min477772.95465740.12463936.05
StdDev882.431299.9327.88
CoV0.000.000.00
Median (p50)479594.49467392.94463936.50
p95479681.77468770.45463989.52
p99479689.53468892.90463994.23
Skewness-0.70-0.050.71
Iteration 1477772.95468923.51463936.50
Iteration 2479691.47467392.94463936.05
Iteration 3479594.49465740.12463995.41

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean373735.70350305.29361969.19
Max375155.83352367.96362133.17
Min372545.18348507.78361822.79
StdDev1078.091587.03127.32
CoV0.000.000.00
Median (p50)373506.09350040.12361951.60
p95374990.86352135.18362115.01
p99375122.84352321.40362129.54
Skewness0.310.250.20
Iteration 1375155.83352367.96362133.17
Iteration 2373506.09350040.12361822.79
Iteration 3372545.18348507.78361951.60