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

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

                Dates

                Due:
                Created:
                Updated:
                Resolved: