TPS by Thread Count - POINT_SELECT

MDEV-39364 - orig

Comparison: TPS

ThreadsMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
4240220.203251520.547252041.140
8261885.043296276.787293569.157
16302371.770310017.413307824.703
32513643.193511296.377506065.593
64468487.713456622.447458467.787
128366670.857350302.397356979.460

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

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 13:15:012026-4-22 23:07:582026-4-23 17:31:04

Thread Count: 4

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean240220.20251520.55252041.14
Max246831.62254521.86255017.48
Min236242.56249769.30249857.10
StdDev4707.062132.092179.94
CoV0.020.010.01
Median (p50)237586.43250270.48251248.84
p95245907.10254096.72254640.62
p99246646.72254436.83254942.11
Skewness0.660.680.50
Iteration 1246831.62254521.86255017.48
Iteration 2237586.43250270.48251248.84
Iteration 3236242.56249769.30249857.10

Thread Count: 8

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean261885.04296276.79293569.16
Max262046.97303417.59293805.26
Min261693.82292336.79293390.25
StdDev145.655058.32174.19
CoV0.000.020.00
Median (p50)261914.34293075.98293511.96
p95262033.71302383.43293775.93
p99262044.32303210.76293799.39
Skewness-0.290.700.46
Iteration 1261914.34293075.98293511.96
Iteration 2262046.97292336.79293390.25
Iteration 3261693.82303417.59293805.26

Thread Count: 16

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean302371.77310017.41307824.70
Max302863.69310350.83308993.26
Min301696.71309535.63305804.49
StdDev493.70348.951434.35
CoV0.000.000.00
Median (p50)302554.91310165.78308676.36
p95302832.81310332.33308961.57
p99302857.51310347.13308986.92
Skewness-0.51-0.56-0.68
Iteration 1302554.91309535.63305804.49
Iteration 2302863.69310350.83308676.36
Iteration 3301696.71310165.78308993.26

Thread Count: 32

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean513643.19511296.38506065.59
Max514039.78513007.82506580.65
Min512943.09510206.69505758.00
StdDev496.501225.16366.49
CoV0.000.000.00
Median (p50)513946.71510674.62505858.13
p95514030.47512774.50506508.40
p99514037.92512961.16506566.20
Skewness-0.690.630.67
Iteration 1512943.09510674.62505858.13
Iteration 2513946.71510206.69506580.65
Iteration 3514039.78513007.82505758.00

Thread Count: 64

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean468487.71456622.45458467.79
Max469272.26458063.53459726.07
Min467584.58454164.44457011.32
StdDev694.081746.681117.12
CoV0.000.000.00
Median (p50)468606.30457639.37458665.97
p95469205.66458021.11459620.06
p99469258.94458055.05459704.87
Skewness-0.25-0.68-0.26
Iteration 1469272.26457639.37459726.07
Iteration 2468606.30458063.53457011.32
Iteration 3467584.58454164.44458665.97

Thread Count: 128

MetricMariadb 11.8.6-MariaDBMariadb 12.3.1-MariaDBMariadb 13.0.0-MariaDB
Mean366670.86350302.40356979.46
Max367368.04353610.32357714.48
Min366134.39346890.92356279.35
StdDev516.302744.16586.41
CoV0.000.010.00
Median (p50)366510.14350405.95356944.55
p95367282.25353289.88357637.49
p99367350.88353546.23357699.08
Skewness0.44-0.060.09
Iteration 1367368.04353610.32357714.48
Iteration 2366134.39350405.95356279.35
Iteration 3366510.14346890.92356944.55