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

Don't keep binary log index file locked during show binary logs

    XMLWordPrintable

Details

    Description

      While doing show binary logs, the index_file mutex is kept locked during the reading of the index file and while calculating the length of each binary file.

      On some systems with 10,000+ binlogs, show binary logs could block log rotation for more than 10 seconds. When this happens, the server is locked for commits during the binary log rotation.

      The fix is to not keep the mutex locked while calculating the file sizes.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d Original Estimate - 1d
                  1d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2.25d
                  2.25d

                  Git Integration

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