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

Do not acquire InnoDB record locks when covering table locks exist

    XMLWordPrintable

Details

    Description

      InnoDB is unnecessarily acquiring record locks when the transaction is already holding a table lock that prevents any conflicts. Starting with MySQL 4.0 or 4.1, the table locks acquired by LOCK TABLES are mapped to shared or exclusive InnoDB table locks, but InnoDB is still acquiring unnecessary record locks internally.

      The attached patch is only a start. It adjusts a debug check so that exclusive or shared table locks are considered to be equivalent to exclusive or shared record locks.

      Attachments

        Issue Links

          Activity

            People

              vlad.lesin Vladislav Lesin
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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