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

innodb_buffer_pool_size

User, date Message
Written by Pablo_89
1 year ago
Category: General
1 posts since Fri, 10 May 13
Hi,

How do I adjust my innodb_buffer_pool_size setting

Thanks
Written by jfalchMoney, Euro
1 year ago
389 posts since Sat, 17 Oct 09
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.
Written by kalvaro
1 year ago
594 posts since Thu, 29 Nov 07
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.