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

--expire-logs-count=N as an alternate to --expire-logs-days

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Feature Request:

      I would like to please request a new binary log removal option, similar to --expire-logs-days (expire_logs_days), but it would be --expire-logs-count=N, where one could specify the actual # of binary logs to keep. This would purge binlog files when the count exceeds N.

      There are multiple advantages to this new option:

      1. You can more accurately account for space requirements this way (i.e., since one would already knwo the max binary log size and now the total number of binary logs that would exist).

      2. You avoid the "Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'" problem that occurs for those who use --expire-logs-days and use a backup older than --expire-logs-days (i.e., if you do that, which can be common in certain situations, your binary logs will be deleted immediately followed by the above error, and replication breaking.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ccalender Chris Calender (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            4 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.