[MDEV-15129] performance regression reading ARIA/MyISAM Created: 2018-01-30  Updated: 2018-02-07  Resolved: 2018-02-07

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 5.5.59, 10.0.33, 10.1.30, 10.2.12, 10.3.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Axel Schwenke Assignee: Axel Schwenke
Resolution: Fixed Votes: 0
Labels: 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



 Comments   
Comment by Axel Schwenke [ 2018-02-03 ]

That is not a regression in MariaDB, but was caused by a kernel upgrade on the machine. The old benchmarks up to 5.5.58 have been done with the 3.16.0 Linux kernel, 5.5.59 used 4.4.0. Rebooting with the 3.16 kernel solved the mystery: 

mariadb-5.5.58 (3.16.0)     23649   147045  230375  189832  176888  175965  181635                                
mariadb-5.5.59 (3.16.0)     25245   151360  230536  188698  175999  175595  181373                                
mariadb-5.5.59 (4.4.0)      23972   146035  228479  181670  162574  157294  158720

Comment by Axel Schwenke [ 2018-02-03 ]

Leaving this issue "stalled" until all benchmarks that were done with the 4.4.0 kernel have been repeated with 3.16 and we can be sure that there is no real regression.

Comment by Axel Schwenke [ 2018-02-07 ]

Turned out not to be a regression in MariaDB. Benchmarks repeated with 3.16 kernel yielded the expected results.

Generated at Thu Feb 08 08:18:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.