MySql innodb_buffer_pool_size for improving performance

Can we set MySql innodb_buffer_pool_size 开发者_StackOverflowdynamically ? We can do the same at startup my modifying the my.cnf.

In short: no, it is only a server startup parameter (according to this manual page).

You can find all dynamic system variables here (for version 5.1):

• http://dev.mysql.com/doc/refman/5.1/de/dynamic-system-variables.html

Currently not. But it will be possible in 5.7:

https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-online-resize.html

Older versions need a restart to change that setting.