I have installed MySQL 5.7 on windows server 2016 and set the buffer pool size to 4 GB through SQL query but when the server is restarted buffer pool size getting reduced resulting in the slowness of application hosted on it … need suggestion so as to permanently fix the buffer pool size…..
Mysql – Permanent solution for Fixing buffer size
buffer-poolinnodbMySQLmysql-5.7
Related Question
- MySQL 5.7 – innodb_buffer_pool_instances Value Issue
- Sql-server – SQL Server Buffer Pool Extension in FullText Index Population
- Mysql – Would the MySQL database benefit from increasing the InnoDB buffer pool size
- MySQL – Optimal innodb_buffer_pool_instances Setting for AWS RDS with 6GB Buffer Pool
- Mysql – innodb buffer pool size not changing
- MySQL takes huge memory by ignoring buffer pool size
- Mysql – Assign different RAM usage (buffer pool size) per db in thesql
Best Answer
To find the slowness of the application, we need to dig deeper on many other aspects, such as
table design, query, indexes, data type, etc...
To set the
innodb_buffer_pool_size
value to 4 GB, edit the configuration file my.ini and add the following statement, then restart the MySQL server:Or you can set it online (restart not required) by running the following statement:
There are few things to consider, before changing this variable. My blog post contains the detailed explanation on allocating
innodb_buffer_pool_size
.