I have a small VPS server that has a Nginx front end that serves up static media files and passes Django requests back to an Apache 2.2 prefork MPM server running mod_wsgi.
With one (very) small site loaded and working, it's currently using 143MB of 256MB of RAM.
Using the top
command I can see that Apache is using 52.9% of available RAM, with memcache in second using 2.1%.
Considering that I'm planning on putting quite a few Django projects on this one server, I'm wondering if there is anything I can do to trim the amount of RAM that Apache is using?
You might consider using Spawning for deployment.
If you want to stick with Apache, a few suggestions, roughly in order of difficulty:
you could run Django on FastCGI. nginx could then drive it directly instead of going through Apache.
For the record, the OP's use of the term MPM is non sensical. The MPM in Apache isn't an option, you are always using an MPM when using Apache. The choice is which MPM you are using. On UNIX the two main MPMs or Multiprocessing Modules, are prefork and worker. On Windows the winnt MPM is always used. Details about the different MPMs can be found in Apache documentation on Apache web site. In the context of mod_wsgi though, you might be better off reading:
http://code.google.com/p/modwsgi/wiki/ProcessesAndThreading
In short though: