[MDEV-23017] range query performance regression in 10.5.4 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.4
Fix Version/s: 10.5.5
Component/s: Storage Engine - InnoDB
Labels:
None

Description

The regression test suite reports rather severe performance regressions in MariaDB 10.5.4 vs. 10.5.3. It looks like it is genuinely for the sysbench OLTP range queries. Example:

Test 't_collate_distinct_range_utf8_general' - sysbench OLTP readonly

selecting distinct rows from short range, collation utf8_general_ci

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.5.3          7840.1  53249   92616   149360  149130  149435  148546

mariadb-10.5.4          7794.3  52208   91235   131122  137925  128168  94999

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

simpe_range4.png
4 kB
2020-07-01 08:34
range_sum.png
5 kB
2020-06-30 12:20
range_simple.png
5 kB
2020-06-30 12:20
range_ordered.png
5 kB
2020-06-30 12:20
range_distinct.png
5 kB
2020-06-30 12:20
MDEV-23017.pdf
29 kB
2020-07-02 07:15

Issue Links

is caused by

MDEV-15053 Reduce buf_pool_t::mutex contention

Closed

relates to

MDEV-515 innodb bulk insert

Closed

MDEV-12288 Reset DB_TRX_ID when the history is removed, to speed up MVCC

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Axel Schwenke

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2020-06-25 19:07

Updated:: 2020-07-02 14:07

Resolved:: 2020-07-02 07:27

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.