Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a small vps, with only 256mb of ram, with maximum burst up to 512mb. When I configure my vps without innodb, it only uses 130 mb of ram, so that is no problem for me. But when I turn on innodb, The memory usage grows to about 300-400 mb. Is it possible to run innodb such that I won't exceed the 256mb? preferably I don't want to use more than 100mb for innodb. I already came across some sites which said I could limit the memory usage, but if I limit it to only 100mb will the db run well enough? (compared to for example the MyISAM storage engine)

If 100mb is too little memory for innodb, can you recommend me any other storage engine which supports transactions?

share|improve this question
up vote 4 down vote accepted

You should use 75-80% or RAM as the max buffer pool size if the server is dedicated to doing MySQL

Please place these two lines in /etc/my.cnf (my.ini)


If you want to go with 100MB recommendation for InnoDB then use these instead


Make sure you resize the innodb log files as follows:

service mysql stop
rm -f /var/lib/mysql/ib_logfile*
service mysql start

(Edit: fixed typo in rm command)

share|improve this answer
For those of you wondering, rm /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1. – Xeoncross Jul 28 '12 at 17:39

Your Answer


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

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