Will increasing the swap space help, or will it simply delay the problem? I wouldn't think it should need this much memory for our small site. I'm thinking we'd be better off tuning the MySQL parameters, but I've been unable to find any LiveJournal-specific guidance for tuning MySQL for memory use (vs speed). MySQL is still using its defaults (key_buffer_size=8MB, table_cache=64).
We are using LiveJournal ~2005-10-27, Apache 1.3.31, mod_perl 1.29, and MySQL 4.0.17.
Should I concentrate on increasing swap space or on tuning MySQL or other? If tuning MySQL, any guidance? Thanks...