Don't forget to pay special attention to "huge pages" ?
On 2/8/10 11:12 AM, Rick James wrote:
> I'm curious -- what will you do with the RAM you take away from InnoDB's
> buffer pool? (In a dedicated MySQL server, I seen no reason to alter the
> size.)
>
>
>> From: Elena Kasyanova<degifter@stripped>
>> Date: Mon, 8 Feb 2010 16:55:12 +0300
>> To:<internals@stripped>
>> Subject: Changing innodb_buffer_pool_size on the fly
>>
>> Hello!
>>
>> It is not possible to reconfigure innodb_buffer_pool_size via SET
>> GLOBAL ... or smth, but I want to implement this option in order to
>> use it when server load changes significantly.
>>
>> Exploring the source code I see a "buf_pool_resize" function in
>> ./storage/innodb_plugin/buf/buf0buf.c that is not called anywhere.
>> I can see how I can set up a callback for changing a system variable.
>>
>> So, given a ready resize function and the ability to make a callback,
>> the solution seems quite simple.
>> Are there any issues that do not allow to implement this resize?
>> Or something else that should be considered?
>>
>> Thanks, Elena.
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals>> To unsubscribe: http://lists.mysql.com/internals?unsub=1>>
>
--
Rick James - MySQL Geek

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.