CODEWITHSUNDEEP
mysql
Arunjith
Arunjith

Reputation: 131

MySql innodb_buffer_pool_size for improving performance

Can we set MySql innodb_buffer_pool_size dynamically ? We can do the same at startup my modifying the my.cnf.

Upvotes: 1

Views: 1269

Answers (2)

Vojtech Kurka
Vojtech Kurka

Reputation: 905

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.

Upvotes: 1

Bjoern
Bjoern

Reputation: 16304

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):

Upvotes: 1

Related Questions