distal-attribute
distal-attribute
distal-attribute
distal-attribute

innodb_buffer_pool_size

Pablo_89 posted 2 years ago in General
Hi,

How do I adjust my innodb_buffer_pool_size setting

Thanks
jfalch posted 2 years ago
find the configuration file used by your mysql server, my.cnf (linux) or sometimes my.ini (windows); this is the hard part - name and location differs by OS and (linux) distribution, cf here.

This is a text file; in its [mysqld] section, add a line

innodb_buffer_pool_size=256M

or such, and restart the server.

Cf here for value to use.
kalvaro posted 2 years ago
If you used MySQL Installer for Windows, you can just click on the notification area icon, select "Configure instance" and change it in the "Configuration" section. HeidiSQL is just a client—it doesn't have full control over the server.

Please login to leave a reply, or register at first.