From: Rick James Date: February 8 2010 7:12pm Subject: Re: Changing innodb_buffer_pool_size on the fly List-Archive: http://lists.mysql.com/internals/37691 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 > Date: Mon, 8 Feb 2010 16:55:12 +0300 > To: > 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=rjames@stripped >