[MDEV-28415] ALTER TABLE on a large table hangs InnoDB - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.2.44, 10.3.35, 10.4.25
Component/s: Storage Engine - InnoDB
Labels:
- not-10.5

Description

MySQL 5.7.38 includes the following change without a test case:
Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE
As far as I understand the description, any CREATE INDEX or table-rebuilding ALTER TABLE operation could exhaust the buffer pool by unnecessarily holding exclusive latches on non-leaf index pages, preventing those pages from being written out.

Attachments

Issue Links

is part of

MDEV-28417 Merge new release of InnoDB 5.7.38 to 10.2

Closed

relates to

MDEV-14550 Error log flood : "InnoDB: page_cleaner: 1000ms intended loop took N ms. The settings might not be optimal."

Closed

MDEV-16809 Allow full redo logging for ALTER TABLE

Closed

MDEV-23399 10.5 performance regression with IO-bound tpcc

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-04-26 10:26

Updated:: 2022-04-27 05:49

Resolved:: 2022-04-27 05:49

Git Integration

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