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

MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables"

Details

    • 10.2.1-1, 10.2.1-2, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-2, 10.0.28, 10.2.4-1

    Attachments

      Issue Links

        causes

        Bug - A problem which impairs or prevents the functions of the product. MDEV-11227 mysqlimport -l doesn't issue UNLOCK TABLES

        • Blocker - Blocks development and/or testing work, production could not run.
        • Closed
        duplicates

        Task - A task that needs to be done. MDEV-7191 optimizations for THR_LOCK and mdl

        • Major - Major loss of function.
        • Closed
        includes

        Bug - A problem which impairs or prevents the functions of the product. MDEV-7894 ALTER TABLE ... IMPORT/DISCARD TABLESPACE under LOCK TABLES doesn't acquire X metadata lock

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-7895 HANDLER READ doesn't upgrade metadata lock from S to SR

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Closed
        relates to

        Bug - A problem which impairs or prevents the functions of the product. MDEV-10245 Two concurrent OPTIMIZE on InnoDB table can cause a long timed wait

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-10719 'create temporary table as select' generates unnecessary table locks

        • Major - Major loss of function.
        • Confirmed

        Activity

          Ascending order - Click to sort in descending order
          View 11 older comments
          serg Sergei Golubchik added a comment -

          I think it's enough to disable auto-commit. Then if any innodb table was mentioned, it will open a transaction automatically.

          serg Sergei Golubchik added a comment - I think it's enough to disable auto-commit. Then if any innodb table was mentioned, it will open a transaction automatically.
          svoj Sergey Vojtovich added a comment -

          serg, please review 4 patches in bb-10.2-mdev7660. Please note that I don't feel confident about the last patch, which disables autocommit. I can't foresee all possible side effects.

          svoj Sergey Vojtovich added a comment - serg , please review 4 patches in bb-10.2-mdev7660. Please note that I don't feel confident about the last patch, which disables autocommit. I can't foresee all possible side effects.
          svoj Sergey Vojtovich added a comment -

          serg, please review my last comments, specifically what should we do about deadlock? Fix this particular thing on MDL level?

          svoj Sergey Vojtovich added a comment - serg , please review my last comments, specifically what should we do about deadlock? Fix this particular thing on MDL level?
          serg Sergei Golubchik added a comment -

          Will deadlock timeout in 50 seconds?

          One simple workaround would be to have an option, like, --innodb-locks-unsafe-for-handler, and only use this optimization if it's true.

          Ideally, the server should be able to break InnoDB locks.

          serg Sergei Golubchik added a comment - Will deadlock timeout in 50 seconds? One simple workaround would be to have an option, like, --innodb-locks-unsafe-for-handler , and only use this optimization if it's true. Ideally, the server should be able to break InnoDB locks.
          svoj Sergey Vojtovich added a comment -

          serg, please review latest patch at https://github.com/MariaDB/server/commit/c90bd38809582b27696a68058fbd57c57d6dbf6d

          svoj Sergey Vojtovich added a comment - serg , please review latest patch at https://github.com/MariaDB/server/commit/c90bd38809582b27696a68058fbd57c57d6dbf6d

          People

            svoj Sergey Vojtovich
            svoj Sergey Vojtovich
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.