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. Piazza del Popolo seen from il Pincio, Rome.Is it oversized? Reasons to shrink the Buffer...
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...