Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25800

DROP TABLE unnecessarily accesses .ibd file

    XMLWordPrintable

Details

    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

          Activity

            People

              debarun Debarun Banerjee
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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