Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : VPS Tutorials : Quick VPS Apache and MySQL optimization guide

[agnivo007]

Well, most VPSs being bought are having 128 to 512 MB of dedicated memory and I've seen people complaining slow response and heavy memory usage.

To help VPS owners tune up their Apache and MySQL quickly, I've written a do-it-yourself guide and decided to share with you all.

You can read it here : Quick VPS Apache and MySQL optimization guide

If you find it useful, don't forget to give a Digg so that other people can find it easily.

Digg it HERE

If there's anything wrong with the guide or you have suggestions, feel free to reply. Mods, if anything is wrong, let me know too.

[seankoons]

Well done! That is an excellent primer on getting your my.cnf and httpd.conf running at top speed with the smallest amount of resources. I'm sure it will help many users.

-Sean

[blazingdrag]

Doesnt work now

[That Guy]

Really? I can still access that website just fine.

[blazingdrag]

It wasnt working just now, now it works.

[layer0]

One configuration does not fit all.

It's not that big of a deal if you use something like the above as a base, but you should be prepared to make changes (sometimes drastic) to fit the usage of the website(s) you host...

[agnivo007]

Thanks for your feedback, guys!

Yes, as suggested by layer0, I've already mentioned that fact in the concluding section of the howto.

BTW, I'm currently testing Apache 2.2, PHP 5.2.1 and MySQL 5.0.37 on the VPS.
Apache 2.2 seems to be very efficient in mem usage but a bit higher on CPU usage than 1.3.x branch.
Will publish the final outcomes soon...

[rdogg]

tmp_table_size = 16M

Nice tuto, imho 16MB for the tmp table size is kind of small, this will force the system to make more tmp disk tables, considering in vps the Disk I/O is a factor that tends to produce bottleneck , i will leave it at the default 32MB or even higher.

table_cache = 1024

Also the table_cache to 1M ? , if you have mysql intensive sites this may be a problem , watch your table cache usage it should be something between 70% and 90% , also compare opened vs open table , if short after you restart mysql you see this value increasing you need to make table_cache bigger, i have it on 96M and i have a 384MB vps.

One last thing is that max_user_connections is not set, if you are using myisam tables, and sometimes the creation of tmp_tables takes a lot of time, then the table gets locked , the next mysql connections wait for it (the tmp table creation) to finish, so it will make 400 connections (max_connections) before it dies with the "unable to connect message" , this will force apache to handle the clients waiting for the results, more child servers will be needed, and this will make the entire server really slow :X,

Once again nice tutorial

[krystofo]

VPS MySQL and Apache Optimization Guide

A "must bookmark" for me. Agnivo has gone to some effort to make instructions that even a non-techy like I might follow. I do not actually "own" a VPS and--with internet equipment so various and constantly changing--would not dare to do this type of thing myself. But, certainly something to show to friends who will understand, and to discuss with my primary webhost.

[agnivo007]

Wow...it feels good to see some words of encouragement from krystofo...

Thanks rdogg for your feedback...I've been waiting to see some of these.

Can you please post some alternative and revised config here or post it as a comment to the original blog post?

Cheers

[rdogg]

Hello agnivo i wanted to correct myself i dont have the table_cache on 96M i have it on 512 , i got confused and tought it was about MB or KB but it is about the tables to keep in cache.

I was looking at my config today and noticed this.

regards

[agnivo007]

OK rdogg... Do you have any good apache2.2 mysql5 config ?

As I see, apache 2.2.4 is a great piece of software and with a little tweaking, it performs even better.

[agnivo007]

What doesn't work ?

[Victoria_jambi]

how can I copy files using putty to my own computer ? what would be the command for linux ?

[[kaze]]

Victoria_jambi,

As far as copying and transferring files from your VPS to your PC, I would suggest you use an FTP client. Filezilla (which I reccomend) has a gui and ssh support built in, so you can connect the same way you do with Putty to do all your transfers to and from your VPS and PC. Much easier than transferring from command line, unless you are transferring files from one server to another.