Not the answer you need?
Register and ask your own question!

Change innodb_buffer_pool_size

mikeytagmikeytag EntrantCurrent User Role Participant
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

Comments

  • sterinsterin Mentor Inactive User Role Contributor
    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.
  • mikeytagmikeytag Entrant Current User Role Participant
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.