Innodb_buffer_pool_size setting over ram size

MySQL & MariaDB
,
1

Hi,

why does mysql allow innodb_buffer_pool_size to be set more than its available memory in the system? But this is not much of a problem than that mysql then tries to allocate more memory than it is available at a certain moment (for example when system is busy) and sometimes this leads to oom kills.

Kind regads,
Rok

2

Swap can be increased on the fly if memory is of concern. Some advanced motherboards allow DIMMs to be added while the system is powered on. MySQL leaves it up to the DBA to understand the consequences of setting too much RAM to MySQL.

1 Like