I used the LAMP stack (in beta) with a low traffic site running PHP5 + MySQL5. Nothing too fancy.
edit: I also added an additional 1gb as swap space, which helped prevent my mysql instance from falling over with low memory at times.
Prefork is pretty much Apache-speak for "please munch all my memory and then lock up if more than a handful of people turn up at once".
Nginx or Lighttpd + PHP-FPM behave almost as badly if you choose dynamic mode and don't pick the right values.