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?

-----EDIT------

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.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

innodb_buffer_pool_size = 512M

To enable the InnoDB Plugin, uncomment the 2 next lines
#ignore-builtin-innodb
#plugin-load=innodb=ha_innodb_plugin.so

# To enable InnoDB-related INFORMATION_SCHEMA tables
# Join the following options to above directive
  ;innodb_trx=ha_innodb_plugin.so
  ;innodb_locks=ha_innodb_plugin.so
  ;innodb_cmp=ha_innodb_plugin.so
  ;innodb_cmp_reset=ha_innodb_plugin.so

----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

 
discard

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

Browse other questions tagged or ask your own question.