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

Add missing MySQL variable log_bin_basename and log_bin_index

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.14
    • 10.1.6
    • Replication
    • None

    Description

      I noticed MariaDB does not have corresponding MySQL system variables:

      log_bin_basename and log_bin_index

      Without log_bin_basename, there is no way to tell the location and name of the binary log.

      This is easily identifiable in MySQL:

      mysql> show global variables like 'log_bin%';
      +---------------------------------+---------------------------------------------------------------------+
      | Variable_name                   | Value                                                               |
      +---------------------------------+---------------------------------------------------------------------+
      | log_bin                         | ON                                                                  |
      | log_bin_basename                | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin       |
      | log_bin_index                   | C:\Program Files\MySQL\MySQL Server 5.6\Data\chris-laptop-bin.index |

      Without these, you can only conform whether binlogging is enabled or not.

      Attachments

        Issue Links

          Activity

            These variables were not listed in the report below, and it is "closed", hence this new bug report:

            https://mariadb.atlassian.net/browse/MDEV-5277

            ccalender Chris Calender (Inactive) added a comment - These variables were not listed in the report below, and it is "closed", hence this new bug report: https://mariadb.atlassian.net/browse/MDEV-5277

            log-bin-basename is actually listed in MDEV-5277, in the last section "NO_CMD_LINE options", which are said not to be added.

            Assigning to svoj who can probably remember why it was decided not to add it, and comment on log_bin_index as well.

            elenst Elena Stepanova added a comment - log-bin-basename is actually listed in MDEV-5277 , in the last section "NO_CMD_LINE options", which are said not to be added. Assigning to svoj who can probably remember why it was decided not to add it, and comment on log_bin_index as well.

            MDEV-5277 was supposed to add missing command line options. While these options have NO_CMD_LINE flag, which means they're just system variables without corresponding command line.

            MySQL revision-id is mats.kindahl@oracle.com-20101104144352-z7dy7e46jlexdfnw

            They should probably be added indeed.

            svoj Sergey Vojtovich added a comment - MDEV-5277 was supposed to add missing command line options. While these options have NO_CMD_LINE flag, which means they're just system variables without corresponding command line. MySQL revision-id is mats.kindahl@oracle.com-20101104144352-z7dy7e46jlexdfnw They should probably be added indeed.

            knielsen, could you take this? Upstream patch is a bit more than just adding log_bin_basename and log_bin_index. I'm not sure if those changes are valuable.

            svoj Sergey Vojtovich added a comment - knielsen , could you take this? Upstream patch is a bit more than just adding log_bin_basename and log_bin_index. I'm not sure if those changes are valuable.
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - http://lists.askmonty.org/pipermail/commits/2015-May/007829.html
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - Patch: https://github.com/MariaDB/server/commit/f965cae5fb04a9fd06a939a8f2b52228a62ce9fa KB entries: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#log_bin_basename https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#log_bin_index https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#relay_log_basename

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              ccalender Chris Calender (Inactive)
              Votes:
              7 Vote for this issue
              Watchers:
              8 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.