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

Add support for SI suffixes in SET statement for configuring size-related variables

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Variables
    • Labels:
      None

      Description

      There are several size-related system variables that can be changed dynamically. e.g.:

      • innodb_log_file_size
      • innodb_buffer_pool_size
      • max_heap_table_size
      • tmp_table_size
      • tmp_disk_table_size
      • binlog_cache_size
      • binlog_file_cache_size
      • binlog_stmt_cache_size
      • etc.

      In configuration files, users are able to set these variables using SI prefixes. e.g.:

      [mariadb]
      innodb_log_file_size=2G
      

      It would be great if users could do the same thing with SET:

      SET GLOBAL innodb_log_file_size='2G';
      

      Currently, users would have to do this instead:

      SET GLOBAL innodb_log_file_size=(2 * 1024 * 1024 * 1024);
      

      Can we implement SI prefixes for SET?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ralf.gebhardt@mariadb.com Ralf Gebhardt
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.