Languages
[Edit]
EN

MySQL - change max memory size on windows

5 points
Created by:
Keisha-Acosta
290

Quick solution, change innodb_buffer_pool_size in my.ini file:

innodb_buffer_pool_size=20G

 

Steps:

1. Location in my case:

C:\Program Files\MariaDB 10.3\data\my.ini

2. Default settings of my.ini

[mysqld]
datadir=C:/Program Files/MariaDB 10.3/data
port=3306
innodb_buffer_pool_size=4083M
[client]
port=3306
plugin-dir=C:/Program Files/MariaDB 10.3/lib/plugin

3. Change value of innodb_buffer_pool_size property to 20G.

my.ini after changes:

[mysqld]
datadir=C:/Program Files/MariaDB 10.3/data
port=3306
innodb_buffer_pool_size=20G
[client]
port=3306
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:

Example after chaning MySQL max memory size to 20 GB and making RAM heavy operations on MySQL
Example after chaning MySQL max memory size to 20 GB and making RAM heavy operations on MySQL
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join