EN
MySQL - change max memory size on windows
5 points
Quick solution, change innodb_buffer_pool_size in my.ini file:
xxxxxxxxxx1
innodb_buffer_pool_size=20G
Steps:
1. Location in my case:
xxxxxxxxxx1
C:\Program Files\MariaDB 10.3\data\my.ini2. Default settings of my.ini
xxxxxxxxxx1
[mysqld]2
datadir=C:/Program Files/MariaDB 10.3/data3
port=33064
innodb_buffer_pool_size=4083M5
[client]6
port=33067
plugin-dir=C:/Program Files/MariaDB 10.3/lib/plugin3. Change value of innodb_buffer_pool_size property to 20G.
my.ini after changes:
xxxxxxxxxx1
[mysqld]2
datadir=C:/Program Files/MariaDB 10.3/data3
port=33064
innodb_buffer_pool_size=20G5
[client]6
port=33067
plugin-dir=C:/Program Files/MariaDB 10.3/lib/plugin
Example after chaning MySQL max memory size to 20 GB and making RAM heavy operations on MySQL:
