This question is pretty much for anybody, but if Joe or Jamie have any suggestions, they would be welcomed as well.
Server Specs: CPU: P4 2.6GHz (Single-Core) RAM: 1GB HD: 80GB IDE (/ 5GB, /home 67GB)
I've moved the data directories for /var/lib/pgsql and /var/lib/mysql to sub-directories of /home, as 5GB isn't enough to hold all the databases for all the sites being hosted. I've also setup a loopback FS for /tmp to run noexec, nosuid.
My specific question is what do others here recommend for a system of this type for setting in PostgreSQL, MySQL, and Apache? Keep in mind it's also running all the standard services you would find on a web hosting server platform, so I don't want to tweak specific services to maximize usage of the resources, while choking off the other services.
I'm looking into putting another 1GB of RAM into the system, but in the meantime, I'd like some ideas on how to maximize performance with what available resources I have.
Thanks to anyone who has some helpful thoughts or advice on it.