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

relay_log_purge variable not very useful

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.5.16
    • None
    • Replication
    • None

    Description

      I have a backup slave server, where I take regular snapshots of the database via LVM.

      By default, with relay_log_purge enabled, the relay log files get deleted as soon as the server has processed them. I thought it might be handy to hang onto them, in case they were useful if the need to restore from these snapshots ever arose, so I disabled relay_log_purge.

      I was expecting the relay log files to be automatically deleted once relay_log_space_limit was hit, but instead once that limit was hit, new relay logs stopped being written and replication ground to an ugly halt.

      It seems to me that the behavior should be to cycle out old relay logs when relay_log_space_limit is hit, or if that is unset, when the partition fills up. That would allow me to keep as much relay log "as possible" while also not having to manually (is that even possible/recommended?) delete old log files.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              xan@biblionix.com Xan Charbonnet
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.