innodb_buffer_pool_size

Hi,

How do I adjust my innodb_buffer_pool_size setting

Thanks

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.

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.