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

Bad value for the variable "Buffer pool size"

    XMLWordPrintable

Details

    Description

      Values are good with the following commands :

      MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_chunk_size";
      innodb_buffer_pool_chunk_size | 805306368 |

      MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_size";
      innodb_buffer_pool_size | 6442450944 |

      MariaDB [nextcloud]> SHOW GLOBAL VARIABLES LIKE "innodb_buffer_pool_instances";
      innodb_buffer_pool_instances | 8 |

      Values are not good when we check with the command "show engine innodb status\g" :

      BUFFER POOL AND MEMORY
      ----------------------
      Total large memory allocated 6623854592
      Dictionary memory allocated 403920
      Buffer pool size 393216
      Free buffers 342904

      INDIVIDUAL BUFFER POOL INFO
      ----------------------
      ---BUFFER POOL 0
      Buffer pool size 49152
      Free buffers 42853
      Database pages 12368
      Old database pages 4581

      The value of each instance is 49 MB instead of 768 MB

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              pgx Philippe Genonceaux
              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.