Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-2174

Enhance size statistics to not wait for the table lock

        Details

        • Type: Improvement
        • Status: Resolved
        • Priority: Major - P3
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: WT2.7.0
        • Labels:
          None

          Description

          It is possible to construct workloads where the table lock is contended. In such cases it can take a long time to open a cursor with statistics=[size].

          We want to avoid blocking when opening special size cursors if at all possible.

            Issue Links

            is depended on by

            Bug - A problem which impairs or prevents the functions of the product. SERVER-20961 Large amounts of create and drop collections can cause listDatabases to be slow under WiredTiger

            • Major - P3 - Major loss of function.
            • Closed

              Activity

              • Comments
              Ascending order - Click to sort in descending order
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'}

              Message: WT-2174 Avoid the table list lock when creating a size only statistics cursor.

              When there are lots of tables being created and dropped it can take
              a long time to get the table lock.
              Branch: develop
              https://github.com/wiredtiger/wiredtiger/commit/9601694d41b4c1812cb6246ca98e4707c633291c

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'} Message: WT-2174 Avoid the table list lock when creating a size only statistics cursor. When there are lots of tables being created and dropped it can take a long time to get the table lock. Branch: develop https://github.com/wiredtiger/wiredtiger/commit/9601694d41b4c1812cb6246ca98e4707c633291c
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'}

              Message: WT-2174 Fixup error handling.
              Branch: develop
              https://github.com/wiredtiger/wiredtiger/commit/792274584fcd714795f374f3180a7bc74832dd38

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'} Message: WT-2174 Fixup error handling. Branch: develop https://github.com/wiredtiger/wiredtiger/commit/792274584fcd714795f374f3180a7bc74832dd38
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'}

              Message: WT-2174 - Cleanup per review comments.
              Branch: develop
              https://github.com/wiredtiger/wiredtiger/commit/db39ef5dab91403e1509da7e17eb34cd9c1b3bbb

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexg@wiredtiger.com'} Message: WT-2174 - Cleanup per review comments. Branch: develop https://github.com/wiredtiger/wiredtiger/commit/db39ef5dab91403e1509da7e17eb34cd9c1b3bbb
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'michaelcahill', u'name': u'Michael Cahill', u'email': u'michael.cahill@mongodb.com'}

              Message: Merge pull request #2256 from wiredtiger/stat-fast-no-table-lock

              WT-2174 Avoid the table list lock when creating a size only statistics cursor.
              Branch: develop
              https://github.com/wiredtiger/wiredtiger/commit/497b744d654c211e95385c5813e224e31d144491

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'michaelcahill', u'name': u'Michael Cahill', u'email': u'michael.cahill@mongodb.com'} Message: Merge pull request #2256 from wiredtiger/stat-fast-no-table-lock WT-2174 Avoid the table list lock when creating a size only statistics cursor. Branch: develop https://github.com/wiredtiger/wiredtiger/commit/497b744d654c211e95385c5813e224e31d144491
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'michaelcahill', u'name': u'Michael Cahill', u'email': u'michael.cahill@mongodb.com'}

              Message: Merge pull request #2256 from wiredtiger/stat-fast-no-table-lock

              (cherry picked from commit 497b744d6)

              WT-2174 Backport - Enhance size statistics to not wait for the table lock
              Branch: mongodb-3.0
              https://github.com/wiredtiger/wiredtiger/commit/deadcdaf1bfe3ba73243e1b5f1a83b3af80deb91

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'michaelcahill', u'name': u'Michael Cahill', u'email': u'michael.cahill@mongodb.com'} Message: Merge pull request #2256 from wiredtiger/stat-fast-no-table-lock (cherry picked from commit 497b744d6) WT-2174 Backport - Enhance size statistics to not wait for the table lock Branch: mongodb-3.0 https://github.com/wiredtiger/wiredtiger/commit/deadcdaf1bfe3ba73243e1b5f1a83b3af80deb91
              Hide
              Permalink
              xgen-internal-githook Githook User added a comment -

              Author:

              {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexander.gorrod@mongodb.com'}

              Message: Merge pull request #2410 from wiredtiger/wt-2174_backport

              WT-2174 Backport - Enhance size statistics to not wait for the table lock
              Branch: mongodb-3.0
              https://github.com/wiredtiger/wiredtiger/commit/a1ddc5e6164ef982dc29dd658d391abff06a7484

              Show
              xgen-internal-githook Githook User added a comment - Author: {u'username': u'agorrod', u'name': u'Alex Gorrod', u'email': u'alexander.gorrod@mongodb.com'} Message: Merge pull request #2410 from wiredtiger/wt-2174_backport WT-2174 Backport - Enhance size statistics to not wait for the table lock Branch: mongodb-3.0 https://github.com/wiredtiger/wiredtiger/commit/a1ddc5e6164ef982dc29dd658d391abff06a7484

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  alexander.gorrod Alexander Gorrod
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: