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

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

                Dates

                Created:
                Updated: