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.

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

1 Answer

up vote 2 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
1  
Copy it to /etc/my.cnf - you may want to backup the original first. –  James Yale Oct 24 '12 at 17:28
add comment

Your Answer

 
discard

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.