[MDEV-25800] DROP TABLE unnecessarily accesses .ibd file - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Fix Version/s: 10.6
Component/s: Storage Engine - InnoDB
Labels:
- performance

Description

In stack traces posted to ~~MDEV-25773~~, we can observe that DROP DATABASE (or DROP TABLE) would end up waiting for the buffer pool mutex, for allocating a page so that the to-be-dropped table could be opened.

This is unnecessary and could cause a crash, in case the data file is corrupted. In ~~MDEV-21069~~ we already removed writes to the .ibd file on DROP TABLE. There should be no need to read the .ibd file either.

Attachments

Issue Links

relates to

MDEV-25801 DROP DATABASE very slow after innodb undo log truncate

Closed

MDEV-21069 Crash on DROP TABLE if the data file is corrupted

Closed

MDEV-25773 sysbench-TPCC failed to prepare with extremely slow execution

Closed

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...

(2 mentioned in)

Activity

People

Assignee:: Debarun Banerjee

Reporter:: Marko Mäkelä

Votes:: 3 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-05-27 13:14

Updated:: 2024-11-13 22:42

Git Integration

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