Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.59, 10.0.33, 10.1.30, 10.2.12, 10.3.3
-
None
Description
The regression test suite shows a performance regression for OLTP read-only workload and tables using ARIA ROW_FORMAT=FIXED and MyISAM. The regression is about 10% and shows for high thread counts.
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-5.5.55 24233 153899 229933 191197 177841 176224 182591
|
mariadb-5.5.56 23907 148898 229983 190843 176440 174863 179944
|
mariadb-5.5.57 24271 149773 232199 187781 175067 174166 179854
|
mariadb-5.5.58 23649 147045 230375 189832 176888 175965 181635
|
mariadb-5.5.59 23972 146035 228479 181670 162574 157294 158720
|
--------------------------------------------------------------------------------
|
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-5.5.55 24148 139714 136335 110383 110686 112551 118669
|
mariadb-5.5.56 23954 139581 135150 110631 110705 112571 118371
|
mariadb-5.5.57 24823 141867 132584 109108 109217 111262 116896
|
mariadb-5.5.58 23362 137074 135110 111791 112141 114064 120162
|
mariadb-5.5.59 24988 134888 134112 105874 107336 109250 114030
|