Setting Innodb Buffer Pool Size
I have a database using innodb completely. Its now having a innodb_buffer_pool_size at 128MB. Which I know is very less for my user.
But no matter what I do it won't change. I have added a value of 1G both in /etc/my.cnf and also in /etc/mysql/my.cnf and restarted the mysql service. It doesn't seem to update.
My mysql keeps on stopping and when i run mysqltuner & tuning-primer.sh all point to the fact I have to increase the innodb_buffer_pool_size but it simply won't increase.
Is there any other way to enforce this?
Edited 1 time(s). Last edit at 10/13/2013 08:59AM by Safwan Erooth.
Subject
Views
Written By
Posted
Setting Innodb Buffer Pool Size
2866
October 13, 2013 08:38AM
1001
October 13, 2013 04:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.