M0NkEY
10-22-2003, 08:40 PM
I've disabled InnoDB and played a little with apache and SQL...
but I'm wondering if anyone has any tips for server with some fairly high traffic sites and only 512MB of RAM? (other than "Buy more ram" :stickout: )
choon
10-22-2003, 10:37 PM
Search on apache and MySQL optimization in this forum or at google (assume you are using apache and MySQL).
hiryuu
10-23-2003, 04:45 AM
This isn't a lot to go on -- choices that optimize one situation can often hurt another. If it always helped, it would be hard-coded in.
You probably don't want mysql to be much more than 30-40MB. Settings like key cache can be dropped quite a bit, since they can be cached at the OS level, which has a better view of memory demands.
Ultimately, Apache's high per-connect memory cost will hurt more than anything else. Strip out any modules and httpd.conf content you can, and see what you can do to reduce the number of apache processes.