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

Enhancing information_schema.global_variables

Details

    Description

      Would it be possible to add the following 2 columns in tie information_schema.global_variables table :
      1. a column which indicate wether the status variable is dynamic or not
      2. a column which indicates wether the actual value is default, inherited from config file or changed through set global command

      the first one is purely indicative, so very not important, but the second one could defintly help with configuration management and would comes in handy.

      Attachments

        Activity

          serg Sergei Golubchik added a comment - - edited

          Can you show an example of what it could look like? E.g. I'll take four rows out of the ~450 row table:

          | Com_drop_trigger                              | 0                    |
          | Com_stmt_reset                                | 0                    |
          | Opened_files                                  | 66                   |
          | Ssl_default_timeout                           | 0                    |
          

          (rows number 100, 200, 300, and 400). What should these columns show for them?

          serg Sergei Golubchik added a comment - - edited Can you show an example of what it could look like? E.g. I'll take four rows out of the ~450 row table: | Com_drop_trigger | 0 | | Com_stmt_reset | 0 | | Opened_files | 66 | | Ssl_default_timeout | 0 | (rows number 100, 200, 300, and 400). What should these columns show for them?

          oh my bad, i do notice i made a mistake in the table name.
          i was thiunking about global_variables not global_status. i will modify the issue accordingly and provide an example.

          SylvainArbaudie Sylvain ARBAUDIE added a comment - oh my bad, i do notice i made a mistake in the table name. i was thiunking about global_variables not global_status. i will modify the issue accordingly and provide an example.
          SylvainArbaudie Sylvain ARBAUDIE added a comment - - edited

          outpuit example :

          mysql> SHOW GLOBAL VARIABLES;

          Variable_name Value Dynamic Source
          basedir /usr/ No File
          bind_address '*' No Default
          general_log_file host_name.log Yes Default
          tmp_table_size 24M Yes File
          innodb_buffer_poolçsize 3G Yes Set
          SylvainArbaudie Sylvain ARBAUDIE added a comment - - edited outpuit example : mysql> SHOW GLOBAL VARIABLES; Variable_name Value Dynamic Source basedir /usr/ No File bind_address '*' No Default general_log_file host_name.log Yes Default tmp_table_size 24M Yes File innodb_buffer_poolçsize 3G Yes Set

          Did you look at INFORMATION_SCHEMA.SYSTEM_VARIABLES table?

          It was implemented in 10.1.1, ten years ago.

          serg Sergei Golubchik added a comment - Did you look at INFORMATION_SCHEMA.SYSTEM_VARIABLES table? It was implemented in 10.1.1, ten years ago.

          I didnt even know this existed. I've always looked at INFORMATION_SCHEMA.GLOBAL_VARIABLES table.

          thanks a lot

          SylvainArbaudie Sylvain ARBAUDIE added a comment - I didnt even know this existed. I've always looked at INFORMATION_SCHEMA.GLOBAL_VARIABLES table. thanks a lot

          People

            serg Sergei Golubchik
            SylvainArbaudie Sylvain ARBAUDIE
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.