Greetings everyone... Just got my very first VPS set up with CentOS 5.5. I've installed Apache, PHP 5.3.5, and MySQL 5.5.
I'm already using 327MB of my 512MB RAM (which it says burst to 512). It looks like 305MB of this is MySQL. How can I work to get the memory usage down? I've tried some of the edits to my.cnf posted in the tutorials section but MySQL fails to start after I put these settings in my.cnf.
Note: This is primarily a remote development/staging/testing server.
Thanks for the help, looking forward to learning much more about all this stuff...!
BuyVM - OpenVZ & KVM Based VPS Servers - Chat with us
- All popular VPN methods supported
- Affordable offloaded MySQL & DDoS protection
- 5GB backup space, unmetered private LAN bandwidth & native IPv6 included. All with a strong serving of pony
First, you should look into Apache. A default Apache uses a lot of RAM. I wouldn't be surprised to find out, most of your 327 RAM usage is from Apache.
Google search, "fine tuning apache". Those sites will give instructions on configuring Apache to work in an environment with little RAM. (This is advance stuff, so its best to know what you are doing before hand. If you decided to risk it, backup your entire server.) Fine tuning Apache will bring down your RAM usage.
The reason why you want to check with Apache first, is that Apache tends to spawn many http processes, and the more http processes you'g got running the more RAM your VPS is using. Fine turning Apache, in the simplest sense, mean killing most of those unneeded processes.