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

MySQL is using 150MB of my RAM memory when it's doing nothing.

I have a VPS with only 256 MB ram available, so what can I do to decrease its RAM usage?

share|improve this question
up vote 3 down vote accepted

There are example my.cnf files included with the MySQL packages on most distributions, on RHEL / CentOS they can be found in /usr/share/mysql.

my-small.cnf is designed for systems with a small memory footprint, so may be suitable for your application.

Alternatively you could follow a MySQL tuning guide on the web to find the commonly tuned memory parameters and simply decrease rather than increase the values.

share|improve this answer
Thanks! Where do I need to put the config file? – ONOZ Oct 24 '12 at 13:26
Copy it to /etc/my.cnf - you may want to backup the original first. – James Yale Oct 24 '12 at 17:28

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.