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

Global variables should only contain configuration settings not state (gtid_current_pos / gtid_slave_pos)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.0.14
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:

      Description

      On a server I notice:

      root@myserver [(none)]> show global variables like 'gtid%';
      +------------------------+----------------------+
      | Variable_name          | Value                |
      +------------------------+----------------------+
      | gtid_binlog_pos        |                      |
      | gtid_binlog_state      |                      |
      | gtid_current_pos       | 0-187204017-44995072 |
      | gtid_domain_id         | 0                    |
      | gtid_ignore_duplicates | OFF                  |
      | gtid_slave_pos         | 0-187204017-44995072 |
      | gtid_strict_mode       | OFF                  |
      +------------------------+----------------------+
      7 rows in set (0.00 sec)

      The 2 "variables" gtid_current_pos and gtid_slave_pos do not have configuration settings but state. Configuration state should be stored somewhere else. SHOW GLOBAL STATUS has traditionally been used for this.

      See an upstream equivalent ticket I wrote some time ago (not resolved either).

      As stated in the original ticket I care because I collect this configuration information and have to explicitly filter out settings like this which change continually to be able to compare settings from one server to another or one moment in time to another.

      So please remove these variables from global_variables and put the information somewhere else.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            simon.mudd Simon J Mudd
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: