Change MySQL innodb_buffer_pool_size at runtime?

Question

This may be a dumb question, but is it possible to change MySQL configuration options such as innodb_buffer_pool_size at run time?

Or, equivalently, is there a way to restart MySQL without closing existing connections or refusing new connections (for example, you can do with Apache)?

Linux_32 (2.6.26) + MySQL 5.0.24a

Answer 1

According to this MySQL forum post , it is not possible to set innodb_buffer_pool_size at runtime.

So the question remains: is it possible to change the configuration of MySQL and transparently update the daemon for its users?

Answer 2

Yes, you can (depending on your server version).

innodb_buffer_pool_size is a dynamic variable since 5.7.5 like this entry in the manual .

Here is more information about server behavior when resizing.