CODEWITHSUNDEEP
mysqlinnodb
user2842195
user2842195

Reputation: 61

how to allocate more memory to mysql in Windows

I am a MYSQL beginner and I want to allocate more memory to MYSQL. My machine is Windows 7 64 bit OS with 12GB RAM and Mysql version is 5.6.

Any one can give me the commands to increase memory for MYSQL.

Upvotes: 1

Views: 5532

Answers (1)

vic
vic

Reputation: 29

there is a file called my.ini for mysql(windows) which contains 

'innodb_buffer_pool_size=M'

(if no such field you can add explicitly under mysqld tag) where M is MB you can use G for GB increasing this value will solve your purpose and remember to verify using query 

show variables like '%innodb_buffer_pool_size%';

Upvotes: 2

Related Questions