I just have a quick question.
I have done some research into how to determine the size of your Innodb
All of the sources I used, specified that the Innodb buffer pool size
should be the same size as your database + 10%.
However, as far as I understand it, the buffer size also relies on that
amount of memory being available. Thus if you increase the buffer size, the
amount of memory used will be increased.
My thinking however, is what happens when the database size grows bigger
than the amount of memory available to the hardware.
Say for instance, a server with MySQL also runs other applications. The
amount of memory on the server is 32Gb and about 31Gb is already in use.
The current Innodb buffer pool size is at 4Gb for instance, and the
innodb tables then grow to be about 8Gb in size.
What would be the appropriate actions for this to ensure the buffers are
set to the size to best suit the database needs?