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

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

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

          People

            monty Michael Widenius
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.