Change innodb_buffer_pool_size

MySQL & MariaDB Other MySQL® Questions
1

Ok, forgive me if this question has been answered elsewhere. I’ve done searches and can’t seem to find the answer.

We recently upgraded one of our DB servers from 16GB to 32GB of ram and I want to change the innodb_buffer_pool_size in /etc/mysql/my.cnf The only problem is that when I do that I get tons of errors about “Incorrect file information”

What is the right way to make this change? FWIW this is my current mysql version:

Server version: 5.1.47-rel11.2 (Percona Server (GPL), 11.2 , Revision 53)

Thanks for any help.

Mike

2

What is the exact error in the error-log?

My guess is that you somehow changed one of the parameters:
innodb_data_file_path
innodb_log_file_size
That can produce the kind of errors that you are experiencing.

Revert to the running my.cnf and test changing only the innodb_buffer_pool_size.

3

Thanks for the advice. I am not sure what I did before but I must have changed something else, or I am wondering if it could have thrown that error if I assigned too much memory? Anyways, I have it up and operational with the the buffer pool at 80% of RAM.

Thanks so much