Ron Johnson wrote:
"Large systems" (meaning mainframes and "traditional" minicomputers 
running legacy OSs) are never dedicated.  They run application 
software as well as RDBMSs.
OK, we're talking about two different things.
Translating that into "modern times", a Linux box *should* be able to 
competently run MySQL and Apache at the same time.
And it can.  If it couldn't, Plesk would not be selling.  In my job I 
admin servers that do web, mail, and db for anything from a handful to 
1200+ domains on a single box.  No problem there (mostly).  But the load 
on the server's resources are, in the end, down to to what your 
application does.
There are several good reasons why you might want to put your DB on a 
separate server.