[MDEV-35163] InnoDB persistent statistics fail to update after ALTER TABLE...ALGORITHM=COPY - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5(EOL), 10.6, 10.11, 11.4
Fix Version/s: 10.6.24, 10.11.15, 11.4.9, 11.8.4, 12.1.2, 12.2.1
Component/s: Storage Engine - InnoDB
Labels:

Bug Category:
Can result in unexpected behaviour
Release Note Summary:
ALTER TABLE could fail to update InnoDB persistent statistics.

Description

The test case for the following change in MySQL 8.0.37 suggests that MariaDB is affected by the same:
Bug#35127747 The n_rows value becomes 0 when repeated altering with algorithm=copy within 10 seconds

That is, for ALTER TABLE...ALGORITHM=COPY the InnoDB statistics will not be updated. This is similar to ~~MDEV-28327~~, which affected INSERT. Note: I did not test with the ~~MDEV-33087~~ setting innodb_alter_copy_bulk=ON.

Attachments

Issue Links

causes

MDEV-38667 Assertion in diagnostics area on DDL stats timeout

Closed

MDEV-38882 Assertion in diagnostics area on DDL stats (MDEV-38667 not fully fixed)

Closed

relates to

MDEV-28327 InnoDB persistent statistics fail to update after bulk insert

Closed

MDEV-33087 ALTER TABLE...ALGORITHM=COPY should build indexes more efficiently

Closed

MDEV-34672 Merge applicable InnoDB changes from MySQL 8.0.38 and 8.0.39

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-10-16 04:53

Updated:: 2026-04-13 06:11

Resolved:: 2025-09-22 12:43

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

2d 5.25h

Git Integration

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