One of our 'heavy' site clients had an interesting problem last night. It looked like a MySQL problem that was slowing down the site and eventually halted the network connectivity. It turned out to be a logging problem. 400mb log file was the cause.
So it's not just PHP & DB that we need to look after but also log rotation configuration is important.