Otto

  • 24 Posts
  • 13 Comments
Joined 2 years ago
cake
Cake day: September 24th, 2023

help-circle




  • Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

    I could think about having a dialog during the installation that asks something like “Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available.”