Unanswered: InnoDB Buffer Pool Size limited by linux kernel?
Our database size is 16 GB, and contains almost exclusively InnoDB tables. Our Buffer Pool size is set to 2 GB. I read that larger Pool size yields better performance and it should be set to at least the size of the database or even 20 % larger to accommodate for database growth.
We are using Linux Kernel 2.6.18. It is a 64 Bit machine. MySQL 5.0.44 is installed.
Does anyone know if there is a limit (by Linux Kernel?) how large the Buffer Pool Size can be set to?
The memory on our machine is currently 7.5 GB, but we are considering to increase it (to over 16GB?) if that will improve our database performance.