Hi,
How do I adjust my innodb_buffer_pool_size setting
Thanks
innodb_buffer_pool_size
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.
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.
Please login to leave a reply, or register at first.