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

Make aria_pagecache_buffer_size dynamic.

    XMLWordPrintable

Details

    Description

      Hi,

      while testing the "no InnoDB Buffer Pool in core dumps" feature (details in [1]), I discovered that aria_pagecache_buffer_size is not dynamic. This is inconvenient as tuning needs restarting the server. In comparison, key_buffer_size is dynamic for a long time ([2]) and innodb_buffer_pool_size is dynamic since MariaDB 10.2 ([3]).

      [1]: https://www.percona.com/community-blog/2018/06/28/nice-feature-in-mariadb-103-no-innodb-buffer-pool-in-coredumps/

      [2]: https://mariadb.com/kb/en/library/myisam-system-variables/#key_buffer_size

      [3]: https://mariadb.com/kb/en/library/xtradbinnodb-server-system-variables/#innodb_buffer_pool_size

      Please make aria_pagecache_buffer_size dynamic.

      Note: the priority of this task is set as Major. The main motivation is that the default value for aria_pagecache_buffer_size is 128 MB, which is a lot. If the default value was much smaller (8 MB or less), the priority of this task might be lowered.

      Related: MDEV-16607: Consider smaller defaults for MyISAM and Aria cache sizes.

      Thanks in advance,

      JFG

      Attachments

        Activity

          People

            Unassigned Unassigned
            jeanfrancois.gagne Jean-François Gagné
            Votes:
            5 Vote for this issue
            Watchers:
            6 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.