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

Online change innodb_buffer_pool_size is inoperative

    XMLWordPrintable

Details

    Description

      Linux Version: Rocky Linux release 9.6 (Blue Onyx)

      Mariadb Version: mysql Ver 15.1 Distrib 10.11.14-MariaDB, for linux-systemd (x86_64) using readline 5.1

      Online change:

      MariaDB [(none)]> show global variables like 'innodb_buffer_pool_size';
      ------------------------------------+

      Variable_name Value

      ------------------------------------+

      innodb_buffer_pool_size 92341796864

      ------------------------------------+
      1 row in set (0.000 sec)

      MariaDB [(none)]> set global innodb_buffer_pool_size = 96636764160;
      Query OK, 0 rows affected, 1 warning (0.000 sec)

      MariaDB [(none)]> exit;
      Bye

      MariaDB [(none)]> show global variables like 'innodb_buffer_pool_size';
      ------------------------------------+

      Variable_name Value

      ------------------------------------+

      innodb_buffer_pool_size 92341796864

      ------------------------------------+
      1 row in set (0.000 sec)

      Attachments

        Issue Links

          Activity

            People

              dbart Daniel Bartholomew
              rank rank
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.