up vote 0 down vote favorite
share [g+] share [fb]

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
link|improve this question
Please tell me what version of MySQL you are running. Either run mysql -v from the command line or SELECT version(); within mysql. – RolandoMySQLDBA Aug 9 '11 at 17:34
Please copy and paste your my.cnf into your question. – RolandoMySQLDBA Aug 9 '11 at 17:35
Added to original Q – bpmccain Aug 9 '11 at 17:42
Please add this also : SHOW VARIABLES LIKE 'version%'; – RolandoMySQLDBA Aug 9 '11 at 17:45
Added to original Q – bpmccain Aug 9 '11 at 18:25
show 3 more comments
feedback

2 Answers

up vote 0 down vote

innodb_buffer_pool_size is not a dynamic variable. It can only be set by adding this to my.cnf

[mysqld]
innodb_buffer_pool_size=1536M

and restarting mysql

link|improve this answer
That is what I have been doing. The problem occurs when I restart mysql. If innodb_buffer_pool_size is above 512M, then I get the problem I described above. – bpmccain Aug 9 '11 at 17:28
feedback
up vote 0 down vote

Maybe there's not enough free RAM

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.