Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to increase my innodb_buffer_pool_size in my.cnf as I have a mysql database that is about 1.5GB on an 8GB VPS.

If I increase it to over 512MB, then innodb seems to fail to start, and all my innodb tables when viewed through phpMyAdmin say 'In Use' next to them.

Any ideas?


Running MySQL 5.1.52

Here is my.cnf. Everything is from the default my.cnf on my VPS except the innodb_buffer_pool_size which I added.

# Disabling symbolic-links is recommended to prevent assorted security risks

innodb_buffer_pool_size = 512M

To enable the InnoDB Plugin, uncomment the 2 next lines

# To enable InnoDB-related INFORMATION_SCHEMA tables
# Join the following options to above directive

----EDIT 2 -----

More MySQL details:

version 5.1.52
version_comment MySQL Community Server (GPL) by Utter Ramblings
version_compile_machine i686
version_compile_os  redhat-linux-gnu
share|improve this question
From the version shown, it looks like the source was compiled by someone other than MySQL. Does the compiled version place a max limit on the innodb_buffer_pool_size ? Do you have the source ? If you do, can you recompile it with the limit lifted ??? –  RolandoMySQLDBA Aug 9 '11 at 19:17
Sorry, you lost me there. I'm not an expert in this area! It's a GoDaddy VPS. CentOS5 and MySQL came pre loaded on the VPS. I don't believe I can recompile mysql. –  bpmccain Aug 9 '11 at 19:28
@bpmccain let us continue this discussion in chat –  RolandoMySQLDBA Aug 9 '11 at 19:29
Maybe there's not enough free RAM –  Alex Nov 1 '11 at 9:31
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.