by Federico Razzoli | Jan 21, 2021 | MariaDB InnoDB, MariaDB, MySQL, MySQL InnoDB
In my previous article, I wrote how to answer the question: Is InnoDB Buffer Pool big enough? But the buffer pool can also be too big. So you may wonder if you can shrink it. Reasons to shrink the Buffer Pool Why would one do such a thing? A common reason is saving...
by Federico Razzoli | Jan 6, 2021 | MariaDB InnoDB, MariaDB, MySQL, MySQL InnoDB
InnoDB buffer pool is the most important memory area to allocate. It contains the most frequently read data and index entries from InnoDB tables. Its size is determined by innodb_buffer_pool_size, which is one of the two most important settings for...