List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:May 20 2010 7:37am
Subject:Innodb buffer pool size
View as plain text  
Hi Guys


    I just have a quick question.



   I have done some research into how to determine the size of your Innodb
buffer pool.


  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?

Innodb buffer pool sizeMachiel Richards20 May
  • Re: Innodb buffer pool sizeNitin Mehta20 May
    • Re: Innodb buffer pool sizemachielr20 May
  • Re: Innodb buffer pool sizeRaj Shekhar21 May
  • Re: Innodb buffer pool sizeBaron Schwartz26 May