out of memory under VPS

Author: firstnetguard
Submited At: 2007-03-19
Votes: 0

You have a pretty well setup on a VPS, but in the last days your services keeping restarting and in your log files you can read "out of memory"?
Well... you can\'t afford a dedicated server and additional memory on your VPS is to expensive?
Ok, than let\'s cut down the memory usage a little bit.
Sounds easy, it is... but you may will loose some performance!

Let\'s start with mysql... open "/etc"my.cnf" in your favorite editor and cut it down a little bit in memory usage.
Now it could look like this one

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=50
table_cache=1000
thread_cache_size=40
thread_stack=100K
wait_timeout=10
join_buffer=1M
myisam_sort_buffer_size=1M
query_cache_size=1M
read_rnd_buffer_size=1M

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

...after these change, don\'t forget to restart mySQL!

Ok, where else could we save some memory?
How about "/etc/cpspamd.conf" ? Well... let\'s try it.
maxchildren=1

But that can\'t be all.... that\'s correct!
Another MAIN task is Apache, let\'s try to save some memory from apache....
Put "/usr/local/apache/conf/httpd.conf" into your favorite editor (e.g. vim or nano) and keep looking for something like
"MinSpareServers", i guess 2 should be enough.
"MaxSpareServers", let\'s try 10
"StartServers", do we really need more than 2 after the server starts?
"MaxClients", if you don\'t run a heavy load, try 150 or less

...ok, save your changes and restart apache.

Was this article useful?
YES | NO

out of memory under VPS

Other useful links