Your site had a 600MB apache process that was overloading the server.
It is just your index.php file. Are you running any modules on your site that may be a rss feed or something similar.
I am trying to install XOOPS on my laptop. I am running Apache 2.0.5, MySQL 4.0.2, and php 4.3.8 on a debian (utunbu) system.