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

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Variables
    • 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

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              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.