-------------------------------------------------------------------------------- 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.2.34 21064 144612 223219 370361 365694 367503 363005 mariadb-10.2.35 21034 144255 221462 364645 363308 362537 360861 -------------------------------------------------------------------------------- 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.2.34 20152 140275 218743 358922 364649 365435 362179 mariadb-10.2.35 20711 140319 220833 358984 364700 365666 362658 -------------------------------------------------------------------------------- Test 't_oltp-9010-innodb-multi' - sysbench simplified OLTP read/write 16 InnoDB tables with 1 mio rows total, 9 point selects + 1 update numbers are queries per second #thread count 1 8 16 32 64 128 256 mariadb-10.2.34 3942.3 21096 35578 50745 57439 59822 58590 mariadb-10.2.35 3997.8 22113 37679 53798 59062 60811 58634 -------------------------------------------------------------------------------- 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.2.34 4704.1 20829 38974 69737 124582 166192 185236 mariadb-10.2.35 4770.5 27634 51266 89290 152881 181892 186598 -------------------------------------------------------------------------------- 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.2.34 4673.0 18181 31052 50964 87576 133973 159350 mariadb-10.2.35 5019.1 27689 50377 88610 149588 170472 168138 -------------------------------------------------------------------------------- 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.2.34 3973.6 19851 37639 69274 114649 167443 186878 mariadb-10.2.35 4540.2 28339 54153 89402 139928 178664 185825 -------------------------------------------------------------------------------- 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.2.34 3640.8 17168 30097 55689 85382 111807 135684 mariadb-10.2.35 4602.1 28815 53517 87859 131675 151234 146157