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

Feature request: Server system variables source of configuration

    XMLWordPrintable

    Details

      Description

      When we analyse MariaDB servers of our customers it is sometimes not clear from where (which file) a specific configuration variable is coming from.

      Thus it would be greate to see the configuration source of a variable. For example:

      {{SQL> SELECT * FROM information_schema.global_variables LIMIT 10;
      +----------------------------------------------+----------------+------------------------------------+
      | VARIABLE_NAME                                | VARIABLE_VALUE | VARIABLE_SOURCE                    |
      +----------------------------------------------+----------------+------------------------------------+
      | INNODB_LOG_CHECKSUMS                         | ON             | default                            |
      | PERFORMANCE_SCHEMA                           | ON             | /etc/mysql/my.cnf                  |
      | SYSTEM_VERSIONING_ALTER_HISTORY              | ERROR          | /etc/mysql/conf.d/mariadb.cnf      |
      | UNIQUE_CHECKS                                | ON             | /etc/mysql/mariadb.conf.d/blub.cnf |
      | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10             | default                            |
      | MAX_RELAY_LOG_SIZE                           | 134217728      | online                             |
      | PERFORMANCE_SCHEMA_MAX_COND_CLASSES          | 90             | default                            |
      | HAVE_RTREE_KEYS                              | YES            | /etc/mysql/my.cnf                  |
      | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES        | -1             | default                            |
      +----------------------------------------------+----------------+------------------------------------+
      

      Where variable source can be:

      • A filename where it was configured
      • default if it was NOT configured at all
      • online if it was configured dynamic/online with SET GLOBAL ...

      I have not found this FR in jira. I hope I have searched good enough...

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration