Ofcourse it will! But you have to define "over used" and relate it to the infrastructure of your hardware. When you expect thousends of concurrent users viewing and editing your data, have lots of content and a desktop machine that acts as a web, file and database server you'll soon run into trouble.
When you have dedicated web, file and database servers on high-end machines with lots of RAM and fast disk access I think you won't run into trouble any time soon. If you do anyway, first look at your software architecture before blaming the database.