Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.4
-
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
Issue Links
- is caused by
-
MDEV-15053 Reduce buf_pool_t::mutex contention
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Axel Schwenke [ axel ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | range_distinct.png [ 52502 ] | |
| Attachment | range_ordered.png [ 52503 ] | |
| Attachment | range_simple.png [ 52504 ] | |
| Attachment | range_sum.png [ 52505 ] |
| Attachment | simpe_range4.png [ 52527 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Link |
This issue relates to |
| Link |
This issue is caused by |
| Assignee | Axel Schwenke [ axel ] | Marko Mäkelä [ marko ] |
| Attachment | MDEV-23017.pdf [ 52551 ] |
| issue.field.resolutiondate | 2020-07-02 07:27:07.0 | 2020-07-02 07:27:07.751 |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Fix Version/s | 10.5.5 [ 24423 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link | This issue blocks MDEV-23074 [ MDEV-23074 ] |
| Workflow | MariaDB v3 [ 110516 ] | MariaDB v4 [ 158022 ] |