[MDEV-33823] UUID sorting performance drop in MariaDB 11.3 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Trivial
Resolution: Not a Bug
Affects Version/s: 11.3.2
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB
Labels:
- regression
Environment:
CentOS 8

Description

We noticed a significant performance drop when upgrading from 11.2.3 to 11.3.2. It seems that the sorting by an UUID column causes the issue. When working on a table of ~140k records, the time difference is ~10 times.

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: James Lao

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2024-04-04 00:43

Updated:: 2024-04-04 12:19

Resolved:: 2024-04-04 12:19

Git Integration

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