I am a newbie to VPS. I recently bought a cheap linux VPS plan from burst.net. It runs on centos 64 bit and has 512MB RAM. There is a small mybb forum on it. It's not active. i am the only one using it as of now.
I have a few problems.
1. Sometimes the SSH is not working properly. I get 'server refused connection' from putty. but the website is loading without any problems. When i login to veportal, the RAM usage shows just 'mb' [no zero just 'mb']. If i reboot the vps everything works properly.
2. One more problem is MySQL occupies almost 300MB of RAM. Initially when apache is running the usage is 30-40MB. But when i start the MySQL service, the usage shoots up to 350-400MB..is that normal ?
I added some code to my.cnf file. I found it in a vpslink site i think.
3. Gzip is not working properly. I have added these lines to httpd.conf file. But still firebug says gzip is not turned on.
I agree with the recommendation to go with 32 bit CentOS for a VM with 512MB of RAM; you only need 64 bit to address more RAM.
I would recommend NOT blindly taking a my.cnf file and putting it in use. Instead, my recommendation is to restore your my.cnf to the default configuration, and do this:
chmod 755 mysqltuner.pl
Then run mysqltuner using "./mysqltuner.pl" to get a list of recommendations for YOUR system. Note that you should run mysql for 24 - 48 hours before implementing any changes, as the program needs enough history to work out its recommendation.
In particular, I would be very careful about setting the table_cache too high at first. table_cache should be increased gradually, probably 4 at a time, to prevent file descriptor limits. table_cache should be at least equal to max_connections * number of tables per join in any queries you execute (you can ask myBB what the maximum number of tables per join is, or just use mysqltuner.pl to configure your my.cnf).