RobM RobM - 2 months ago 25
MySQL Question

Change MySQL innodb_buffer_pool_size at runtime?

This may be a dumb question, but is it possible to change the MySQL configuration options such as

innodb_buffer_pool_size
at runtime?

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

Linux_32 (2.6.26) + MySQL 5.0.24a

Answer

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 MySQL configuration and reload the daemon transparently to its users?

Comments