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

InnoDB should skip MVCC and transaction locking for temporary tables.

Details

    Description

      InnoDB Should skip mvcc and transaction locking for temporary tables in 10.2+. Currently row_search_mvcc() process temporary tables with locking. Temporary tables is private to
      the connection. There can be one active transaction in temporary table. So it is not necessary
      to use mvcc and transaction locking for temporary tables.

      Attachments

        Issue Links

          Activity

            Similarly, InnoDB should skip transactional locking for the change buffer tree. The attachment uniqstack.txt in MDEV-16467 shows that lock_update_delete() is being called via btr_cur_optimistic_delete_func() by ibuf_delete_rec(). There should be no transactions operating on the change buffer tree, hence the locking there is completely unnecessary.

            I would also disable the use of the adaptive hash index on temporary tables and the change buffer tree if they are not already disabled.

            marko Marko Mäkelä added a comment - Similarly, InnoDB should skip transactional locking for the change buffer tree. The attachment uniqstack.txt in MDEV-16467 shows that lock_update_delete() is being called via btr_cur_optimistic_delete_func() by ibuf_delete_rec() . There should be no transactions operating on the change buffer tree, hence the locking there is completely unnecessary. I would also disable the use of the adaptive hash index on temporary tables and the change buffer tree if they are not already disabled.

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 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.