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

Consider smaller defaults for MyISAM and Aria cache sizes.

    XMLWordPrintable

    Details

      Description

      Hi,

      in MariaDB 10.3, the defaults for MyISAM and Aria cache sizes (key_buffer_size and aria_pagecache_buffer_size) are 128 MB. This is the same as for the InnoDB Buffer Pool (innodb_buffer_pool_size).

      IMHO, those values should be lower. Here are some arguments for this:

      • Allocating 3x 128 MB in the default configuration is a waste (both in RAM usage and in core dump size),
      • MyISAM and Aria are less used than InnoDB.

      I would like to point out that this is not a change for the sake of change. The goal is to reduce the memory footprint of a default MariaDB installation.

      Another consideration is that the size of caches for all storage engine is very workload specific and those parameters should be tuned in most serious deployment. The default for InnoDB (128 MB) looks good to me as this is the main Storage Engine in the MySQL/MariaDB up to now. But considering that MyISAM and Aria are less used, I think their default should be much lower.

      As a side-note, MySQL default for MyISAM cache is 8 MB since at least 5.5. If this is good for MySQL, it should probably be good for MariaDB.

      Note: the priority of this task is set as Major. The main motivation is that aria_pagecache_buffer_size is is not dynamic, so fixing it needs a server restart. If aria_pagecache_buffer_size was dynamic, the priority of this task might be lowered.

      Related: MDEV-16606: Make aria_pagecache_buffer_size dynamic.

      Thanks for looking into that,

      JFG

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            jeanfrancois.gagne Jean-François Gagné
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration