can i ask how do you tune your mysql and httpd ? do you use any default setting for all the shared hosting server ? thanx
No you definitely don't want the default settings for MySQL nor apache. There are a lot of tutorials for optimizing both, but if you're not familiar maybe you should consider hiring a sysadmin to do it for you (e.g. rack911.com). Only when you fully understand your hardware and your client's software needs will you be able to effectively tune the server.
I'd suggest a fully managed server if you're new to all this and want to start a hosting company, so that you can focus on gaining customers rather than keeping the system performing optimally. There's no harm in learning and testing on a separate machine in your spare time and then when you're comfortable switch to an unmanaged server.
You can look at some of the settings in the sample my-large.conf and my-huge.cnf files then go and google the variables and see what each one does, then figure out what is best for your system. There are scripts like mysqltuner.pl, but personally I prefer to understand the settings and configure them myself.
To briefly answer your original question, the more data MySQL can keep in RAM the less time it has to spend accessing or waiting on the disks. RAM is extremely fast, if you allow a large enough MySQL cache etc you can see dramatic queries speed gains.
Last edited by ServiceProvider; 05-07-2011 at 11:44 PM.
Dallas Colocation by Incero
e: sales(at)incero(dot)com • 855.217.COLO (2656)
Colocation & Enterprise Servers, SATA/SAS/SSD, secure IPMI/KVM remote control, 100% U.S.A. Based Staff
SSAE 16, SAS70, Redundant Power & Network, Fully Diverse Fiber