-------------------------------------------------------------------------------- Test 't_1K-reads-aria-fixed-multi' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 32 tables, 1 mio rows total, engine ARIA ROW_FORMAT=FIXED numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 18193 119414 172979 144541 137629 140458 143094 mariadb-10.4.8-mb4 17336 118940 173071 146018 138650 141955 144956 -------------------------------------------------------------------------------- Test 't_1K-reads-aria-fixed-single' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 1 table, 1 mio rows, engine ARIA ROW_FORMAT=FIXED numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 17320 117726 176067 166203 147085 145697 148075 mariadb-10.4.8-mb4 17205 118177 177393 168197 148518 145595 148798 -------------------------------------------------------------------------------- Test 't_1K-reads-aria-multi' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 32 tables, 1 mio rows total, engine ARIA TRANSACTIONAL=0 numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 17667 109020 111575 94328 96635 98945 100117 mariadb-10.4.8-mb4 17561 110323 114735 94624 96630 99400 100513 -------------------------------------------------------------------------------- Test 't_1K-reads-aria-single' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 1 table, 1 mio rows total, engine ARIA TRANSACTIONAL=0 numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 17826 105754 92662 81577 82742 84236 84772 mariadb-10.4.8-mb4 18423 107876 90874 80865 81969 83206 83852 -------------------------------------------------------------------------------- Test 't_1K-reads-innodb-multi' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 20 tables, 1 mio rows total, engine InnoDB/XtraDB (builtin) numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 18185 129164 211136 345821 347471 348081 344796 mariadb-10.4.8-mb4 18405 128147 209724 343457 343846 344178 342814 -------------------------------------------------------------------------------- Test 't_1K-reads-innodb-single' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 1 table, 1 mio rows, engine InnoDB/XtraDB (builtin) numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 18795 128542 209073 345015 341029 343621 339355 mariadb-10.4.8-mb4 17608 123749 205211 339227 339756 341613 338120 -------------------------------------------------------------------------------- Test 't_1K-reads-memory-multi' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 20 tables, 1 mio rows total, engine MEMORY numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 19465 132861 217432 365103 361621 361478 359014 mariadb-10.4.8-mb4 18505 133866 218071 363660 361948 363799 359294 -------------------------------------------------------------------------------- Test 't_1K-reads-memory-single' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 1 table, 1 mio rows, engine MEMORY numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 19961 136203 216275 334705 348676 345682 336016 mariadb-10.4.8-mb4 19054 133049 212257 330359 342775 341466 331101 -------------------------------------------------------------------------------- Test 't_1K-reads-myisam-multi' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 20 tables, 1 mio rows total, engine MyISAM numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 18095 114084 130594 96188 97421 98352 100088 mariadb-10.4.8-mb4 17757 113068 129351 94658 96673 97974 99772 -------------------------------------------------------------------------------- Test 't_1K-reads-myisam-single' - sysbench OLTP readonly 1000 point selects per iteration, no range queries 1 table, 1 mio rows, engine MyISAM numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 17549 114455 131410 95995 97246 97920 99565 mariadb-10.4.8-mb4 17341 111899 132169 96209 97115 97810 99520 -------------------------------------------------------------------------------- Test 't_aria_insert_fixed' - insert rows in batches of 100 single table, engine ARIA ROW_FORMAT=FIXED, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 876.99 mariadb-10.4.8-mb4 758.27 -------------------------------------------------------------------------------- Test 't_aria_insert_fixed_ni' - insert rows in batches of 100 single table, engine ARIA ROW_FORMAT=FIXED, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 1423.2 mariadb-10.4.8-mb4 1066.5 -------------------------------------------------------------------------------- Test 't_aria_insert_fixed_tmp' - insert rows in batches of 100 temporary table, engine ARIA ROW_FORMAT=FIXED, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 893.63 mariadb-10.4.8-mb4 779.82 -------------------------------------------------------------------------------- Test 't_aria_insert_fixed_tmp_ni' - insert rows in batches of 100 temporary table, engine ARIA ROW_FORMAT=FIXED, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 1492.7 mariadb-10.4.8-mb4 976.98 -------------------------------------------------------------------------------- Test 't_aria_insert_page' - insert rows in batches of 100 single table, engine ARIA TRANSACTIONAL=0, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 768.32 mariadb-10.4.8-mb4 738.58 -------------------------------------------------------------------------------- Test 't_aria_insert_page_ni' - insert rows in batches of 100 single table, engine ARIA TRANSACTIONAL=0, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 1099.8 mariadb-10.4.8-mb4 928.90 -------------------------------------------------------------------------------- Test 't_aria_insert_page_tmp' - insert rows in batches of 100 temporary table, engine ARIA TRANSACTIONAL=0, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 876.92 mariadb-10.4.8-mb4 756.92 -------------------------------------------------------------------------------- Test 't_aria_insert_page_tmp_ni' - insert rows in batches of 100 temporary table, engine ARIA TRANSACTIONAL=0, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 1336.0 mariadb-10.4.8-mb4 1042.5 -------------------------------------------------------------------------------- Test 't_aria_insert_trans' - insert rows in batches of 100 single table, engine ARIA TRANSACTIONAL=1, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 211.35 mariadb-10.4.8-mb4 199.47 -------------------------------------------------------------------------------- Test 't_aria_insert_trans_ni' - insert rows in batches of 100 single table, engine ARIA TRANSACTIONAL=1, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 371.51 mariadb-10.4.8-mb4 349.45 -------------------------------------------------------------------------------- Test 't_aria_insert_trans_tmp' - insert rows in batches of 100 temporary table, engine ARIA TRANSACTIONAL=1, PRIMARY KEY AUTO_INCREMENT number is batches inserted per second #thread count 1 mariadb-10.4.8 858.39 mariadb-10.4.8-mb4 751.74 -------------------------------------------------------------------------------- Test 't_aria_insert_trans_tmp_ni' - insert rows in batches of 100 temporary table, engine ARIA TRANSACTIONAL=1, no index number is batches inserted per second #thread count 1 mariadb-10.4.8 1342.7 mariadb-10.4.8-mb4 1006.1 -------------------------------------------------------------------------------- Test 't_connect-TC=64' - connect test, thread cache size = 64 workload: connect; SELECT 1 FROM dual; disconnect numbers are connects per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 6158.4 35140 82603 106240 105821 106162 80734 mariadb-10.4.8-mb4 5224.6 36250 82381 106455 105776 106243 81568 -------------------------------------------------------------------------------- Test 't_connect-TC=default' - connect test, default thread cache size workload: connect; SELECT 1 FROM dual; disconnect numbers are connects per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 5194.3 34556 82247 106595 105277 107460 82955 mariadb-10.4.8-mb4 5952.2 35716 83044 105994 105100 105788 80259 -------------------------------------------------------------------------------- Test 't_oltp-aria-multi' - sysbench OLTP read/write 32 ARIA tables with 100K rows each numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 4047.1 16633 13576 7489.1 9030.0 9553.9 9484.8 mariadb-10.4.8-mb4 4256.0 16026 13162 7357.5 9411.3 9413.7 9581.3 -------------------------------------------------------------------------------- Test 't_oltp-innodb-multi' - sysbench OLTP read/write 32 InnoDB tables with 10 mio rows total numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 4962.5 27988 51470 92859 150177 173933 174360 mariadb-10.4.8-mb4 4629.5 26965 49381 88673 142341 157563 157310 -------------------------------------------------------------------------------- Test 't_oltp-innodb-single' - sysbench OLTP read/write single InnoDB table with 10 mio rows numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 4902.4 27660 51014 92360 150950 160975 154120 mariadb-10.4.8-mb4 4645.1 26798 48923 88785 140364 145690 139675 -------------------------------------------------------------------------------- Test 't_oltp-memory-btree-multi' - sysbench OLTP read/write 32 Memory tables with 100K rows each numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 14986 101353 165368 275200 258493 253226 249704 mariadb-10.4.8-mb4 12777 85994 146491 243690 223752 216416 218440 -------------------------------------------------------------------------------- Test 't_oltp-memory-multi' - sysbench OLTP read/write 32 Memory tables with 100K rows each numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 933.76 5474.2 6694.4 6839.6 6826.9 6823.1 6825.3 mariadb-10.4.8-mb4 367.66 1645.2 1828.0 1845.5 1841.0 1842.2 1841.4 -------------------------------------------------------------------------------- Test 't_oltp-myisam-multi' - sysbench OLTP read/write 32 MyISAM tables with 100K rows each numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 10913 61850 43089 34827 30192 29017 28622 mariadb-10.4.8-mb4 9336.2 57335 43780 34291 29943 29301 28939 -------------------------------------------------------------------------------- Test 't_threadpool_off' - sysbench OLTP readonly 32 InnoDB tables, 1 mio rows total high thread counts, default (thread per worker) scheduling numbers are transactions per second #thread count 1 8 16 32 64 128 256 512 1024 2048 4096 mariadb-10.4.8 775.58 5213.3 9441.0 10765 11371 11180 10270 9702.8 9140.9 8882.8 --- mariadb-10.4.8-mb4 660.42 4453.2 8480.0 9552.6 9946.4 9669.8 8984.2 8781.9 8099.2 7675.4 --- -------------------------------------------------------------------------------- Test 't_threadpool_on' - sysbench OLTP readonly 32 InnoDB tables, 10 mio rows total high thread counts, using the threadpool numbers are transactions per second #thread count 1 8 16 32 64 128 256 512 1024 2048 4096 mariadb-10.4.8 761.90 5096.6 9195.7 11310 11610 11860 11624 11286 10031 9707.5 10067 mariadb-10.4.8-mb4 642.58 4418.0 8326.5 9964.3 10307 10345 10250 9838.5 8870.8 8596.2 8498.1 -------------------------------------------------------------------------------- Test 't_writes-aria-fixed-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 100K rows, engine ARIA ROW_FORMAT=FIXED numbers are queries per second #thread count 1 mariadb-10.4.8 15471 mariadb-10.4.8-mb4 14641 -------------------------------------------------------------------------------- Test 't_writes-aria-page-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 100K rows, engine ARIA TRANSACTIONAL=0 numbers are queries per second #thread count 1 mariadb-10.4.8 14022 mariadb-10.4.8-mb4 13910 -------------------------------------------------------------------------------- Test 't_writes-aria-trans-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 100K rows, engine ARIA TRANSACTIONAL=1 numbers are queries per second #thread count 1 mariadb-10.4.8 4533.5 mariadb-10.4.8-mb4 4531.6 -------------------------------------------------------------------------------- Test 't_writes-binlog-multi' - sysbench OLTP write-only, with synchronous binlog 9 index-update, 9 non-index-update, 1 delete, 1 insert 32 tables, 10 mio rows total, engine InnoDB/XtraDB (builtin) numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 3931.8 19279 33815 59393 102023 146134 158340 mariadb-10.4.8-mb4 4031.0 19445 34221 60468 104409 151828 160817 -------------------------------------------------------------------------------- Test 't_writes-innodb-multi' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert 32 tables, 10 mio rows total, engine InnoDB/XtraDB (builtin) numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 4705.1 29055 53710 91576 143359 175503 179719 mariadb-10.4.8-mb4 4923.0 30121 55203 94409 146619 177881 179272 -------------------------------------------------------------------------------- Test 't_writes-innodb-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 10 mio rows, engine InnoDB/XtraDB (builtin) numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 4568.5 28968 52570 91972 134081 153387 141258 mariadb-10.4.8-mb4 4778.8 29770 54757 93131 134546 154196 141473 -------------------------------------------------------------------------------- Test 't_writes-memory-multi' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert 32 tables, 1 mio rows total, engine MEMORY numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 22038 144668 217227 284352 285612 280492 268931 mariadb-10.4.8-mb4 21206 139293 212579 283253 287407 283216 266796 -------------------------------------------------------------------------------- Test 't_writes-memory-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 1 mio rows, engine MEMORY numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.4.8 21525 10738 10182 10362 10026 9807.0 9739.7 mariadb-10.4.8-mb4 20601 10339 10036 9874.5 9621.5 9765.1 9683.6 -------------------------------------------------------------------------------- Test 't_writes-myisam-single' - sysbench OLTP write-only 9 index-update, 9 non-index-update, 1 delete, 1 insert single table, 1 mio rows, engine MyISAM numbers are queries per second #thread count 1 mariadb-10.4.8 15019 mariadb-10.4.8-mb4 14991