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

SET GLOBAL innodb_buffer_pool_size cannot be increased by default

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • On 64-bit systems other than IBM AIX, the minimum and default values of innodb_buffer_pool_size_max were changed to 8 MiB and 8 TiB, respectively.
    • Q1/2026 Server Development

    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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38958 Core dump may contain buffer pool in release builds

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-29445 reorganise innodb buffer pool (and remove buffer pool chunks)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38779 New InnoDB Buffer Pool autosize feature not so optimal implemented

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38884 Runtime check for Intel TSX-NI incurs some overhead

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34863 RAM Usage Changed Significantly Between 10.11 Releases

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37557 Issues with new Buffer Pool Implementation in MariaDB Q2 Minors (10.11.12 and 11.4.6)

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              marko Marko Mäkelä
              rank rank
              Marko Mäkelä Marko Mäkelä
              Vladislav Vaintroub Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              9 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.